/// <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));//个人业务提成
}
