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()); } }
private void frmCheckBill_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()); } //绑定经手人 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()); } }
private void CboBind() { //绑定仓库 DepotManage DepotManage = new DepotManage(); DataTable dtl = DepotManage.GetDepotData(); cboDepotOut.Items.Add(""); for (int i = 0; i < dtl.Rows.Count; i++) { cboDepotOut.Items.Add(dtl.Rows[i]["仓库名称"].ToString()); } //绑定仓库 dtl = DepotManage.GetDepotData(); cboDepotIn.Items.Add(""); for (int i = 0; i < dtl.Rows.Count; i++) { cboDepotIn.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()); } }
//载入货品数据 public void LoadEmployee() { DataTable dtl = EmployeeManage.GetEmployeeData(); 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("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> /// <param name="MaterialGuid"></param> private void FillData(string EmployeeGuid) { EmployeeManage Employeemanage = new EmployeeManage(); DataTable dtl = Employeemanage.GetEmployeeData(EmployeeGuid); if (dtl.Rows.Count > 0) { txtGuid.Text = dtl.Rows[0]["EmpGuid"].ToString(); txtEmpId.Text = dtl.Rows[0]["EmpID"].ToString(); txtEmpName.Text = dtl.Rows[0]["EmpName"].ToString(); txtTelephone.Text = dtl.Rows[0]["Telephone"].ToString(); txtCardID.Text = dtl.Rows[0]["CardID"].ToString(); txtAddress.Text = dtl.Rows[0]["Address"].ToString(); txtDept.Text = dtl.Rows[0]["Dept"].ToString(); txtSex.Text = dtl.Rows[0]["Sex"].ToString(); } this.ShowDialog(); }
/// <summary> /// 加载数据 /// </summary> /// <param name="MaterialGuid"></param> private void FillData(string EmployeeGuid) { //绑定部门 cboDataBind(cboDept); EmployeeManage Employeemanage = new EmployeeManage(); DataTable dtl = Employeemanage.GetEmployeeData(EmployeeGuid); if (dtl.Rows.Count > 0) { txtGuid.Text = dtl.Rows[0]["EmpGuid"].ToString(); txtEmpId.Text = dtl.Rows[0]["EmpID"].ToString(); txtEmpName.Text = dtl.Rows[0]["EmpName"].ToString(); txtTelephone.Text = dtl.Rows[0]["Telephone"].ToString(); txtCardID.Text = dtl.Rows[0]["CardID"].ToString(); txtAddress.Text = dtl.Rows[0]["Address"].ToString(); txtSex.Text = dtl.Rows[0]["Sex"].ToString(); if (dtl.Rows[0]["IsEnable"].ToString() == "1") { chkIsEnable.Checked = true; } else { chkIsEnable.Checked = false; } for (int i = 0; i < cboDept.Items.Count; i++) { ListItem item = cboDept.Items[i] as ListItem; if (item.Value.Trim() == dtl.Rows[0]["Dept"].ToString().Trim()) { cboDept.SelectedIndex = i; break; } } } this.ShowDialog(); }
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()); } } }