public ActionResult AddEmployeeInfoNew() { EditEmployeeInfoModel model = new EditEmployeeInfoModel(); // 证件类型 model.CertificateTypeSelectList = new SelectList(EmployeeInfoBLL.GetCertificateTypes(), "CertificateTypeID", "CertificateTypeName"); // 默认选中驾驶员 model.IsDriver = true; return(PartialView("_AddEmployeeInfoNew", model)); }
public ActionResult AddEmployeeInfoNew(EditEmployeeInfoModel model) { if (ModelState.IsValid) { var result = EmployeeInfoBLL.AddEmployeeInfoNew(model, base.CurrentUserID); base.DoLog(OperationTypeEnum.Add, result, "EmployeeName:" + model.EmployeeName); return(Json(result)); } else { // 证件类型 model.CertificateTypeSelectList = new SelectList(EmployeeInfoBLL.GetCertificateTypes(), "CertificateTypeID", "CertificateTypeName"); return(PartialView("_AddEmployeeInfoNew", model)); } }
public ActionResult EditEmployeeInfoNew(EditEmployeeInfoModel model) { // 获取当前员工已经被哪些车使用过 如果对应的员工类型已经关联了相关的车辆 则不能取消绑定 List <VehicleEmployeeInfoDDLModel> list = EmployeeInfoBLL.GetEmployeeInfoUsedToVehicle(model.ID); if (list != null && list.Count > 0) { if (!model.IsDriver) { if (list.Find(o => o.Type == 1) != null) { ModelState.AddModelError("DriveCode", DataAnnotations.DriverError); } } if (!model.IsCarrier && ModelState.IsValid) { if (list.Find(o => o.Type == 2) != null) { ModelState.AddModelError("DriveCode", DataAnnotations.CarrierError); } } } if (ModelState.IsValid) { var result = EmployeeInfoBLL.EditEmployeeInfoNew(model, base.CurrentUserID); base.DoLog(OperationTypeEnum.Edit, result, "ID:" + model.ID); return(Json(result)); } else { // 证件类型 model.CertificateTypeSelectList = new SelectList(EmployeeInfoBLL.GetCertificateTypes(), "CertificateTypeID", "CertificateTypeName"); return(PartialView("_EditEmployeeInfoNew", model)); } }
/// <summary> /// 获取员工信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static SelectResult <EditEmployeeInfoModel> GetNewEmployeeInfoByID(int id) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@ID", SqlDbType.Int), }; paras[0].Value = id; string sql = @"SELECT a.ID,EmployeeName,EmployeeGender,ContactPhone,ContactAddress ,CertificateTypeID,CertificateCode ,IsDriver,DriveCode,IsCarrier ,EmergePhone,CarrierCode ,StrucID ,b.StrucName ,a.Remark, CAST(DriveCodeValidTime AS CHAR(10)) AS DriveCodeValidTime,CAST(CarrieCodeValidTime AS CHAR(10)) AS CarrieCodeValidTime,a.IsOwners FROM dbo.EmployeeInfo AS a LEFT JOIN dbo.Structures AS b ON a.StrucID = b.ID WHERE a.ID=@ID"; List <EditEmployeeInfoModel> list = ConvertToList <EditEmployeeInfoModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray())); EditEmployeeInfoModel data = null; string msg = string.Empty; if (list == null) { msg = PromptInformation.DBError; } else if (list.Count == 0) { msg = PromptInformation.NotExists; } else { data = list[0]; } return(new SelectResult <EditEmployeeInfoModel>() { DataResult = data, Message = msg }); }
public static OperationResult AddEmployeeInfoNew(EditEmployeeInfoModel model, int currentUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@EmployeeName", SqlDbType.NVarChar, 50), new SqlParameter("@EmployeeGender", SqlDbType.Bit), new SqlParameter("@CertificateTypeID", SqlDbType.Int), new SqlParameter("@CertificateCode", SqlDbType.NVarChar, 20), new SqlParameter("@ContactPhone", SqlDbType.NVarChar, 20), new SqlParameter("@ContactAddress", SqlDbType.NVarChar, 200), new SqlParameter("@IsDriver", SqlDbType.Bit), new SqlParameter("@DriveCode", SqlDbType.NVarChar, 20), new SqlParameter("@IsCarrier", SqlDbType.Bit), new SqlParameter("@EmergePhone", SqlDbType.NVarChar, 20), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@CreateUser", SqlDbType.Int), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@DriveCodeValidTime", SqlDbType.Date), new SqlParameter("@CarrieCodeValidTime", SqlDbType.Date), new SqlParameter("@CarrierCode", SqlDbType.NVarChar, 20), new SqlParameter("@StrucID", SqlDbType.Int), new SqlParameter("@IsOwners", SqlDbType.Bit), }; paras[0].Value = model.EmployeeName.Trim(); paras[1].Value = model.EmployeeGender; paras[2].Value = model.CertificateTypeID; if (string.IsNullOrWhiteSpace(model.CertificateCode)) { paras[3].Value = DBNull.Value; } else { paras[3].Value = model.CertificateCode.Trim(); } paras[4].Value = model.ContactPhone; if (string.IsNullOrWhiteSpace(model.ContactAddress)) { paras[5].Value = DBNull.Value; } else { paras[5].Value = model.ContactAddress.Trim(); } paras[6].Value = model.IsDriver; if (string.IsNullOrEmpty(model.DriveCode)) { paras[7].Value = DBNull.Value; } else { paras[7].Value = model.DriveCode.Trim(); } paras[8].Value = model.IsCarrier; if (string.IsNullOrEmpty(model.EmergePhone)) { paras[9].Value = DBNull.Value; } else { paras[9].Value = model.EmergePhone.Trim(); } if (string.IsNullOrWhiteSpace(model.Remark)) { paras[10].Value = DBNull.Value; } else { paras[10].Value = model.Remark; } paras[11].Value = 0; paras[12].Value = currentUserID; paras[13].Value = DateTime.Now; if (string.IsNullOrEmpty(model.DriveCodeValidTime)) { paras[14].Value = DBNull.Value; } else { paras[14].Value = model.DriveCodeValidTime; } if (string.IsNullOrEmpty(model.CarrieCodeValidTime)) { paras[15].Value = DBNull.Value; } else { paras[15].Value = model.CarrieCodeValidTime; } if (string.IsNullOrEmpty(model.CarrierCode)) { paras[16].Value = DBNull.Value; } else { paras[16].Value = model.CarrierCode.Trim(); } paras[17].Value = model.StrucID; paras[18].Value = model.IsOwners; #region SQL string sql = @"INSERT INTO dbo.EmployeeInfo (EmployeeName ,EmployeeGender , ContactPhone ,ContactAddress ,CertificateTypeID ,CertificateCode , IsDriver ,DriveCode ,IsCarrier ,EmergePhone ,Remark ,Status ,CreateUser ,CreateTime , DriveCodeValidTime ,CarrieCodeValidTime,CarrierCode ,StrucID,IsOwners ) VALUES ( @EmployeeName , -- EmployeeName - nvarchar(50) @EmployeeGender , -- EmployeeGender - bit @ContactPhone , -- ContactPhone - nvarchar(20) @ContactAddress , -- ContactAddress - nvarchar(200) @CertificateTypeID , -- CertificateTypeID - int @CertificateCode , -- CertificateCode - nvarchar(20) @IsDriver , -- IsDriver - bit @DriveCode , -- DriveCode - nvarchar(20) @IsCarrier , -- IsCarrier - bit @EmergePhone , -- EmergePhone - nvarchar(20) @Remark , -- Remark - nvarchar(500) @Status , -- Status - int @CreateUser , -- CreateUser - int @CreateTime , -- CreateTime - datetime @DriveCodeValidTime, @CarrieCodeValidTime, @CarrierCode , @StrucID, @IsOwners )"; #endregion bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }
/// <summary> /// 员工信息修改 /// </summary> /// <param name="model"></param> /// <param name="currentUserID"></param> /// <returns></returns> public static OperationResult EditEmployeeInfoNew(EditEmployeeInfoModel model, int currentUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@EmployeeName", SqlDbType.NVarChar, 50), new SqlParameter("@EmployeeGender", SqlDbType.Bit), new SqlParameter("@CertificateTypeID", SqlDbType.Int), new SqlParameter("@CertificateCode", SqlDbType.NVarChar, 20), new SqlParameter("@ContactPhone", SqlDbType.NVarChar, 20), new SqlParameter("@ContactAddress", SqlDbType.NVarChar, 200), new SqlParameter("@IsDriver", SqlDbType.Bit), new SqlParameter("@DriveCode", SqlDbType.NVarChar, 20), new SqlParameter("@IsCarrier", SqlDbType.Bit), new SqlParameter("@EmergePhone", SqlDbType.NVarChar, 20), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@DriveCodeValidTime", SqlDbType.Date), new SqlParameter("@CarrieCodeValidTime", SqlDbType.Date), new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@UpdateUser", SqlDbType.Int), new SqlParameter("@CarrierCode", SqlDbType.NVarChar, 20), new SqlParameter("@StrucID", SqlDbType.Int), new SqlParameter("@IsOwners", SqlDbType.Bit), }; paras[0].Value = model.EmployeeName.Trim(); paras[1].Value = model.EmployeeGender; paras[2].Value = model.CertificateTypeID; if (string.IsNullOrEmpty(model.CertificateCode)) { paras[3].Value = DBNull.Value; } else { paras[3].Value = model.CertificateCode.Trim(); } paras[4].Value = model.ContactPhone; if (string.IsNullOrEmpty(model.ContactAddress)) { paras[5].Value = DBNull.Value; } else { paras[5].Value = model.ContactAddress.Trim(); } paras[6].Value = model.IsDriver; if (string.IsNullOrEmpty(model.DriveCode)) { paras[7].Value = DBNull.Value; } else { paras[7].Value = model.DriveCode.Trim(); } paras[8].Value = model.IsCarrier; if (string.IsNullOrEmpty(model.EmergePhone)) { paras[9].Value = DBNull.Value; } else { paras[9].Value = model.EmergePhone.Trim(); } if (string.IsNullOrWhiteSpace(model.Remark)) { paras[10].Value = DBNull.Value; } else { paras[10].Value = model.Remark; } if (string.IsNullOrWhiteSpace(model.DriveCodeValidTime)) { paras[11].Value = DBNull.Value; } else { paras[11].Value = model.DriveCodeValidTime; } if (string.IsNullOrWhiteSpace(model.CarrieCodeValidTime)) { paras[12].Value = DBNull.Value; } else { paras[12].Value = model.CarrieCodeValidTime; } paras[13].Value = model.ID; paras[14].Value = currentUserID; if (string.IsNullOrWhiteSpace(model.CarrierCode)) { paras[15].Value = DBNull.Value; } else { paras[15].Value = model.CarrierCode.Trim(); } paras[16].Value = model.StrucID; paras[17].Value = model.IsOwners; #region SQL // 更新员工信息的时候需要注意 如果打开编辑页面的时候该员工还未被车辆使用,此时界面上是可以修改隶属单位的,但是当点击保存的时候 // 用户在这之前刚好把这个员工关联了车辆 那么此时隶属单位就不应该被修改 为了防止类似事情发生,故where条件中在做限制 // 上述的限制仅仅是在更换了隶属单位的时候才需要添加 如果隶属单位未做修改 无需添加此限制 string sql = @"UPDATE dbo.EmployeeInfo SET EmployeeName = @EmployeeName ,EmployeeGender = @EmployeeGender , ContactPhone = @ContactPhone ,ContactAddress = @ContactAddress ,CertificateTypeID = @CertificateTypeID , CertificateCode = @CertificateCode ,IsDriver = @IsDriver ,DriveCode = @DriveCode ,IsCarrier = @IsCarrier , EmergePhone = @EmergePhone ,Remark = @Remark ,UpdateUser = @UpdateUser ,UpdateTime = GetDate() , DriveCodeValidTime = @DriveCodeValidTime ,CarrieCodeValidTime = @CarrieCodeValidTime, CarrierCode = @CarrierCode ,StrucID = @StrucID,IsOwners = @IsOwners WHERE ID = @ID "; if (model.OldStrucID != model.StrucID) { sql += "AND NOT EXISTS(SELECT EmployeeInfoID FROM VehicleEmployeeInfo WHERE EmployeeInfoID=@ID)"; } #endregion int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()); string msg = string.Empty; switch (result) { case 1: msg = PromptInformation.OperationSuccess; break; case 0: msg = PromptInformation.NotExists; break; case -1: msg = PromptInformation.DBError; break; } return(new OperationResult() { Success = result > 0, Message = msg }); }