public int AddSalary(VAN_OA.Model.HR.HR_PERSON model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); strSql1.Append("ID,"); strSql2.Append(model.ID + ","); strSql1.Append("BasicSalary,"); strSql2.Append(model.BasicSalary + ","); strSql1.Append("GongLin,"); strSql2.Append(model.GongLin + ","); strSql1.Append("MobileFee,"); strSql2.Append(model.MobileFee + ","); strSql1.Append("PositionFee,"); strSql2.Append(model.PositionFee + ","); strSql1.Append("YangLaoJin,"); strSql2.Append(model.YangLaoJin + ","); strSql1.Append("UnionFee,"); strSql2.Append(model.UnionFee + ","); strSql1.Append("DefaultWorkDays,"); strSql2.Append(model.DefaultWorkDays + ","); strSql1.Append("IsRetailed,"); strSql2.Append((model.IsRetailed == true ? 1 : 0) + ","); strSql1.Append("IsQuit,"); strSql2.Append((model.IsQuit == true ? 1 : 0) + ","); 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_Salary("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DBHelp.ExeScalar(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条基本工资数据 /// </summary> public bool UpdateSalary(VAN_OA.Model.HR.HR_PERSON model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update HR_Salary set "); strSql.Append("BasicSalary=" + model.BasicSalary + ","); strSql.Append("GongLin=" + model.GongLin + ","); strSql.Append("MobileFee=" + model.MobileFee + ","); strSql.Append("PositionFee=" + model.PositionFee + ","); strSql.Append("YangLaoJin=" + model.YangLaoJin + ","); strSql.Append("UnionFee=" + model.UnionFee + ","); strSql.Append("DefaultWorkDays=" + model.DefaultWorkDays + ","); strSql.Append("IsRetailed=" + (model.IsRetailed == true ? 1 : 0) + ","); strSql.Append("IsQuit=" + (model.IsQuit == true ? 1 : 0) + ","); 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 + ""); bool rowsAffected = DBHelp.ExeCommand(strSql.ToString()); return(rowsAffected); }
public HR_PERSON getModel() { DateTime UpdateTime = DateTime.Now; int UpdatePerson = Convert.ToInt32(Session["currentUserId"]); VAN_OA.Model.HR.HR_PERSON model = new VAN_OA.Model.HR.HR_PERSON(); if (base.Request["Code"] != null) { model.ID = Convert.ToInt32(base.Request["Code"]); } model.BasicSalary = decimal.Parse(txtBasicSalary.Text); model.GongLin = decimal.Parse(txtGonglin.Text);; model.MobileFee = decimal.Parse(txtMobileFee.Text);; model.PositionFee = decimal.Parse(txtPositionFee.Text); model.YangLaoJin = decimal.Parse(txtYangLaoJin.Text); model.UnionFee = decimal.Parse(txtUnionFee.Text); model.DefaultWorkDays = decimal.Parse(txtDefaultWorkDays.Text); model.IsRetailed = this.ChkRetail.Checked; model.IsQuit = this.ChkQuit.Checked; model.UpdateTime = UpdateTime; model.UpdatePerson = UpdatePerson; return(model); }
/// <summary> /// 得到一个员工基本工资的对象实体 /// </summary> public VAN_OA.Model.HR.HR_PERSON GetSalary(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select"); strSql.Append(" H.ID,U.Name,H.BasicSalary,H.GongLin,H.MobileFee,H.PositionFee,H.YangLaoJin,H.UnionFee,H.DefaultWorkDays,H.IsRetailed,H.IsQuit,H.UpdateTime,H.UpdatePerson,U.OnBoardTime,U.QuitTime,U1.loginName as UpdatePersonName"); strSql.Append(" from HR_Salary H right join HR_Person U on H.ID=U.ID left join tb_user U1 on H.UpdatePerson=U1.ID"); strSql.Append(" where U.ID=" + ID + ""); VAN_OA.Model.HR.HR_PERSON 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_PERSON GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" ID,Code,Department,Position,Name,Birthday,Sex,EducationLevel,EducationSchool,Major,GraduationTime,OnBoardTime,BeNormalTime,ContractTime,ContractCloseTime,HuKou,Marriage,IDCard,MobilePhone,HomePhone,HomeAddress,EmailAddress,CreateTime,CreatePerson,UpdateTime,UpdatePerson,QuitStatus,'' as QuitStatusName "); strSql.Append(" from HR_PERSON "); strSql.Append(" where ID=" + ID + ""); VAN_OA.Model.HR.HR_PERSON 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 = ReaderBind(objReader); } } } return(model); }
public HR_PERSON getModel() { string ID = this.lblID.Text; string Code = this.txtCode.Text; string Department = this.txtDepartment.Text; string Position = this.txtPosition.Text; string Name = this.txtName.Text; DateTime Birthday = DateTime.Parse(this.txtBirthday.Text); string Sex = this.ddlSex.Text; string EducationLevel = this.txtEducationLevel.Text; string EducationSchool = this.txtEducationSchool.Text; string Major = this.txtMajor.Text; DateTime?GraduationTime = null; if (txtGraduationTime.Text != "") { GraduationTime = DateTime.Parse(this.txtGraduationTime.Text); } DateTime?BeNormalTime = null; if (txtBeNormalTime.Text != "") { BeNormalTime = DateTime.Parse(this.txtBeNormalTime.Text); } DateTime?OnBoardTime = null; if (txtOnBoardTime.Text != "") { OnBoardTime = DateTime.Parse(this.txtOnBoardTime.Text); } DateTime?ContractTime = null; if (txtContractTime.Text != "") { ContractTime = DateTime.Parse(this.txtContractTime.Text); } DateTime?ContractCloseTime = null; if (txtContractCloseTime.Text != "") { ContractCloseTime = DateTime.Parse(this.txtContractCloseTime.Text); } string HuKou = this.txtHuKou.Text; string Marriage = this.ddlMarriage.Text; string IDCard = this.txtIDCard.Text; string MobilePhone = this.txtMobilePhone.Text; string HomePhone = this.txtHomePhone.Text; string HomeAddress = this.txtHomeAddress.Text; string EmailAddress = this.txtEmailAddress.Text; bool quit = this.chkQuit.Checked; DateTime?quitTime = null; if (txtQuitTime.Text != "") { quitTime = DateTime.Parse(this.txtQuitTime.Text); } string quitReason = this.txtQuitReason.Text; DateTime CreateTime = DateTime.Now; int CreatePerson = Convert.ToInt32(Session["currentUserId"]); DateTime UpdateTime = DateTime.Now; int UpdatePerson = Convert.ToInt32(Session["currentUserId"]); VAN_OA.Model.HR.HR_PERSON model = new VAN_OA.Model.HR.HR_PERSON(); if (base.Request["Code"] != null) { model.ID = Convert.ToInt32(base.Request["Code"]); } else { model.ID = Convert.ToInt32(lblID.Text); } model.Code = Code; model.Department = Department; model.Position = Position; model.Name = Name; model.Birthday = Birthday; model.Sex = Sex; model.EducationLevel = EducationLevel; model.EducationSchool = EducationSchool; model.Major = Major; model.GraduationTime = GraduationTime; model.OnBoardTime = OnBoardTime; model.BeNormalTime = BeNormalTime; model.ContractTime = ContractTime; model.ContractCloseTime = ContractCloseTime; model.HuKou = HuKou; model.Marriage = Marriage; model.IDCard = IDCard; model.MobilePhone = MobilePhone; model.HomePhone = HomePhone; model.HomeAddress = HomeAddress; model.EmailAddress = EmailAddress; model.Quit = quit; model.QuitTime = quitTime; model.QuitReason = quitReason; model.CreateTime = CreateTime; model.CreatePerson = CreatePerson; model.UpdateTime = UpdateTime; model.UpdatePerson = UpdatePerson; return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public VAN_OA.Model.HR.HR_PERSON SalaryReaderBind(IDataReader dataReader) { VAN_OA.Model.HR.HR_PERSON model = new VAN_OA.Model.HR.HR_PERSON(); object ojb; ojb = dataReader["ID"]; if (ojb != null && ojb != DBNull.Value) { model.ID = (int)ojb; } model.Name = dataReader["Name"].ToString(); ojb = dataReader["BasicSalary"]; if (ojb != null && ojb != DBNull.Value) { model.BasicSalary = (Decimal)ojb; } ojb = dataReader["GongLin"]; if (ojb != null && ojb != DBNull.Value) { model.GongLin = (Decimal)ojb; } ojb = dataReader["MobileFee"]; if (ojb != null && ojb != DBNull.Value) { model.MobileFee = (Decimal)ojb; } ojb = dataReader["PositionFee"]; if (ojb != null && ojb != DBNull.Value) { model.PositionFee = (Decimal)ojb; } ojb = dataReader["YangLaoJin"]; if (ojb != null && ojb != DBNull.Value) { model.YangLaoJin = (Decimal)ojb; } ojb = dataReader["UnionFee"]; if (ojb != null && ojb != DBNull.Value) { model.UnionFee = (Decimal)ojb; } ojb = dataReader["DefaultWorkDays"]; if (ojb != null && ojb != DBNull.Value) { model.DefaultWorkDays = (Decimal)ojb; } ojb = dataReader["IsRetailed"]; if (ojb != null && ojb != DBNull.Value) { model.IsRetailed = (bool)ojb; } else { model.IsRetailed = false; } ojb = dataReader["IsQuit"]; if (ojb != null && ojb != DBNull.Value) { model.IsQuit = (bool)ojb; } else { model.IsQuit = false; } ojb = dataReader["OnBoardTime"]; if (ojb != null && ojb != DBNull.Value) { model.OnBoardTime = (DateTime )ojb; } ojb = dataReader["QuitTime"]; if (ojb != null && ojb != DBNull.Value) { model.QuitTime = (DateTime)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; } ojb = dataReader["UpdatePersonName"]; if (ojb != null && ojb != DBNull.Value) { model.UpdatePersonName = (string)ojb; } return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public VAN_OA.Model.HR.HR_PERSON ReaderBind(IDataReader dataReader) { VAN_OA.Model.HR.HR_PERSON model = new VAN_OA.Model.HR.HR_PERSON(); object ojb; ojb = dataReader["ID"]; if (ojb != null && ojb != DBNull.Value) { model.ID = (int)ojb; } model.Code = dataReader["Code"].ToString(); model.Department = dataReader["Department"].ToString(); model.Position = dataReader["Position"].ToString(); model.Name = dataReader["Name"].ToString(); ojb = dataReader["Birthday"]; if (ojb != null && ojb != DBNull.Value) { model.Birthday = (DateTime)ojb; } model.Sex = dataReader["Sex"].ToString(); model.EducationLevel = dataReader["EducationLevel"].ToString(); model.EducationSchool = dataReader["EducationSchool"].ToString(); model.Major = dataReader["Major"].ToString(); ojb = dataReader["GraduationTime"]; if (ojb != null && ojb != DBNull.Value) { model.GraduationTime = (DateTime)ojb; } ojb = dataReader["OnBoardTime"]; if (ojb != null && ojb != DBNull.Value) { model.OnBoardTime = (DateTime)ojb; } ojb = dataReader["BeNormalTime"]; if (ojb != null && ojb != DBNull.Value) { model.BeNormalTime = (DateTime)ojb; } ojb = dataReader["ContractTime"]; if (ojb != null && ojb != DBNull.Value) { model.ContractTime = (DateTime)ojb; } ojb = dataReader["ContractCloseTime"]; if (ojb != null && ojb != DBNull.Value) { model.ContractCloseTime = (DateTime)ojb; } model.HuKou = dataReader["HuKou"].ToString(); model.Marriage = dataReader["Marriage"].ToString(); model.IDCard = dataReader["IDCard"].ToString(); model.MobilePhone = dataReader["MobilePhone"].ToString(); model.HomePhone = dataReader["HomePhone"].ToString(); model.HomeAddress = dataReader["HomeAddress"].ToString(); model.EmailAddress = dataReader["EmailAddress"].ToString(); ojb = dataReader["CreateTime"]; if (ojb != null && ojb != DBNull.Value) { model.CreateTime = (DateTime)ojb; } ojb = dataReader["CreatePerson"]; if (ojb != null && ojb != DBNull.Value) { model.CreatePerson = (int)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; } ojb = dataReader["QuitStatus"]; if (ojb != null && ojb != DBNull.Value) { model.Quit = (bool)ojb; } model.QuitStatusName = dataReader["QuitStatusName"].ToString(); return(model); }
/// <summary> /// 更新一条员工数据 /// </summary> public bool Update(VAN_OA.Model.HR.HR_PERSON model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update HR_PERSON set "); if (model.Code != null) { strSql.Append("Code='" + model.Code + "',"); } else { strSql.Append("Code= null ,"); } if (model.Department != null) { strSql.Append("Department='" + model.Department + "',"); } else { strSql.Append("Department= null ,"); } if (model.Position != null) { strSql.Append("Position='" + model.Position + "',"); } else { strSql.Append("Position= null ,"); } if (model.Name != null) { strSql.Append("Name='" + model.Name + "',"); } else { strSql.Append("Name= null ,"); } if (model.Birthday != null) { strSql.Append("Birthday='" + model.Birthday + "',"); } else { strSql.Append("Birthday= null ,"); } if (model.Sex != null) { strSql.Append("Sex='" + model.Sex + "',"); } else { strSql.Append("Sex= null ,"); } if (model.EducationLevel != null) { strSql.Append("EducationLevel='" + model.EducationLevel + "',"); } else { strSql.Append("EducationLevel= null ,"); } if (model.EducationSchool != null) { strSql.Append("EducationSchool='" + model.EducationSchool + "',"); } if (model.Major != null) { strSql.Append("Major='" + model.Major + "',"); } else { strSql.Append("Major= null ,"); } if (model.GraduationTime != null) { strSql.Append("GraduationTime='" + model.GraduationTime + "',"); } else { strSql.Append("GraduationTime= null ,"); } if (model.OnBoardTime != null) { strSql.Append("OnBoardTime='" + model.OnBoardTime + "',"); } else { strSql.Append("OnBoardTime= null ,"); } if (model.BeNormalTime != null) { strSql.Append("BeNormalTime='" + model.BeNormalTime + "',"); } else { strSql.Append("BeNormalTime= null ,"); } if (model.ContractTime != null) { strSql.Append("ContractTime='" + model.ContractTime + "',"); } else { strSql.Append("ContractTime= null ,"); } if (model.ContractCloseTime != null) { strSql.Append("ContractCloseTime='" + model.ContractCloseTime + "',"); } else { strSql.Append("ContractCloseTime= null ,"); } if (model.HuKou != null) { strSql.Append("HuKou='" + model.HuKou + "',"); } else { strSql.Append("HuKou= null ,"); } if (model.Marriage != null) { strSql.Append("Marriage='" + model.Marriage + "',"); } else { strSql.Append("Marriage= null ,"); } if (model.IDCard != null) { strSql.Append("IDCard='" + model.IDCard + "',"); } else { strSql.Append("IDCard= null ,"); } if (model.MobilePhone != null) { strSql.Append("MobilePhone='" + model.MobilePhone + "',"); } else { strSql.Append("MobilePhone= null ,"); } if (model.HomePhone != null) { strSql.Append("HomePhone='" + model.HomePhone + "',"); } else { strSql.Append("HomePhone= null ,"); } if (model.HomeAddress != null) { strSql.Append("HomeAddress='" + model.HomeAddress + "',"); } else { strSql.Append("HomeAddress= null ,"); } if (model.EmailAddress != null) { strSql.Append("EmailAddress='" + model.EmailAddress + "',"); } else { strSql.Append("EmailAddress= null ,"); } if (model.Quit != null) { strSql.Append("QuitStatus=" + (model.Quit == true ? 1 : 0) + ","); } else { strSql.Append("QuitStatus= 0 ,"); } if (model.QuitTime != null) { strSql.Append("QuitTime='" + model.QuitTime + "',"); } else { strSql.Append("QuitTime= null ,"); } if (model.QuitReason != null) { strSql.Append("QuitReason='" + model.QuitReason + "',"); } else { strSql.Append("QuitReason= null ,"); } //if (model.CreateTime != null) //{ // strSql.Append("CreateTime='" + model.CreateTime + "',"); //} //else //{ // strSql.Append("CreateTime= null ,"); //} //if (model.CreatePerson != null) //{ // strSql.Append("CreatePerson=" + model.CreatePerson + ","); //} //else //{ // strSql.Append("CreatePerson= null ,"); //} 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 + ""); bool rowsAffected = DBHelp.ExeCommand(strSql.ToString()); return(rowsAffected); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(VAN_OA.Model.HR.HR_PERSON model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); strSql1.Append("ID,"); strSql2.Append(model.ID + ","); if (model.Code != null) { strSql1.Append("Code,"); strSql2.Append("'" + model.Code + "',"); } if (model.Department != null) { strSql1.Append("Department,"); strSql2.Append("'" + model.Department + "',"); } if (model.Position != null) { strSql1.Append("Position,"); strSql2.Append("'" + model.Position + "',"); } if (model.Name != null) { strSql1.Append("Name,"); strSql2.Append("'" + model.Name + "',"); } if (model.Birthday != null) { strSql1.Append("Birthday,"); strSql2.Append("'" + model.Birthday + "',"); } if (model.Sex != null) { strSql1.Append("Sex,"); strSql2.Append("'" + model.Sex + "',"); } if (model.EducationLevel != null) { strSql1.Append("EducationLevel,"); strSql2.Append("'" + model.EducationLevel + "',"); } if (model.EducationSchool != null) { strSql1.Append("EducationSchool,"); strSql2.Append("'" + model.EducationSchool + "',"); } if (model.Major != null) { strSql1.Append("Major,"); strSql2.Append("'" + model.Major + "',"); } if (model.GraduationTime != null) { strSql1.Append("GraduationTime,"); strSql2.Append("'" + model.GraduationTime + "',"); } if (model.OnBoardTime != null) { strSql1.Append("OnBoardTime,"); strSql2.Append("'" + model.OnBoardTime + "',"); } if (model.BeNormalTime != null) { strSql1.Append("BeNormalTime,"); strSql2.Append("'" + model.BeNormalTime + "',"); } if (model.ContractTime != null) { strSql1.Append("ContractTime,"); strSql2.Append("'" + model.ContractTime + "',"); } if (model.ContractCloseTime != null) { strSql1.Append("ContractCloseTime,"); strSql2.Append("'" + model.ContractCloseTime + "',"); } if (model.HuKou != null) { strSql1.Append("HuKou,"); strSql2.Append("'" + model.HuKou + "',"); } if (model.Marriage != null) { strSql1.Append("Marriage,"); strSql2.Append("'" + model.Marriage + "',"); } if (model.IDCard != null) { strSql1.Append("IDCard,"); strSql2.Append("'" + model.IDCard + "',"); } if (model.MobilePhone != null) { strSql1.Append("MobilePhone,"); strSql2.Append("'" + model.MobilePhone + "',"); } if (model.HomePhone != null) { strSql1.Append("HomePhone,"); strSql2.Append("'" + model.HomePhone + "',"); } if (model.HomeAddress != null) { strSql1.Append("HomeAddress,"); strSql2.Append("'" + model.HomeAddress + "',"); } if (model.EmailAddress != null) { strSql1.Append("EmailAddress,"); strSql2.Append("'" + model.EmailAddress + "',"); } if (model.CreateTime != null) { strSql1.Append("CreateTime,"); strSql2.Append("'" + model.CreateTime + "',"); } if (model.CreatePerson != null) { strSql1.Append("CreatePerson,"); strSql2.Append("" + model.CreatePerson + ","); } if (model.Quit != null) { strSql1.Append("QuitStatus,"); strSql2.Append("" + (model.Quit == true ? 1 : 0) + ","); } if (model.QuitTime != null) { strSql1.Append("QuitTime,"); strSql2.Append("'" + model.QuitTime + "',"); } if (model.QuitReason != null) { strSql1.Append("QuitReason,"); strSql2.Append("'" + model.QuitReason + "',"); } //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_PERSON("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";"); bool rowsAffected = DBHelp.ExeCommand(strSql.ToString()); return(rowsAffected); }