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();
}
