protected void LoadData(bool onlyPayGroup) { currRows.Clear(); CreateWaitDialog("正在查询...", "请稍等"); //清除原来的数据 List <PrivateSalary> rows = PrivateSalary.GetPrivateSalarys(null, (string)cbb日历组.EditValue); foreach (PrivateSalary row in rows) { if (myPayGroupList.Find(a => a.英文名 == row.薪资组.Trim()) != null) { currRows.Add(row); } } if (onlyPayGroup) { currRows = currRows.FindAll(a => a.薪资组 == (string)cb薪资组.EditValue); SetButtonEnabled(); } //排序 currRows = currRows.OrderBy(a => a.基础工资表.财务公司).ThenBy(a => a.基础工资表.财务部门序号).ThenBy(a => a.基础工资表.员工序号).ToList(); CreateWaitDialog("正在加载...", "请稍等"); gridControl1.DataSource = currRows; gridControl1.RefreshDataSource(); CloseWaitDialog(); SetButtonEnabled(); gridView1.ExpandAllGroups(); }
protected void LoadData() { string accType = cb账户类型.EditValue as string; string calRunId = cbb日历组.EditValue as string; CreateWaitDialog("正在查询...", "请稍等"); List <PrivateSalary> rows = new List <PrivateSalary>(); string errMsg = ""; foreach (PayGroup payGroup in myPayGroupList) { SalaryAuditingResult checkInfo = SalaryAuditingResult.GetSalaryAuditingResult(payGroup.英文名, calRunId); if (checkInfo != null) { if (checkInfo.已审核) { rows.AddRange(PrivateSalary.GetPrivateSalarys(payGroup.英文名, calRunId)); continue; } else { errMsg = String.Format("薪资组【{0}】的工资表未审核\n", payGroup.中文名); } } } if (errMsg != "") { CloseWaitDialog(); MessageBox.Show(errMsg, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //生成报盘记录 currRows = rows; //排序 currRows = currRows.OrderBy(a => a.基础工资表.财务公司).ThenBy(a => a.基础工资表.财务部门序号).ThenBy(a => a.基础工资表.员工序号).ToList(); CreateWaitDialog("正在加载...", "请稍等"); pivotGridControl1.DataSource = currRows; CloseWaitDialog(); CalRunInfo cal = CalRunInfo.Get(calRunId); 当前期间 = String.Format("{0}年{1}", cal.年度, cal.月份) + "月"; 当前账号 = cb账户类型.Text; }
protected void LoadData() { CreateWaitDialog("正在查询...", "请稍等"); List <PrivateSalary> rows = new List <PrivateSalary>(); foreach (PayGroup payGroup in AccessController.我管理的薪资组) { rows.AddRange(PrivateSalary.GetPrivateSalarys(Convert.ToInt32(year.Value), Convert.ToInt32(month.Text), ccb发放单位.Text, payGroup.英文名)); } //过滤 rows = rows.FindAll(a => a.封闭工资账号.银行名称 == ccb银行.Text).ToList(); //排序 rows = rows.OrderBy(a => a.基础工资表.财务公司).ThenBy(a => a.基础工资表.财务部门序号).ThenBy(a => a.基础工资表.员工序号).ToList(); int currOrder = 1; foreach (PrivateSalary item in rows) { item.序号 = currOrder++; } CreateWaitDialog("正在加载...", "请稍等"); if (ccb银行.Text == "中信银行") { documentViewer1.PrintingSystem = zx_report.PrintingSystem; zx_report.银行名称 = ccb银行.Text; zx_report.工资表 = rows; zx_report.BindData(); zx_report.CreateDocument(false); } else { documentViewer1.PrintingSystem = report.PrintingSystem; report.银行名称 = ccb银行.Text; report.工资表 = rows; report.BindData(); report.CreateDocument(false); } CloseWaitDialog(); 当前期间 = String.Format("{0}年{1}", year.Value, month.Text) + "月"; }
protected void LoadData(string searchScope) { string calRunId = cbb日历组.EditValue as string; CreateWaitDialog("正在查询...", "请稍等"); List <PrivateSalary> rows = new List <PrivateSalary>(); foreach (PayGroup payGroup in AccessController.我管理的薪资组) { SalaryAuditingResult checkInfo = SalaryAuditingResult.GetSalaryAuditingResult(payGroup.英文名, calRunId); if (checkInfo != null) { rows.AddRange(PrivateSalary.GetPrivateSalarys(payGroup.英文名, calRunId)); } } switch (searchScope) { case "按发放单位": rows = rows.FindAll(a => a.基础工资表.财务公司 == (string)ccb发放单位.EditValue); break; case "按所属公司": rows = rows.FindAll(a => a.基础工资表.财务公司 == (string)ccb发放单位.EditValue && a.基础工资表.公司名称 == (string)ccb所属公司.EditValue); break; default: break; } //排序 rows = rows.OrderBy(a => a.基础工资表.财务公司).ThenBy(a => a.基础工资表.财务部门序号).ThenBy(a => a.基础工资表.员工序号).ToList(); CreateWaitDialog("正在加载...", "请稍等"); report.DataSource = rows; report.CreateDocument(true); CloseWaitDialog(); CalRunInfo cal = CalRunInfo.Get(calRunId); 当前期间 = String.Format("{0}年{1}", cal.年度, cal.月份) + "月"; }
protected void LoadData() { CreateWaitDialog("正在查询...", "请稍等"); List <PrivateSalary> rows = new List <PrivateSalary>(); foreach (PayGroup payGroup in AccessController.我管理的薪资组) { rows.AddRange(PrivateSalary.GetPrivateSalarys(Convert.ToInt32(year.Value), Convert.ToInt32(month.Text), ccb发放单位.Text, payGroup.英文名)); } //排序 rows = rows.OrderBy(a => a.基础工资表.财务公司).ThenBy(a => a.基础工资表.财务部门序号).ThenBy(a => a.基础工资表.员工序号).ToList(); CreateWaitDialog("正在加载...", "请稍等"); report.DataSource = rows; report.CreateDocument(false); CloseWaitDialog(); 当前期间 = String.Format("{0}年{1}", year.Value, month.Text) + "月"; }
protected void LoadData() { CreateWaitDialog("正在查询...", "请稍等"); List <PrivateSalary> rows = new List <PrivateSalary>(); foreach (PayGroup payGroup in AccessController.我管理的薪资组) { rows.AddRange(PrivateSalary.GetPrivateSalarys(Convert.ToInt32(year.Value), Convert.ToInt32(month.Text), ccb发放单位.Text, payGroup.英文名)); } //排序 rows = rows.OrderBy(a => a.基础工资表.财务公司).ThenBy(a => a.基础工资表.财务部门序号).ThenBy(a => a.基础工资表.员工序号).ToList(); CreateWaitDialog("正在加载...", "请稍等"); //2018-5-26 设置序号 int currOrder = 1; string lastCalDept = null; //上一个人的计算部门 foreach (PrivateSalary item in rows) { if (lastCalDept != item.基础工资表.财务部门) { currOrder = 1; } item.序号 = currOrder++; lastCalDept = item.基础工资表.财务部门; } report.DataSource = rows; report.CreateDocument(false); CloseWaitDialog(); 当前期间 = String.Format("{0}年{1}", year.Value, month.Text) + "月"; }
protected void LoadData() { string accType = cb账户类型.EditValue as string; CreateWaitDialog("正在查询...", "请稍等"); //生成报盘记录 currRows.Clear(); switch (accType) { case "A": case "D": List <SalaryResult> salaryList = new List <SalaryResult>(); //获取上表工资清单 foreach (PayGroup payGroup in AccessController.我管理的薪资组) { salaryList.AddRange(SalaryResult.GetSalaryResults(Convert.ToInt32(year.Value), Convert.ToInt32(month.Text), ccb发放单位.Text, payGroup.英文名)); } foreach (SalaryResult row in salaryList) { ToBankReportItem item = new ToBankReportItem(); item.账户类型 = accType; item.员工编号 = row.员工编号; item.员工姓名 = row.姓名; item.员工序号 = row.员工序号; item.部门序号 = row.财务部门序号; SetBankInfo(row.员工编号, accType, item); if (accType == "A") //上表 { item.金额 = row.实发工资总额; currRows.Add(item); } if (accType == "D" && row.未休年休假工资 > 0) //年休假 { item.金额 = row.未休年休假工资; currRows.Add(item); } } break; case "B": List <PrivateSalary> rows = new List <PrivateSalary>(); foreach (PayGroup payGroup in AccessController.我管理的薪资组) { rows.AddRange(PrivateSalary.GetPrivateSalarys(Convert.ToInt32(year.Value), Convert.ToInt32(month.Text), ccb发放单位.Text, payGroup.英文名)); } foreach (PrivateSalary row in rows) { ToBankReportItem item = new ToBankReportItem(); item.账户类型 = accType; item.员工编号 = row.员工编号; item.员工姓名 = row.姓名; item.部门序号 = row.基础工资表.财务部门序号; item.员工序号 = row.基础工资表.员工序号; item.金额 = row.本次实发工资; SetBankInfo(row.员工编号, accType, item); currRows.Add(item); } break; } //排序 currRows = currRows.OrderBy(a => a.部门序号).ThenBy(a => a.员工序号).ToList(); CreateWaitDialog("正在加载...", "请稍等"); gridControl1.DataSource = currRows; gridView1.ExpandAllGroups(); CloseWaitDialog(); 当前期间 = String.Format("{0}年{1}", year.Value, month.Text) + "月"; 当前账号 = cb账户类型.Text; }
protected void LoadData(bool onlyPayGroup) { currRows.Clear(); CreateWaitDialog("正在查询...", "请稍等"); //清除原来的数据 List <PrivateSalary> rows = PrivateSalary.GetPrivateSalarys(null, (string)cbb日历组.EditValue); foreach (PrivateSalary row in rows) { if (myPayGroupList.Find(a => a.英文名 == row.薪资组.Trim()) != null) { currRows.Add(row); } } if (onlyPayGroup) { currRows = currRows.FindAll(a => a.薪资组 == (string)cb薪资组.EditValue); SetButtonEnabled(); } //排序 currRows = currRows.OrderBy(a => a.基础工资表.财务公司).ThenBy(a => a.基础工资表.财务部门序号).ThenBy(a => a.基础工资表.员工序号).ToList(); //2018-5-24 设置序号 int currOrder = 1; string lastCalDept = null; //上一个人的计算部门 foreach (PrivateSalary item in currRows) { if (lastCalDept != item.基础工资表.财务部门) { currOrder = 1; } item.序号 = currOrder++; lastCalDept = item.基础工资表.财务部门; } CreateWaitDialog("正在加载...", "请稍等"); gridControl1.DataSource = currRows; gridControl1.RefreshDataSource(); CloseWaitDialog(); #region 显示审核信息 if (onlyPayGroup) { lbl审核人.Text = "审核人: "; lbl审核时间.Text = "审核时间: "; SalaryAuditingResult checkInfo = SalaryAuditingResult.GetSalaryAuditingResult((string)cb薪资组.EditValue, (string)cbb日历组.EditValue); if (checkInfo != null) { lbl审核人.Text = "审核人: " + checkInfo.表审核人; lbl审核时间.Text = "审核时间: " + checkInfo.表审核时间.ToString(); } } #endregion SetButtonEnabled(); bandedGridView1.ExpandAllGroups(); }