private void RefreshComBo() { BDCH_new tscl0 = new BDCH_new("0", "0"); BDCH_new tscl1 = new BDCH_new("1", "1"); List <BDCH_new> listtscl = new List <BDCH_new>(); listtscl.Add(tscl0); listtscl.Add(tscl1); comboBDCHBZ.DataSource = listtscl; comboBDCHBZ.DisplayMember = "name"; comboBDCHBZ.ValueMember = "flag"; //此处应该根据单位代码反查单位名称,IT_MRP String selectsql = "select distinct t.FS_USEDEPART from BT_CARDMANAGE t where t.FS_SECONDDEPART='" + departmentcode + "'"; DataTable testdatatable = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.carcard.CarCard"; ccp.MethodName = "queryByClientSql"; ccp.ServerParams = new object[] { selectsql }; ccp.SourceDataTable = testdatatable; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (testdatatable.Rows.Count > 0) { DataRow newrow = testdatatable.NewRow(); newrow["FS_USEDEPART"] = ""; testdatatable.Rows.InsertAt(newrow, 0);//加入一个空值 comboCKDW.DataSource = testdatatable; comboCKDW.DisplayMember = "FS_USEDEPART"; } }
private void RefreshComBo() { BDCH_new tscl0 = new BDCH_new("0", "0"); BDCH_new tscl1 = new BDCH_new("1", "1"); List<BDCH_new> listtscl = new List<BDCH_new>(); listtscl.Add(tscl0); listtscl.Add(tscl1); comboBDCHBZ.DataSource = listtscl; comboBDCHBZ.DisplayMember = "name"; comboBDCHBZ.ValueMember = "flag"; //此处应该根据单位代码反查单位名称,IT_MRP String selectsql = "select distinct t.FS_USEDEPART from BT_CARDMANAGE t where t.FS_SECONDDEPART='" + departmentcode + "'"; DataTable testdatatable = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.carcard.CarCard"; ccp.MethodName = "queryByClientSql"; ccp.ServerParams = new object[] { selectsql }; ccp.SourceDataTable = testdatatable; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (testdatatable.Rows.Count > 0) { DataRow newrow = testdatatable.NewRow(); newrow["FS_USEDEPART"] = ""; testdatatable.Rows.InsertAt(newrow, 0);//加入一个空值 comboCKDW.DataSource = testdatatable; comboCKDW.DisplayMember = "FS_USEDEPART"; } }