private static OtherCorpInfoModel ChangeOtherCorpInfoModel(DataRow data)
{
//定义返回的 EmployeeInfoModel
OtherCorpInfoModel model = new OtherCorpInfoModel();
//人员信息存在时，转化为model形式的数据
if (data != null)
{
model.ID = GetSafeData.ValidateDataRow_Int(data, "ID");
model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
model.BigType = GetSafeData.ValidateDataRow_String(data, "BigType");
model.CustNo = GetSafeData.ValidateDataRow_String(data, "CustNo");
model.CustName = GetSafeData.ValidateDataRow_String(data, "CustName");
model.CorpNam = GetSafeData.ValidateDataRow_String(data, "CorpNam");
model.PYShort = GetSafeData.ValidateDataRow_String(data, "PYShort");
model.CustNote = GetSafeData.ValidateDataRow_String(data, "CustNote");
model.AreaID = GetSafeData.GetStringFromInt(data, "AreaID");
model.CompanyType = GetSafeData.ValidateDataRow_String(data, "CompanyType");
model.StaffCount = GetSafeData.GetStringFromInt(data, "StaffCount");
model.SetupDate = GetSafeData.ValidateDataRow_String(data, "SetupDate");
model.ArtiPerson = GetSafeData.ValidateDataRow_String(data, "ArtiPerson");
model.SetupMoney = GetSafeData.GetStringFromDecimal(data, "SetupMoney");
model.SetupAddress = GetSafeData.ValidateDataRow_String(data, "SetupAddress");
model.CapitalScale = GetSafeData.GetStringFromDecimal(data, "CapitalScale");
model.SaleroomY = GetSafeData.GetStringFromDecimal(data, "SaleroomY");
model.ProfitY = GetSafeData.GetStringFromDecimal(data, "ProfitY");
model.TaxCD = GetSafeData.ValidateDataRow_String(data, "TaxCD");
model.BusiNumber = GetSafeData.ValidateDataRow_String(data, "BusiNumber");
model.isTax = GetSafeData.ValidateDataRow_String(data, "isTax");
model.SellArea = GetSafeData.ValidateDataRow_String(data, "SellArea");
model.CountryID = GetSafeData.GetStringFromInt(data, "CountryID");
model.Province = GetSafeData.ValidateDataRow_String(data, "Province");
model.City = GetSafeData.ValidateDataRow_String(data, "City");
model.Post = GetSafeData.ValidateDataRow_String(data, "Post");
model.ContactName = GetSafeData.ValidateDataRow_String(data, "ContactName");
model.Tel = GetSafeData.ValidateDataRow_String(data, "Tel");
model.Fax = GetSafeData.ValidateDataRow_String(data, "Fax");
model.Mobile = GetSafeData.ValidateDataRow_String(data, "Mobile");
model.email = GetSafeData.ValidateDataRow_String(data, "email");
model.Addr = GetSafeData.ValidateDataRow_String(data, "Addr");
model.BillType = GetSafeData.ValidateDataRow_String(data, "BillType");
model.PayType = GetSafeData.GetStringFromInt(data, "PayType");
model.MoneyType = GetSafeData.GetStringFromInt(data, "MoneyType");
model.CurrencyType = GetSafeData.GetStringFromInt(data, "CurrencyType");
model.Remark = GetSafeData.ValidateDataRow_String(data, "Remark");
model.UsedStatus = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
model.Creator = GetSafeData.GetStringFromInt(data, "Creator");
model.CreateDate = GetSafeData.GetStringFromDateTime(data, "CreateDate", "yyyy-MM-dd");
model.ModifiedDate = GetSafeData.GetStringFromDateTime(data, "ModifiedDate", "yyyy-MM-dd");
model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
model.EmployeeName = GetSafeData.ValidateDataRow_String(data, "EmployeeName");
}
return(model);
}
/// <summary>
/// 设置参与人员
/// </summary>
/// <param name="dtJionUser">参与人员信息</param>
private void InitJionUserInfo(DataTable dtJionUser)
{
//参与人员ID
StringBuilder sbJoinUserName = new StringBuilder();
//参与人员名
StringBuilder sbJoinUserID = new StringBuilder();
//参与人员存在时，设置参与人员
if (dtJionUser != null && dtJionUser.Rows.Count > 0)
{
//遍历所有参与人员
for (int i = 0; i < dtJionUser.Rows.Count; i++)
{
//获取人员部门区分
//string flag = GetSafeData.ValidateDataRow_String(dtJionUser.Rows[i], "Flag");
//获取参与人ID
string joinID = GetSafeData.GetStringFromInt(dtJionUser.Rows[i], "JoinID");
////部门时
//if (flag.Equals(ConstUtil.DEPT_EMPLOY_FLAG_DEPT))
//{
// //设置参与人ID
// sbJoinUserID.Append(ConstUtil.DEPT_EMPLOY_SELECT_DEPT + joinID + ",");
// //设置参与人名
// sbJoinUserName.Append(GetSafeData.ValidateDataRow_String(dtJionUser.Rows[i], "DeptName") + ";");
//}
//人员时
//else if (flag.Equals(ConstUtil.DEPT_EMPLOY_FLAG_EMPLOY))
//{
//设置参与人ID
//sbJoinUserID.Append(ConstUtil.DEPT_EMPLOY_SELECT_EMPLOY + joinID + ",");
sbJoinUserID.Append(joinID + ",");
//设置参与人名
//sbJoinUserName.Append();
sbJoinUserName.Append(GetSafeData.ValidateDataRow_String(dtJionUser.Rows[i], "EmployeeName") + ",");
//}
}
}
//设置参与人名在页面表示
//DeptJoinUserName.Text = sbJoinUserName.ToString().TrimEnd(';');
UserJoinUserName.Text = sbJoinUserName.ToString().TrimEnd(',');
//设置参与人ID到隐藏域
txtJoinUser.Value = sbJoinUserID.ToString().TrimEnd(',');
}
/// <summary>
/// 初期表示机构信息
/// </summary>
public static string InitDeptQuarterInfo()
{
//定义变量
StringBuilder sbDeptQuarterInfo = new StringBuilder();
//获取机构信息
DataTable dtDeptInfo = GetDeptInfo();
//机构信息存在
if (dtDeptInfo != null && dtDeptInfo.Rows.Count > 0)
{
//表格开始
sbDeptQuarterInfo.AppendLine("<table border='0' cellpadding='0' cellspacing='0'>");
//遍历所有机构信息，获取岗位信息
for (int i = 0; i < dtDeptInfo.Rows.Count; i++)
{
//行开始
sbDeptQuarterInfo.AppendLine("<tr>");
//获取机构ID
string deptID = GetSafeData.GetStringFromInt(dtDeptInfo.Rows[i], "ID");
//获取机构名称
string deptName = GetSafeData.ValidateDataRow_String(dtDeptInfo.Rows[i], "DeptName");
//获取机构岗位信息
// string deptQuarterInfo = GetQuarterInfoWithDeptID(deptID);
// 机构岗位信息设置
sbDeptQuarterInfo.AppendLine("<td ><div id='divDeptName_" + deptID + "' onMouseOver=\"getColor(this.id)\" style=\"cursor:pointer; font-size:13px\" onclick=\"GetInfoByDeptID('" + deptID + "')\">" + deptName + "</div></td>");
// sbDeptQuarterInfo.AppendLine("<td><div id='divDept_" + deptID + "'>" + deptQuarterInfo + "</div></td>");
//行结束
sbDeptQuarterInfo.AppendLine("</tr>");
}
//表格结束
sbDeptQuarterInfo.AppendLine("</table>");
}
//不存在时，提示错误信息
else
{
sbDeptQuarterInfo.AppendLine("您还没有录入组织机构信息");
}
//显示机构岗位信息
return(sbDeptQuarterInfo.ToString());
}
/// <summary>
/// 查询计时工资项信息
/// </summary>
/// <param name="model">查询条件</param>
/// <param name="itemNo">计时项目编号</param>
/// <returns></returns>
public static string GetPieceworkSalaryInfo(EmployeeSearchModel model, string itemNo)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//获取满足条件的人员信息查询
DataTable dtEmplInfo = PieceworkSalaryDBHelper.GetEmplInfo(model, itemNo);
//变量定义
StringBuilder sbPieceworkSalaryInfo = 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 dtPeiceItemInfo = PieceworkSalaryDBHelper.GetPeiceItemInfo(model.CompanyCD
, emplID, itemNo, model.StartDate, model.EndDate);
//变量定义
decimal totalMoney = 0;
int pieceworkItemCount = 0;
int totalRowCount = 0;
StringBuilder sbEmplFirstRow = new StringBuilder();
StringBuilder sbEmplNotFirstRow = new StringBuilder();
//获取工资项目总数
if (dtPeiceItemInfo != null && dtPeiceItemInfo.Rows.Count > 0)
{
pieceworkItemCount = dtPeiceItemInfo.Rows.Count;
}
#region 生成每个计时项目的具体信息
//遍历工资项
for (int j = 0; j < pieceworkItemCount; j++)
{
//变量定义
decimal pieceworkTotalMoney = 0;
StringBuilder sbPieceworkFirstRow = new StringBuilder();
StringBuilder sbPieceworkNotFirstRow = new StringBuilder();
//获取工资项编号
string pieceworkItemNo = GetSafeData.ValidateDataRow_String(dtPeiceItemInfo.Rows[j], "ItemNo");
//获取工资内容
DataTable dtPieceworkSalaryInfo = PieceworkSalaryDBHelper.GetPieceworkSalaryInfo(model.CompanyCD
, emplID, pieceworkItemNo, model.StartDate, model.EndDate);
//获取工资内容总数
int PieceworkSalaryCount = 0;
if (dtPieceworkSalaryInfo != null && dtPieceworkSalaryInfo.Rows.Count > 0)
{
PieceworkSalaryCount = dtPieceworkSalaryInfo.Rows.Count;
}
//单价
string price = StringUtil.TrimZero(GetSafeData.GetStringFromDecimal(dtPeiceItemInfo.Rows[j], "UnitPrice"));
StringBuilder sbItemTemp = new StringBuilder();
//
//工资编号
sbItemTemp.AppendLine("<td class='tdColInputCenter' rowspan='" + PieceworkSalaryCount.ToString() + "'>"
+ "<input type='hidden' id='txtSalaryNo_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "' value='" + pieceworkItemNo + "' />"
+ "<input type='hidden' id='txtSalaryCount_" + (i + 1).ToString() + "_" + (j + 1).ToString() + "' value='"
+ PieceworkSalaryCount + "' />"
+ GetSafeData.ValidateDataRow_String(dtPeiceItemInfo.Rows[j], "ItemName") + "</td>");
//单价
sbItemTemp.AppendLine("<td class='tdColInputCenter' rowspan='" + PieceworkSalaryCount.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 < PieceworkSalaryCount; x++)
{
StringBuilder sbTemp = new StringBuilder();
//数量
string amount = StringUtil.TrimZero(GetSafeData.GetStringFromDecimal(dtPieceworkSalaryInfo.Rows[x], "Amount"));
sbTemp.AppendLine("<td class='tdColInputCenter' >"
+ "<input type='text' class='tdinput' readonly='readonly' id='txtAmount_" + (i + 1).ToString() + "_" + (j + 1).ToString()
+ "_" + (x + 1).ToString() + "' value='" + amount + "' style='width=95%;background-color:#FFFFE0;'"
+ " onblur='CalculateTotalSalary(this, \"" + (i + 1).ToString() + "\", \"" + (j + 1).ToString()
+ "\", \"" + (x + 1).ToString() + "\");' onchange='Number_round(this,\"2\");' maxlength = '8' />" + "</td>");
//金额
string salaryMoney = StringUtil.TrimZero(GetSafeData.GetStringFromDecimal(dtPieceworkSalaryInfo.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(dtPieceworkSalaryInfo.Rows[x], "PieceDate") + "</td>");
//来源
//sbTemp.AppendLine("<td class='tdColInputCenter' id='tdSalaryDate_" + (i + 1).ToString() + "_" + (j + 1).ToString()
// + "_" + (x + 1).ToString() + "'>" + GetSafeData.ValidateDataRow_String(dtPieceworkSalaryInfo.Rows[x], "PieceDate") + "</td>");
//计算小计金额
pieceworkTotalMoney += decimal.Parse(salaryMoney);
if (x == 0)
{
//人员的第一行信息时
if (j == 0)
{
sbEmplFirstRow.AppendLine(sbTemp.ToString());
}
//不是人员的第一行信息，但是是计时工资项的第一行信息
else
{
sbPieceworkFirstRow.AppendLine(sbTemp.ToString());
}
}
else
{
//行开始
sbPieceworkNotFirstRow.AppendLine("<tr>");
sbPieceworkNotFirstRow.AppendLine(sbTemp.ToString());
//行结束
sbPieceworkNotFirstRow.AppendLine("</tr>");
}
}
//工资小计
if (j == 0)
{
sbEmplFirstRow.AppendLine("<td id='tdAmountTotalMoney_" + (i + 1).ToString() + "_" + (j + 1).ToString()
+ "' class='tdColInputCenter' rowspan='" + PieceworkSalaryCount.ToString() + "'>" + pieceworkTotalMoney.ToString() + "</td>");
}
else
{
sbPieceworkFirstRow.AppendLine("<td id='tdAmountTotalMoney_" + (i + 1).ToString() + "_" + (j + 1).ToString()
+ "' class='tdColInputCenter' rowspan='" + PieceworkSalaryCount.ToString() + "'>" + pieceworkTotalMoney.ToString() + "</td></tr>");
}
//计算合计金额
totalMoney += pieceworkTotalMoney;
//行数统计
totalRowCount += PieceworkSalaryCount;
//非第一行时，添加到非第一行的信息里
sbEmplNotFirstRow.AppendLine(sbPieceworkFirstRow.ToString() + sbPieceworkNotFirstRow.ToString());
}
#endregion
//行开始
sbPieceworkSalaryInfo.AppendLine("<tr>");
//选择
sbPieceworkSalaryInfo.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>");
//人员编号
sbPieceworkSalaryInfo.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='" + pieceworkItemCount + "' />"
+ GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "EmployeeNo") + "</td>");
//人员姓名
sbPieceworkSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>"
+ GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "EmployeeName") + "</td>");
//所在部门
sbPieceworkSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>"
+ GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "DeptName") + "</td>");
//岗位名称
sbPieceworkSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>"
+ GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "QuarterName") + "</td>");
//岗位职等
sbPieceworkSalaryInfo.AppendLine("<td class='tdColInputCenter' rowspan='" + totalRowCount.ToString() + "'>"
+ GetSafeData.ValidateDataRow_String(dtEmplInfo.Rows[i], "AdminLevelName") + "</td>");
//具体的计时项目信息
sbPieceworkSalaryInfo.AppendLine(sbEmplFirstRow.ToString());
//工资合计
sbPieceworkSalaryInfo.AppendLine("<td class='tdColInputCenter' id='tdTotalMoney_" + (i + 1).ToString() + "' rowspan='" + totalRowCount.ToString() + "'>" + totalMoney.ToString() + "</td>");
//行结束
sbPieceworkSalaryInfo.AppendLine("</tr>");
//具体的计时项目信息
sbPieceworkSalaryInfo.AppendLine(sbEmplNotFirstRow.ToString());
}
}
return(sbPieceworkSalaryInfo.ToString());
}
/// <summary>
/// 设置工资内容
/// <param name="isHaveInfo">是否包含生产模块区分</param>
/// </summary>
private string InitSalaryDetailInfo(bool isHaveInfo)
{
//定义变量
StringBuilder sbSalaryInfo = new StringBuilder();
//获取数据
DataTable dtSalaryInfo = PieceworkItemBus.GetPieceworkItemInfo(false);
//数据存在时
if (dtSalaryInfo != null && dtSalaryInfo.Rows.Count > 0)
{
//遍历显示所有数据
for (int i = 0; i < dtSalaryInfo.Rows.Count; i++)
{
//插入行开始标识
sbSalaryInfo.AppendLine("<tr>");
//选择框
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtPieceworkID_" + (i + 1).ToString() + "' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ID")
+ "' /><input type='hidden' id='txtEditFlag_" + (i + 1).ToString() + "' value='1' />"
+ "<input type='checkbox' onclick='SetCheckAll(this);' id='chkSelect_" + (i + 1).ToString() + "' /></td>");
//项目编号
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '50' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "ItemNo")
+ "' disabled class='tdinput' id='txtItemNo_" + (i + 1).ToString() + "' /></td>");
string disabled = string.Empty;
//包含生产模块区分
if (isHaveInfo)
{
//不可编辑
disabled = "disabled";
}
//项目名称
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '50' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "ItemName")
+ "'" + disabled + " class='tdinput' id='txtItemName_" + (i + 1).ToString() + "' /></td>");
//单价
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "UnitPrice")
+ "' class='tdinput' id='txtUnitPrice_" + (i + 1).ToString() + "' style='text-align:center' onchange='Number_round(this,\"2\");' /></td>");
//启用状态
string usedStatus = GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "UsedStatus");
//变量定义
string selectZero = string.Empty;
string selectOne = string.Empty;
//停用
if ("0".Equals(usedStatus))
{
selectZero = "selected";
selectOne = "";
}
//启用
else
{
selectZero = "";
selectOne = "selected";
}
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtUsedStatusModify_" + (i + 1).ToString() + "' value='" + usedStatus + "' / >"
+ "<select id='ddlUsedStatus_" + (i + 1).ToString() + "'><option value='0' " + selectZero
+ ">停用</option><option value='1'" + selectOne + ">启用</option></select></td>");
//插入行结束标识
sbSalaryInfo.AppendLine("</tr>");
}
}
//返回信息
return(sbSalaryInfo.ToString());
}
/// <summary>
/// 根据培训ID，获取培训信息，并设置到页面显示
/// </summary>
/// <param name="trainingID">培训ID</param>
private void InitTrainingInfo(string trainingID)
{
//设置培训编号可见
divTrainingNo.Attributes.Add("style", "display:block;");
//自动生成编号的控件设置为不可见
divCodeRule.Attributes.Add("style", "display:none;");
//查询培训信息
DataSet dsTrainingInfo = TrainingBus.GetTrainingInfoWithID(trainingID);
//获取培训基本信息
DataTable dtBaseInfo = dsTrainingInfo.Tables[0];
//基本信息存在时
if (dtBaseInfo != null && dtBaseInfo.Rows.Count > 0)
{
#region 设置培训基本信息
//培训编号
divTrainingNo.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingNo");
//培训名称
txtTrainingName.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingName");
//发起时间
txtApplyDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "ApplyDate");
//发起人
UserCreaterName.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "EmployeeName");
txtCreateID.Value = GetSafeData.GetStringFromInt(dtBaseInfo.Rows[0], "EmployeeID");
//项目编号
txtProjectNo.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "ProjectNo");
//项目名称
txtProjectName.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "ProjectName");
//培训机构
txtTrainingOrgan.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingOrgan");
//预算费用
txtPlanCost.Text = GetSafeData.GetStringFromDecimal(dtBaseInfo.Rows[0], "PlanCost");
//培训天数
txtTrainingCount.Text = GetSafeData.GetStringFromInt(dtBaseInfo.Rows[0], "TrainingCount");
//培训地点
txtTrainingPlace.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingPlace");
//培训方式
ddlTrainingWay.SelectedValue = GetSafeData.GetStringFromInt(dtBaseInfo.Rows[0], "TrainingWay");
//培训老师
txtTrainingTeacher.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingTeacher");
//开始时间
txtStartDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "StartDate");
//结束时间
txtEndDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "EndDate");
//考核人
txtCheckPerson.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckPerson");
//附件
string attatchment = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Attachment");
hfAttachment.Value = attatchment;
hfPageAttachment.Value = attatchment;
//设置下载 上传的显示
if (string.IsNullOrEmpty(attatchment))
{
//简历处理不显示
divDealAttachment.Attributes.Add("style", "display:none;");
//上传简历显示
divUploadAttachment.Attributes.Add("style", "display:block;");
}
else
{
//上传简历不显示
divUploadAttachment.Attributes.Add("style", "display:none;");
//简历处理显示
divDealAttachment.Attributes.Add("style", "display:block;");
}
spanAttachmentName.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "AttachmentName");
//目的
txtGoal.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Goal");
//培训备注
txtTrainingRemark.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingRemark");
#endregion
//设置参与人员
InitJionUserInfo(dsTrainingInfo.Tables[1]);
//设置招聘目标
InitScheduleInfo(dsTrainingInfo.Tables[2]);
}
}
/// <summary>
/// 设置招聘目标
/// </summary>
/// <param name="dtGoal">招聘目标信息</param>
private void InitGoalInfo(DataTable dtGoal)
{
//定义保存招聘目标的变量
StringBuilder sbGoalInfo = new StringBuilder();
//招聘目标存在时，设置招聘目标
if (dtGoal != null && dtGoal.Rows.Count > 0)
{
for (int i = 0; i < dtGoal.Rows.Count; i++)
{
//插入行开始标识
sbGoalInfo.AppendLine("<tr>");
//选择框
sbGoalInfo.AppendLine("<td class='tdColInputCenter' ><input type='checkbox' id='tblRectGoalDetailInfo_chkSelect_" + (i + 1).ToString() + "'>");
//部门ID
sbGoalInfo.AppendLine("<input type='hidden' id='hidDeptID_" + (i + 1).ToString() + "' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "ApplyDept") + "'></td>");
//部门
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "DeptName") + "' class='tdinput' id='DeptrtName_" + (i + 1).ToString() + "' onclick=\"alertdiv('DeptrtName_" + (i + 1).ToString() + ",hidDeptID_" + (i + 1).ToString() + "');\"></td>");
//岗位
//sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
// + GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "PositionTitle") + "' class='tdinput' id='txtPositionTitle_" + (i + 1).ToString() + "'></td>");
sbGoalInfo.AppendLine("<td class='tdColInput'><input type=\"hidden\" id=\"DeptQuarter" + (i + 1).ToString() + "Hidden\" value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "PositionID") + "'/> <input id=\"DeptQuarter" + (i + 1).ToString() + "\" type=\"text\" reado maxlength =\"30\" class=\"tdinput\" onclick =\"treeveiwPopUp.show()\" readonly=\"readonly\" value='" + GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "PositionTitle") + "'/></td>");
//objTD.innerHTML = "<input type=\"hidden\" id=\"DeptQuarter" + (i + 1).ToString() + "Hidden\" value='"
// + GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "PositionID") + "'/> <input id=\"DeptQuarter" + (i + 1).ToString() + "\" type=\"text\" reado maxlength =\"30\" class=\"tdinput\" onclick =\"treeveiwPopUp.show()\" readonly=\"readonly\" value='" + GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "PositionTitle") + "'/> ";
//人员数量
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '3' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "PersonCount") + "' class='tdinput' id='txtPersonCount_" + (i + 1).ToString() + "' onchange='GetRequireNum();'></td>");
//性别
sbGoalInfo.AppendLine("<td class='tdColInputCenter'>"
+ InitSexDropDownList("ddlSex_" + (i + 1).ToString(), GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "Sex")) + "</td>");
//年龄
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '25' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "Age") + "' class='tdinput' id='txtAge_" + (i + 1).ToString() + "'></td>");
sbGoalInfo.AppendLine("<td class='tdColInput'><select class='tdinput'id='txtWorkAge_" + (i + 1).ToString() + "'>" + GetWorkAge(GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "WorkAge")) + "</select></td>");
//学历
sbGoalInfo.AppendLine("<td class='tdColInputCenter'>" +
CodePublicTypeBus.CreateSelectInputControlString(ConstUtil.CODE_TYPE_HUMAN, ConstUtil.CODE_TYPE_CULTURE
, "ddlCultureLevel_" + (i + 1).ToString(), "tdinput", true, GetSafeData.GetStringFromInt(dtGoal.Rows[i], "CultureLevel"))
+ "</td>");
//专业
sbGoalInfo.AppendLine("<td class='tdColInputCenter'>" +
CodePublicTypeBus.CreateSelectInputControlString(ConstUtil.CODE_TYPE_HUMAN, ConstUtil.CODE_TYPE_PROFESSIONAL
, "ddlProfessional_" + (i + 1).ToString(), "tdinput", true, GetSafeData.GetStringFromInt(dtGoal.Rows[i], "Professional"))
+ "</td>");
//要求
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '500' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "Requisition") + "' class='tdinput' id='txtRequisition_" + (i + 1).ToString() + "'></td>");
//计划完成时间
sbGoalInfo.AppendLine("<td class='tdColInputCenter'><input type='text' readonly maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtGoal.Rows[i], "CompleteDate", "yyyy-MM-dd")
+ "' class='tdinput' id='txtCompleteDate_" + (i + 1).ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtCompleteDate_" + (i + 1).ToString() + "')})\"></td>");
//插入行结束标识
sbGoalInfo.AppendLine("</tr>");
}
}
//招聘目标设置到DIV中表示
divRectGoalDetail.InnerHtml = CreateGoalTable() + sbGoalInfo.ToString() + EndTable();
}
/// <summary>
/// 根据考试记录ID，获取考试记录信息，并设置到页面显示
/// </summary>
/// <param name="asseID">考核ID</param>
private void InitTestInfo(string testID)
{
//查询考试信息
DataSet dsTestInfo = EmployeeTestBus.GetTestInfoWithID(testID);
//获取考试基本信息
DataTable dtBaseInfo = dsTestInfo.Tables[0];
//基本信息存在时
if (dtBaseInfo != null && dtBaseInfo.Rows.Count > 0)
{
#region 设置考试记录基本信息
//设置培训编号不可见
divCodeNo.Attributes.Add("style", "display:block;");
divCodeNo.Attributes.Add("style", "width:60%;");
//自动生成编号的控件设置为可见
divCodeRule.Attributes.Add("style", "display:none;");
//考试编号
divCodeNo.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TestNo");
//主题
txtTitle.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Title");
//考试负责人
UserTeacher.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "EmployeeName");
txtTeacher.Value = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Teacher");
//开始时间
txtStartDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "StartDate");
//结束时间
txtEndDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "EndDate");
//考试地点
txtAddress.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Addr");
//考试结果
txtTestResult.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TestResult");
//考试状态
ddlStatus.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Status");
//附件
string attach = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Attachment");
//附件未上传时
if (string.IsNullOrEmpty(attach))
{
divUploadAttachment.Attributes.Add("style", "display:block;");
divDealAttachment.Attributes.Add("style", "display:none;");
}
//上传了附件时
else
{
divUploadAttachment.Attributes.Add("style", "display:none;");
divDealAttachment.Attributes.Add("style", "display:block;");
}
//
spanAttachmentName.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "AttachmentName");
//设置附件
hfAttachment.Value = attach;
hfPageAttachment.Value = attach;
//考试内容摘要
txtContent.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TestContent");
//备注
txtRemark.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Remark");
//缺考人数
txtAbsenceCount.Text = GetSafeData.GetStringFromInt(dtBaseInfo.Rows[0], "AbsenceCount");
#endregion
//设置考试结果
InitTestResultInfo(dsTestInfo.Tables[1]);
}
}
private void InitGoalInfo(DataTable dtGoal)
{
//定义保存招聘目标的变量
StringBuilder sbGoalInfo = new StringBuilder();
//招聘目标存在时，设置招聘目标
if (dtGoal != null && dtGoal.Rows.Count > 0)
{
for (int i = 0; i < dtGoal.Rows.Count; i++)
{
//插入行开始标识
sbGoalInfo.AppendLine("<tr>");
//选择框
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='checkbox' id='tblRectGoalDetailInfo_chkSelect_" + (i + 1).ToString() + "'>");
//岗位
sbGoalInfo.AppendLine("<td class='tdColInput'><input type=\"hidden\" id=\"DeptQuarter" + (i + 1).ToString() + "Hidden\" value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "JobID") + "'/> <input id=\"DeptQuarter" + (i + 1).ToString() + "\" type=\"text\" reado maxlength =\"30\" class=\"tdinput\" onclick =\"treeveiwPopUp.show()\" readonly=\"readonly\" value='" + GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "JobName") + "'/></td>");
//职务说明
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '100' size='10' class='tdinput' id='txtJobDescripe_" + (i + 1).ToString() + "' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "JobDescripe") + "' ondblclick ='alertContent(this.id)' ></td>");
//需求人数
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '3' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "RectCount") + "' class='tdinput' id='txtPersonCount_" + (i + 1).ToString() + "' onchange='GetRequireNum();'></td>");
//最迟上岗时间
sbGoalInfo.AppendLine("<td class='tdColInputCenter'><input type='text' readonly maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtGoal.Rows[i], "UsedDate", "yyyy-MM-dd")
+ "' class='tdinput' id='txtUsedDate_" + (i + 1).ToString() + "' onclick=\"J.calendar.get();\"></td>");
//工作地点
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '100' size='10' class='tdinput' id='txtWorkPlace_" + (i + 1).ToString() + "' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "WorkPlace") + "' ondblclick ='alertContent(this.id)'></td>");
//工作性质
sbGoalInfo.AppendLine("<td class='tdColInput'>"
+ InitWorkNatureDropDownList("ddlWorkNature_" + (i + 1).ToString(), GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "WorkNature")) + "</td>");
//性别
sbGoalInfo.AppendLine("<td class='tdColInputCenter'>"
+ InitSexDropDownList("ddlSex_" + (i + 1).ToString(), GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "Sex")) + "</td>");
//起始年龄
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '3' size='3' class='tdinput' id='txtMinAge_" + (i + 1).ToString() + "' onkeydown='Numeric_OnKeyDown();' value='" + GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "MinAge") + "'></td>");
//截止年龄
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '3' size='3' class='tdinput' id='txtMaxAge_" + (i + 1).ToString() + "' onkeydown='Numeric_OnKeyDown();' value='" + GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "MaxAge") + "'></td>");
//专业
sbGoalInfo.AppendLine("<td class='tdColInputCenter'>" +
CodePublicTypeBus.CreateSelectInputControlString(ConstUtil.CODE_TYPE_HUMAN, ConstUtil.CODE_TYPE_PROFESSIONAL
, "ddlProfessional_" + (i + 1).ToString(), "tdinput", true, GetSafeData.GetStringFromInt(dtGoal.Rows[i], "Professional"))
+ "</td>");
//学历
sbGoalInfo.AppendLine("<td class='tdColInputCenter'>" +
CodePublicTypeBus.CreateSelectInputControlString(ConstUtil.CODE_TYPE_HUMAN, ConstUtil.CODE_TYPE_CULTURE
, "ddlCultureLevel_" + (i + 1).ToString(), "tdinput", true, GetSafeData.GetStringFromInt(dtGoal.Rows[i], "CultureLevel"))
+ "</td>");
//工作年限
sbGoalInfo.AppendLine("<td class='tdColInput'>"
+ InitWorkAgeDropDownList("ddlWorkAge_" + (i + 1).ToString(), GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "WorkAge")) + "</td>");
//工作要求
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '1000' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "WorkNeeds") + "' class='tdinput' id='txtRequisition_" + (i + 1).ToString() + "' ondblclick ='alertContent(this.id)' ></td>");
//其他要求
sbGoalInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '1000' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "OtherAbility") + "' class='tdinput' id='txtOtherAbility_" + (i + 1).ToString() + "' title='" + GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "OtherAbility") + "' ondblclick ='alertContent(this.id)' ></td>");
//其他要求
sbGoalInfo.AppendLine("<td class='tdColInput' title='" + GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "SalaryNote") + "' ><input type='text' maxlength = '1000' value='"
+ GetSafeData.ValidateDataRow_String(dtGoal.Rows[i], "SalaryNote") + "' class='tdinput' id='txtSalaryNote_" + (i + 1).ToString() + "' ondblclick ='alertContent(this.id)' ></td>");
//插入行结束标识
sbGoalInfo.AppendLine("</tr>");
}
}
//招聘目标设置到DIV中表示
divRectGoalDetail.InnerHtml = CreateGoalTable() + sbGoalInfo.ToString() + EndTable();
}
/// <summary>
/// 获取岗位信息树
/// </summary>
/// <param name="dtDeptQuarterInfo">岗位信息</param>
/// <returns></returns>
private static string GetQuarterTreeInfo(DataTable dtDeptQuarterInfo)
{
//定义变量
StringBuilder sbDeptQuarterInfo = new StringBuilder();
//数据存在时
if (dtDeptQuarterInfo != null && dtDeptQuarterInfo.Rows.Count > 0)
{
//获取记录数
int deptQuarterCount = dtDeptQuarterInfo.Rows.Count;
//遍历所有机构岗位，以显示数据
for (int i = 0; i < dtDeptQuarterInfo.Rows.Count; i++)
{
//获取岗位ID
string quarterID = GetSafeData.GetStringFromInt(dtDeptQuarterInfo.Rows[i], "ID");
//获取岗位名称
string quarterName = GetSafeData.ValidateDataRow_String(dtDeptQuarterInfo.Rows[i], "QuarterName");
//获取父岗位
string superQuarterID = GetSafeData.GetStringFromInt(dtDeptQuarterInfo.Rows[i], "SuperQuarterID");
//获取所属机构
string deptID = GetSafeData.GetStringFromInt(dtDeptQuarterInfo.Rows[i], "DeptID");
//获取是否有子岗位
int subCount = GetSafeData.ValidateDataRow_Int(dtDeptQuarterInfo.Rows[i], "SubCount");
//样式名称
string className = "file";
//Javascript事件名
string jsAction = "";
//样式表名称
string showClass = "list";
//有子结点时
if (subCount > 0)
{
//最后一个结点
if (i == deptQuarterCount - 1)
{
className = "folder_close_end";
showClass = "list_last";
}
else
{
className = "folder_close";
}
jsAction = "onclick=\"ShowDeptQuarterTree('" + quarterID + "');\"";
}
else if (i == deptQuarterCount - 1)
{
className = "file_end";
}
//生成子树代码
sbDeptQuarterInfo.Append("<table border='0' cellpadding='0' cellspacing='0'>");
sbDeptQuarterInfo.Append("<tr><td><div id='divQSuper_" + quarterID + "' class='" + className + "' " + jsAction
+ " alt='" + quarterName + "'><a href='#' onclick=\"SetSelectValue('"
+ quarterID + "','" + quarterName + "','" + superQuarterID + "','"
+ deptID + "');\"><div id='divQuarterName_" + quarterID
+ "'>" + " " + quarterName + "</div></a></div>");
sbDeptQuarterInfo.Append("<div id='divQSub_" + quarterID + "' style='display:none;' class='" + showClass + "'></div></td></tr>");
sbDeptQuarterInfo.Append("</table>");
}
}
//返回
return(sbDeptQuarterInfo.ToString());
}
/// <summary>
/// 设置人员工作履历以及学习履历
/// </summary>
/// <param name="employModel">人员信息</param>
private void InitHistoryInfo(EmployeeInfoModel employModel)
{
//获取技能信息
DataTable dtHistory = employModel.HistoryInfo;
//定义保存工作履历详细信息变量
StringBuilder sbWorkInfo = new StringBuilder();
//定义保存学习履历详细信息变量
StringBuilder sbStudyInfo = new StringBuilder();
//技能信息存在时，设置技能信息
if (dtHistory != null && dtHistory.Rows.Count > 0)
{
//工作履历记录数
int workCount = 1;
//学习履历记录数
int studyCount = 1;
//遍历所有技能信息
for (int i = 0; i < dtHistory.Rows.Count; i++)
{
//区分
string flag = GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "Flag");
//工作履历
if (ConstUtil.HUMAN_HISTORY_WORK.Equals(flag))
{
//插入行开始标识
sbWorkInfo.AppendLine("<tr>");
//选择框
sbWorkInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='tblWorkHistory_chkSelect_" + workCount.ToString() + "'></td>");
//开始时间
sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtHistory.Rows[i], "StartDate", "yyyy-MM-dd")
+ "' class='tdinput' readonly id='txtWorkStart_" + workCount.ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtWorkStart_" + workCount.ToString() + "')})\"></td>");
//结束时间
sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtHistory.Rows[i], "EndDate", "yyyy-MM-dd")
+ "' class='tdinput' readonly id='txtWorkEnd_" + workCount.ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtWorkEnd_" + workCount.ToString() + "')})\"></td>");
//工作单位
sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "Company") + "' class='tdinput' id='txtWorkCompany_" + workCount.ToString() + "'></td>");
//所在部门
sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "Department") + "' class='tdinput' id='txtWorkDept_" + workCount.ToString() + "'></td>");
//工作内容
sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "WorkContent") + "' class='tdinput' id='txtWorkContent_" + workCount.ToString() + "'></td>");
//离职原因
sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "LeaveReason") + "' class='tdinput' id='txtLeaveReason_" + workCount.ToString() + "'></td>");
//插入行结束标识
sbWorkInfo.AppendLine("</tr>");
//增长工作履历数
workCount++;
}
//学习履历
else if (ConstUtil.HUMAN_HISTORY_STUDY.Equals(flag))
{
//插入行开始标识
sbStudyInfo.AppendLine("<tr>");
//选择框
sbStudyInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='tblStudyHistory_chkSelect_" + studyCount.ToString() + "'></td>");
//开始时间
sbStudyInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtHistory.Rows[i], "StartDate", "yyyy-MM-dd")
+ "' class='tdinput' readonly id='txtStudyStart_" + studyCount.ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtStudyStart_" + studyCount.ToString() + "')})\"></td>");
//结束时间
sbStudyInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtHistory.Rows[i], "EndDate", "yyyy-MM-dd")
+ "' class='tdinput' readonly id='txtStudyEnd_" + studyCount.ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtStudyEnd_" + studyCount.ToString() + "')})\"></td>");
//学校名称
sbStudyInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "SchoolName") + "' class='tdinput' id='txtSchoolName_" + studyCount.ToString() + "'></td>");
//专业
sbStudyInfo.AppendLine("<td class='tdColInput'>" +
CodePublicTypeBus.CreateSelectInputControlString(ConstUtil.CODE_TYPE_HUMAN, ConstUtil.CODE_TYPE_PROFESSIONAL
, "ddlProfessional_" + studyCount.ToString(), "tdinput", false, GetSafeData.GetStringFromInt(dtHistory.Rows[i], "Professional"))
+ "</td>");
//学历
sbStudyInfo.AppendLine("<td class='tdColInput'>" +
CodePublicTypeBus.CreateSelectInputControlString(ConstUtil.CODE_TYPE_HUMAN, ConstUtil.CODE_TYPE_CULTURE
, "ddlCultureLevel_" + studyCount.ToString(), "tdinput", false, GetSafeData.GetStringFromInt(dtHistory.Rows[i], "CultureLevel"))
+ "</td>");
//插入行结束标识
sbStudyInfo.AppendLine("</tr>");
//增长学习履历数
studyCount++;
}
}
}
//工作履历设置到DIV中表示
divWorkInfo.InnerHtml = CreateWorkTable() + sbWorkInfo.ToString() + EndTable();
//学习履历设置到DIV中表示
divStudyInfo.InnerHtml = CreateStudyTable() + sbStudyInfo.ToString() + EndTable();
}
/// <summary>
/// 设置工资内容
/// </summary>
private string InitSalaryDetailInfo(string DeptID)
{
//定义变量
StringBuilder sbSalaryInfo = new StringBuilder();
//获取数据
DataTable dtSalaryInfo = SalaryCompanyRoyaltySetBus.GetInfoTable(DeptID);
//数据存在时
if (dtSalaryInfo != null && dtSalaryInfo.Rows.Count > 0)
{
//遍历显示所有数据
for (int i = 0; i < dtSalaryInfo.Rows.Count; i++)
{
//插入行开始标识
sbSalaryInfo.AppendLine("<tr>");
//选择框
if (i == dtSalaryInfo.Rows.Count - 1)
{
//选择
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtSalaryID_" + (i + 1).ToString() + "' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ID")
+ "' /><input type='hidden' id='txtEditFlag_" + (i + 1).ToString() + "' value='1' />"
+ "<input type='checkbox' onclick='SetCheckAll(this);' id='chkSelect_" + (i + 1).ToString() + "' /></td>");
//公司名称
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' onclick=\"getsubcompany(this.id,'Hid'+this.id);\" readonly=\"readonly\" style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "DeptName")
+ "' class='tdinput' id='txtDept_" + (i + 1).ToString() + "' />"
+ "<input type='hidden' id='HidtxtDept_" + (i + 1).ToString() + "' value='" + GetSafeData.ValidateDataRow_Int(dtSalaryInfo.Rows[i], "DeptID") + "'></td>");
//业绩上限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onkeydown='Numeric_OnKeyDown();' onchange='Number_round(this,\"0\");' readonly=\"readonly\" style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MiniMoney")
+ "' class='tdinput' id='txtMiniMoney_" + (i + 1).ToString() + "' /></td>");
//业绩下限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onkeydown='Numeric_OnKeyDown();' onchange='Number_round(this,\"0\");' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MaxMoney")
+ "' class='tdinput' id='txtMaxMoney_" + (i + 1).ToString() + "' /></td>");
//提成率
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '3' style='width:98%;' onkeydown='Numeric_OnKeyDown();' onchange='Number_round(this,\"2\");' onblur='CalculateTotalSalary(this,\"" + (i + 1).ToString() + "\");' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "TaxPercent")
+ "' class='tdinput' id='txtTaxPercent_" + (i + 1).ToString() + "' /></td>");
}
else
{
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtSalaryID_" + (i + 1).ToString() + "' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ID")
+ "' /><input type='hidden' id='txtEditFlag_" + (i + 1).ToString() + "' value='1' />"
+ "<input type='checkbox' onclick='SetCheckAll(this);' id='chkSelect_" + (i + 1).ToString() + "' style=\"display:none \" /></td>");
//公司名称
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' onclick=\"getsubcompany(this.id,'Hid'+this.id);\" readonly=\"readonly\" style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "DeptName")
+ "' class='tdinput' id='txtDept_" + (i + 1).ToString() + "' /><input type='hidden' id='HidtxtDept_" + (i + 1).ToString() + "'></td>");
//业绩上限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onkeydown='Numeric_OnKeyDown();' readonly=\"readonly\" onchange='Number_round(this,\"0\");' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MiniMoney")
+ "' class='tdinput' id='txtMiniMoney_" + (i + 1).ToString() + "' /></td>");
//业绩下限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onkeydown='Numeric_OnKeyDown();' readonly=\"readonly\" onchange='Number_round(this,\"0\");' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MaxMoney")
+ "' class='tdinput' id='txtMaxMoney_" + (i + 1).ToString() + "' /></td>");
//提成率
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '3' style='width:98%;' onkeydown='Numeric_OnKeyDown();' onchange='Number_round(this,\"2\");' readonly=\"readonly\" onblur='CalculateTotalSalary(this,\"" + (i + 1).ToString() + "\");' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "TaxPercent")
+ "' class='tdinput' id='txtTaxPercent_" + (i + 1).ToString() + "' /></td>");
}
//插入行结束标识
sbSalaryInfo.AppendLine("</tr>");
}
}
//返回信息
return(sbSalaryInfo.ToString());
}
/// <summary>
/// 设置工资内容
/// </summary>
private string InitSalaryDetailInfo()
{
//定义变量
StringBuilder sbSalaryInfo = new StringBuilder();
//获取数据
DataTable dtSalaryInfo = SalaryItemBus.GetSalaryItemInfo(false);
//数据存在时
if (dtSalaryInfo != null && dtSalaryInfo.Rows.Count > 0)
{
//遍历显示所有数据
for (int i = 0; i < dtSalaryInfo.Rows.Count; i++)
{
//插入行开始标识
sbSalaryInfo.AppendLine("<tr>");
//选择框
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtItemNo_" + (i + 1).ToString() + "' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ItemNo")
+ "' /><input type='hidden' id='txtEditFlag_" + (i + 1).ToString() + "' value='1' />"
+ "<input type='checkbox' onclick='SetCheckAll(this);' id='chkSelect_" + (i + 1).ToString() + "' /></td>");
//固定工资项编号
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' readonly='readonly' id='txtItem2No_" + (i + 1).ToString() + "' class='tdinput' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ItemNo")
+ "' /> "
+ " </td>");
//排列顺序
sbSalaryInfo.AppendLine("<td class='tdColInputCenter' id='tdRowNo_" + (i + 1).ToString() + "'>"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ItemOrder") + "</td>");
//名称
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '50' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "ItemName")
+ "' class='tdinput' id='txtSalaryName_" + (i + 1).ToString() + "' /></td>");
//计算公式
string t = GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "Calculate");
while (t.IndexOf('A') != -1)
{
t = t.Replace('A', '+');
}
sbSalaryInfo.AppendLine("<td class='tdColInputCenter' >"
+ "<input type='hidden' value='"
+ t + "' id='txtCalculate_" + (i + 1).ToString() + "' />"
+ "<input type='hidden' value='"
+ GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "ParamsList") + "' id='txtCalculateParam_" + (i + 1).ToString() + "' />"
+ "<a href='#' onclick='DoEditCalculate( +\"" + GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ItemNo") + "\" ,\"" + (i + 1).ToString() + "\");'>编辑计算公式</a></td>");
//备注
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '100' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "Remark")
+ "' class='tdinput' id='txtRemark_" + (i + 1).ToString() + "' /></td>");
//变量定义
string selectZero = string.Empty;
string selectOne = string.Empty;
//是否扣款
//否
if ("0".Equals(GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "PayFlag")))
{
selectZero = "selected";
}
//是
else
{
selectOne = "selected";
}
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<select id='ddlPayFlag_" + (i + 1).ToString() + "'><option value='0' " + selectZero
+ ">否</option><option value='1'" + selectOne + ">是</option></select></td>");
//是否固定
//否
if ("0".Equals(GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "ChangeFlag")))
{
selectZero = "selected";
selectOne = "";
}
//是
else
{
selectZero = "";
selectOne = "selected";
}
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<select id='ddlChangeFlag_" + (i + 1).ToString() + "'><option value='0' " + selectZero
+ ">否</option><option value='1'" + selectOne + ">是</option></select></td>");
//启用状态
string usedStatus = GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "UsedStatus");
//停用
if ("0".Equals(usedStatus))
{
selectZero = "selected";
selectOne = "";
}
//启用
else
{
selectZero = "";
selectOne = "selected";
}
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtUsedStatusModify_" + (i + 1).ToString() + "' value='" + usedStatus + "' / >"
+ "<select id='ddlUsedStatus_" + (i + 1).ToString() + "'><option value='0' " + selectZero
+ ">停用</option><option value='1'" + selectOne + ">启用</option></select></td>");
//插入行结束标识
sbSalaryInfo.AppendLine("</tr>");
}
}
//返回信息
return(sbSalaryInfo.ToString());
}
/// <summary>
/// 设置工资内容
/// </summary>
private string InitSalaryDetailInfo()
{
//定义变量
StringBuilder sbSalaryInfo = new StringBuilder();
//获取数据
DataTable dtSalaryInfo = InsuSocialBus.GetInsuSocialInfo(false);
//数据存在时
if (dtSalaryInfo != null && dtSalaryInfo.Rows.Count > 0)
{
//遍历显示所有数据
for (int i = 0; i < dtSalaryInfo.Rows.Count; i++)
{
//插入行开始标识
sbSalaryInfo.AppendLine("<tr>");
//选择框
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtSalaryID_" + (i + 1).ToString() + "' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ID")
+ "' /><input type='hidden' id='txtEditFlag_" + (i + 1).ToString() + "' value='1' />"
+ "<input type='checkbox' onclick='SetCheckAll(this);' id='chkSelect_" + (i + 1).ToString() + "' /></td>");
//保险名称
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '50' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "InsuranceName")
+ "' class='tdinput' id='txtInsuranceName_" + (i + 1).ToString() + "' /></td>");
//单位比例
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '6' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "CompanyPayRate")
+ "' class='tdinput' id='txtCompanyPayRate_" + (i + 1).ToString() + "' onchange='Number_round(this,\"2\");' /></td>");
//个人比例
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '6' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "PersonPayRate")
+ "' class='tdinput' id='txtPersonPayRate_" + (i + 1).ToString() + "' onchange='Number_round(this,\"2\");' /></td>");
//变量定义
string selectOne = string.Empty;
string selectTwo = string.Empty;
//投保方式
//按月
if ("1".Equals(GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "InsuranceWay")))
{
selectOne = "selected";
selectTwo = "";
}
//按年
else
{
selectOne = "";
selectTwo = "selected";
}
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<select id='ddlInsuranceWay_" + (i + 1).ToString() + "'><option value='1' " + selectOne
+ ">按月</option><option value='2'" + selectTwo + ">按年</option></select></td>");
//启用状态
string usedStatus = GetSafeData.ValidateDataRow_String(dtSalaryInfo.Rows[i], "UsedStatus");
//停用
if ("0".Equals(usedStatus))
{
selectOne = "selected";
selectTwo = "";
}
//启用
else
{
selectOne = "";
selectTwo = "selected";
}
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtUsedStatusModify_" + (i + 1).ToString() + "' value='" + usedStatus + "' / >"
+ "<select id='ddlUsedStatus_" + (i + 1).ToString() + "'><option value='0' " + selectOne
+ ">停用</option><option value='1'" + selectTwo + ">启用</option></select></td>");
//插入行结束标识
sbSalaryInfo.AppendLine("</tr>");
}
}
//返回信息
return(sbSalaryInfo.ToString());
}
/// <summary>
/// 设置工资内容
/// </summary>
private string InitSalaryDetailInfo()
{
//定义变量
StringBuilder sbSalaryInfo = new StringBuilder();
//获取数据
DataTable dtSalaryInfo = InsuPersonaIncomeTaxBus.GetInsuPersonalTaxInfo();
//数据存在时
if (dtSalaryInfo != null && dtSalaryInfo.Rows.Count > 0)
{
//遍历显示所有数据
for (int i = 0; i < dtSalaryInfo.Rows.Count; i++)
{
//插入行开始标识
sbSalaryInfo.AppendLine("<tr>");
//选择框
if (i == dtSalaryInfo.Rows.Count - 1)
{
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtSalaryID_" + (i + 1).ToString() + "' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ID")
+ "' /><input type='hidden' id='txtEditFlag_" + (i + 1).ToString() + "' value='1' />"
+ "<input type='checkbox' onclick='SetCheckAll(this);' id='chkSelect_" + (i + 1).ToString() + "' /></td>");
//应缴税上限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onchange='Number_round(this,\"0\");' readonly=\"readonly\" style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MinMoney")
+ "' class='tdinput' id='txtMinMoney_" + (i + 1).ToString() + "' /></td>");
//应缴税下限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' onchange='Number_round(this,\"0\");' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MaxMoney")
+ "' class='tdinput' id='txtMaxMoney_" + (i + 1).ToString() + "' /></td>");
//税率
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '3' style='width:98%;' onchange='Number_round(this,\"2\");' onblur='CalculateTotalSalary(this,\"" + (i + 1).ToString() + "\");' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "TaxPercent")
+ "' class='tdinput' id='txtPersonTaxPercent_" + (i + 1).ToString() + "' /></td>");
//速算扣除数（元）
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '16' readonly ='readonly' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MinusMoney")
+ "' class='tdinput' id='txtPersonMinusMoney_" + (i + 1).ToString() + "' /></td>");
}
else
{
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='hidden' id='txtSalaryID_" + (i + 1).ToString() + "' value='"
+ GetSafeData.GetStringFromInt(dtSalaryInfo.Rows[i], "ID")
+ "' /><input type='hidden' id='txtEditFlag_" + (i + 1).ToString() + "' value='1' />"
+ "<input type='checkbox' onclick='SetCheckAll(this);' id='chkSelect_" + (i + 1).ToString() + "' style=\"display:none \" /></td>");
//应缴税上限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' readonly=\"readonly\" onchange='Number_round(this,\"0\");' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MinMoney")
+ "' class='tdinput' id='txtMinMoney_" + (i + 1).ToString() + "' /></td>");
//应缴税下限
sbSalaryInfo.AppendLine("<td class='tdColInputCenter'>"
+ "<input type='text' maxlength = '12' readonly=\"readonly\" onchange='Number_round(this,\"0\");' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MaxMoney")
+ "' class='tdinput' id='txtMaxMoney_" + (i + 1).ToString() + "' /></td>");
//税率
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '3' style='width:98%;' onchange='Number_round(this,\"2\");' readonly=\"readonly\" onblur='CalculateTotalSalary(this,\"" + (i + 1).ToString() + "\");' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "TaxPercent")
+ "' class='tdinput' id='txtPersonTaxPercent_" + (i + 1).ToString() + "' /></td>");
//速算扣除数（元）
sbSalaryInfo.AppendLine("<td class='tdColInput'>"
+ "<input type='text' maxlength = '16' readonly ='readonly' style='width:98%;' value='"
+ GetSafeData.ValidateDataRow_Decimal(dtSalaryInfo.Rows[i], "MinusMoney")
+ "' class='tdinput' id='txtPersonMinusMoney_" + (i + 1).ToString() + "' /></td>");
}
//插入行结束标识
sbSalaryInfo.AppendLine("</tr>");
}
}
//返回信息
return(sbSalaryInfo.ToString());
}
