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());
}
