/// <summary> /// 修改员工 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateEmp(EmpleeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OA_Emplee set "); strSql.Append("EmpCode=@EmpCode,"); strSql.Append("EmpName=@EmpName,"); strSql.Append("EmpSex=@EmpSex,"); strSql.Append("EmpAge=@EmpAge,"); strSql.Append("EmpBrithday=@EmpBrithday,"); strSql.Append("EmpNative=@EmpNative,"); strSql.Append("EmpNation=@EmpNation,"); strSql.Append("EmpPolitics=@EmpPolitics,"); strSql.Append("EmpPosition=@EmpPosition,"); strSql.Append("EmpEducation=@EmpEducation,"); strSql.Append("EmpSpecialty=@EmpSpecialty,"); strSql.Append("EmpSchool=@EmpSchool,"); strSql.Append("EmpState=@EmpState,"); strSql.Append("EmpTel=@EmpTel,"); strSql.Append("EmpMobile=@EmpMobile,"); strSql.Append("EmpEmail=@EmpEmail,"); strSql.Append("Remart=@Remart,"); strSql.Append("EmpCard=@EmpCard,"); strSql.Append("EmpAddress=@EmpAddress,"); strSql.Append("EmpType=@EmpType,"); strSql.Append("EmpDate=@EmpDate,"); strSql.Append("EmpContractStart=@EmpContractStart,"); strSql.Append("EmpContractEnd=@EmpContractEnd"); strSql.Append(" where EmpID=@EmpID "); SqlParameter[] parameters = { new SqlParameter("@EmpCode", SqlDbType.VarChar, 36), new SqlParameter("@EmpName", SqlDbType.VarChar, 36), new SqlParameter("@EmpSex", SqlDbType.Char, 1), new SqlParameter("@EmpAge", SqlDbType.Int, 4), new SqlParameter("@EmpBrithday", SqlDbType.VarChar, 10), new SqlParameter("@EmpNative", SqlDbType.VarChar, 36), new SqlParameter("@EmpNation", SqlDbType.VarChar, 20), new SqlParameter("@EmpPolitics", SqlDbType.VarChar, 10), new SqlParameter("@EmpPosition", SqlDbType.VarChar, 36), new SqlParameter("@EmpEducation", SqlDbType.VarChar, 10), new SqlParameter("@EmpSpecialty", SqlDbType.VarChar, 36), new SqlParameter("@EmpSchool", SqlDbType.VarChar, 36), new SqlParameter("@EmpState", SqlDbType.Char, 1), new SqlParameter("@EmpTel", SqlDbType.VarChar, 20), new SqlParameter("@EmpMobile", SqlDbType.VarChar, 20), new SqlParameter("@EmpEmail", SqlDbType.VarChar, 36), new SqlParameter("@Remart", SqlDbType.VarChar, 200), new SqlParameter("@EmpCard", SqlDbType.VarChar, 18), new SqlParameter("@EmpAddress", SqlDbType.NVarChar, 150), new SqlParameter("@EmpType", SqlDbType.Char, 1), new SqlParameter("@EmpDate", SqlDbType.Char, 8), new SqlParameter("@EmpContractStart", SqlDbType.Char, 8), new SqlParameter("@EmpContractEnd", SqlDbType.Char, 8), new SqlParameter("@EmpID", SqlDbType.VarChar, 36) }; parameters[0].Value = model.EmpCode; parameters[1].Value = model.EmpName; parameters[2].Value = model.EmpSex; parameters[3].Value = model.EmpAge; parameters[4].Value = model.EmpBrithday; parameters[5].Value = model.EmpNative; parameters[6].Value = model.EmpNation; parameters[7].Value = model.EmpPolitics; parameters[8].Value = model.EmpPosition; parameters[9].Value = model.EmpEducation; parameters[10].Value = model.EmpSpecialty; parameters[11].Value = model.EmpSchool; parameters[12].Value = model.EmpState; parameters[13].Value = model.EmpTel; parameters[14].Value = model.EmpMobile; parameters[15].Value = model.EmpEmail; parameters[16].Value = model.Remart; parameters[17].Value = model.EmpCard; parameters[18].Value = model.EmpAddress; parameters[19].Value = model.EmpType; parameters[20].Value = model.EmpDate; parameters[21].Value = model.EmpContractStart; parameters[22].Value = model.EmpContractEnd; parameters[23].Value = model.EmpID; int rows = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获取员工模型 /// </summary> /// <param name="EmpID"></param> /// <returns></returns> public EmpleeInfo GetModel(string EmpID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 EmpID,EmpCode,EmpName,EmpSex,EmpAge,EmpBrithday,EmpNative,EmpNation,EmpPolitics,EmpPosition,EmpEducation,EmpSpecialty,EmpSchool,EmpState,EmpTel,EmpMobile,EmpEmail,Remart,CreateTime,CreateUserID,EmpCard,EmpAddress,EmpType,EmpDate,EmpContractStart,EmpContractEnd from OA_Emplee "); strSql.Append(" where EmpID=@EmpID "); SqlParameter[] parameters = { new SqlParameter("@EmpID", SqlDbType.VarChar, 36) }; parameters[0].Value = EmpID; EmpleeInfo model = new EmpleeInfo(); DataSet ds = DBAccess.ExecuteDataset(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["EmpID"] != null && ds.Tables[0].Rows[0]["EmpID"].ToString() != "") { model.EmpID = ds.Tables[0].Rows[0]["EmpID"].ToString(); } if (ds.Tables[0].Rows[0]["EmpCode"] != null && ds.Tables[0].Rows[0]["EmpCode"].ToString() != "") { model.EmpCode = ds.Tables[0].Rows[0]["EmpCode"].ToString(); } if (ds.Tables[0].Rows[0]["EmpName"] != null && ds.Tables[0].Rows[0]["EmpName"].ToString() != "") { model.EmpName = ds.Tables[0].Rows[0]["EmpName"].ToString(); } if (ds.Tables[0].Rows[0]["EmpSex"] != null && ds.Tables[0].Rows[0]["EmpSex"].ToString() != "") { model.EmpSex = ds.Tables[0].Rows[0]["EmpSex"].ToString(); } if (ds.Tables[0].Rows[0]["EmpAge"] != null && ds.Tables[0].Rows[0]["EmpAge"].ToString() != "") { model.EmpAge = int.Parse(ds.Tables[0].Rows[0]["EmpAge"].ToString()); } if (ds.Tables[0].Rows[0]["EmpBrithday"] != null && ds.Tables[0].Rows[0]["EmpBrithday"].ToString() != "") { model.EmpBrithday = ds.Tables[0].Rows[0]["EmpBrithday"].ToString(); } if (ds.Tables[0].Rows[0]["EmpNative"] != null && ds.Tables[0].Rows[0]["EmpNative"].ToString() != "") { model.EmpNative = ds.Tables[0].Rows[0]["EmpNative"].ToString(); } if (ds.Tables[0].Rows[0]["EmpNation"] != null && ds.Tables[0].Rows[0]["EmpNation"].ToString() != "") { model.EmpNation = ds.Tables[0].Rows[0]["EmpNation"].ToString(); } if (ds.Tables[0].Rows[0]["EmpPolitics"] != null && ds.Tables[0].Rows[0]["EmpPolitics"].ToString() != "") { model.EmpPolitics = ds.Tables[0].Rows[0]["EmpPolitics"].ToString(); } if (ds.Tables[0].Rows[0]["EmpPosition"] != null && ds.Tables[0].Rows[0]["EmpPosition"].ToString() != "") { model.EmpPosition = ds.Tables[0].Rows[0]["EmpPosition"].ToString(); } if (ds.Tables[0].Rows[0]["EmpEducation"] != null && ds.Tables[0].Rows[0]["EmpEducation"].ToString() != "") { model.EmpEducation = ds.Tables[0].Rows[0]["EmpEducation"].ToString(); } if (ds.Tables[0].Rows[0]["EmpSpecialty"] != null && ds.Tables[0].Rows[0]["EmpSpecialty"].ToString() != "") { model.EmpSpecialty = ds.Tables[0].Rows[0]["EmpSpecialty"].ToString(); } if (ds.Tables[0].Rows[0]["EmpSchool"] != null && ds.Tables[0].Rows[0]["EmpSchool"].ToString() != "") { model.EmpSchool = ds.Tables[0].Rows[0]["EmpSchool"].ToString(); } if (ds.Tables[0].Rows[0]["EmpState"] != null && ds.Tables[0].Rows[0]["EmpState"].ToString() != "") { model.EmpState = ds.Tables[0].Rows[0]["EmpState"].ToString(); } if (ds.Tables[0].Rows[0]["EmpTel"] != null && ds.Tables[0].Rows[0]["EmpTel"].ToString() != "") { model.EmpTel = ds.Tables[0].Rows[0]["EmpTel"].ToString(); } if (ds.Tables[0].Rows[0]["EmpMobile"] != null && ds.Tables[0].Rows[0]["EmpMobile"].ToString() != "") { model.EmpMobile = ds.Tables[0].Rows[0]["EmpMobile"].ToString(); } if (ds.Tables[0].Rows[0]["EmpEmail"] != null && ds.Tables[0].Rows[0]["EmpEmail"].ToString() != "") { model.EmpEmail = ds.Tables[0].Rows[0]["EmpEmail"].ToString(); } if (ds.Tables[0].Rows[0]["Remart"] != null && ds.Tables[0].Rows[0]["Remart"].ToString() != "") { model.Remart = ds.Tables[0].Rows[0]["Remart"].ToString(); } if (ds.Tables[0].Rows[0]["CreateTime"] != null && ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } if (ds.Tables[0].Rows[0]["CreateUserID"] != null && ds.Tables[0].Rows[0]["CreateUserID"].ToString() != "") { model.CreateUserID = ds.Tables[0].Rows[0]["CreateUserID"].ToString(); } if (ds.Tables[0].Rows[0]["EmpCard"] != null && ds.Tables[0].Rows[0]["EmpCard"].ToString() != "") { model.EmpCard = ds.Tables[0].Rows[0]["EmpCard"].ToString(); } if (ds.Tables[0].Rows[0]["EmpAddress"] != null && ds.Tables[0].Rows[0]["EmpAddress"].ToString() != "") { model.EmpAddress = ds.Tables[0].Rows[0]["EmpAddress"].ToString(); } if (ds.Tables[0].Rows[0]["EmpType"] != null && ds.Tables[0].Rows[0]["EmpType"].ToString() != "") { model.EmpType = ds.Tables[0].Rows[0]["EmpType"].ToString(); } if (ds.Tables[0].Rows[0]["EmpDate"] != null && ds.Tables[0].Rows[0]["EmpDate"].ToString() != "") { model.EmpDate = ds.Tables[0].Rows[0]["EmpDate"].ToString(); } if (ds.Tables[0].Rows[0]["EmpContractStart"] != null && ds.Tables[0].Rows[0]["EmpContractStart"].ToString() != "") { model.EmpContractStart = ds.Tables[0].Rows[0]["EmpContractStart"].ToString(); } if (ds.Tables[0].Rows[0]["EmpContractEnd"] != null && ds.Tables[0].Rows[0]["EmpContractEnd"].ToString() != "") { model.EmpContractEnd = ds.Tables[0].Rows[0]["EmpContractEnd"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 修改员工 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateEmp(EmpleeInfo model) { return(iEmpleeDAL.UpdateEmp(model)); }
/// <summary> /// 新增员工 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddEmp(EmpleeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OA_Emplee("); strSql.Append("EmpID,EmpCode,EmpName,EmpSex,EmpAge,EmpBrithday,EmpNative,EmpNation,EmpPolitics,EmpPosition,EmpEducation,EmpSpecialty,EmpSchool,EmpState,EmpTel,EmpMobile,EmpEmail,Remart,CreateTime,CreateUserID,EmpCard,EmpAddress,EmpType,EmpDate,EmpContractStart,EmpContractEnd)"); strSql.Append(" values ("); strSql.Append("@EmpID,@EmpCode,@EmpName,@EmpSex,@EmpAge,@EmpBrithday,@EmpNative,@EmpNation,@EmpPolitics,@EmpPosition,@EmpEducation,@EmpSpecialty,@EmpSchool,@EmpState,@EmpTel,@EmpMobile,@EmpEmail,@Remart,@CreateTime,@CreateUserID,@EmpCard,@EmpAddress,@EmpType,@EmpDate,@EmpContractStart,@EmpContractEnd)"); SqlParameter[] parameters = { new SqlParameter("@EmpID", SqlDbType.VarChar, 36), new SqlParameter("@EmpCode", SqlDbType.VarChar, 36), new SqlParameter("@EmpName", SqlDbType.VarChar, 36), new SqlParameter("@EmpSex", SqlDbType.Char, 1), new SqlParameter("@EmpAge", SqlDbType.Int, 4), new SqlParameter("@EmpBrithday", SqlDbType.VarChar, 10), new SqlParameter("@EmpNative", SqlDbType.VarChar, 36), new SqlParameter("@EmpNation", SqlDbType.VarChar, 20), new SqlParameter("@EmpPolitics", SqlDbType.VarChar, 10), new SqlParameter("@EmpPosition", SqlDbType.VarChar, 36), new SqlParameter("@EmpEducation", SqlDbType.VarChar, 10), new SqlParameter("@EmpSpecialty", SqlDbType.VarChar, 36), new SqlParameter("@EmpSchool", SqlDbType.VarChar, 36), new SqlParameter("@EmpState", SqlDbType.Char, 1), new SqlParameter("@EmpTel", SqlDbType.VarChar, 20), new SqlParameter("@EmpMobile", SqlDbType.VarChar, 20), new SqlParameter("@EmpEmail", SqlDbType.VarChar, 36), new SqlParameter("@Remart", SqlDbType.VarChar, 200), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.VarChar, 36), new SqlParameter("@EmpCard", SqlDbType.VarChar, 18), new SqlParameter("@EmpAddress", SqlDbType.NVarChar, 150), new SqlParameter("@EmpType", SqlDbType.Char, 1), new SqlParameter("@EmpDate", SqlDbType.Char, 8), new SqlParameter("@EmpContractStart", SqlDbType.Char, 8), new SqlParameter("@EmpContractEnd", SqlDbType.Char, 8) }; parameters[0].Value = model.EmpID; parameters[1].Value = model.EmpCode; parameters[2].Value = model.EmpName; parameters[3].Value = model.EmpSex; parameters[4].Value = model.EmpAge; parameters[5].Value = model.EmpBrithday; parameters[6].Value = model.EmpNative; parameters[7].Value = model.EmpNation; parameters[8].Value = model.EmpPolitics; parameters[9].Value = model.EmpPosition; parameters[10].Value = model.EmpEducation; parameters[11].Value = model.EmpSpecialty; parameters[12].Value = model.EmpSchool; parameters[13].Value = model.EmpState; parameters[14].Value = model.EmpTel; parameters[15].Value = model.EmpMobile; parameters[16].Value = model.EmpEmail; parameters[17].Value = model.Remart; parameters[18].Value = model.CreateTime; parameters[19].Value = model.CreateUserID; parameters[20].Value = model.EmpCard; parameters[21].Value = model.EmpAddress; parameters[22].Value = model.EmpType; parameters[23].Value = model.EmpDate; parameters[24].Value = model.EmpContractStart; parameters[25].Value = model.EmpContractEnd; return(DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters)); }
/// <summary> /// 新增员工 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddEmp(EmpleeInfo model) { return(iEmpleeDAL.AddEmp(model)); }