public void GetAllList_BRANCH() { Class.PhongBan dm = new Class.PhongBan(); DataTable dt = dm.LoadDanhSachChiNhanh(); if (dt.Rows.Count > 0) { txtBranchName.Properties.DataSource = dt; txtBranchName.Properties.DisplayMember = "BranchName"; txtBranchName.Properties.ValueMember = "BranchCode"; } }
public void GetListDEPARTMENTByBranch(string strCode) { Class.PhongBan dm = new Class.PhongBan(); dm.BranchCode = strCode; DataTable dt = dm.LoadDanhSachPhongBanThuocChiNhanh(); if (dt.Rows.Count > 0) { txtDepartment.Properties.DataSource = dt; txtDepartment.Properties.DisplayMember = "DepartmentName"; txtDepartment.Properties.ValueMember = "DepartmentCode"; } }
private void btnExportExcelTemplate_Click(object sender, EventArgs e) { // SaveFileDialog saveFile = new SaveFileDialog(); saveFile.Filter = "Excel File|*.xlsx"; saveFile.Title = "Exprot to Excel File"; saveFile.ShowDialog(); if (saveFile.FileName != "") { Waiting.ShowWaitForm(); string Link_Template = Application.StartupPath + "\\Templates\\Templates_ChiTietChamCong.xlsx"; Class.PhongBan pb = new Class.PhongBan(); DataTable dtpb = pb.GetAllList_DEPARTMENT(); if (System.IO.File.Exists(Link_Template)) { // Class.ExportDataToExcel.ExportExcel_CTCC(dtxp, dtpb, 4, "A", true, Link_Template, saveFile.FileName, false); Waiting.CloseWaitForm(); } } }