private void frmBill_Load(object sender, EventArgs e)
{
BeginDate.Text = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-01";
endDate.Text = DateTime.Now.ToShortDateString();
LoadBill();
//绑定仓库
DepotManage DepotManage = new DepotManage();
DataTable dtl = DepotManage.GetDepotData();
cboDepot.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboDepot.Items.Add(dtl.Rows[i]["仓库名称"].ToString());
}
//绑定类型
dtl = DepotManage.GetStorageTypeData("E");
cboStorageType.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboStorageType.Items.Add(dtl.Rows[i]["StorageTypeName"].ToString());
}
//绑定部门
DeptManage DeptManage = new DeptManage();
dtl = DeptManage.GetDeptData();
cboDept.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboDept.Items.Add(dtl.Rows[i]["部门名称"].ToString());
}
//绑定经手人
EmployeeManage EmployeeManage = new EmployeeManage();
dtl = EmployeeManage.GetEmployeeData();
cboHandlePerson.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboHandlePerson.Items.Add(dtl.Rows[i]["员工姓名"].ToString());
}
//绑定供应商
ClientManage ClientManage = new ClientManage();
dtl = ClientManage.GetClientData();
cboSupplier.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboSupplier.Items.Add(dtl.Rows[i]["客户名称"].ToString());
}
}
//载入货品数据
public void LoadClient()
{
DataTable dtl = ClientManage.GetClientData();
gridControl1.DataSource = dtl;
gridView1.Columns[0].Visible = false;
}
private void frmBill_Load(object sender, EventArgs e)
{
LoadBill();
//绑定仓库
DepotManage DepotManage = new DepotManage();
DataTable dtl = DepotManage.GetDepotData();
cboDepot.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboDepot.Items.Add(dtl.Rows[i]["仓库名称"].ToString());
}
//绑定类型
dtl = DepotManage.GetStorageTypeData("I");
cboStorageType.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboStorageType.Items.Add(dtl.Rows[i]["StorageTypeName"].ToString());
}
//绑定部门
DeptManage DeptManage = new DeptManage();
dtl = DeptManage.GetDeptData();
cboDept.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboDept.Items.Add(dtl.Rows[i]["部门名称"].ToString());
}
//绑定经手人
EmployeeManage EmployeeManage = new EmployeeManage();
dtl = EmployeeManage.GetEmployeeData();
cboHandlePerson.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboHandlePerson.Items.Add(dtl.Rows[i]["员工姓名"].ToString());
}
//绑定客户
ClientManage ClientManage = new ClientManage();
dtl = ClientManage.GetClientData();
cboSupplier.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboSupplier.Items.Add(dtl.Rows[i]["客户名称"].ToString());
}
}
private void CboBind(string flag)
{
//绑定仓库
DepotManage DepotManage = new DepotManage();
DataTable dtl = DepotManage.GetDepotData();
cboDepot.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboDepot.Items.Add(dtl.Rows[i]["仓库名称"].ToString());
}
//绑定类型
dtl = DepotManage.GetStorageTypeData(flag);
cboStorageType.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboStorageType.Items.Add(dtl.Rows[i]["StorageTypeName"].ToString());
}
//绑定部门
DeptManage DeptManage = new DeptManage();
dtl = DeptManage.GetDeptData();
cboDept.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboDept.Items.Add(dtl.Rows[i]["部门名称"].ToString());
}
//绑定经手人
EmployeeManage EmployeeManage = new EmployeeManage();
dtl = EmployeeManage.GetEmployeeData();
cboHandlePerson.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboHandlePerson.Items.Add(dtl.Rows[i]["员工姓名"].ToString());
}
//绑定供应商
if (flag == "I")
{
SupplierManage SupplierManage = new SupplierManage();
dtl = SupplierManage.GetSupplierData();
cboSupplier.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboSupplier.Items.Add(dtl.Rows[i]["供应商名称"].ToString());
}
}
else
{
ClientManage ClientManage = new ClientManage();
dtl = ClientManage.GetClientData();
cboSupplier.Items.Add("");
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboSupplier.Items.Add(dtl.Rows[i]["客户名称"].ToString());
}
}
}