protected void LoadData() { all_rows = MonthlyWageLoanItem.GetMonthlyWageLoanItems(Convert.ToInt32(year.Value), Convert.ToInt32(month.EditValue)); all_rows = all_rows.OrderByDescending(a => a.月借款标准).ThenBy(a => a.部门).ThenBy(a => a.职务).ToList(); gridControl1.DataSource = all_rows; gridControl1.RefreshDataSource(); gridControl1.Refresh(); }
public WageLoanVoucher(MonthlyWageLoanItem item) { InitializeComponent(); 借款记录 = item; xr公司.Text = 借款记录.发放单位; xr大写金额.Text = 借款记录.税后实发金额_大写; xr小写金额.Text = "¥" + 借款记录.税后实发金额.ToString("0.00"); }
private void bandedGridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e) { MonthlyWageLoanItem item = bandedGridView1.GetRow(bandedGridView1.FocusedRowHandle) as MonthlyWageLoanItem; if (item != null && e.Column.Caption == "打印") { WageLoanVoucher report = new WageLoanVoucher(item); ReportPrintTool tool = new ReportPrintTool(report); tool.PrintDialog(); } }
private void ShowPrintDialog() { MonthlyWageLoanItem item = bandedGridView1.GetRow(bandedGridView1.FocusedRowHandle) as MonthlyWageLoanItem; if (item != null) { WageLoanVoucher report = new WageLoanVoucher(item); ReportPrintTool tool = new ReportPrintTool(report); tool.ShowPreview(); } }
private void FillTable() { if (mySalary == null) { return; } DateTime 期间开始 = new DateTime(mySalary.年度, mySalary.月份, 1); DateTime 期间结束 = 期间开始.AddMonths(1).AddDays(-1); EmployeeSalaryStructure 薪酬结构 = mySalary.薪酬结构; SalaryResult 表工资 = mySalary.基础工资表; PrivateSalary 封闭工资 = mySalary; WageLoan 工资借款 = WageLoan.GetEffective(mySalary.员工编号, 期间开始); ContractAllowance 契约津贴 = ContractAllowance.GetEffective(mySalary.员工编号, 期间开始); decimal 月薪剩余 = 0; #region 薪酬结构 if (薪酬结构 != null) { cells["G3"].Value = (薪酬结构.年薪_合计 / 10000).ToString("#0.####"); cells["G4"].Value = (薪酬结构.年薪_奖励 / 10000).ToString("#0.####"); cells["G5"].Value = (薪酬结构.年薪_12个月 / 10000).ToString("#0.####"); } else { cells["G3"].Value = (封闭工资.职级工资 * 12 / 10000).ToString("#0.####"); cells["G5"].Value = 封闭工资.职级工资.ToString("#0.##"); } cells["G6"].Value = 封闭工资.职级工资.ToString("#0.##"); 月薪剩余 = 封闭工资.职级工资; if (工资借款 != null) { List <MonthlyWageLoanItem> items = MonthlyWageLoanItem.GetMonthlyWageLoanItems(mySalary.员工编号); items = items.FindAll(a => a.期间开始 >= 工资借款.开始时间 && a.期间开始 <= 期间结束); cells["G7"].Value = 工资借款.月借款额度.ToString("#0.##"); cells["G8"].Value = items.Sum(a => a.月借款标准).ToString("#0.##"); 月薪剩余 -= 工资借款.月借款额度; } if (契约津贴 != null) { List <MonthlyContractAllowanceItem> items = MonthlyContractAllowanceItem.GetMonthlyContractAllowanceItems(mySalary.员工编号); items = items.FindAll(a => a.期间开始 >= 契约津贴.开始时间 && a.期间开始 <= 期间结束); cells["G7"].Value = 契约津贴.月津贴额度.ToString("#0.##"); cells["G8"].Value = items.Sum(a => a.月津贴标准).ToString("#0.##"); 月薪剩余 -= 契约津贴.月津贴额度; } 月薪剩余 -= 封闭工资.本月执行绩效工资额; cells["G16"].Value = 封闭工资.本月执行绩效工资额.ToString("#0.##"); cells["G17"].Value = 月薪剩余.ToString("#0.##"); #endregion //工资发放 #region 工资发放 cells["G18"].Value = 表工资.企业排班天数.ToString("#0.##"); cells["G19"].Value = 表工资.实际出勤天数.ToString("#0.##"); cells["G20"].Value = 封闭工资.总出勤工资.ToString("#0.##"); cells["G21"].Value = 表工资.未休年休假工资.ToString("#0.##"); cells["G22"].Value = 表工资.实得满勤奖.ToString("#0.##"); cells["G23"].Value = 封闭工资.总补助工资.ToString("#0.##"); decimal 加班工资 = 表工资.法定节假日出勤工资 + 表工资.休息日出勤工资 + 表工资.月综合出勤工资 + 表工资.工作日延长工作出勤工资; cells["G24"].Value = 加班工资.ToString("#0.##"); cells["G25"].Value = 表工资.综合考核工资.ToString("#0.##"); cells["G28"].Value = 封闭工资.奖项_不含满勤奖.ToString("#0.##"); cells["G29"].Value = 封闭工资.扣项.ToString("#0.##"); cells["G30"].Value = 封闭工资.工资发放总额.ToString("#0.##"); //社保缴纳 cells["G33"].Value = 表工资.住房公积金个人缴纳金额.ToString("#0.##"); cells["G34"].Value = 表工资.养老保险个人缴纳金额.ToString("#0.##"); cells["G35"].Value = 表工资.大病医疗个人缴纳金额.ToString("#0.##"); cells["G36"].Value = 表工资.医疗保险个人缴纳金额.ToString("#0.##"); cells["G37"].Value = 表工资.失业保险个人缴纳金额.ToString("#0.##"); cells["G38"].Value = 0; //生育 cells["G39"].Value = 0; //工伤 cells["G40"].Value = 表工资.社保个人缴纳金额.ToString("#0.##"); //预留工资作奖金 //税后工资 cells["G43"].Value = 封闭工资.总应税工资.ToString("#0.##"); cells["G44"].Value = 封闭工资.个人所得税.ToString("#0.##"); cells["G45"].Value = 封闭工资.总代垫费用.ToString("#0.##"); cells["G46"].Value = 封闭工资.实发工资.ToString("#0.##"); //年薪资奖励 //预留工资作奖金 //税后奖金 #endregion }