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";
}
}
