| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.IO; |
| | | using System.Threading.Tasks; |
| | | using System.Windows.Forms; |
| | | |
| | |
| | | gvMx1.SetFocusedRowCellValue("dcHz", _orgName); |
| | | gvMx1.SetFocusedRowCellValue("dcHzGuid", _orgId); |
| | | }; |
| | | |
| | | #region 2025-08-27 复制beg |
| | | btnCopyXls.Click += (s, e) => |
| | | { |
| | | string kcZz = txt_fapporgid.GetId(); |
| | | if (string.IsNullOrEmpty(kcZz)) |
| | | { |
| | | Gs.DevApp.ToolBox.MsgHelper.ShowError("请先选择申请组织后才能使用复制功能!"); |
| | | txt_fapporgid.Focus(); |
| | | return; |
| | | } |
| | | string filePath = AppContext.BaseDirectory + "xlsCopy.xls"; |
| | | if (File.Exists(filePath)) |
| | | { |
| | | var frm = new CopyXls(kcZz, lbGuid.Text.Trim(), OrderType.物料调拨.ToString()); |
| | | frm.UpdateParent += (ss, ee) => |
| | | { |
| | | try |
| | | { |
| | | string _orgId = txt_fapporgid.GetId(); |
| | | string _orgName = txt_fapporgid.GetName(); |
| | | var lst = ee.DynamicList; |
| | | DataTable _Table = (DataTable)gcMx1.DataSource; |
| | | foreach (dynamic dym in lst) |
| | | { |
| | | DataRow _row = _Table.NewRow(); |
| | | _row["itemNo"] = dym.itemNo; |
| | | _row["itemName"] = dym.itemName; |
| | | _row["itemModel"] = dym.itemModel; |
| | | _row["itemUnit"] = dym.dwName; |
| | | _row["itemId"] = dym.itemId; |
| | | _row["shNum"] = dym.sl; |
| | | _row["remark"] = dym.bz; |
| | | if (!string.IsNullOrEmpty(_orgId)) |
| | | { |
| | | _row["dcOrg"] = _orgName; |
| | | _row["dcOrgGuid"] = _orgId; |
| | | _row["drOrg"] = _orgName; |
| | | _row["drOrgGuid"] = _orgId; |
| | | _row["drHz"] = _orgName; |
| | | _row["drHzGuid"] = _orgId; |
| | | _row["dcHz"] = _orgName; |
| | | _row["dcHzGuid"] = _orgId; |
| | | } |
| | | _Table.Rows.Add(_row); |
| | | } |
| | | gcMx1.BindingContext = new BindingContext(); |
| | | gcMx1.DataSource = _Table; |
| | | gcMx1.ForceInitialize(); |
| | | gvMx1.CloseEditor(); |
| | | gvMx1.PostEditor(); |
| | | gvMx1.UpdateCurrentRow(); |
| | | gvMx1.BestFitColumns(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | Gs.DevApp.ToolBox.MsgHelper.ShowError(ex.Message); |
| | | } |
| | | }; |
| | | frm.ShowDialog(); |
| | | } |
| | | else |
| | | { |
| | | Gs.DevApp.ToolBox.MsgHelper.ShowError("找不到xlsCopy.xls文件,请联系管理员!"); |
| | | } |
| | | }; |
| | | #endregion |
| | | } |
| | | private void GridView1_ColumnFilterChanged(object sender, EventArgs e) |
| | | { |
| | |
| | | /// <param name="pageSize">每页几条</param> |
| | | private void getPageList(int curPage) |
| | | { |
| | | gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); |
| | | gcMain1.DataSource = null; |
| | | System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder(); |
| | | _sbSqlWhere.Append(" and a.FAPPORGID in"); |
| | | _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere()); |
| | | _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList)); |
| | | PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "create_date", "asc", "", _sbSqlWhere.ToString()); |
| | | string json = JsonConvert.SerializeObject(pgq); |
| | | try |
| | |
| | | if (xtraTabControl1.SelectedTabPageIndex == 1) |
| | | { |
| | | getModel(lbGuid.Text.Trim()); |
| | | int rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], rowGuid); |
| | | gridView1.FocusedRowHandle = rowHandle; |
| | | if (_inFieldValue <= 1) |
| | | UtilityHelper.SetCheckIco(gridView1, "chkStatus", "FAPPROVEBY", "FAPPROVEDATE", picCheckBox, this, _inFieldValue.ToString()); |
| | | } |
| | | int rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], rowGuid); |
| | | gridView1.FocusedRowHandle = rowHandle; |
| | | UtilityHelper.SetCheckIco(gridView1, "chkStatus", "FAPPROVEBY", "FAPPROVEDATE", picCheckBox, this, _inFieldValue.ToString()); |
| | | else |
| | | { |
| | | //注意,这里和其它页面有点不一样 |
| | | getPageList(this.pageBar1.CurrentPage); |
| | | int rowHandle = gridView1.LocateByValue("guid", rowGuid); |
| | | gridView1.FocusedRowHandle = rowHandle; |
| | | } |
| | | } |
| | | else |
| | | MsgHelper.ShowError(_rtn.rtnData.outMsg.ToString()); |