public ErrorList SetUpFromSarRow(KlonsADataSet.SALARY_SHEETSRow dr_lapa) { var error_list = new ErrorList(); var er = SetUpLightFromSarRow(dr_lapa); if (er != "OK") { return(new ErrorList("", er)); } var drs_r = dr_lapa.XKind == ESalarySheetKind.Total ? dr_lapa.GetSALARY_SHEETS_RRowsByFK_SALARY_SHEETS_R_IDST().OrderBy(d => d.SNR) : dr_lapa.GetSALARY_SHEETS_RRowsByFK_SALARY_SHEETS_R_IDS().OrderBy(d => d.SNR); foreach (var dr_r in drs_r) { var salary_sheet_row = new SalarySheetRowInfo(this); var err = salary_sheet_row.SetUpFromRowX(dr_r); if (err.HasErrors) { return(err); } Rows.Add(salary_sheet_row); } return(error_list); }
public bool GetRow(int addmt, out SalarySheetRowInfo row) { row = null; var table_sar = MyData.DataSetKlons.SALARY_SHEETS; var table_sar_r = MyData.DataSetKlons.SALARY_SHEETS_R; int yr = SalarySheet.YR; int mt = SalarySheet.MT; Utils.AddMonths(ref yr, ref mt, addmt); int idp = Row.IDP; int idam = Row.IDAM; var drs = table_sar_r.WhereX( d => { var dr_sar = d.SALARY_SHEETSRowByFK_SALARY_SHEETS_R_IDS; return (d.IDP == idp && d.IDAM == idam && dr_sar.YR == yr && dr_sar.MT == mt); }).ToArray(); if (drs.Length == 0) { return(true); } var dr = drs[0]; var shr = new SalarySheetRowInfo(); var err = shr.SetUpFromRowX(dr); if (err != null && err.Count > 0) { return(false); } row = shr; return(true); }
public static ReportViewerData MakeReportData(KlonsADataSet.SALARY_SHEETS_RRow dr_lapas_r) { var sr = new SalarySheetRowInfo(); var err = sr.SetUpFromRowX(dr_lapas_r); if (err.HasErrors) { Form_ErrorList.ShowErrorList(MyData.MyMainForm, err); return(null); } sr.CheckLinkedRows(dr_lapas_r.IDP); var sc = new SalaryCalcTInfo(sr.SalarySheetRowSet, new SalaryInfo(), true); err = sc.FillRow(); if (err.HasErrors) { Form_ErrorList.ShowErrorList(MyData.MyMainForm, err); return(null); } var person = string.Format("{0} {1}, {2}", sr.DR_Person_r.FNAME, sr.DR_Person_r.LNAME, sr.GetPositionTitle().Nz().ToLower()); var period = string.Format("{0:dd.MM.yyyy} - {1:dd.MM.yyyy}", sr.SalarySheet.DT1, sr.SalarySheet.DT2); ReportViewerData rd = new ReportViewerData(); rd.FileName = "ReportA_AprIzklasts_1"; if (sr.IsSingleRow()) { var sc0 = sc.LinkedSCI[0]; sc0.CheckBeforeReport(); sc0.AvPayCalc.SetCurMonthPay(sr.SalarySheet.YR, sr.SalarySheet.MT, sc.TotalSI._TOTAL_BEFORE_TAXES, sc.TotalSI._PAY); rd.Sources["dsSickPay"] = sc0.SickDayCalc?.Rows; rd.Sources["dsAvPay"] = sc0.AvPayCalc.ReportRows; rd.Sources["dsWorkPay"] = sc0.WorkPayCalc.GetRows2(); rd.Sources["dsVacationPay"] = sc0.VacationCalc.Rows; rd.Sources["dsCalcR"] = sc0.CalcR.ReportRows; rd.Sources["dsBonus"] = sc0.BonusCalc.ReportRows; rd.Sources["dsSalary"] = sc0.MakeReport1(); rd.AddReportParameters(new string[] { "CompanyName", MyData.Params.CompNameX, "RPerson", person, "RPeriod", period, "RSickPay", sc0.SickDayCalc.TotalRow.SickDayPay.ToString("N2"), "RSickPay75", sc0.SickDayCalc.TotalRow.SickDayPay75.ToString("N2"), "RSickPay80", sc0.SickDayCalc.TotalRow.SickDayPay80.ToString("N2"), "RAvPayHour", sc0.AvPayCalc.RateHour.ToString("N4"), "RAvPayDay", sc0.AvPayCalc.RateDay.ToString("N4"), "RAvPayCalDay", sc0.AvPayCalc.RateCalendarDay.ToString("N4"), "RAvPayRemark", sc0.AvPayCalc.UsingMinRate?"Izmantotas minimālās likmes.": "", "RPosTitle0", sc0.SR.GetPositionTitle(), "RPosTitle1", null, "RPosTitle2", null, "RPosTitle3", null, "RPosTitle4", null, "RIsAvPayUsed", sc0.SI.IsAvPayUsed().ToString() }); } else { var rep = sc.MakeReport1(); sc.CheckBeforeReport(); sc.AvPayCalc.SetCurMonthPay(sr.SalarySheet.YR, sr.SalarySheet.MT, sc.TotalSI._TOTAL_BEFORE_TAXES, sc.TotalSI._PAY); rd.Sources["dsSickPay"] = sc.SickDayCalc.Rows; rd.Sources["dsAvPay"] = sc.AvPayCalc.ReportRows; rd.Sources["dsWorkPay"] = sc.WorkPayCalc.GetRows2(); rd.Sources["dsVacationPay"] = sc.VacationCalc.Rows; rd.Sources["dsCalcR"] = sc.CalcR.ReportRows; rd.Sources["dsBonus"] = sc.BonusCalc.ReportRows; rd.Sources["dsSalary"] = rep.GetGoodRows(); rd.AddReportParameters(new string[] { "CompanyName", MyData.Params.CompNameX, "RPerson", person, "RPeriod", period, "RSickPay", sc.SickDayCalc.TotalRow.SickDayPay.ToString("N2"), "RSickPay75", sc.SickDayCalc.TotalRow.SickDayPay75.ToString("N2"), "RSickPay80", sc.SickDayCalc.TotalRow.SickDayPay80.ToString("N2"), "RAvPayHour", sc.AvPayCalc.RateHour.ToString("N4"), "RAvPayDay", sc.AvPayCalc.RateDay.ToString("N4"), "RAvPayCalDay", sc.AvPayCalc.RateCalendarDay.ToString("N4"), "RAvPayRemark", sc.AvPayCalc.UsingMinRate?"Izmantotas minimālās likmes.": "", "RPosTitle0", rep.Titles[0], "RPosTitle1", rep.Titles[1], "RPosTitle2", rep.Titles[2], "RPosTitle3", rep.Titles[3], "RPosTitle4", rep.Titles[4], "RIsAvPayUsed", sc.TotalSI.IsAvPayUsed().ToString() }); } return(rd); }