| | |
| | | using DevExpress.XtraCharts.GLGraphics.Platform; |
| | | using DevExpress.XtraEditors; |
| | | using Gs.DevApp.Entity; |
| | | using Gs.DevApp.ToolBox; |
| | |
| | | ucLookHuoZhu1.HzId = _ucHz; |
| | | ucLookHuoZhu1.SetHzLx(_ucHzlx); |
| | | ucLookHuoZhu1.SetHzId(_ucHz); |
| | | System.Text.StringBuilder sbWhere = new System.Text.StringBuilder(); |
| | | sbWhere.Append(" and a.FSubsidiary ='" + _orgId + "'"); |
| | | var _obj = new PageQueryModel(1, 999999, "item_no", "asc", "", sbWhere.ToString(), ""); |
| | | var json = JsonConvert.SerializeObject(_obj); |
| | | try |
| | | { |
| | | var strReturn = UtilityHelper.HttpPost("", "MesItemsManager/GetListSelect", json); |
| | | var rtn = UtilityHelper.ReturnToTablePage(strReturn); |
| | | var dt = rtn.rtnData.list; |
| | | this.repositoryItemSearchLookUpEdit1.DataSource = dt; |
| | | // repositoryItemSearchLookUpEdit1.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; |
| | | //repositoryItemSearchLookUpEdit1.PopupFormSize = new System.Drawing.Size(500, 300); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | MsgHelper.ShowError("提示:" + ex.Message); |
| | | } |
| | | _bindLookSearch(txt_qt035.Text.Trim(), "",""); |
| | | }; |
| | | //选择领用组织 |
| | | txt_qt024.EditChanged += (s, e) => |
| | |
| | | //选择来源单号 |
| | | txt_qt035.ButtonClick += (s, e) => |
| | | { |
| | | string strSrmNo = ""; |
| | | SelectDaa frm = new SelectDaa(); |
| | | string _orgId = txt_qt023.GetId(); |
| | | SelectDaa frm = new SelectDaa(_orgId); |
| | | frm.UpdateParent += (ss, ee) => |
| | | { |
| | | var lst = new List<dynamic>(); |
| | | lst = ee.DynamicList; |
| | | strSrmNo = lst[0].guid; |
| | | string strSrmNo = lst[0].guid; |
| | | string strGdlx = lst[0].gdlx; |
| | | string strGdlxWlid = lst[0].gdlxWlid; |
| | | txt_qt035.Text = strSrmNo; |
| | | _bindLookSearch(txt_qt035.Text.Trim(), strGdlx, strGdlxWlid); |
| | | #region 选择工单后带出下面的物料 2025-09-27 |
| | | //try |
| | | //{ |
| | | // var _obj = new |
| | | // { |
| | | // strDaaNo = strSrmNo,//主建 |
| | | // }; |
| | | // var strReturn = UtilityHelper.HttpPost("", |
| | | // "WomdaaManager/SelectDaaMx", |
| | | // JsonConvert.SerializeObject(_obj)); |
| | | // var dt = UtilityHelper.ReturnToList(strReturn); |
| | | // DataTable _newTable = dt.rtnData; |
| | | // DataTable _oldTable = (DataTable)gcMx1.DataSource; |
| | | // foreach (DataRow dddddd in _newTable.Rows) |
| | | // { |
| | | // DataRow _row = _oldTable.NewRow(); |
| | | // _row["qd002"] = dddddd["itemNo"].ToString(); |
| | | // _row["qd003"] = dddddd["itemName"].ToString(); |
| | | // _row["qd004"] = dddddd["itemModel"].ToString(); |
| | | // _row["qd009dw"] = dddddd["dwName"].ToString(); |
| | | // _row["itemId"] = dddddd["itemId"].ToString(); |
| | | // _row["depotName"] = dddddd["depotName"].ToString(); |
| | | // _row["depotId"] = dddddd["depotId"].ToString(); |
| | | // _row["kcQty"] = dddddd["kcQty"].ToString(); |
| | | // _oldTable.Rows.Add(_row); |
| | | // } |
| | | // gcMx1.BindingContext = new BindingContext(); |
| | | // gcMx1.DataSource = _oldTable; |
| | | // gcMx1.ForceInitialize(); |
| | | // gvMx1.BestFitColumns(); |
| | | // Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx1); |
| | | //} |
| | | //catch (Exception ex) |
| | | //{ |
| | | // MessageBox.Show(ex.Message); |
| | | //} |
| | | #endregion |
| | | }; |
| | | frm.ShowDialog(); |
| | | }; |
| | | |
| | | #region 2025-08-27 复制beg |
| | | btnCopyXls.Click += (s, e) => |
| | | { |
| | |
| | | } |
| | | }; |
| | | #endregion |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 来源明细限制, |
| | | /// </summary> |
| | | /// <param name="strGdlx">工单类型,如果是维修,根据物料找</param> |
| | | private void _bindLookSearch(string daaNo, string strGdlx,string gdlxWlid) |
| | | { |
| | | System.Text.StringBuilder sbWhere = new System.Text.StringBuilder(); |
| | | sbWhere.Append(" and a.FSubsidiary ='" + txt_qt023.GetId() + "'"); |
| | | if (daaNo.Trim().Length > 0) |
| | | { |
| | | if (strGdlx == "W-维修返工" || strGdlx == "C-拆机返工") |
| | | { |
| | | sbWhere.Append(" and a.item_id in ("); |
| | | sbWhere.Append(" select dab.dab003 from WOMDAA daa left join WOMDAB dab on daa.guid=dab.daaGuid "); |
| | | sbWhere.Append(" where daa.guid=( select top 1 ddddd.guid as dddddGuid from WOMDAA ddddd where ddddd.daa002='"+ gdlxWlid + "' and ddddd.daa025 in('F-量产','S-试产') order by ddddd.daa001 desc )"); |
| | | sbWhere.Append(" )"); |
| | | } |
| | | else { |
| | | sbWhere.Append(" and a.item_id in ("); |
| | | sbWhere.Append(" select dab.dab003 from WOMDAB dab where dab.dab001 = '" + txt_qt035.Text.Trim() + "'"); |
| | | sbWhere.Append(" )"); |
| | | } |
| | | } |
| | | var _obj = new PageQueryModel(1, 999999, "item_no", "asc", "", sbWhere.ToString(), ""); |
| | | var json = JsonConvert.SerializeObject(_obj); |
| | | try |
| | | { |
| | | var strReturn = UtilityHelper.HttpPost("", "MesItemsManager/GetListSelect", json); |
| | | var rtn = UtilityHelper.ReturnToTablePage(strReturn); |
| | | DataTable dt = rtn.rtnData.list; |
| | | //如果没有,再读一遍 |
| | | if (dt == null || dt.Rows.Count <= 1) |
| | | { |
| | | _bindLookSearch("","", ""); |
| | | } |
| | | else |
| | | { |
| | | this.gridView2.IndicatorWidth = 60; |
| | | this.gridView2.CustomDrawRowIndicator += (ss, ee) => |
| | | { |
| | | if (ee.Info.IsRowIndicator && ee.RowHandle >= 0) |
| | | ee.Info.DisplayText = (ee.RowHandle + 1).ToString(); |
| | | }; |
| | | this.repositoryItemSearchLookUpEdit1.DataSource = dt; |
| | | // repositoryItemSearchLookUpEdit1.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; |
| | | //repositoryItemSearchLookUpEdit1.PopupFormSize = new System.Drawing.Size(500, 300); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | MsgHelper.ShowError("提示:" + ex.Message); |
| | | } |
| | | } |
| | | |
| | | private void GridView1_ColumnFilterChanged(object sender, EventArgs e) |
| | |
| | | _ucHzlx = dy.qt025; |
| | | _ucHz = dy.qt018; |
| | | _ucGys = dy.wwgys;//委外供应商 |
| | | // ucLookHuoZhu1.OrgId = _orgId; |
| | | // ucLookHuoZhu1.OrgId = _orgId; |
| | | ucLookHuoZhu1.HzId = _ucHz; |
| | | ucLookHuoZhu1.SetHzLx(_ucHzlx); |
| | | ucLookHuoZhu1.SetHzId(_ucHz); |