//自定义绑定数据
private void requistionDate(string sql)
{
this.dataGridViewCK.AutoGenerateColumns = false;// 关闭自动创建列
HY_BLL.HY_StorageBLL hystorfobll = new HY_StorageBLL();
this.dataGridViewCK.DataSource = hystorfobll.ExecuteQuerySelect(sql);
}
//绑定产品类别
private void cp_Class()
{
HY_BLL.HY_StorageBLL hystorbll = new HY_StorageBLL();
string sql = "select * from HY_CPClass order by c_ID desc";
this.listBoxClass.DataSource = hystorbll.ExecuteQuerySelect(sql);
this.listBoxClass.DisplayMember = "c_Class";
this.listBoxClass.ValueMember = "c_ID";
}
//绑定产品类别
private void c_Class()
{
//HY_BLL.HY_StorageBLL hystorbll = new HY_StorageBLL();
string sql = "select * from HY_CPClass order by c_ID desc";
this.s_Class.DataSource = hystorbll.ExecuteQuerySelect(sql);
this.s_Class.DisplayMember = "c_Class";
this.s_Class.ValueMember = "c_ID";
}
//自定义绑定数据
private void requistionDate(string sql)
{
this.dataGridViewCK.AutoGenerateColumns = false;// 关闭自动创建列
this.dataGridViewCK.DataSource = hystorfobll.ExecuteQuerySelect(sql);
}
//自定义绑定数据
private void requistionDate()
{
this.dataGridViewCK.AutoGenerateColumns = false;// 关闭自动创建列
HY_BLL.HY_StorageBLL hystorfobll = new HY_StorageBLL();
string sql = "select s_ID,s_DID,s_CID,s_Supplier,s_Person,s_Class,s_Warehouse,s_XDate,s_DDate,s_PID,s_Pname,s_Origin,s_Specifications,s_Amount,s_Price,s_Notes,(s_Amount*s_Price) as ABV,s_WFDate,s_DWDate,s_WFSup,s_WFDateHot,s_DWDateHot,s_WFHotSup,s_WFDateBM,s_DWDateBM,s_WFSupBM from HY_Storage order by s_ID desc";
this.dataGridViewCK.DataSource = hystorfobll.ExecuteQuerySelect(sql);
}