| | |
| | | InitializeComponent(); |
| | | txt_hzabc.Properties.NullText = "请选择货主"; |
| | | txt_hzlxabc.Properties.NullText = "请选择货主类型"; |
| | | //先读取组织列表 |
| | | getData(0); |
| | | this.txt_hzlxabc.SelectedIndexChanged += (s, e) => |
| | | { |
| | | txt_hzabc.EditValue = null; |
| | | int _strType = txt_hzlxabc.SelectedIndex; |
| | | string _orgId = OrgId; |
| | | this.searchLookUpEdit1View.Columns.Clear(); |
| | | txt_hzabc.Properties.DataSource = null; |
| | | if (_strType <= 0) return; |
| | | string _strMeth = ""; |
| | | string _DisplayMember = ""; |
| | | string _ValueMember = ""; |
| | | PageQueryModel pgq = new PageQueryModel(1, 999999, "", "", "", ""); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn5 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | switch (_strType) |
| | | { |
| | | case 1://组织 |
| | | pgq = new PageQueryModel(1, 999999, "FID", "asc", "", " and IS_STATUS=1"); |
| | | _strMeth = "Organization/GetListPage"; |
| | | _DisplayMember = "name"; |
| | | _ValueMember = "fid"; |
| | | gridColumn1.Caption = "组织ID"; |
| | | gridColumn1.FieldName = "fid"; |
| | | gridColumn1.Name = "gridColumn1"; |
| | | gridColumn5.Caption = "组织名称"; |
| | | gridColumn5.FieldName = "name"; |
| | | gridColumn5.Name = "gridColumn5"; |
| | | gridColumn5.Visible = true; |
| | | gridColumn2.Caption = "组织编号"; |
| | | gridColumn2.FieldName = "fNumber"; |
| | | gridColumn2.MinWidth = 80; |
| | | gridColumn2.Name = "gridColumn2"; |
| | | gridColumn2.UnboundDataType = typeof(string); |
| | | gridColumn2.Visible = true; |
| | | gridColumn2.VisibleIndex = 1; |
| | | gridColumn2.Width = 80; |
| | | gridColumn4.Caption = "guid"; |
| | | gridColumn4.FieldName = "guid"; |
| | | gridColumn4.Name = "gridColumn4"; |
| | | break; |
| | | case 2://供应商 |
| | | pgq = new PageQueryModel(1, 999999, "org.FNumber asc ,a.supp_no", "asc", "", " and a.FSubsidiary ='" + _orgId + "'"); |
| | | _strMeth = "MesSupplierManager/GetListPage"; |
| | | _DisplayMember = "suppName"; |
| | | _ValueMember = "id"; |
| | | gridColumn5.Caption = "使用组织"; |
| | | gridColumn5.FieldName = "fSubsidiary"; |
| | | gridColumn5.Name = "gridColumn5"; |
| | | gridColumn5.Visible = true; |
| | | gridColumn5.VisibleIndex = 0; |
| | | gridColumn1.Caption = "供应商ID"; |
| | | gridColumn1.FieldName = "id"; |
| | | gridColumn1.MaxWidth = 100; |
| | | gridColumn1.MinWidth = 80; |
| | | gridColumn1.Name = "gridColumn1"; |
| | | gridColumn1.UnboundDataType = typeof(string); |
| | | gridColumn1.Width = 100; |
| | | gridColumn2.Caption = "供应商编号"; |
| | | gridColumn2.FieldName = "suppNo"; |
| | | gridColumn2.MinWidth = 80; |
| | | gridColumn2.Name = "gridColumn2"; |
| | | gridColumn2.Visible = true; |
| | | gridColumn2.VisibleIndex = 2; |
| | | gridColumn2.Width = 80; |
| | | gridColumn3.Caption = "供应商名称"; |
| | | gridColumn3.FieldName = "suppName"; |
| | | gridColumn3.MinWidth = 100; |
| | | gridColumn3.Name = "gridColumn3"; |
| | | gridColumn3.Visible = true; |
| | | gridColumn3.VisibleIndex = 1; |
| | | gridColumn3.Width = 100; |
| | | gridColumn4.Caption = "guid"; |
| | | gridColumn4.FieldName = "guid"; |
| | | gridColumn4.Name = "gridColumn4"; |
| | | break; |
| | | case 3://客户 |
| | | pgq = new PageQueryModel(1, 999999, "org.FNumber asc ,a.cust_no", "asc", "", " and a.FSubsidiary ='" + _orgId + "'"); |
| | | _strMeth = "MesCustomerManager/GetListPage"; |
| | | _DisplayMember = "custName"; |
| | | _ValueMember = "id"; |
| | | gridColumn5.Caption = "所在组织"; |
| | | gridColumn5.FieldName = "fSubsidiary"; |
| | | gridColumn5.MinWidth = 200; |
| | | gridColumn5.Name = "gridColumn5"; |
| | | gridColumn5.Visible = true; |
| | | gridColumn5.VisibleIndex = 0; |
| | | gridColumn5.Width = 200; |
| | | gridColumn1.Caption = "客户ID"; |
| | | gridColumn1.FieldName = "id"; |
| | | gridColumn1.MinWidth = 50; |
| | | gridColumn1.Name = "gridColumn1"; |
| | | gridColumn1.Visible = true; |
| | | gridColumn1.VisibleIndex = 1; |
| | | gridColumn2.Caption = "客户编号"; |
| | | gridColumn2.FieldName = "custNo"; |
| | | gridColumn2.MinWidth = 80; |
| | | gridColumn2.Name = "gridColumn2"; |
| | | gridColumn2.Visible = true; |
| | | gridColumn2.VisibleIndex = 2; |
| | | gridColumn2.Width = 80; |
| | | gridColumn3.Caption = "客户名称"; |
| | | gridColumn3.FieldName = "custName"; |
| | | gridColumn3.MinWidth = 100; |
| | | gridColumn3.Name = "gridColumn3"; |
| | | gridColumn3.Visible = true; |
| | | gridColumn3.VisibleIndex = 3; |
| | | gridColumn3.Width = 100; |
| | | gridColumn4.Caption = "guid"; |
| | | gridColumn4.FieldName = "guid"; |
| | | gridColumn4.Name = "gridColumn4"; |
| | | break; |
| | | } |
| | | this.searchLookUpEdit1View.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { |
| | | gridColumn1, |
| | | gridColumn5, |
| | | gridColumn3, |
| | | gridColumn2, |
| | | gridColumn4 }); |
| | | var json = JsonConvert.SerializeObject(pgq); |
| | | try |
| | | { |
| | | var strReturn = UtilityHelper.HttpPost("", _strMeth, json); |
| | | var rtn = UtilityHelper.ReturnToTablePage(strReturn); |
| | | var dt = rtn.rtnData.list; |
| | | txt_hzabc.Properties.DataSource = dt; |
| | | txt_hzabc.Properties.DisplayMember = _DisplayMember; |
| | | txt_hzabc.Properties.ValueMember = _ValueMember; |
| | | txt_hzabc.ForceInitialize(); |
| | | txt_hzabc.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; |
| | | if (!string.IsNullOrEmpty(HzId)) |
| | | SetHzId(HzId); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | MsgHelper.Warning("提示:" + ex.Message); |
| | | } |
| | | getData(_strType); |
| | | }; |
| | | } |
| | | |
| | |
| | | /// <returns></returns> |
| | | public string GetHzLx() |
| | | { |
| | | if (txt_hzlxabc.SelectedIndex <= 0) |
| | | if (txt_hzlxabc.SelectedIndex < 0) |
| | | return ""; |
| | | string id = txt_hzlxabc.Text.Trim(); |
| | | return id; |
| | |
| | | else |
| | | txt_hzlxabc.Text = Code; |
| | | } |
| | | |
| | | private void getData(int _strType) |
| | | { |
| | | txt_hzabc.EditValue = null; |
| | | string _orgId = OrgId; |
| | | this.searchLookUpEdit1View.Columns.Clear(); |
| | | txt_hzabc.Properties.DataSource = null; |
| | | if (_strType < 0) return; |
| | | string _strMeth = ""; |
| | | string _DisplayMember = ""; |
| | | string _ValueMember = ""; |
| | | PageQueryModel pgq = new PageQueryModel(1, 999999, "", "", "", ""); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn5 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | DevExpress.XtraGrid.Columns.GridColumn gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn(); |
| | | switch (_strType) |
| | | { |
| | | case 0://组织 |
| | | pgq = new PageQueryModel(1, 999999, "FID", "asc", "", " and IS_STATUS=1"); |
| | | _strMeth = "Organization/GetListPage"; |
| | | _DisplayMember = "name"; |
| | | _ValueMember = "fid"; |
| | | gridColumn1.Caption = "组织ID"; |
| | | gridColumn1.FieldName = "fid"; |
| | | gridColumn1.Name = "gridColumn1"; |
| | | gridColumn5.Caption = "组织名称"; |
| | | gridColumn5.FieldName = "name"; |
| | | gridColumn5.Name = "gridColumn5"; |
| | | gridColumn5.Visible = true; |
| | | gridColumn2.Caption = "组织编号"; |
| | | gridColumn2.FieldName = "fNumber"; |
| | | gridColumn2.MinWidth = 80; |
| | | gridColumn2.Name = "gridColumn2"; |
| | | gridColumn2.UnboundDataType = typeof(string); |
| | | gridColumn2.Visible = true; |
| | | gridColumn2.VisibleIndex = 1; |
| | | gridColumn2.Width = 80; |
| | | gridColumn4.Caption = "guid"; |
| | | gridColumn4.FieldName = "guid"; |
| | | gridColumn4.Name = "gridColumn4"; |
| | | break; |
| | | case 1://供应商 |
| | | pgq = new PageQueryModel(1, 999999, "org.FNumber asc ,a.supp_no", "asc", "", " and a.FSubsidiary ='" + _orgId + "'"); |
| | | _strMeth = "MesSupplierManager/GetListPage"; |
| | | _DisplayMember = "suppName"; |
| | | _ValueMember = "id"; |
| | | gridColumn5.Caption = "使用组织"; |
| | | gridColumn5.FieldName = "fSubsidiary"; |
| | | gridColumn5.Name = "gridColumn5"; |
| | | gridColumn5.Visible = true; |
| | | gridColumn5.VisibleIndex = 0; |
| | | gridColumn1.Caption = "供应商ID"; |
| | | gridColumn1.FieldName = "id"; |
| | | gridColumn1.MaxWidth = 100; |
| | | gridColumn1.MinWidth = 80; |
| | | gridColumn1.Name = "gridColumn1"; |
| | | gridColumn1.UnboundDataType = typeof(string); |
| | | gridColumn1.Width = 100; |
| | | gridColumn2.Caption = "供应商编号"; |
| | | gridColumn2.FieldName = "suppNo"; |
| | | gridColumn2.MinWidth = 80; |
| | | gridColumn2.Name = "gridColumn2"; |
| | | gridColumn2.Visible = true; |
| | | gridColumn2.VisibleIndex = 2; |
| | | gridColumn2.Width = 80; |
| | | gridColumn3.Caption = "供应商名称"; |
| | | gridColumn3.FieldName = "suppName"; |
| | | gridColumn3.MinWidth = 100; |
| | | gridColumn3.Name = "gridColumn3"; |
| | | gridColumn3.Visible = true; |
| | | gridColumn3.VisibleIndex = 1; |
| | | gridColumn3.Width = 100; |
| | | gridColumn4.Caption = "guid"; |
| | | gridColumn4.FieldName = "guid"; |
| | | gridColumn4.Name = "gridColumn4"; |
| | | break; |
| | | case 2://客户 |
| | | pgq = new PageQueryModel(1, 999999, "org.FNumber asc ,a.cust_no", "asc", "", " and a.FSubsidiary ='" + _orgId + "'"); |
| | | _strMeth = "MesCustomerManager/GetListPage"; |
| | | _DisplayMember = "custName"; |
| | | _ValueMember = "id"; |
| | | gridColumn5.Caption = "所在组织"; |
| | | gridColumn5.FieldName = "fSubsidiary"; |
| | | gridColumn5.MinWidth = 200; |
| | | gridColumn5.Name = "gridColumn5"; |
| | | gridColumn5.Visible = true; |
| | | gridColumn5.VisibleIndex = 0; |
| | | gridColumn5.Width = 200; |
| | | gridColumn1.Caption = "客户ID"; |
| | | gridColumn1.FieldName = "id"; |
| | | gridColumn1.MinWidth = 50; |
| | | gridColumn1.Name = "gridColumn1"; |
| | | gridColumn1.Visible = true; |
| | | gridColumn1.VisibleIndex = 1; |
| | | gridColumn2.Caption = "客户编号"; |
| | | gridColumn2.FieldName = "custNo"; |
| | | gridColumn2.MinWidth = 80; |
| | | gridColumn2.Name = "gridColumn2"; |
| | | gridColumn2.Visible = true; |
| | | gridColumn2.VisibleIndex = 2; |
| | | gridColumn2.Width = 80; |
| | | gridColumn3.Caption = "客户名称"; |
| | | gridColumn3.FieldName = "custName"; |
| | | gridColumn3.MinWidth = 100; |
| | | gridColumn3.Name = "gridColumn3"; |
| | | gridColumn3.Visible = true; |
| | | gridColumn3.VisibleIndex = 3; |
| | | gridColumn3.Width = 100; |
| | | gridColumn4.Caption = "guid"; |
| | | gridColumn4.FieldName = "guid"; |
| | | gridColumn4.Name = "gridColumn4"; |
| | | break; |
| | | } |
| | | this.searchLookUpEdit1View.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { |
| | | gridColumn1, |
| | | gridColumn5, |
| | | gridColumn3, |
| | | gridColumn2, |
| | | gridColumn4 }); |
| | | var json = JsonConvert.SerializeObject(pgq); |
| | | try |
| | | { |
| | | var strReturn = UtilityHelper.HttpPost("", _strMeth, json); |
| | | var rtn = UtilityHelper.ReturnToTablePage(strReturn); |
| | | var dt = rtn.rtnData.list; |
| | | txt_hzabc.Properties.DataSource = dt; |
| | | txt_hzabc.Properties.DisplayMember = _DisplayMember; |
| | | txt_hzabc.Properties.ValueMember = _ValueMember; |
| | | txt_hzabc.ForceInitialize(); |
| | | txt_hzabc.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; |
| | | if (!string.IsNullOrEmpty(HzId)) |
| | | SetHzId(HzId); |
| | | //增加时,默认组织beg |
| | | if (_strType == 0) |
| | | { |
| | | string userGuid = LoginInfoModel.CurrentUser.LoginUserGuid; |
| | | var pgq66 = new PageQueryModel(1, 999999, "FID", "asc", userGuid, " and IS_STATUS=1"); |
| | | var json66 = JsonConvert.SerializeObject(pgq66); |
| | | try |
| | | { |
| | | var strReturn66 = UtilityHelper.HttpPost("", "Organization/GetListPage", json66); |
| | | var _obj = UtilityHelper.ReturnToDynamic(strReturn66); |
| | | string _extendText = _obj.rtnData.extendText; |
| | | string[] _dftOrg = _extendText.Split(','); |
| | | if (_dftOrg.Length > 0) |
| | | { |
| | | txt_hzabc.EditValue = (_dftOrg[0].Trim()); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | } |
| | | } |
| | | //增加时,默认组织end |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | MsgHelper.Warning("提示:" + ex.Message); |
| | | } |
| | | } |
| | | } |
| | | } |