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("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());
}
//绑定供应商
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());
}
}
/// <summary>
/// 加载数据
/// </summary>
/// <param name="MaterialGuid"></param>
private void FillData(string DeptGuid)
{
DeptManage Deptmanage = new DeptManage();
DataTable dtl = Deptmanage.GetDeptData(DeptGuid);
if (dtl.Rows.Count > 0)
{
txtGuid.Text = dtl.Rows[0]["DeptGuid"].ToString();
txtDeptName.Text = dtl.Rows[0]["DeptName"].ToString();
txtDeptPerson.Text = dtl.Rows[0]["DeptPerson"].ToString();
txtTelephone.Text = dtl.Rows[0]["Telephone"].ToString();
txtFax.Text = dtl.Rows[0]["Fax"].ToString();
txtAddress.Text = dtl.Rows[0]["Address"].ToString();
if (dtl.Rows[0]["IsEnable"].ToString() == "1")
{
chkIsEnable.Checked = true;
}
else
{
chkIsEnable.Checked = false;
}
}
this.ShowDialog();
}
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("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());
}
}
/// <summary>
/// 绑定下拉列表框，通用方法
/// </summary>
public void cboDataBind(ComboBox obj)
{
DeptManage dm = new DeptManage();
DataTable dtl = dm.GetDeptData();
ListItem item;
for (int i = 0; i < dtl.Rows.Count; i++)
{
item = new ListItem();
item.Text = dtl.Rows[i]["部门名称"].ToString();
item.Value = dtl.Rows[i]["DeptGuid"].ToString();
obj.Items.Add(item);
}
}
/// <summary>
/// 数据选择：1:员工 2:部门 3:供应商 4:客户
/// </summary>
/// <param name="flag"></param>
public void ShowSelectData(int flag)
{
intFlag = flag;
DataTable dtl = new DataTable();
switch (flag)
{
case 2: //部门
DeptManage DeptManage = new DeptManage();
dtl = DeptManage.GetDeptDataBySelect2();
gridControl1.DataSource = dtl;
gridView1.Columns[1].Caption = "部门名称";
this.Text = "部门选择";
break;
}
this.ShowDialog();
}
/// <summary>
/// 数据选择：1:员工 2:部门 3:供应商 4:客户
/// </summary>
/// <param name="flag"></param>
public void ShowSelectData(int flag)
{
intFlag = flag;
DataTable dtl = new DataTable();
switch (flag)
{
case 1: //员工
EmployeeManage EmployeeManage = new EmployeeManage();
dtl = EmployeeManage.GetEmployeeDataBySelect();
gridControl1.DataSource = dtl;
gridView1.Columns[1].Caption = "员工编号";
gridView1.Columns[2].Caption = "员工姓名";
gridView1.Columns[3].Caption = "部门";
this.Text = "员工选择";
break;
case 2: //部门
DeptManage DeptManage = new DeptManage();
dtl = DeptManage.GetDeptDataBySelect();
gridControl1.DataSource = dtl;
gridView1.Columns[1].Caption = "部门名称";
this.Text = "部门选择";
break;
case 3: //供应商
SupplierManage SupplierManage = new SupplierManage();
dtl = SupplierManage.GetSupplierDataBySelect();
gridControl1.DataSource = dtl;
gridView1.Columns[1].Caption = "供应商名称";
this.Text = "供应商选择";
break;
case 4: //客户
ClientManage ClientManage = new ClientManage();
dtl = ClientManage.GetClientDataBySelect();
gridControl1.DataSource = dtl;
gridView1.Columns[1].Caption = "客户名称";
this.Text = "客户选择";
break;
}
gridView1.Columns[0].Visible = false;
this.ShowDialog();
}
private void frmBill_Load(object sender, EventArgs e)
{
BeginDate.Text = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-01";
endDate.Text = DateTime.Now.ToShortDateString();
//绑定部门
DeptManage DeptManage = new DeptManage();
DataTable dtl = DeptManage.GetDeptData();
if (dtl.Rows.Count > 0)
{
for (int i = 0; i < dtl.Rows.Count; i++)
{
cboDept.Items.Add(dtl.Rows[i]["部门名称"].ToString());
}
cboDept.SelectedIndex = 0;
}
}
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());
}
}
}
