public HR_Payment getPayment()
{
YearMonth = ddlYear.SelectedValue + "-" + ddlMonth.SelectedValue;
UpdateTime = DateTime.Now;
int UpdatePerson = Convert.ToInt32(Session["currentUserId"]);
VAN_OA.Model.HR.HR_Payment ENPayment = new VAN_OA.Model.HR.HR_Payment();
if (base.Request["Code"] != null)
{
ENPayment.ID = Convert.ToInt32(base.Request["Code"]);
}
ENPayment.YearMonth = YearMonth;
ENPayment.BasicSalary = decimal.Parse(txtBasicSalary.Text.Trim());
ENPayment.FullAttendence = decimal.Parse(txtFullAttendence.Text.Trim());
ENPayment.MobileFee = decimal.Parse(txtMobileFee.Text.Trim());
ENPayment.SpecialAward = decimal.Parse(txtSpecialAward.Text.Trim());
ENPayment.SpecialAwardNote = txtSpecialAwardNote.Text.Trim();
ENPayment.GongLin = decimal.Parse(txtGonglin.Text.Trim());
ENPayment.PositionPerformance = decimal.Parse(txtPositionPerformance.Text.Trim());
ENPayment.PositionFee = decimal.Parse(txtPositionFee.Text.Trim());
ENPayment.WorkPerformance = decimal.Parse(txtWorkPerformance.Text.Trim());
ENPayment.FullPayment = decimal.Parse(lblFullPayment.Text.Trim());
ENPayment.DefaultWorkDays = decimal.Parse(lblDefaultWorkDays.Text.Trim());
ENPayment.WorkDays = decimal.Parse(txtWorkDays.Text.Trim());
ENPayment.ShouldPayment = decimal.Parse(lblShouldPayment.Text.Trim());
ENPayment.UnionFee = decimal.Parse(txtUnionFee.Text);
ENPayment.Deduction = decimal.Parse(txtDeduction.Text.Trim());
ENPayment.DeductionNote = txtDeductionNote.Text.Trim();
ENPayment.YangLaoJin = decimal.Parse(txtYangLaoJin.Text);
ENPayment.ActualPayment = decimal.Parse(lblActualPayment.Text.Trim());
ENPayment.UpdateTime = UpdateTime;
ENPayment.UpdatePerson = UpdatePerson;
return(ENPayment);
}
/// <summary>
/// 更新一条工资数据
/// </summary>
public bool Update(VAN_OA.Model.HR.HR_Payment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HR_Payment set ");
strSql.Append("YearMonth='" + model.YearMonth + "',");
strSql.Append("BasicSalary=" + model.BasicSalary + ",");
strSql.Append("FullAttendence=" + model.FullAttendence + ",");
strSql.Append("MobileFee=" + model.MobileFee + ",");
strSql.Append("SpecialAward=" + model.SpecialAward + ",");
strSql.Append("SpecialAwardNote='" + model.SpecialAwardNote + "',");
strSql.Append("Gonglin=" + model.GongLin + ",");
strSql.Append("PositionPerformance=" + model.PositionPerformance + ",");
strSql.Append("WorkPerformance=" + model.WorkPerformance + ",");
strSql.Append("FullPayment=" + model.FullPayment + ",");
strSql.Append("DefaultWorkDays=" + model.DefaultWorkDays + ",");
strSql.Append("WorkDays=" + model.WorkDays + ",");
strSql.Append("ShouldPayment=" + model.ShouldPayment + ",");
strSql.Append("UnionFee=" + model.UnionFee + ",");
strSql.Append("Deduction=" + model.Deduction + ",");
strSql.Append("DeductionNote='" + model.DeductionNote + "',");
strSql.Append("YangLaoJin=" + model.YangLaoJin + ",");
strSql.Append("ActualPayment=" + model.ActualPayment + ",");
if (model.UpdateTime != null)
{
strSql.Append("UpdateTime='" + model.UpdateTime + "',");
}
else
{
strSql.Append("UpdateTime= null ,");
}
if (model.UpdatePerson != null)
{
strSql.Append("UpdatePerson=" + model.UpdatePerson + ",");
}
else
{
strSql.Append("UpdatePerson= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where ID=" + model.ID + " and YearMonth='" + model.YearMonth + "'");
bool rowsAffected = DBHelp.ExeCommand(strSql.ToString());
return(rowsAffected);
}
/// <summary>
/// 得到一个员工基本信息的对象实体
/// </summary>
public VAN_OA.Model.HR.HR_Payment GetModel(int ID, string Yearmonth)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" P.ID,P.YearMonth,H.Name,P.BasicSalary,P.FullAttendence,P.MobileFee,P.SpecialAward,P.SpecialAwardNote,P.Gonglin,P.PositionPerformance,P.PositionFee,P.WorkPerformance,P.FullPayment,P.DefaultWorkDays,P.WorkDays,P.ShouldPayment,P.UnionFee,P.Deduction,P.DeductionNote,P.YangLaoJin,P.ActualPayment,P.UpdateTime,P.UpdatePerson");
strSql.Append(" from HR_Payment P left join HR_Person H on P.ID=H.ID ");
strSql.Append(" where P.ID=" + ID + " and P.YearMonth='" + Yearmonth + "'");
VAN_OA.Model.HR.HR_Payment model = null;
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader objReader = objCommand.ExecuteReader())
{
if (objReader.Read())
{
model = SalaryReaderBind(objReader);
}
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public VAN_OA.Model.HR.HR_Payment SalaryReaderBind(IDataReader dataReader)
{
VAN_OA.Model.HR.HR_Payment model = new VAN_OA.Model.HR.HR_Payment();
model.ID = (int)dataReader["ID"];
model.YearMonth = dataReader["YearMonth"].ToString();
model.Name = dataReader["Name"].ToString();
if (dataReader["BasicSalary"] != DBNull.Value)
{
model.BasicSalary = (decimal)dataReader["BasicSalary"];
}
if (dataReader["FullAttendence"] != DBNull.Value)
{
model.FullAttendence = (decimal)dataReader["FullAttendence"];
}
if (dataReader["MobileFee"] != DBNull.Value)
{
model.MobileFee = (decimal)dataReader["MobileFee"];
}
if (dataReader["SpecialAward"] != DBNull.Value)
{
model.SpecialAward = (decimal)dataReader["SpecialAward"];
}
model.SpecialAwardNote = dataReader["SpecialAwardNote"].ToString();
if (dataReader["Gonglin"] != DBNull.Value)
{
model.GongLin = (decimal)dataReader["Gonglin"];
}
if (dataReader["PositionPerformance"] != DBNull.Value)
{
model.PositionPerformance = (decimal)dataReader["PositionPerformance"];
}
if (dataReader["PositionFee"] != DBNull.Value)
{
model.PositionFee = (decimal)dataReader["PositionFee"];
}
if (dataReader["WorkPerformance"] != DBNull.Value)
{
model.WorkPerformance = (decimal)dataReader["WorkPerformance"];
}
if (dataReader["FullPayment"] != DBNull.Value)
{
model.FullPayment = (decimal)dataReader["FullPayment"];
}
if (dataReader["DefaultWorkDays"] != DBNull.Value)
{
model.DefaultWorkDays = (decimal)dataReader["DefaultWorkDays"];
}
if (dataReader["WorkDays"] != DBNull.Value)
{
model.WorkDays = (decimal)dataReader["WorkDays"];
}
if (dataReader["ShouldPayment"] != DBNull.Value)
{
model.ShouldPayment = (decimal)dataReader["ShouldPayment"];
}
if (dataReader["UnionFee"] != DBNull.Value)
{
model.UnionFee = (decimal)dataReader["UnionFee"];
}
if (dataReader["Deduction"] != DBNull.Value)
{
model.Deduction = (decimal)dataReader["Deduction"];
}
model.DeductionNote = dataReader["DeductionNote"].ToString();
if (dataReader["YangLaoJin"] != DBNull.Value)
{
model.YangLaoJin = (decimal)dataReader["YangLaoJin"];
}
if (dataReader["ActualPayment"] != DBNull.Value)
{
model.ActualPayment = (decimal)dataReader["ActualPayment"];
}
object ojb;
ojb = dataReader["UpdateTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.UpdateTime = (DateTime)ojb;
}
ojb = dataReader["UpdatePerson"];
if (ojb != null && ojb != DBNull.Value)
{
model.UpdatePerson = (int)ojb;
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(VAN_OA.Model.HR.HR_Payment model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
strSql1.Append("ID,");
strSql2.Append("'" + model.ID + "',");
if (model.YearMonth != null)
{
strSql1.Append("YearMonth,");
strSql2.Append("'" + model.YearMonth + "',");
}
if (model.BasicSalary != null)
{
strSql1.Append("BasicSalary,");
strSql2.Append(+model.BasicSalary + ",");
}
if (model.FullAttendence != null)
{
strSql1.Append("FullAttendence,");
strSql2.Append(+model.FullAttendence + ",");
}
if (model.MobileFee != null)
{
strSql1.Append("MobileFee,");
strSql2.Append(model.MobileFee + ",");
}
if (model.SpecialAward != null)
{
strSql1.Append("SpecialAward,");
strSql2.Append(model.SpecialAward + ",");
}
if (model.SpecialAwardNote != null)
{
strSql1.Append("SpecialAwardNote,");
strSql2.Append("'" + model.SpecialAwardNote + "',");
}
if (model.GongLin != null)
{
strSql1.Append("Gonglin,");
strSql2.Append(model.GongLin + ",");
}
if (model.PositionPerformance != null)
{
strSql1.Append("PositionPerformance,");
strSql2.Append(model.PositionPerformance + ",");
}
if (model.PositionFee != null)
{
strSql1.Append("PositionFee,");
strSql2.Append(model.PositionFee + ",");
}
if (model.WorkPerformance != null)
{
strSql1.Append("WorkPerformance,");
strSql2.Append(model.WorkPerformance + ",");
}
if (model.FullPayment != null)
{
strSql1.Append("FullPayment,");
strSql2.Append(model.FullPayment + ",");
}
if (model.DefaultWorkDays != null)
{
strSql1.Append("DefaultWorkDays,");
strSql2.Append(model.DefaultWorkDays + ",");
}
if (model.WorkDays != null)
{
strSql1.Append("WorkDays,");
strSql2.Append(model.WorkDays + ",");
}
if (model.ShouldPayment != null)
{
strSql1.Append("ShouldPayment,");
strSql2.Append(model.ShouldPayment + ",");
}
if (model.UnionFee != null)
{
strSql1.Append("UnionFee,");
strSql2.Append(model.UnionFee + ",");
}
if (model.Deduction != null)
{
strSql1.Append("Deduction,");
strSql2.Append(model.Deduction + ",");
}
if (model.DeductionNote != null)
{
strSql1.Append("DeductionNote,");
strSql2.Append("'" + model.DeductionNote + "',");
}
if (model.YangLaoJin != null)
{
strSql1.Append("YangLaoJin,");
strSql2.Append(model.YangLaoJin + ",");
}
if (model.ActualPayment != null)
{
strSql1.Append("ActualPayment,");
strSql2.Append(model.ActualPayment + ",");
}
if (model.UpdateTime != null)
{
strSql1.Append("UpdateTime,");
strSql2.Append("'" + model.UpdateTime + "',");
}
if (model.UpdatePerson != null)
{
strSql1.Append("UpdatePerson,");
strSql2.Append(model.UpdatePerson + ",");
}
strSql.Append("insert into HR_Payment(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
DBHelp.ExeCommand(strSql.ToString());
}