using DevExpress.XtraEditors; using Gs.DevApp.Entity; using Gs.DevApp.ToolBox; using Newtonsoft.Json; using System; using System.Data; namespace Gs.DevApp.UserControl { public partial class UcLookHuoZhu : DevExpress.XtraEditors.XtraUserControl { /// /// /// public string OrgId { get; set; } public string HzId { get; set; } public bool IsReadly { set; get; } public UcLookHuoZhu() { InitializeComponent(); txt_hzabc.Properties.NullText = "请选择货主"; txt_hzlxabc.Properties.NullText = "请选择货主类型"; 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); } }; } /// /// 读取货主id /// /// public string GetHzId() { var row2 = txt_hzabc.GetSelectedDataRow() as DataRowView; if (row2 != null) { string inHz = txt_hzlxabc.SelectedIndex > 1 ? row2["Id"].ToString() : row2["fid"].ToString(); return inHz; } return ""; } /// /// 读取货主类型 /// /// public string GetHzLx() { if (txt_hzlxabc.SelectedIndex <= 0) return ""; string id = txt_hzlxabc.Text.Trim(); return id; } /// /// 设置 /// /// public void SetHzId(string Code) { if (Code == "-1" || string.IsNullOrEmpty(Code)) { txt_hzabc.EditValue = null; return; } txt_hzabc.EditValue = Int64.Parse(((Code.ToString().Trim()))); txt_hzabc.Text = Code; } /// /// 设置 /// /// public void SetHzLx(string Code) { if (string.IsNullOrEmpty(Code)) txt_hzlxabc.SelectedIndex = 0; else txt_hzlxabc.Text = Code; } } }