protected void Page_Load(object sender, EventArgs e)
{
//页面初期表示
if (!IsPostBack)
{
//显示工资项列表
//InitSalaryInfo();
//岗位初期
DataTable dtQuarter = DeptQuarterBus.GetQuarterInfoWithCompanyCD();
ddlQuarter.DataSource = dtQuarter;
ddlQuarter.DataValueField = "ID";
ddlQuarter.DataTextField = "QuarterName";
ddlQuarter.DataBind();
//添加一请选择选项
ListItem Item = new ListItem(ConstUtil.CODE_TYPE_INSERT_TEXT, ConstUtil.CODE_TYPE_INSERT_VALUE);
ddlQuarter.Items.Insert(0, Item);
DataTable dtTaxInfo = InputPersonTrueIncomeTaxBus.PersonTaxInfo();
StringBuilder message = new StringBuilder();
if (dtTaxInfo != null || dtTaxInfo.Rows.Count > 1)
{
//遍历个人所得税的所有信息
for (int i = 0; i < dtTaxInfo.Rows.Count; i++)
{
string MinMoney = GetSafeData.GetStringFromDecimal(dtTaxInfo.Rows[i], "MinMoney");
string MaxMoney = GetSafeData.GetStringFromDecimal(dtTaxInfo.Rows[i], "MaxMoney");
string TaxPercent = GetSafeData.GetStringFromDecimal(dtTaxInfo.Rows[i], "TaxPercent");
string MinusMoney = GetSafeData.GetStringFromDecimal(dtTaxInfo.Rows[i], "MinusMoney");
message.AppendLine(MinMoney + "," + MaxMoney + "," + TaxPercent + "," + MinusMoney + "@");
}
}
hidTaxInfo.Value = message.ToString();
}
}
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="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>
/// 根据培训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]);
}
}