/// <summary>
/// 根据ID获取分类信息
/// </summary>
/// <returns></returns>
public static CodeEquipmentTypeModel GetCodeBigTypeById(int id, string TableName)
{
CodeEquipmentTypeModel model = new CodeEquipmentTypeModel();
string sql = "select * from " + TableName + " where id=@id ";
SqlParameter[] param = new SqlParameter[1];
param[0] = SqlHelper.GetParameter("@id", id);
DataTable dt = SqlHelper.ExecuteSql(sql, param);
DataRow data = dt.Rows[0];
if (dt.Rows.Count > 0)
{
model.SupperID = GetSafeData.ValidateDataRow_Int(data, "SupperID");
model.ModifiedDate = GetSafeData.ValidateDataRow_DateTime(data, "ModifiedDate");
model.UsedStatus = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
model.CodeName = GetSafeData.ValidateDataRow_String(data, "CodeName");
model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
model.Description = GetSafeData.ValidateDataRow_String(data, "Description");
if (TableName == "officedba.CodeCompanyType")// 往来单位
{
model.BigType = GetSafeData.ValidateDataRow_String(data, "BigType");
}
else if (TableName == "officedba.CodeProductType")
{
model.BigType = GetSafeData.ValidateDataRow_String(data, "TypeFlag");
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获取并设置人员信息
/// </summary>
/// <param name="ID">ID</param>
private void InitEmployeInfo(string ID)
{
//获取申请单数据
DataTable dtEmpl = EmployeeInfoBus.GetEmplDeptInfoWithID(ID);
//数据存在时，设置值
if (dtEmpl != null && dtEmpl.Rows.Count > 0)
{
//离职人
txtEmployeeID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "ID");
//员工编号
txtEmployeeNo.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeNo");
//员工名
txtEmployeeName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeName");
//部门名称
txtDeptName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "DeptName");
//岗位名
txtQuarterName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "QuarterName");
//岗位职等
txtAdminLevelName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "AdminLevelName");
//入职时间
txtEnterDate.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EnterDate");
//设置不可编辑
txtEmployeeNo.Enabled = false;
}
}
/// <summary>
/// 设置进度安排
/// </summary>
/// <param name="dtSchedule">进度安排信息</param>
private void InitScheduleInfo(DataTable dtSchedule)
{
//定义保存进度安排的变量
StringBuilder sbScheduleInfo = new StringBuilder();
//进度安排存在时，设置进度安排
if (dtSchedule != null && dtSchedule.Rows.Count > 0)
{
for (int i = 0; i < dtSchedule.Rows.Count; i++)
{
//插入行开始标识
sbScheduleInfo.AppendLine("<tr>");
//选择框
sbScheduleInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='chkSelect_" + (i + 1).ToString() + "'></td>");
//进度时间
sbScheduleInfo.AppendLine("<td class='tdColInputCenter'><input type='text' maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtSchedule.Rows[i], "ScheduleDate", "yyyy-MM-dd")
+ "' class='tdinput' id='txtScheduleDate_" + (i + 1).ToString() + "' onfocus=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtScheduleDate_" + (i + 1).ToString() + "')})\"></td>");
//内容摘要时间
sbScheduleInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '100' value='"
+ GetSafeData.ValidateDataRow_String(dtSchedule.Rows[i], "Abstract") + "' class='tdinput' id='txtAbstract_" + (i + 1).ToString() + "'></td>");
//备注
sbScheduleInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '100' value='"
+ GetSafeData.ValidateDataRow_String(dtSchedule.Rows[i], "Remark") + "' class='tdinput' id='txtRemark_" + (i + 1).ToString() + "'></td>");
//插入行结束标识
sbScheduleInfo.AppendLine("</tr>");
}
}
//进度安排设置到DIV中表示
divScheduleInfo.InnerHtml = CreateScheduleTable() + sbScheduleInfo.ToString() + EndTable();
}
public static bool IsCheck(string TaskNo, string CompanyCD)
{
//校验SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine(" SELECT ");
searchSql.AppendLine(" Status ");
searchSql.AppendLine(" FROM ");
searchSql.AppendLine(" officedba.PerformancePersonal ");
searchSql.AppendLine(" WHERE CompanyCD='" + CompanyCD + "' ");
searchSql.AppendLine("and id ='" + TaskNo + "'");
//执行查询
DataTable dtCount = SqlHelper.ExecuteSql(searchSql.ToString());
//获取记录数
string Status = GetSafeData.ValidateDataRow_String(dtCount.Rows[0], "Status");
if (Status == "1")
{
return(false);
}
else
{
return(true);
}
//返回结果
//return count > 0 ? true : false;
}
/// <summary>
/// 根据面试模板ID，获取模板信息，并设置到页面显示
/// </summary>
/// <param name="templateID">模板ID</param>
private void InitTemplateInfo(string templateID)
{
//设置编号可见
divCodeNo.Attributes.Add("style", "display:block;");
//自动生成编号的控件设置为不可见
divCodeRule.Attributes.Add("style", "display:none;");
//查询考试信息
DataSet dsTemplateInfo = RectCheckTemplateBus.GetRectCheckTemplateInfoWithID(templateID);
//获取考试基本信息
DataTable dtBaseInfo = dsTemplateInfo.Tables[0];
//基本信息存在时
if (dtBaseInfo != null && dtBaseInfo.Rows.Count > 0)
{
#region 设置基本信息
//模板编号
divCodeNo.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TemplateNo");
//主题
txtTitle.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Title");
//岗位
ddlQuarter.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "QuarterID");
//考试状态
txtRemark.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Remark");
#endregion
//设置要素信息
InitElemInfo(dsTemplateInfo.Tables[1]);
}
}
/// <summary>
/// 获取并设置人员信息
/// </summary>
/// <param name="ID">ID</param>
private void InitEmployeInfo(string ID)
{
//获取申请单数据
DataTable dtEmpl = EmployeeInfoBus.GetEmplDeptInfoWithID(ID);
//数据存在时，设置值
if (dtEmpl != null && dtEmpl.Rows.Count > 0)
{
//调职人
txtEmployeeID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "ID");
divCodeNo.Attributes.Add("style", "width:60%;");
//员工编号
txtEmployeeNo.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeNo");
//员工名
txtEmployeeName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "EmployeeName");
//原部门名称
txtNowDeptName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "DeptName");
//原部门ID
txtNowDeptID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "DeptID");
//原岗位名
txtNowQuarterName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "QuarterName");
//原岗位ID
txtNowQuarterID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "QuarterID");
//原岗位职等名称
txtNowQuarterAdminName.Text = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "AdminLevelName");
//原岗位职等ID
txtNowQuarterAdminID.Value = GetSafeData.ValidateDataRow_String(dtEmpl.Rows[0], "AdminLevelID");
//设置不可编辑
txtEmployeeNo.Enabled = false;
}
}
public void GetTempalte(string quarterID, string templateNo)
{
DataTable dtTemplate = RectInterviewBus.GetTemplateInfo(quarterID);
StringBuilder sbTemplateInfo = new StringBuilder();
//数据存在的时候
if (dtTemplate != null && dtTemplate.Rows.Count > 0)
{
//遍历所有模板信息
for (int i = 0; i < dtTemplate.Rows.Count; i++)
{
//获取模板编号
string no = GetSafeData.ValidateDataRow_String(dtTemplate.Rows[i], "TemplateNo");
//获取模板主题
string title = GetSafeData.ValidateDataRow_String(dtTemplate.Rows[i], "Title");
if (no == templateNo)
{
ddlTemplate.Items.Add(new ListItem(title, no));
//sbTemplateInfo.AppendLine("<option value=\"" + no + "\" selected=\"selected\">" + title + "</option>");
}
else
{
ddlTemplate.Items.Add(new ListItem(title, no));
//sbTemplateInfo.AppendLine("<option value=\"" + no + "\">" + title + "</option>");
}
}
ddlTemplate.SelectedValue = templateNo;
}
}
/// <summary>
/// 根据ID获取文档信息
/// </summary>
/// <returns></returns>
public static CodeEquipmentTypeModel GetodeDocType(int id)
{
CodeEquipmentTypeModel model = new CodeEquipmentTypeModel();
string sql = "select * from officedba.CodeDocType where id=@id ";
SqlParameter[] param = new SqlParameter[1];
param[0] = SqlHelper.GetParameter("@id", id);
DataTable dt = SqlHelper.ExecuteSql(sql, param);
DataRow data = dt.Rows[0];
if (dt.Rows.Count > 0)
{
model.SupperID = GetSafeData.ValidateDataRow_Int(data, "SupperID");
model.ModifiedDate = GetSafeData.ValidateDataRow_DateTime(data, "ModifiedDate");
model.UsedStatus = GetSafeData.ValidateDataRow_String(data, "UsedStatus");
model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID");
model.CodeName = GetSafeData.ValidateDataRow_String(data, "CodeName");
model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD");
model.Description = GetSafeData.ValidateDataRow_String(data, "Description");
return(model);
}
else
{
return(null);
}
}
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="dtElemScore">要素信息</param>
/// <param name="testScore">面试总成绩</param>
///
private void InitElemScoreInfo(DataTable dtElemScore, string testScore)
{
//面试总成绩为空时，设置默认值
if (string.IsNullOrEmpty(testScore))
{
testScore = "0.00";
}
//定义变量
StringBuilder sbElemScoreInfo = new StringBuilder();
//要素得分时，设置要素得分
if (dtElemScore != null && dtElemScore.Rows.Count > 0)
{
//遍历所有要素得分添加到表格中
for (int i = 0; i < dtElemScore.Rows.Count; i++)
{
//插入行开始标识
sbElemScoreInfo.AppendLine("<tr>");
//要素名称
sbElemScoreInfo.AppendLine("<td class='tdColInput'><input type='hidden' value='"
+ GetSafeData.ValidateDataRow_String(dtElemScore.Rows[i], "ElemID") + "' id='txtElemID_" + (i + 1).ToString() + "'>"
+ GetSafeData.ValidateDataRow_String(dtElemScore.Rows[i], "ElemName") + "</td>");
//满分
sbElemScoreInfo.AppendLine("<td class='tdColInputCenter' id='tdMaxScore_" + (i + 1).ToString() + "'>"
+ StringUtil.TrimZero(GetSafeData.ValidateDataRow_String(dtElemScore.Rows[i], "MaxScore"))
+ "</td>");
//权重
sbElemScoreInfo.AppendLine("<td class='tdColInputCenter' id='tdRate_" + (i + 1).ToString() + "'>"
+ StringUtil.TrimZero(GetSafeData.ValidateDataRow_String(dtElemScore.Rows[i], "Rate"))
+ "</td>");
//面试得分
sbElemScoreInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '6' value='"
+ StringUtil.TrimZero(GetSafeData.ValidateDataRow_String(dtElemScore.Rows[i], "RealScore"))
+ "' style= 'width:95%;' class='tdinput' id='txtRealScore_"
+ (i + 1).ToString() + "' onchange='Number_round(this,\"2\");' onblur='CalculateTestScore(this);'></td>");
//备注
sbElemScoreInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '250' value='"
+ GetSafeData.ValidateDataRow_String(dtElemScore.Rows[i], "Remark")
+ "' style= 'width:95%;' class='tdinput' id='txtScoreRemark_" + (i + 1).ToString() + "'></td>");
//插入行结束标识
sbElemScoreInfo.AppendLine("</tr>");
}
//插入面试总成绩行
sbElemScoreInfo.AppendLine("<tr><td colSpan = '5' class='tdColInput' align='right'><table><tr><td>面试总成绩：</td><td><div id='divTestScore' style='width:100px;text-align:right;'>"
+ testScore + "</div></td></tr></table></td></tr>");
}
//要素得分设置到DIV中表示
divElemScoreDetail.InnerHtml = CreateElemScoreTable() + sbElemScoreInfo.ToString() + EndTable();
}
/// <summary>
/// 设置考核结果
/// </summary>
/// <param name="dtSchedule">考核结果信息</param>
private void InitAsseResultInfo(DataTable dtResult)
{
//定义保存进度安排的变量
StringBuilder sbResultInfo = new StringBuilder();
//换行标识
int flag = 0;
//进度安排存在时，设置进度安排
if (dtResult != null && dtResult.Rows.Count > 0)
{
for (int i = 0; i < dtResult.Rows.Count; i++)
{
/* 每行显示两条数据，所以通过对2取余来判断是否换行 以及 行是否结束 */
//对2进行取余
flag = i % 2;
//余数为0时，表示需要新添加一行
if (flag == 0)
{
//插入行开始标识
sbResultInfo.AppendLine("<tr>");
}
//姓名
sbResultInfo.AppendLine("<td class='tdColInputCenter'><input type='hidden' value='"
+ GetSafeData.ValidateDataRow_String(dtResult.Rows[i], "EmployeeID") + "' class='tdinput' id='txtJoinUserID_" + i.ToString()
+ "'>" + GetSafeData.ValidateDataRow_String(dtResult.Rows[i], "EmployeeName") + "</td>");
//考核得分
sbResultInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '6' onchange='Number_round(this,2);' value='"
+ GetSafeData.ValidateDataRow_String(dtResult.Rows[i], "AssessScore") + "' class='tdinput' id='txtAsseScore_" + i.ToString() + "'></td>");
//考核等级
sbResultInfo.AppendLine("<td class='tdColInputCenter'>"
+ InitLevelDropDownList("ddlAsseLevel_" + i.ToString(), GetSafeData.ValidateDataRow_String(dtResult.Rows[i], "AssessLevel")) + "</td>");
//余数为1时，表示行结束
if (flag == 1)
{
//插入行结束标识
sbResultInfo.AppendLine("</tr>");
}
}
//余数为0时，表示所有的记录为单数条，因此需要把未结束的行结束
if (flag == 0)
{
//插入空白列
sbResultInfo.AppendLine("<td class='tdColInputCenter'></td><td class='tdColInput'></td><td class='tdColInputCenter'></td>");
//插入行结束标识
sbResultInfo.AppendLine("</tr>");
}
}
//考核结果设置到DIV中表示
divRsseResultDetail.InnerHtml = CreateResultTable() + sbResultInfo.ToString() + EndTable();
}
/// <summary>
/// 根据编码规则获取单据编号
/// </summary>
/// <param name="codeID">编码规则ID</param>
/// <returns></returns>
public static string GetCodeValue(string codeID)
{
//上次生成的最大流水号
//int lastpreNo =-1;
//定义返回的值
string codeValue = "";
//获取编码规则详细设置内容
DataTable ruleData = ItemCodingRuleDBHelper.GetCodingRuleInfoWithID(codeID);
//数据存在时进行Code生成操作
if (ruleData != null && ruleData.Rows.Count > 0)
{
//获取编码示例
string ruleExample = GetSafeData.ValidateDataRow_String(ruleData.Rows[0], "RuleExample");
//编码示例长度小于4时，进行设置
if (!string.IsNullOrEmpty(ruleExample) && ruleExample.Length > 4)
{
//获取流水号类型
int start = ruleExample.LastIndexOf(ConstUtil.RULE_EXAMPLE_START);
string ruleNoType = ruleExample.Substring(start);
//获取当前流水号最大值
string lastNo = GetSafeData.ValidateDataRow_Int(ruleData.Rows[0], "LastNo").ToString();
//编码流水号长度
int ruleNoLen = GetSafeData.ValidateDataRow_Int(ruleData.Rows[0], "RuleNoLen");
//长度不够时左边添加0
lastNo = lastNo.PadLeft(ruleNoLen, ConstUtil.RULE_EXAMPLE_ZERO);
//替换流水号
codeValue = ruleExample.Replace(ruleNoType, lastNo);
//获取编码类型
string codingType = GetSafeData.ValidateDataRow_String(ruleData.Rows[0], "CodingType");
//编码类型为单据时，替换日期设置
if (!ConstUtil.CODING_RULE_TYPE_ZERO.Equals(codingType))
{
//获取流水号类型
start = ruleExample.IndexOf(ConstUtil.RULE_EXAMPLE_START);
int end = ruleExample.IndexOf(ConstUtil.RULE_EXAMPLE_END);
string dateType = ruleExample.Substring(start, end - start + 1);
//获取当前日期值
string dateTypeValue = DateTime.Now.ToString(dateType.Substring(1, dateType.Length - 2));
//替换日期类型
codeValue = codeValue.Replace(dateType, dateTypeValue);
}
}
}
//返回生成的单据编号
return(codeValue);
}
/// <summary>
/// 设置技能信息
/// </summary>
/// <param name="employModel">人员信息</param>
private void InitSkillInfo(EmployeeInfoModel employModel)
{
//获取技能信息
DataTable dtSkill = employModel.SkillInfo;
//定义保存技能详细信息变量
StringBuilder sbSkillInfo = new StringBuilder();
//技能信息存在时，设置技能信息
if (dtSkill != null && dtSkill.Rows.Count > 0)
{
//遍历所有技能信息
for (int i = 0; i < dtSkill.Rows.Count; i++)
{
//插入行开始标识
sbSkillInfo.AppendLine("<tr>");
//选择框
sbSkillInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='tblSkill_chkSelect_" + (i + 1).ToString() + "'></td>");
//技能名称
sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "SkillName") + "' class='tdinput' id='txtSkillName_" + (i + 1).ToString() + "'></td>");
//证件名称
sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "CertificateName") + "' class='tdinput' id='txtCertificateName_" + (i + 1).ToString() + "'></td>");
//证件编号
sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '25' value='"
+ GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "CertificateNo") + "' class='tdinput' id='txtCertificateNo_" + (i + 1).ToString() + "'></td>");
//证件等级
sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '25' value='"
+ GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "CertificateLevel") + "' class='tdinput' id='txtCertificateLevel_" + (i + 1).ToString() + "'></td>");
//发证单位
sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "IssueCompany") + "' class='tdinput' id='txtIssueCompany_" + (i + 1).ToString() + "'></td>");
//发证时间
sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtSkill.Rows[i], "IssueDate", "yyyy-MM-dd")
+ "' class='tdinput' id='txtIssueDate_" + (i + 1).ToString() + "' readonly onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtIssueDate_" + (i + 1).ToString() + "')})\"></td>");
//有效期
sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '25' value='"
+ GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "Validity") + "' class='tdinput' id='txtValidity_" + (i + 1).ToString() + "'></td>");
//插入行结束标识
sbSkillInfo.AppendLine("</tr>");
}
}
//技能信息设置到DIV中表示
divSkillInfo.InnerHtml = CreateSkillTable() + sbSkillInfo.ToString() + EndTable();
}
/// <summary>
/// 设置信息发布
/// </summary>
/// <param name="dtPublish">信息发布的信息</param>
private void InitPublishInfo(DataTable dtPublish)
{
//定义保存信息发布的变量
StringBuilder sbPublishInfo = new StringBuilder();
//信息发布存在时，设置信息发布
if (dtPublish != null && dtPublish.Rows.Count > 0)
{
for (int i = 0; i < dtPublish.Rows.Count; i++)
{
//插入行开始标识
sbPublishInfo.AppendLine("<tr>");
//选择框
sbPublishInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='tblRectPublishDetailInfo_chkSelect_" + (i + 1).ToString() + "'></td>");
//发布媒体和渠道
sbPublishInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' style='width:85%' value='"
+ GetSafeData.ValidateDataRow_String(dtPublish.Rows[i], "PublishPlace") + "' class='tdinput' id='txtPublishPlace_" + (i + 1).ToString() + "'> <span style=\"cursor:hand\" onclick=\"popTaskObj.ShowList('txtPublishPlace_" + (i + 1).ToString() + "')\">选择</span></td>");
//发布时间
sbPublishInfo.AppendLine("<td class='tdColInputCenter'><input type='text' readonly maxlength = '10' style='width:95%' onchange='SetEndDate(\"" + (i + 1).ToString() + "\");' value='"
+ GetSafeData.GetStringFromDateTime(dtPublish.Rows[i], "PublishDate", "yyyy-MM-dd")
+ "' class='tdinput' id='txtPublishDate_" + (i + 1).ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtPublishDate_" + (i + 1).ToString() + "')})\"></td>");
//有效时间
sbPublishInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '4' onblur='SetEndDate(\"" + (i + 1).ToString() + "\");' value='"
+ GetSafeData.ValidateDataRow_String(dtPublish.Rows[i], "Valid") + "' style='width:95%' class='tdinput' id='txtValid_" + (i + 1).ToString() + "'></td>");
//截止时间
sbPublishInfo.AppendLine("<td class='tdColInputCenter'><input type='text' style='width:95%' maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtPublish.Rows[i], "EndDate", "yyyy-MM-dd")
+ "' class='tdinput' id='txtEndDate_" + (i + 1).ToString() + "' readonly></td>");
//费用
sbPublishInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '12' style='width:95%' onchange='Number_round(this,\"2\");' value='"
+ GetSafeData.ValidateDataRow_String(dtPublish.Rows[i], "Cost") + "' class='tdinput' id='txtCost_" + (i + 1).ToString() + "'></td>");
//效果
sbPublishInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '25' style='width:95%' value='"
+ GetSafeData.ValidateDataRow_String(dtPublish.Rows[i], "Effect") + "' class='tdinput' id='txtEffect_" + (i + 1).ToString() + "'></td>");
//发布状态
sbPublishInfo.AppendLine("<td class='tdColInputCenter'>"
+ InitPublishDropDownList("ddlStatus_" + (i + 1).ToString(), GetSafeData.ValidateDataRow_String(dtPublish.Rows[i], "Status")) + "</td>");
//插入行结束标识
sbPublishInfo.AppendLine("</tr>");
}
}
//信息发布设置到DIV中表示
divRectPublishDetail.InnerHtml = CreatePublishTable() + sbPublishInfo.ToString() + EndTable();
}
/// <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="companyCD">公司代码</param>
/// <returns></returns>
public static DataTable GetGoalInfoFromRectApply()
{
//公司代码
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//执行查询
DataTable dtApplyData = RectApplyDBHelper.GetGoalInfoFromRectApply(companyCD);
//数据存在时，编辑年龄
if (dtApplyData != null && dtApplyData.Rows.Count > 0)
{
for (int i = 0; i < dtApplyData.Rows.Count; i++)
{
//获取最小年龄
string minAge = GetSafeData.ValidateDataRow_String(dtApplyData.Rows[i], "MinAge");
//获取最大年龄
string maxAge = GetSafeData.ValidateDataRow_String(dtApplyData.Rows[i], "MaxAge");
//最大年龄和最小年龄都未输入时
//最小年龄输入，最大年龄未输入时
if (!string.IsNullOrEmpty(minAge) && string.IsNullOrEmpty(maxAge))
{
//设置年龄
dtApplyData.Rows[i]["Age"] = minAge + " 岁以上";
}
//最大年龄输入，最小年龄未输入时
else if (string.IsNullOrEmpty(minAge) && !string.IsNullOrEmpty(maxAge))
{
//设置年龄
dtApplyData.Rows[i]["Age"] = maxAge + " 岁以下";
}
//最大年龄和最小年龄都输入时
else if (!string.IsNullOrEmpty(minAge) && !string.IsNullOrEmpty(maxAge))
{
//设置年龄
dtApplyData.Rows[i]["Age"] = minAge + " 岁 ~ " + maxAge + " 岁";
}
}
}
//返回数据
return(dtApplyData);
}
/// <summary>
/// 根据考核ID，获取考核信息，并设置到页面显示
/// </summary>
/// <param name="asseID">考核ID</param>
private void InitTrainingAsseInfo(string asseID)
{
//查询培训信息
DataSet dsTrainingAsseInfo = TrainingAsseBus.GetTrainingAsseInfoWithID(asseID);
//获取培训基本信息
DataTable dtBaseInfo = dsTrainingAsseInfo.Tables[0];
//基本信息存在时
if (dtBaseInfo != null && dtBaseInfo.Rows.Count > 0)
{
#region 设置培训基本信息
//考核编号
divTrainingAsseNo.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "AsseNo");
//培训
ddlTraining.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingNo");
//考核人
UserCheckPerson.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckPerson");
//考核方式
//ddlCheckWay.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckWay");
txtCheckWay.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckWay");
//考核时间
txtCheckDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckDate");
//填写人
txtFillUserName.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "FillUserName");
//培训规划
txtTrainingPlan.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingPlan");
//领导意见
txtLeadViews.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "LeadViews");
//说明
txtDescription.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Description");
//考核总评
txtGeneralComment.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "GeneralComment");
//考核备注
txtCheckRemark.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckRemark");
#endregion
//设置考核结果
InitAsseResultInfo(dsTrainingAsseInfo.Tables[1]);
}
}
/// <summary>
/// 设置要素结果
/// </summary>
/// <param name="dtElem">要素信息</param>
private void InitElemInfo(DataTable dtElem)
{
//定义保存进度安排的变量
StringBuilder sbElemInfo = new StringBuilder();
//进度安排存在时，设置进度安排
if (dtElem != null && dtElem.Rows.Count > 0)
{
//遍历所有要素添加到表格中
for (int i = 0; i < dtElem.Rows.Count; i++)
{
//插入行开始标识
sbElemInfo.AppendLine("<tr>");
//选择框
sbElemInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='chkSelect_" + (i + 1).ToString() + "' style='width:95%'></td>");
//要素名称
sbElemInfo.AppendLine("<td class='tdColInput' disabled =\"true\"><input type='hidden' value='"
+ GetSafeData.ValidateDataRow_String(dtElem.Rows[i], "CheckElemID") + "' id='hidElemID_" + (i + 1).ToString() + "' style='width:95%'>"
+ GetSafeData.ValidateDataRow_String(dtElem.Rows[i], "ElemName") + "</td>");
//满分
sbElemInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '6' value='"
+ StringUtil.TrimZero(GetSafeData.ValidateDataRow_String(dtElem.Rows[i], "MaxScore"))
+ "' class='tdinput' id='txtMaxScore_" + (i + 1).ToString() + "' style='width:95%'></td>");
//权重
sbElemInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '6' value='"
+ StringUtil.TrimZero(GetSafeData.ValidateDataRow_String(dtElem.Rows[i], "Rate"))
+ "' class='tdinput' id='txtRate_" + (i + 1).ToString() + "' style='width:95%'></td>");
//备注
sbElemInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '100' value='"
+ GetSafeData.ValidateDataRow_String(dtElem.Rows[i], "Remark") + "' class='tdinput' id='txtElemRemark_" + (i + 1).ToString() + "' style='width:95%'></td>");
//插入行结束标识
sbElemInfo.AppendLine("</tr>");
}
}
//要素细腻设置到DIV中表示
divElemDetail.InnerHtml = CreateElemTable() + sbElemInfo.ToString() + EndTable();
}
/// <summary>
/// 获取并设置页面信息
/// </summary>
/// <param name="ID">ID</param>
private void InitContractInfo(string ID)
{
//获取数据
DataTable dtContract = EmployeeContractBus.GetEmployeeContractInfoWithID(ID);
//数据存在时，设置值
if (dtContract != null && dtContract.Rows.Count > 0)
{
//编号
divCodeNo.InnerHtml = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractNo");
//员工
UserEmployee.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "EmployeeName");
txtEmployeeID.Value = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "EmployeeID");
//合同名称
ctContractName.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractName");
//主题
txtTitle.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Title");
//合同类型
ddlContractType.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractType");
//合同属性
ddlContractProperty.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractProperty");
//工种
//ddlContractKind.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractKind");
//合同状态
ddlContractStatus.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractStatus");
//合同期限
ddlContractPeriod.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractPeriod");
//试用月数
txtTestMonth.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "TrialMonthCount");
//试用工资
txtTestWage.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "TestWage");
//转正工资
txtWage.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Wage");
//签约时间
txtSigningDate.Text = GetSafeData.GetStringFromDateTime(dtContract.Rows[0], "SigningDate", "yyyy-MM-dd");
//生效时间
txtStartDate.Text = GetSafeData.GetStringFromDateTime(dtContract.Rows[0], "StartDate", "yyyy-MM-dd");
//失效时间
txtEndDate.Text = GetSafeData.GetStringFromDateTime(dtContract.Rows[0], "EndDate", "yyyy-MM-dd");
//转正标识
ddlFlag.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Flag");
//提醒人
UserReminder.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ReminderName");
hidReminder.Value = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Reminder");
//提前时间
txtAheadDay.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "AheadDay");
//附件
string attachment = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Attachment");
hfAttachment.Value = attachment;
hfPageAttachment.Value = attachment;
//设置下载 上传的显示
if (string.IsNullOrEmpty(attachment))
{
//简历处理不显示
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(dtContract.Rows[0], "AttachmentName");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// 多计量单位控制
_isMoreUnit = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit;
//模板列表模块ID
this.txtModifiedDate.Text = Convert.ToString(DateTime.Now.ToShortDateString());
this.txtModifiedUserID.Text = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
hidModuleID.Value = ConstUtil.Menu_SerchProduct;
//获取请求参数
string requestParam = Request.QueryString.ToString();
//通过参数个数来判断是否从菜单过来
int firstIndex = requestParam.IndexOf("&");
//从列表过来时
if (firstIndex > 0)
{
//返回按钮可见
product_btnback.Visible = true;
//获取列表的查询条件
string searchCondition = requestParam.Substring(firstIndex);
//去除参数
searchCondition = searchCondition.Replace("&ModuleID=" + ConstUtil.Menu_AddProduct, string.Empty);
//设置检索条件
hidSearchCondition.Value = searchCondition;
//迁移页面
hidFromPage.Value = Request.QueryString["FromPage"];
}
else
{
//返回按钮不可见
product_btnback.Visible = false;
}
CodingRuleControl1.CodingType = ConstUtil.CODING_RULE_TYPE_ZERO;
CodingRuleControl1.ItemTypeID = ConstUtil.CODINGA_BASE_ITEM_PRODUCT;
//CodingRuleControl1.TableName = "ProductInfo";
//CodingRuleControl1.ColumnName = "ProdNo";
this.txt_CheckUser.Value = Convert.ToString(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID);
this.txtPrincipal.Value = Convert.ToString(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID);
this.UserPrincipal.Text = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName;
this.txt_CheckUserName.Text = Convert.ToString(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName);
this.txt_CheckDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
this.txt_CreateDate.Text = Convert.ToString(DateTime.Now.ToShortDateString());
BindTree();
BindCom();//绑定下拉框
if (Request["intOtherCorpInfoID"] != "" && Request["intOtherCorpInfoID"] != null)
{
if (ProductInfoBus.IsConfirmProduct(Request["intOtherCorpInfoID"]))
{
this.txt_IsConfirmProduct.Value = "1";
}
ProductInfoModel model = new ProductInfoModel();
DataTable dt = ProductInfoBus.GetProductInfoByID(int.Parse(Request["intOtherCorpInfoID"]));
if (dt.Rows.Count > 0)
{
this.txtModifiedUserID.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ModifiedUserID");
this.txtModifiedDate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ModifiedDate");
this.divNo.InnerHtml = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ProdNo");
txt_PYShort.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "PYShort");
this.txt_Manufacturer.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Manufacturer");
txt_ProductName.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ProductName");
txt_ShortNam.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ShortNam");
txt_BarCode.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "BarCode");
txt_BigType.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "BigType");
sel_GradeID.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "GradeID");
sel_UnitID.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "UnitID");
sel_Brand.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Brand");
sel_ColorID.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ColorID");
txt_Specification.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Specification");
txt_Size.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Size");
sel_Source.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Source");
txt_FromAddr.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "FromAddr");
txt_DrawingNum.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "DrawingNum");
//txt_ImgUrl.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ImgUrl");
txt_FileNo.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "FileNo");
txt_PricePolicy.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "PricePolicy");
txt_Params.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Params");
txt_Questions.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Questions");
txt_ReplaceName.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ReplaceName");
txt_Description.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Description");
if (dt.Rows[0]["IsBatchNo"].ToString() == "1")
{
RdUseBatch.Checked = true;
RdNotUseBatch.Checked = false;
}
else
{
RdUseBatch.Checked = false;
RdNotUseBatch.Checked = true;
}
this.txt_CheckUserName.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CheckUserName");
this.txtPrincipal.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Creator");
this.UserPrincipal.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CreatorName");
var photoURL = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ImgUrl");;
string StockIs = GetSafeData.ValidateDataRow_String(dt.Rows[0], "StockIs");
string MinusIs = GetSafeData.ValidateDataRow_String(dt.Rows[0], "MinusIs");
if (StockIs == "1")
{
rd_StockIs.Checked = true; rd_notStockIs.Checked = false;
}
if (StockIs == "0")
{
rd_notStockIs.Checked = true; rd_StockIs.Checked = false;
}
if (MinusIs == "1")
{
this.rd_MinusIs.Checked = true; this.rd_notMinusIs.Checked = false;
}
if (MinusIs == "0")
{
this.rd_notMinusIs.Checked = true; this.rd_MinusIs.Checked = false;
}
//chk_MinusIs.Checked=StockIs=="0"?false:true;
//chk_StockIs.Checked = StockIs == "0" ? false: true;
this.HdGroupNo.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "GroupUnitNo");
if (!String.IsNullOrEmpty(dt.Rows[0]["GroupUnitNo"].ToString()))
{
this.txtUnitGroup.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "GroupUnitNo") + "_" + GetSafeData.ValidateDataRow_String(dt.Rows[0], "GroupUnitName");
}
if (!string.IsNullOrEmpty(HdGroupNo.Value))
{
string GroupUnitNo = HdGroupNo.Value;
DataTable dt_GroupUnit = ProductInfoBus.GetUnitGroupList(GroupUnitNo);
if (dt_GroupUnit.Rows.Count > 0)
{
//库存单位
selStorageUnit.DataSource = dt_GroupUnit;
selStorageUnit.DataTextField = "CodeName";
selStorageUnit.DataValueField = "UnitID";
selStorageUnit.DataBind();
//采购单位
selPurchseUnit.DataSource = dt_GroupUnit;
selPurchseUnit.DataTextField = "CodeName";
selPurchseUnit.DataValueField = "UnitID";
selPurchseUnit.DataBind();
//销售
selSellUnit.DataSource = dt_GroupUnit;
selSellUnit.DataTextField = "CodeName";
selSellUnit.DataValueField = "UnitID";
selSellUnit.DataBind();
//生产
selProductUnit.DataSource = dt_GroupUnit;
selProductUnit.DataTextField = "CodeName";
selProductUnit.DataValueField = "UnitID";
selProductUnit.DataBind();
}
//selSellUnit.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "SaleUnitID");
this.selStorageUnit.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "StockUnitID");
this.selPurchseUnit.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "InUnitID");
this.selSellUnit.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "SaleUnitID");
this.selProductUnit.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "MakeUnitID");
}
else
{
//往各业务单位组里添加默认的单位
selStorageUnit.Items.Insert(0, new ListItem(sel_UnitID.SelectedItem.Text, sel_UnitID.SelectedValue));
selPurchseUnit.Items.Insert(0, new ListItem(sel_UnitID.SelectedItem.Text, sel_UnitID.SelectedValue));
selSellUnit.Items.Insert(0, new ListItem(sel_UnitID.SelectedItem.Text, sel_UnitID.SelectedValue));
selProductUnit.Items.Insert(0, new ListItem(sel_UnitID.SelectedItem.Text, sel_UnitID.SelectedValue));
}
if (photoURL == "")
{
imgPhoto.Src = "../../../Images/Pic/Pic_Nopic.jpg";
//document.getElementById("imgPhoto").src = "../../../Images/Pic/Pic_Nopic.jpg";
}
else
{
//document.getElementById("imgPhoto").src = "../../../Images/Photo/" + photoURL;
imgPhoto.Src = "../../../Images/Photo/" + photoURL;
hfPagePhotoUrl.Value = photoURL;
hfPagePhotoUrl.Value = photoURL;
}
sel_StorageID.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "StorageID");
sel_Material.SelectedValue = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Material");
txt_SafeStockNum.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "SafeStockNum");
txt_MinStockNum.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "MinStockNum");
txt_MaxStockNum.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "MaxStockNum");
sel_ABCType.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ABCType");
sel_CalcPriceWays.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CalcPriceWays");
txt_StandardCost.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "StandardCost");
txt_PlanCost.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "PlanCost");
txt_StandardSell.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "StandardSell");
txt_SellMin.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "SellMin");
txt_SellMax.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "SellMax");
txt_TaxRate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "TaxRate");
txt_InTaxRate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "InTaxRate");
txt_SellTax.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "SellTax");
txt_SellPrice.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "SellPrice");
txt_TransfrePrice.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "TransferPrice");
txt_Discount.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Discount");
txt_StandardBuy.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "StandardBuy");
txt_TaxBuy.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "TaxBuy");
txt_BuyMax.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "BuyMax");
txt_Remark.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Remark");
txt_CreateDate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CreateDate");
sel_CheckStatus.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CheckStatus");
if (sel_CheckStatus.Value == "1")
{
txt_CheckDate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CheckDate");
divConfirmor.Attributes.Add("style", "display:block;");
this.txt_CheckUser.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CheckUser");
this.txt_CheckUserName.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CheckUserName");
}
sel_UsedStatus.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "UsedStatus");
txt_Code.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "TypeID"); //隐藏
string Flag = GetSafeData.ValidateDataRow_String(dt.Rows[0], "TypeFlag");
txt_BigType.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "BigType"); //隐藏
txt_TypeID.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CodeName"); //隐藏
storage.Attributes.Add("style", "display:block;");
divInputNo.Attributes.Add("style", "display:none;float:left");
divNo.Attributes.Add("style", "display:block;float:left");
DataTable dt_stor = ProductInfoBus.GetStorageCount(int.Parse(Request["intOtherCorpInfoID"]));
if (dt_stor.Rows[0]["ProductCount"].ToString().IndexOf('.') > -1)
{
this.txt_Storage.Value = dt_stor.Rows[0]["ProductCount"].ToString();
}
//txt_TypeID.Disabled = true;
switch (Flag)
{
case "1":
this.txt_BigTypeName.Value = "成品";
break;
case "2":
this.txt_BigTypeName.Value = "原材料";
break;
case "3":
this.txt_BigTypeName.Value = "固定资产";
break;
case "4":
this.txt_BigTypeName.Value = "低值易耗";
break;
case "5":
this.txt_BigTypeName.Value = "包装物";
break;
case "6":
this.txt_BigTypeName.Value = "服务产品";
break;
case "7":
this.txt_BigTypeName.Value = "半成品";
break;
}
//this.txt_CheckUserName.Text = Convert.ToString(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName);
//this.txt_CheckDate.Text = Convert.ToString(DateTime.Now.ToShortDateString());
}
}
}
}
/// <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]);
}
}
protected string GetSource()
{
string ID = Request.QueryString["ID"].Trim().ToString();
DataTable dtReportInfo = SalaryReportBus.GetReportInfoByNo(ID);
int defaultCount = Convert.ToInt32(this.linesPerPage.Value);
//设置查询条件
StringBuilder htmlStr = new StringBuilder();
htmlStr.Append("\r\t <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
//表头开始（在打印预览中每页都有）****************************************************************
htmlStr.Append("\r\t <thead style=\"display:table-header-group;font-weight:bold\">");
htmlStr.Append("\r\t <tr><td colspan=\"18\">");
htmlStr.Append("\r\t <table width=\"98%\" height=\"40\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" =\"center\">");
htmlStr.Append("\r\t <tr>");
htmlStr.Append("\r\t <td align=\"center\" class=\"pS\" valign=\"middle\"><strong> 工资报表 </strong></td>");
htmlStr.Append("\r\t </tr></table>");
htmlStr.Append("\r\t <table width=\"98%\" height=\"25px\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
htmlStr.Append("\r\t <tr><td align=\"left\" style=\"height: 25px;\" class=\"td\" colspan=\"2\">编制单位：" + ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyName + " </td>");
// htmlStr.Append("\r\t <td align=\"center\" style=\"height: 25px;\" class=\"td\" colspan=\"3\">会计期间：" + AccountDate + " </td>");
htmlStr.Append("\r\t <td align=\"right\" style=\"height: 25px;\" class=\"td\" colspan=\"3\"> </td>");
htmlStr.Append("\r\t </tr></table>");
htmlStr.Append("\r\t <table width=\"98%\" height=\"25px\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
htmlStr.Append("\r\t <tr><td align=\"center\" style=\"height: 25px;\" > 工资报表编号</td>");
htmlStr.Append("\r\t <td align=\"left\" style=\"height: 25px;\" > " + GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "ReprotNo") + " </td>");
htmlStr.Append("\r\t <td align=\"center\" style=\"height: 25px;\" > 工资报表主题</td>");
htmlStr.Append("\r\t <td align=\"left\" style=\"height: 25px;\" > " + GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "ReportName") + " </td>");
htmlStr.Append("\r\t <td align=\"center\" style=\"height: 25px;\" > 所属月份</td>");
htmlStr.Append("\r\t <td align=\"left\" style=\"height: 25px;\" > " + GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "ReportYear") + GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "ReportMonth") + " </td>");
htmlStr.Append("\r\t </tr><tr>");
htmlStr.Append("\r\t <td align=\"center\" style=\"height: 25px;\" > 开始时间</td>");
htmlStr.Append("\r\t <td align=\"left\" style=\"height: 25px;\" > " + GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "StartDate") + " </td>");
htmlStr.Append("\r\t <td align=\"center\" style=\"height: 25px;\" > 结束时间</td>");
htmlStr.Append("\r\t <td align=\"left\" style=\"height: 25px;\" > " + GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "EndDate") + " </td>");
htmlStr.Append("\r\t <td align=\"center\" style=\"height: 25px;\" > 编制人</td>");
htmlStr.Append("\r\t <td align=\"left\" style=\"height: 25px;\" > " + GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "Creator") + " </td>");
htmlStr.Append("\r\t </tr><tr>");
htmlStr.Append("\r\t <td align=\"center\" style=\"height: 25px;\" > 报表状态</td>");
htmlStr.Append("\r\t <td align=\"left\" style=\"height: 25px;\" > " + GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "Status") + " </td>");
htmlStr.Append("\r\t <td align=\"center\" style=\"height: 25px;\" > 编制日期</td>");
htmlStr.Append("\r\t <td align=\"left\" style=\"height: 25px;\" > " + GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "CreateDate") + " </td>");
//htmlStr.Append("\r\t <td align=\"center\" style=\"height: 25px;\" class=\"td\" colspan=\"3\">会计期间：" + AccountDate + " </td>");
//htmlStr.Append("\r\t <td align=\"right\" style=\"height: 25px;\" class=\"td\" colspan=\"3\">单位：元 </td>");
htmlStr.Append("\r\t </tr> ");
htmlStr.Append("\r\t </table><br/>");
htmlStr.Append("\r\t </td></tr>");
string resul = SalaryReportBus.PrintInitSalaryReportInfo(GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "ReprotNo"), defaultCount, Printclass);
htmlStr.Append(resul);
//表尾开始（在打印预览中每页都有）****************************************************************
htmlStr.Append("\r\t <tfoot class='noprint2' style=\"display:table-footer-group;font-weight:bold\">");
htmlStr.Append("\r\t <tr><td align=\"left\" class=\"noprint2\" colspan=\"7\"> 制表： " + ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName + "</td>");
htmlStr.Append("\r\t <td align=\"center\" style=\"height: 23px\" class=\"noprint2\" colspan=\"10\" >打印日期：" + DateTime.Now.ToString("yyyy-MM-dd") + "");
htmlStr.Append("\r\t </td>");
htmlStr.Append("\r\t </tr></tfoot>");
//表尾结束（在打印预览中每页都有）****************************************************************
htmlStr.Append("\r\t </table>");
return(htmlStr.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="ID">ID</param>
private void InitNotifyInfo(string ID)
{
//获取申请单数据
DataTable dtNotify = MoveNotifyBus.GetMoveNotifyInfoWithID(ID);
//数据存在时，设置值
if (dtNotify != null && dtNotify.Rows.Count > 0)
{
//离职单编号
divCodeNo.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "NotifyNo");
//离职单主题
txtTitle.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "Title");
//对应申请单
string applyNo = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "MoveApplyNo");
ddlApply.SelectedValue = applyNo;
//离职人
txtEmployeeID.Value = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "EmployeeID");
//员工编号
txtEmployeeNo.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "EmployeeNo");
//员工名
txtEmployeeName.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "EmployeeName");
//入职时间
txtEnterDate.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "EnterDate");
//部门名称
txtDeptName.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "DeptName");
//岗位名
txtQuarterName.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "QuarterName");
//岗位职等
txtAdminLevelName.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "TypeName");
//离职事由
txtReason.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "Reason");
//离职时间
txtOutDate.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "OutDate");
//离职交接说明
txtJobNote.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "JobNote");
//制单人
txtCreator.Value = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "Creator");
UserCreator.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "CreatorName");
//制单人不可编辑
UserCreator.Enabled = false;
//制单日期
txtCreateDate.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "CreateDate");
txtCreateDate.Enabled = false;
if (GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "Confirmor") != "")
{
//确认人
txtConfirmor.Value = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "Confirmor");
UserConfirmor.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "ConfirmorName");
//确认日期
txtConfirmDate.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "ConfirmDate");
btnSave.Src = "../../../Images/Button/UnClick_bc.jpg";
btnConfirm.Src = "../../../Images/Button/UnClick_qr.jpg";
//btnConfirm.Attributes.Add("onclick", "DoConfirm();");
//btnSave.Attributes.Add("style", "display:none;");
//UnSave.Attributes.Add("style", "display:block;");
}
else
{
btnSave.Src = "../../../Images/Button/Bottom_btn_save.jpg";
btnConfirm.Src = "../../../Images/Button/Bottom_btn_confirm.jpg";
btnConfirm.Attributes.Add("onclick", "DoConfirm();");
}
//备注
txtRemark.Text = GetSafeData.ValidateDataRow_String(dtNotify.Rows[0], "Remark");
//申请编号存在时
if (!string.IsNullOrEmpty(applyNo))
{
//员工编号不可编辑
txtEmployeeNo.Enabled = false;
}
//设置确定按钮
//btnConfirm.Src = "../../../Images/Button/Bottom_btn_confirm.jpg";
//btnConfirm.Attributes.Add("onclick", "DoConfirm();");
}
}
/// <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>
/// 设置招聘目标
/// </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>
/// 初期表示工资报表信息
/// </summary>
/// <param name="ID">工资报表ID</param>
private void InitReprotInfo(string ID)
{
//获取基本信息
DataTable dtReportInfo = SalaryReportBus.GetReportInfoByID(ID);
hidModuleID.Value = ConstUtil.MODULE_ID_HUMAN_SALARY_REPORT_LIST;
//数据存在时
if (dtReportInfo != null && dtReportInfo.Rows.Count > 0)
{
//报表编号
string reportNo = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "ReprotNo");
divCodeNo.InnerHtml = reportNo;
txtIdentityID.Value = ID;
txtReportNo.Value = reportNo;
//报表主题
txtTitle.Text = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "ReportName");
//报表状态
txtReportStatus.Text = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "Status");
string ssd = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "FlowStatus");
//if (string.IsNullOrEmpty(ssd))
//{
// txtBillStatus.Value = "1";
//}
//else
//{
// txtBillStatus.Value = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "FlowStatus");
//}
string temp = "";
if (txtReportStatus.Text == "待提交")
{
temp = "1";
}
else if (txtReportStatus.Text == "已生成")
{
temp = "1";
}
else if (txtReportStatus.Text == "已确认")
{
temp = "2";
}
else if (txtReportStatus.Text == "已提交")
{
temp = "1";
}
txtBillStatus.Value = temp;
if (txtReportStatus.Text == "已确认")
{
//txtBillStatus.Value = "2";
// btnSave.Visible = false;
//btnSave.Attributes.Add("style", "display:none");
//this.ImgReBuild .Attributes.Add("style", "display:none");
//document.getElementById("ImgReBuild").src = "../../../Images/Button/ btn_qxsc.jpg";
//document.getElementById("ImgReBuild").attachEvent("onclick", DoDelete);
//document.getElementById("ImgReBuild").src = "../../../Images/Button/ UnClick_qxsc.jpg";
//document.getElementById("ImgReBuild").attachEvent("onclick", gogo);
ImgReBuild.Src = "../../../Images/Button/UnClick_qxsc.jpg";
ImgReBuild.Attributes.Add("onclick", "gogo();");
//btnUnSave.Attributes.Add("style", "display:Block");
btnSave.Src = "../../../Images/Button/UnClick_bc.jpg";
btnSave.Attributes.Add("onclick", "gogo();");
// Response.Write("<script language='javascript'>GetFlowButton_DisplayControl()</script>");
}
else if (txtReportStatus.Text == "已提交")
{
//btnSave.Attributes.Add("style", "display:none");
//btnUnSave.Attributes.Add("style", "display:Block");
ImgReBuild.Src = "../../../Images/Button/UnClick_qxsc.jpg";
ImgReBuild.Attributes.Add("onclick", "gogo();");
btnSave.Src = "../../../Images/Button/UnClick_bc.jpg";
btnSave.Attributes.Add("onclick", "gogo();");
// Response.Write("<script language='javascript'>GetFlowButton_DisplayControl()</script>");
}
//所属年月
ddlYear.SelectedValue = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "ReportYear");
ddlMonth.SelectedValue = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "ReportMonth");
ddlYear.Enabled = false;
ddlMonth.Enabled = false;
//开始日期
txtStartDate.Text = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "StartDate");
txtStartDate.Enabled = false;
//结束日期
txtEndDate.Text = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "EndDate");
txtEndDate.Enabled = false;
//编制人
UserCreator.Text = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "Creator");
//编制日期
txtCreateDate.Text = GetSafeData.ValidateDataRow_String(dtReportInfo.Rows[0], "CreateDate");
UserCreator.Enabled = false;
txtCreateDate.Enabled = false;
btnCreateReport.Disabled = true;
btnCreateReport.Src = "../../../Images/Button/cw_uscbb.jpg";
//设置页面信息
divSalaryDetailInfo.InnerHtml = SalaryReportBus.InitSalaryReportInfo(reportNo);
}
}
/// <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());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
hidModuleID.Value = ConstUtil.Menu_SerchProductPrice;
this.txtChenger.Value = Convert.ToString(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID);
this.hf_Confirmor.Value = Convert.ToString(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID);
this.hf_Creator.Value = Convert.ToString(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID);
this.UserChengerName.Text = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName;
this.txt_ConfirmorName.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName;
this.txt_CreatorName.Text = Convert.ToString(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName);
this.txt_CreateDate.Text = Convert.ToString(DateTime.Now.ToShortDateString());
this.txt_ConfirmDate.Text = Convert.ToString(DateTime.Now.ToShortDateString());
this.txt_ChangeDate.Text = Convert.ToString(DateTime.Now.ToShortDateString());
this.txtModifiedDate.Text = Convert.ToString(DateTime.Now.ToShortDateString());
this.txtModifiedUserID.Text = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
string requestParam = Request.QueryString.ToString();
//通过参数个数来判断是否从菜单过来
int firstIndex = requestParam.IndexOf("&");
//从列表过来时
if (firstIndex > 0)
{
//获取列表的查询条件
string searchCondition = requestParam.Substring(firstIndex);
//去除参数
searchCondition = searchCondition.Replace("&ModuleID=" + ConstUtil.Menu_AddProductPrice, string.Empty);
//设置检索条件
hidSearchCondition.Value = searchCondition;
//迁移页面
btnback.Visible = true;
}
else
{
btnback.Visible = false;
}
if (Request["intOtherCorpInfoID"] != "" && Request["intOtherCorpInfoID"] != null)
{
this.divConfirmor.Attributes.Add("style", "display:block;");
this.btn_AD.Attributes.Add("style", "display:block;");
DataTable dt = ProductPriceChangeBus.GetProductPriceInfoByID(int.Parse(Request["intOtherCorpInfoID"]));
if (dt.Rows.Count > 0)
{
txt_ChangeNo.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ChangeNo");
txt_Title.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Title");
txt_ProductName.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ProductName");
hf_ProductID.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ProductID");
this.txtModifiedUserID.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ModifiedUserID");
string sell = GetSafeData.ValidateDataRow_String(dt.Rows[0], "StandardSell");
txt_StandardSell.Text = sell;
this.txtModifiedDate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ModifiedDate");
txt_SellTax.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "SellTax");
txt_StandardSellNew.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "StandardSellNew");
txt_SellTaxNew.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "SellTaxNew");
txt_TaxRate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "TaxRate");
txt_Discount.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Discount");
txt_TaxRateNew.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "TaxRateNew");
txt_DiscountNew.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "DiscountNew");
txt_ChangeDate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ChangeDate");
this.txtChenger.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Chenger");
this.UserChengerName.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ChengeName");
if (!string.IsNullOrEmpty(GetSafeData.ValidateDataRow_String(dt.Rows[0], "ConfirmorName")))
{
this.txt_ConfirmorName.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ConfirmorName");
}
this.txt_CreatorName.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CreatorName");
if (!string.IsNullOrEmpty(GetSafeData.ValidateDataRow_String(dt.Rows[0], "Confirmor")))
{
this.hf_Confirmor.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Confirmor");
}
this.hf_Creator.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Creator");
txt_Remark.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "Remark");
sel_BillStatus.Value = GetSafeData.ValidateDataRow_String(dt.Rows[0], "BillStatus");
txt_CreateDate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "CreateDate");
if (!string.IsNullOrEmpty(GetSafeData.ValidateDataRow_String(dt.Rows[0], "ConfirmDate")))
{
txt_ConfirmDate.Text = GetSafeData.ValidateDataRow_String(dt.Rows[0], "ConfirmDate");
}
if (sel_BillStatus.Value == "1")
{
this.btnAdd.Attributes.Add("style", "display:block;float:left");
this.btnsave.Attributes.Add("style", "display:none;float:left");
this.btnsure.Attributes.Add("style", "display:none;float:left");
this.btn_AD.Attributes.Add("style", "display:block;float:left");
this.divConfirmor.Attributes.Add("style", "display:none;");
}
else if (sel_BillStatus.Value == "5")
{
this.btnAdd.Attributes.Add("style", "display:none;float:left");
this.btnsave.Attributes.Add("style", "display:block;float:left");
this.btnsure.Attributes.Add("style", "display:block;float:left");
this.btn_AD.Attributes.Add("style", "display:none;float:left");
}
this.btnback.Attributes.Add("style", "display:block;float:left");
}
}
//this.hf_Chenger.Value = "5";
//this.hf_Confirmor.Value = "5";
//this.hf_Creator.Value = "5";
//this.txt_ChengerName.Text = "管理员";
//this.txt_ConfirmorName.Value = "管理员";
//this.txt_CreatorName.Text = "管理员";
}
}