public static bool DeletePerTypeInfo(string elemID) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //获取公司代码 string companyCD = userInfo.CompanyCD; //执行删除操作 bool isSucc = TimeSalaryDBHelper.DeletePerTypeInfo(elemID, companyCD); //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //操作日志 LogInfoModel logModel = InitLogInfo(elemID); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_DELETE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return(isSucc); }
/// <summary> /// 编辑计时工资项信息 /// </summary> /// <param name="lstEdit">计时工资项信息</param> /// <returns></returns> public static bool SaveTimeSalaryInfo(ArrayList lstEdit) { //定义返回变量 bool isSucc = true; //信息存在时,进行操作 if (lstEdit != null && lstEdit.Count > 0) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //执行保存操作 try { //执行保存操作 isSucc = TimeSalaryDBHelper.SaveTimeSalaryInfo(lstEdit, userInfo.CompanyCD, userInfo.UserID); } catch (Exception ex) { //输出系统日志 WriteSystemLog(userInfo, ex); } //操作日志 LogInfoModel logModel = InitLogInfo(userInfo.CompanyCD); //设置关键元素 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //更新成功时 if (isSucc) { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } //更新不成功 else { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } //登陆日志 LogDBHelper.InsertLog(logModel); } return(isSucc); }
/// <summary> /// 查询计时工资项信息 /// </summary> /// <param name="model">查询条件</param> /// <param name="timeNo">计时项目编号</param> /// <returns></returns> public static string GetTimeSalaryInfo(EmployeeSearchModel model, string timeNo) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; //获取满足条件的人员信息查询 DataTable dtEmplInfo = TimeSalaryDBHelper.GetEmplInfo(model, timeNo); //变量定义 StringBuilder sbTimeSalaryInfo = new StringBuilder(); //数据存在时,设置数据 if (dtEmplInfo != null && dtEmplInfo.Rows.Count > 0) { //设置记录数 model.RecordCount = dtEmplInfo.Rows.Count.ToString(); //遍历员工获取计时工资信息 for (int i = 0; i < dtEmplInfo.Rows.Count; i++) { //获取人员ID string emplID = GetSafeData.GetStringFromInt(dtEmplInfo.Rows[i], "EmployeeID"); //获取人员计时工资 DataTable dtTimeItemInfo = TimeSalaryDBHelper.GetTimeItemInfo(model.CompanyCD , emplID, timeNo, model.StartDate, model.EndDate); //变量定义 decimal totalMoney = 0; int timeItemCount = 0; int totalRowCount = 0; StringBuilder sbEmplFirstRow = new StringBuilder(); StringBuilder sbEmplNotFirstRow = new StringBuilder(); StringBuilder sbTimeInfo = new StringBuilder(); //获取工资项目总数 if (dtTimeItemInfo != null && dtTimeItemInfo.Rows.Count > 0) { timeItemCount = dtTimeItemInfo.Rows.Count; } #region 生成每个计时项目的具体信息 //遍历工资项 for (int j = 0; j < timeItemCount; j++) { //变量定义 decimal timeTotalMoney = 0; StringBuilder sbTimeFirstRow = new StringBuilder(); StringBuilder sbTimeNotFirstRow = new StringBuilder(); //获取工资项编号 string timeItemNo = GetSafeData.ValidateDataRow_String(dtTimeItemInfo.Rows[j], "TimeNo"); //获取工资内容 DataTable dtTimeSalaryInfo = TimeSalaryDBHelper.GetTimeSalaryInfo(model.CompanyCD , emplID, timeItemNo, model.StartDate, model.EndDate); //获取工资内容总数 int timeSalaryCount = 0; if (dtTimeSalaryInfo != null && dtTimeSalaryInfo.Rows.Count > 0) { timeSalaryCount = dtTimeSalaryInfo.Rows.Count; } //单价 string price = StringUtil.TrimZero(GetSafeData.GetStringFromDecimal(dtTimeItemInfo.Rows[j], "UnitPrice")); StringBuilder sbItemTemp = new StringBuilder(); // //工资编号 sbItemTemp.AppendLine("<td class='tdColInputCenter' rowspan='" + timeSalaryCount.ToString() + "'>" + "<input type='hidden' id='txtSalaryNo_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "' value='" + timeItemNo + "' />" + "<input type='hidden' id='txtSalaryCount_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "' value='" + timeSalaryCount + "' />" + GetSafeData.ValidateDataRow_String(dtTimeItemInfo.Rows[j], "TimeName") + "</td>"); //单价 sbItemTemp.AppendLine("<td class='tdColInputCenter' rowspan='" + timeSalaryCount.ToString() + "' id='tdUnitPrice_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "' >" + price + "</td>"); //第一行时 if (j == 0) { sbEmplFirstRow.AppendLine(sbItemTemp.ToString()); } else { //行开始 sbEmplNotFirstRow.AppendLine("<tr>"); sbEmplNotFirstRow.AppendLine(sbItemTemp.ToString()); } //遍历所有项目获取具体 for (int x = 0; x < timeSalaryCount; x++) { StringBuilder sbTemp = new StringBuilder(); //时长 string timeCount = StringUtil.TrimZero(GetSafeData.GetStringFromDecimal(dtTimeSalaryInfo.Rows[x], "TimeCount")); sbTemp.AppendLine("<td class='tdColInputCenter' >" + "<input type='text' class='tdinput' readonly='readonly' id='txtAmount_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "_" + (x + 1).ToString() + "' value='" + timeCount + "' style='width=95%;background-color:#FFFFE0;'" + " onblur='CalculateTotalSalary(this, \"" + (i + 1).ToString() + "\", \"" + (j + 1).ToString() + "\", \"" + (x + 1).ToString() + "\");' onchange='Number_round(this,\"2\");' maxlength = '12' />" + "</td>"); //金额 string salaryMoney = StringUtil.TrimZero(GetSafeData.GetStringFromDecimal(dtTimeSalaryInfo.Rows[x], "SalaryMoney")); sbTemp.AppendLine("<td class='tdColInputCenter' id='tdAmountMoney_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "_" + (x + 1).ToString() + "' >" + salaryMoney + "</td>"); //日期 sbTemp.AppendLine("<td class='tdColInputCenter' id='tdSalaryDate_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "_" + (x + 1).ToString() + "'>" + GetSafeData.ValidateDataRow_String(dtTimeSalaryInfo.Rows[x], "TimeDate") + "</td>"); //计算小计金额 timeTotalMoney += decimal.Parse(salaryMoney); if (x == 0) { //人员的第一行信息时 if (j == 0) { sbEmplFirstRow.AppendLine(sbTemp.ToString()); } //不是人员的第一行信息,但是是计时工资项的第一行信息 else { sbTimeFirstRow.AppendLine(sbTemp.ToString()); } } else { //行开始 sbTimeNotFirstRow.AppendLine("<tr>"); sbTimeNotFirstRow.AppendLine(sbTemp.ToString()); //行结束 sbTimeNotFirstRow.AppendLine("</tr>"); } } //工资小计 if (j == 0) { sbEmplFirstRow.AppendLine("<td id='tdAmountTotalMoney_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "' class='tdColInputCenter' rowspan='" + timeSalaryCount.ToString() + "'>" + timeTotalMoney.ToString() + "</td>"); } else { sbTimeFirstRow.AppendLine("<td id='tdAmountTotalMoney_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "' class='tdColInputCenter' rowspan='" + timeSalaryCount.ToString() + "'>" + timeTotalMoney.ToString() + "</td></tr>"); } //计算合计金额 totalMoney += timeTotalMoney; //行数统计 totalRowCount += timeSalaryCount; //非第一行时,添加到非第一行的信息里 sbEmplNotFirstRow.AppendLine(sbTimeFirstRow.ToString() + sbTimeNotFirstRow.ToString()); } #endregion //行开始 sbTimeSalaryInfo.AppendLine("<tr>"); //选择 sbTimeSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>" + "<input id='chkSelect_" + (i + 1).ToString() + "' name='chkSelect' value='" + GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "EmployeeNo") + "' type='checkbox' onpropertychange='getChage(this)' />" + "</td>"); //人员编号 sbTimeSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>" + "<input type='hidden' id='txtEmplID_" + (i + 1).ToString() + "' value='" + emplID + "' />" + "<input type='hidden' id='txtItemCount_" + (i + 1).ToString() + "' value='" + timeItemCount + "' />" + GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "EmployeeNo") + "</td>"); //人员姓名 sbTimeSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>" + GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "EmployeeName") + "</td>"); //所在部门 sbTimeSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>" + GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "DeptName") + "</td>"); //岗位名称 sbTimeSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>" + GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "QuarterName") + "</td>"); //岗位职等 sbTimeSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>" + GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "AdminLevelName") + "</td>"); //具体的计时项目信息 sbTimeSalaryInfo.AppendLine(sbEmplFirstRow.ToString()); //工资合计 sbTimeSalaryInfo.AppendLine("<td class='tdColInputCenter' id='tdTotalMoney_" + (i + 1).ToString() + "' rowspan='" + totalRowCount.ToString() + "'>" + totalMoney.ToString() + "</td>"); //行结束 sbTimeSalaryInfo.AppendLine("</tr>"); //具体的计时项目信息 sbTimeSalaryInfo.AppendLine(sbEmplNotFirstRow.ToString()); } } return(sbTimeSalaryInfo.ToString()); }