/// <summary> /// 生成报表处理 /// </summary> /// <param name="belongMonth">所属月份</param> /// <returns></returns> public static string CreateSalaryReport(SalaryReportModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //获取公司代码 string companyCD = userInfo.CompanyCD; string userID = userInfo.UserID; model.CompanyCD = companyCD; model.ModifiedUserID = userID; //获取人员信息 EmployeeSearchModel searchEmplModel = new EmployeeSearchModel(); //设置公司代码 searchEmplModel.CompanyCD = companyCD; searchEmplModel.StartDate = model.StartDate; searchEmplModel.EndDate = model.EndDate; //查询人员信息 DataTable dtEmplInfo = EmployeeInfoDBHelper.GetWorkEmplInfo(searchEmplModel); DataTable dtNew = SalaryItemBus.GetOutEmployeeInfo(searchEmplModel); dtEmplInfo.Merge(dtNew); //获取员工固定工资 DataTable dtEmplSalary = SalaryEmployeeDBHelper.GetSalaryEmployeeInfo(companyCD); DataTable dtFixedSalary = new DataTable(); dtFixedSalary = dtEmplSalary.Clone(); //dtFixedSalary.Columns["SalaryMoney"].DataType.GetType() = "System.Decimal"; //获取员工计件工资 DataTable dtPeiceSalary = PieceworkSalaryDBHelper.GetMonthPieceworkSalary(companyCD, model.ReportMonth,model .StartDate ,model.EndDate ); string spMonth = model.ReportMonth.Substring(0, 4) + "-" + model.ReportMonth.Substring(4); //获取员工出勤率 DataTable dtAttendance = PieceworkSalaryDBHelper.GetMonthAttendance(companyCD, spMonth ); //获取员工计时工资 DataTable dtTimeSalary = TimeSalaryDBHelper.GetMonthTimeSalary(companyCD, model.ReportMonth, model.StartDate, model.EndDate); //获取员工产品单品提成工资 DataTable dtCommSalary = CommissionSalaryDBHelper.GetMonthCommSalary(companyCD, model.ReportMonth, model.StartDate, model.EndDate); //获取公司业务提成 DataTable dtComanySalary = InputCompanyRoyaltyDBHelper.GetMonthCompanySalary(companyCD, model.ReportMonth, model.StartDate, model.EndDate); //获取公司业务提成设置 DataTable dtCompanySet = InputCompanyRoyaltyDBHelper.GetCompanySetInfo(companyCD); //获取个人业务信息 DataTable dtPersonCommSalary = InputPersonalRoyaltyDBHelper.GetMonthPersonSalary(companyCD, model.ReportMonth, model.StartDate, model.EndDate); //获取部门业务提成 DataTable dtDeptSalary = InputDepatmentRoyaltyDBHelper.GetMonthDeptSalary (companyCD, model.ReportMonth, model.StartDate, model.EndDate); //获取部门业务提成设置 DataTable dtDeptSet = InputDepatmentRoyaltyDBHelper.GetDeptSetInfo(companyCD); //获取员工整体薪资结构 DataTable dtStructure = SalaryEmployeeStructureSetDBHelper.GetSalaryStructure(companyCD); //获取绩效工资 DataTable dtPerformanceSalary = InputPerformanceRoyaltyDBHelper.GetMonthPerformanceSalary (companyCD, model.ReportMonth, model.StartDate, model.EndDate); //获取社会保险信息 DataTable dtInsuSalary = InsuEmployeeDBHelper.GetInsuEmployeeInf(companyCD,model.ReportMonth ); //获取个人所得税信息 DataTable dtPersonSalary = InputPersonTrueIncomeTaxDBHelper.SearchPersonTax (companyCD, model.ReportMonth); //变量定义 ArrayList lstSummary = new ArrayList(); //遍历所有的员工信息,获取工资总额 for (int i = 0; i < dtEmplInfo.Rows.Count; i++) { //变量定义 SalaryReportSummaryModel summaryModel = new SalaryReportSummaryModel(); //变量定义 decimal totalSalary = 0; decimal salaryMoney = 0; //公司代码 summaryModel.CompanyCD = companyCD; //报表编号 summaryModel.ReprotNo = model.ReprotNo; //获取员工ID string employeeID = GetSafeData.GetStringFromInt(dtEmplInfo.Rows[i], "ID"); summaryModel.EmployeeID = employeeID; summaryModel.AdminLevelName = GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "AdminLevelName"); summaryModel.DeptName = GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "DeptName"); summaryModel.EmployeeName = GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "EmployeeName"); summaryModel.EmployeeNo = GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "EmployeeNo"); summaryModel.QuarterName = GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "QuarterName"); string deptID = GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "DeptID"); //获取员工薪资结构 DataRow[] drStructure = dtStructure.Select("EmployeeID=" + employeeID); if (drStructure.Length > 0) { } else { lstSummary.Add(summaryModel); continue; } #region 判断是否设置固定工资 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsFixSalarySet") == "1")//判断是否设置固定工资 { //固定工资 DataRow[] drFixedSalary = dtEmplSalary.Select("EmployeeID=" + employeeID); //遍历所有固定工资项,计算工资额 for (int j = 0; j < drFixedSalary.Length; j++) { //导入工资记录 dtFixedSalary.ImportRow(drFixedSalary[j]); //该项工资额为DBNull时,增加该工资项 if (drFixedSalary[j]["SalaryMoney"] != DBNull.Value) { //获取是否扣款 string flag = GetSafeData.ValidateDataRow_String(drFixedSalary[j], "PayFlag"); string cal = GetSafeData.ValidateDataRow_String(drFixedSalary[j], "Calculate"); decimal fina=0; if (string.IsNullOrEmpty(cal)) { fina =Convert.ToDecimal(drFixedSalary[j]["SalaryMoney"]); } else { while (cal.IndexOf('A') != -1) { cal = cal.Replace('A', '+'); } string numlist = GetSafeData.ValidateDataRow_String(drFixedSalary[j], "ParamsList"); string[] numberlist = numlist.Split(','); string temp = cal; for (int inde = 0; inde < numberlist.Length; inde++) { if (numberlist[inde] == "@") { DataRow[] drtem = dtAttendance.Select("EmployeeID=" + employeeID); decimal atten=0; if (drtem .Length >0) { atten = Math.Round(Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drtem[0], "AttendanceRate")) / 100, 2); } if (atten < 1) { cal = cal.Replace("{" + numberlist[inde] + "}", Convert.ToString(atten)); } else { cal = cal.Replace("{" + numberlist[inde] + "}", "0"); } } else { if (!string.IsNullOrEmpty(numberlist[inde])) { DataRow[] drtem = dtEmplSalary.Select("EmployeeID=" + employeeID + " and ItemNo=" + numberlist[inde]); if (drtem.Length > 0) { cal = cal.Replace("{" + numberlist[inde] + "}", GetSafeData.ValidateDataRow_String(drtem[0], "SalaryMoney")); } else { cal = cal.Replace("{" + numberlist[inde] + "}", "0"); } } } } try { // string result = CustomEval.eval(cal).ToString(); // fina = Convert.ToDecimal(result); } catch { fina = 0; } } if ("0".Equals(flag)) { //增加工资额 totalSalary += fina; } else { //减少工资额 // totalSalary -= Convert.ToDecimal(drFixedSalary[j]["SalaryMoney"]); salaryMoney += fina ; } for (int a = 0; a < dtFixedSalary.Rows.Count; a++) { string empl=dtFixedSalary .Rows [a]["EmployeeID"]==null ?"":dtFixedSalary .Rows [a]["EmployeeID"].ToString (); string iten=dtFixedSalary .Rows [a]["ItemNo"]==null ?"":dtFixedSalary .Rows [a]["ItemNo"].ToString (); string organItem=drFixedSalary[j]["ItemNo"] ==null ?"":drFixedSalary[j]["ItemNo"] .ToString (); if ((empl == employeeID) && ( iten == organItem)) { dtFixedSalary.Rows[a]["SalaryMoney"] = fina.ToString(); } } } } //固定工资 summaryModel.FixedMoney = totalSalary.ToString(); } else { //固定工资 summaryModel.FixedMoney = "0"; } #endregion #region 判断是否设置计件 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsPieceWorkSet") == "1")//判断是否设置计件 { //计件工资 DataRow[] drPeiceSalary = dtPeiceSalary.Select("EmployeeID=" + employeeID); if (drPeiceSalary.Length > 0) { //设置计件工资 summaryModel.WorkMoney = GetSafeData.GetStringFromDecimal(drPeiceSalary[0], "TotalSalary"); //加到总工资 totalSalary += Convert.ToDecimal(drPeiceSalary[0]["TotalSalary"]); } } else { //设置计件工资 summaryModel.WorkMoney = "0"; //加到总工资 totalSalary += 0; } #endregion #region 判断是否设置计时 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsTimeWorkSet") == "1")//判断是否设置计时 { //计时工资 DataRow[] drTimeSalary = dtTimeSalary.Select("EmployeeID=" + employeeID); if (drTimeSalary.Length > 0) { //设置计时工资 summaryModel.TimeMoney = GetSafeData.GetStringFromDecimal(drTimeSalary[0], "TotalSalary"); totalSalary += Convert.ToDecimal(drTimeSalary[0]["TotalSalary"]); } } else { //设置计时工资 summaryModel.TimeMoney = "0"; totalSalary += 0; } #endregion #region 判断是否设置产品单品提成 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsProductRoyaltySet") == "1")//判断是否设置产品单品提成 { //提成工资 dtPersonSalary DataRow[] drCommSalary = dtCommSalary.Select("EmployeeID=" + employeeID); if (drCommSalary.Length > 0) { //设置产品单品提成工资 //summaryModel.CommissionMoney = GetSafeData.GetStringFromDecimal(drCommSalary[0], "TotalSalary");Convert.ToDecimal(drCommSalary[0]["TotalSalary"]); summaryModel.CommissionMoney = GetSafeData.GetStringFromDecimal(drCommSalary[0], "TotalSalary"); totalSalary += Convert.ToDecimal(drCommSalary[0]["TotalSalary"]); } } else { //设置产品单品提成工资 summaryModel.CommissionMoney = "0"; //commisionMoney = 0; totalSalary += 0; } #endregion #region 判断是否设置个人业务提成 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsPersonalRoyaltySet") == "1")//判断是否设置个人业务提成 { // DataRow[] drPersonCommSalary = dtPersonCommSalary.Select("EmployeeID=" + employeeID); if (drPersonCommSalary.Length > 0) { //设置个人业务提成 summaryModel.PersonComMoney = GetSafeData.GetStringFromDecimal(drPersonCommSalary[0], "TotalSalary"); totalSalary += Convert.ToDecimal(drPersonCommSalary[0]["TotalSalary"]); } } else { //设置个人业务提成 //summaryModel.CommissionMoney = "0"; summaryModel.PersonComMoney ="0"; totalSalary += 0; } #endregion #region 判断是否设置公司业务提成 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsCompanyRoyaltySet") == "1")//判断是否设置公司业务提成 { decimal rate = 0; //提成工资 dtPersonSalary dtComanySalary DataRow[] drCompanyalary = dtComanySalary.Select("DeptID=" + deptID); DataRow[] drCompanyalarySet = dtCompanySet.Select("DeptID=" + deptID, "MiniMoney asc"); DataRow[] drCompanyalarySetCommon = dtCompanySet.Select("DeptID=0", "MiniMoney asc");//获取通用规则 if (drCompanyalary.Length > 0) { string tem= GetSafeData.ValidateDataRow_String(drCompanyalary[0], "TotalSalary"); decimal temp=Convert .ToDecimal (tem ); bool isCheck = false; if (drCompanyalarySet.Length > 0) { for (int a = 0; a < drCompanyalarySet.Length; a++) { decimal minMoney = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drCompanyalarySet[a], "MiniMoney")); decimal maxMoney = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drCompanyalarySet[a], "MaxMoney")); if (temp >= minMoney && temp <maxMoney) { rate = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drCompanyalarySet[a], "TaxPercent")); isCheck = true; break; } } if (!isCheck) { rate = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drCompanyalarySet[(drCompanyalarySet.Length - 1)], "TaxPercent")); } } else if (drCompanyalarySetCommon.Length > 0) { bool isHave = false; int len=drCompanyalarySetCommon.Length; for (int a = 0; a <len ; a++) { decimal minMoney = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drCompanyalarySetCommon[a], "MiniMoney")); decimal maxMoney = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drCompanyalarySetCommon[a], "MaxMoney")); if (temp >= minMoney && temp < maxMoney) { rate = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drCompanyalarySetCommon[a], "TaxPercent")); isHave = true; break; } } if (!isHave) { rate = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drCompanyalarySetCommon[(len -1)], "TaxPercent")); } } summaryModel .CompanyComMoney = Convert .ToString ( decimal.Round(temp * rate * (Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drStructure[0], "CompanyRatePercent"))) / 10000, 2)); totalSalary += decimal.Round(temp * rate * (Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drStructure[0], "CompanyRatePercent"))) / 10000, 2); } } else { summaryModel.CompanyComMoney = "0"; totalSalary += 0; } #endregion #region 判断是否设置部门业务提成 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsDeptRoyaltySet") == "1")//判断是否设置部门业务提成 { decimal rate = 0; //提成工资 dtPersonSalary dtComanySalary DataRow[] drDeptalary = dtDeptSalary.Select("DeptID=" + deptID); DataRow[] drDeptalarySet = dtDeptSet.Select("DeptID=" + deptID, "MiniMoney asc"); DataRow[] drDeptalarySetCommon = dtDeptSet.Select("DeptID=0", "MiniMoney asc");//获取通用规则 if (drDeptalary.Length > 0) { string tem = GetSafeData.ValidateDataRow_String(drDeptalary[0], "TotalSalary"); decimal temp = Convert.ToDecimal(tem); bool isCheck = false; if (drDeptalarySet.Length > 0) { for (int a = 0; a < drDeptalarySet.Length; a++) { decimal minMoney = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drDeptalarySet[a], "MiniMoney")); decimal maxMoney = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drDeptalarySet[a], "MaxMoney")); if (temp >= minMoney && temp < maxMoney) { rate = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drDeptalarySet[a], "TaxPercent")); break; } } if (!isCheck) { rate = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drDeptalarySet[(drDeptalarySet.Length - 1)], "TaxPercent")); } } else if (drDeptalarySetCommon.Length > 0) { bool isHave = false; int len = drDeptalarySetCommon.Length; for (int a = 0; a < len; a++) { decimal minMoney = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drDeptalarySetCommon[a], "MiniMoney")); decimal maxMoney = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drDeptalarySetCommon[a], "MaxMoney")); if (temp >= minMoney && temp < maxMoney) { rate = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drDeptalarySetCommon[a], "TaxPercent")); isHave = true; break; } } if (!isHave) { rate = Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drDeptalarySetCommon[(len- 1)], "TaxPercent")); } } summaryModel .DeptComMoney = Convert .ToString ( decimal.Round(temp * rate * (Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drStructure[0], "DeptRatePercent"))) / 10000, 2)); totalSalary += decimal.Round(temp * rate * (Convert.ToDecimal(GetSafeData.ValidateDataRow_String(drStructure[0], "DeptRatePercent"))) / 10000, 2); } } else { summaryModel.DeptComMoney = "0"; totalSalary += 0; } #endregion #region 判断是否设置绩效 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsPerformanceSet") == "1")//判断是否设置绩效 { //计时工资 DataRow[] drPerformanceSalary = dtPerformanceSalary.Select("EmployeeID=" + employeeID); if (drPerformanceSalary.Length > 0) { //设置绩效工资 //summaryModel.TimeMoney = GetSafeData.GetStringFromDecimal(drPerformanceSalary[0], "TotalPerformanceMoney"); summaryModel.PerformanceMoney = GetSafeData.GetStringFromDecimal(drPerformanceSalary[0], "TotalPerformanceMoney");//待新建一项绩效工资栏目 totalSalary += Convert.ToDecimal(drPerformanceSalary[0]["TotalPerformanceMoney"]); } } else { //设置绩效工资 summaryModel.PerformanceMoney = "0"; totalSalary += 0; } #endregion //工资总额 summaryModel.AllGetMoney = totalSalary.ToString(); decimal insuMoney = 0; #region 判断是否设置社会保险 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsInsurenceSet") == "1")//判断是否设置社会保险 { //社会保险 DataRow[] drInsuSalary = dtInsuSalary.Select("EmployeeID=" + employeeID); for (int x = 0; x < drInsuSalary.Length; x++) { //数据不为空时,计算社会保险总额 if (drInsuSalary[x]["InsuranceBase"] != DBNull.Value && drInsuSalary[x]["PersonPayRate"] != DBNull.Value) { //保险基数 decimal insuBase = Convert.ToDecimal(drInsuSalary[x]["InsuranceBase"]); //个人缴纳百分比 decimal insuPercent = Convert.ToDecimal(drInsuSalary[x]["PersonPayRate"]); //增加社会保险额 insuMoney += insuBase * insuPercent / 100; } } //社会保险 summaryModel.Insurance = StringUtil.TrimZero(insuMoney.ToString()); } else { summaryModel.Insurance = "0"; } #endregion decimal minusMoney = 0; decimal PersonMoney = 0; #region 判断是否设置个人所得税 if (GetSafeData.ValidateDataRow_String(drStructure[0], "IsPerIncomeTaxSet") == "1")//判断是否设置个人所得税 { //个人所得税 dtPersonSalary DataRow[] drPersonSalary = dtPersonSalary.Select("EmployeeID=" + employeeID); if (drPersonSalary.Length > 0) { decimal salryCount = drPersonSalary[0]["SalaryCount"] == null ? 0 : Convert.ToDecimal(drPersonSalary[0]["SalaryCount"]); decimal TaxPercent = drPersonSalary[0]["TaxPercent"] == null ? 0 : Convert.ToDecimal(drPersonSalary[0]["TaxPercent"]); decimal TaxCount = drPersonSalary[0]["TaxCount"] == null ? 0 : Convert.ToDecimal(drPersonSalary[0]["TaxCount"]); decimal te=0; if ((totalSalary - salryCount - insuMoney) > 0) { te = (totalSalary - salryCount - insuMoney) * TaxPercent / 100 - TaxCount; } //个人所得税 summaryModel.IncomeTax = te.ToString (); // totalSalary -= Convert.ToDecimal(drPersonSalary[0]["TaxCount"]); PersonMoney = te; } } else { //个人所得税 summaryModel.IncomeTax = "0" ; // totalSalary -= Convert.ToDecimal(drPersonSalary[0]["TaxCount"]); PersonMoney = 0; } #endregion // decimal[] taxInfo = TaxCalculateBus.CalculateTax(totalSalary); //税额 // decimal minusMoney = taxInfo[1]; // summaryModel.IncomeTax = StringUtil.TrimZero(minusMoney.ToString()); minusMoney = insuMoney + PersonMoney + salaryMoney; //应扣款合计 //minusMoney =minusMoney +salaryMoney; summaryModel.AllKillMoney = minusMoney.ToString() ; //实发工资 summaryModel.SalaryMoney = (totalSalary - minusMoney).ToString(); // lstSummary.Add(summaryModel); } //登陆报表信息 bool isSucc = SalaryReportDBHelper.CreateSalaryReport(model, lstSummary, dtFixedSalary); if (!isSucc) return null; else return PageDisplayInfo(dtEmplInfo, dtFixedSalary, lstSummary, companyCD); }
/// <summary> /// 工资合计参数设置 /// </summary> /// <param name="comm">命令</param> /// <param name="model">工资合计信息</param> private static void SetSummaryParameter(SqlCommand comm, SalaryReportSummaryModel model) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ReprotNo", model.ReprotNo));//工资报表编号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeID", model.EmployeeID));//员工ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@FixedMoney", model.FixedMoney));//固定 comm.Parameters.Add(SqlHelper.GetParameterFromString("@WorkMoney", model.WorkMoney));//计件工资 comm.Parameters.Add(SqlHelper.GetParameterFromString("@TimeMoney", model.TimeMoney));//计时工资 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CommissionMoney", model.CommissionMoney));//提成工资 comm.Parameters.Add(SqlHelper.GetParameterFromString("@OtherGetMoney", model.OtherGetMoney));//其他应付工资额 comm.Parameters.Add(SqlHelper.GetParameterFromString("@AllGetMoney", model.AllGetMoney));//应付工资额合计 comm.Parameters.Add(SqlHelper.GetParameterFromString("@IncomeTax", model.IncomeTax));//个人所得税(扣款) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Insurance", model.Insurance));//社保(扣款) comm.Parameters.Add(SqlHelper.GetParameterFromString("@OtherKillMoney", model.OtherKillMoney));//其他应扣款额 comm.Parameters.Add(SqlHelper.GetParameterFromString("@AllKillMoney", model.AllKillMoney));//应扣款额合计 comm.Parameters.Add(SqlHelper.GetParameterFromString("@SalaryMoney", model.SalaryMoney));//实发工资额 comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdminLevelName", model.AdminLevelName));//应付工资额合计 comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptName", model.DeptName));//个人所得税(扣款) comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeName", model.EmployeeName));//社保(扣款) comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeNo", model.EmployeeNo));//其他应扣款额 comm.Parameters.Add(SqlHelper.GetParameterFromString("@QuarterName", model.QuarterName));//应扣款额合计 comm.Parameters.Add(SqlHelper.GetParameterFromString("@PerformanceMoney", model.PerformanceMoney ));//绩效金额 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyComMoney", model.CompanyComMoney));//公司业务提成 comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptComMoney", model.DeptComMoney));//部门业务提成 comm.Parameters.Add(SqlHelper.GetParameterFromString("@PersonComMoney", model.PersonComMoney));//个人业务提成 }