public static SelectResult <EmployeeInfoEditModel> GetEmployeeInfoByID(int id) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@ID", SqlDbType.NVarChar, 20), }; paras[0].Value = id; string sql = @"SELECT EmployeeID,EmployeeName ,EmployeeGender ,CAST(BirthDate AS CHAR(10)) AS BirthDate ,ContactPhone ,ContactAddress ,CertificateTypeID ,CertificateCode ,CertificateOffice ,CAST(ValidStartTime AS CHAR(10)) AS ValidStartTime ,CAST(ValidEndTime AS CHAR(10)) AS ValidEndTime ,IsDriver ,DriveCode ,DriveTypeID ,DriveLicenseStateID ,IsCarrier ,EmergePhone ,CarrierCode ,StrucID ,Remark ,CAST(DriveCodeValidTime AS CHAR(10)) AS DriveCodeValidTime FROM dbo.EmployeeInfo WHERE ID=@ID"; List <EmployeeInfoEditModel> list = ConvertToList <EmployeeInfoEditModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray())); EmployeeInfoEditModel 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 <EmployeeInfoEditModel>() { DataResult = data, Message = msg }); }
public static OperationResult EditEmployeeInfo(EmployeeInfoEditModel 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("@BirthDate", SqlDbType.Date), new SqlParameter("@CertificateOffice", SqlDbType.NVarChar, 50), new SqlParameter("@ValidStartTime", SqlDbType.Date), new SqlParameter("@ValidEndTime", SqlDbType.Date), 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("@DriveTypeID", SqlDbType.NVarChar, 20), new SqlParameter("@IsCarrier", SqlDbType.Bit), new SqlParameter("@EmergePhone", SqlDbType.NVarChar, 20), new SqlParameter("@DriveLicenseStateID", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@DriveCodeValidTime", SqlDbType.Date), new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@UpdateUser", SqlDbType.Int), new SqlParameter("@CarrierCode", SqlDbType.NVarChar, 20), new SqlParameter("@StrucID", SqlDbType.Int), }; paras[0].Value = model.EmployeeName.Trim(); paras[1].Value = model.EmployeeGender; paras[2].Value = model.CertificateTypeID; paras[3].Value = model.CertificateCode.Trim(); if (string.IsNullOrEmpty(model.BirthDate)) { paras[4].Value = DBNull.Value; } else { paras[4].Value = model.BirthDate; } if (string.IsNullOrEmpty(model.CertificateOffice)) { paras[5].Value = DBNull.Value; } else { paras[5].Value = model.CertificateOffice.Trim(); } if (string.IsNullOrEmpty(model.ValidStartTime)) { paras[6].Value = DBNull.Value; } else { paras[6].Value = model.ValidStartTime; } if (string.IsNullOrEmpty(model.ValidEndTime)) { paras[7].Value = DBNull.Value; } else { paras[7].Value = model.ValidEndTime; } paras[8].Value = model.ContactPhone.Trim(); paras[9].Value = model.ContactAddress.Trim(); paras[10].Value = model.IsDriver; if (string.IsNullOrEmpty(model.DriveCode)) { paras[11].Value = DBNull.Value; } else { paras[11].Value = model.DriveCode.Trim(); } paras[12].Value = model.DriveTypeID; paras[13].Value = model.IsCarrier; if (string.IsNullOrEmpty(model.EmergePhone)) { paras[14].Value = DBNull.Value; } else { paras[14].Value = model.EmergePhone.Trim(); } paras[15].Value = model.DriveLicenseStateID; if (string.IsNullOrWhiteSpace(model.Remark)) { paras[16].Value = DBNull.Value; } else { paras[16].Value = model.Remark; } if (string.IsNullOrWhiteSpace(model.DriveCodeValidTime)) { paras[17].Value = DBNull.Value; } else { paras[17].Value = model.DriveCodeValidTime; } paras[18].Value = model.ID; paras[19].Value = currentUserID; if (string.IsNullOrWhiteSpace(model.CarrierCode)) { paras[20].Value = DBNull.Value; } else { paras[20].Value = model.CarrierCode.Trim(); } paras[21].Value = model.StrucID; #region SQL string sql = @"UPDATE dbo.EmployeeInfo SET EmployeeName = @EmployeeName , EmployeeGender = @EmployeeGender , BirthDate = @BirthDate , ContactPhone = @ContactPhone , ContactAddress = @ContactAddress , CertificateTypeID = @CertificateTypeID , CertificateCode = @CertificateCode , CertificateOffice = @CertificateOffice , ValidStartTime = @ValidStartTime , ValidEndTime = @ValidEndTime , IsDriver = @IsDriver , DriveCode = @DriveCode , DriveTypeID = @DriveTypeID , DriveLicenseStateID = @DriveLicenseStateID , IsCarrier = @IsCarrier , EmergePhone = @EmergePhone , Remark = @Remark , UpdateUser = @UpdateUser , UpdateTime = GetDate() , DriveCodeValidTime = @DriveCodeValidTime , CarrierCode = @CarrierCode , StrucID = @StrucID WHERE ID = @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 }); }
public ActionResult EditEmployeeInfo(EmployeeInfoEditModel model) { //if (model.CertificateTypeID == 1) //{ // bool isIDcard = IsIDcard(model.CertificateCode); // if (!isIDcard) // { // ModelState.AddModelError("CertificateCode", DataAnnotations.IDcardError); // } //} //if (model.IsDriver == true && string.IsNullOrEmpty(model.DriveCode)) //{ // ModelState.AddModelError("DriveCode", DataAnnotations.NeedDriveCode); //} //if (model.IsDriver == true && string.IsNullOrEmpty(model.DriveCodeValidTime)) //{ // ModelState.AddModelError("DriveCodeValidTime", DataAnnotations.MustInputDriveCodeValidTime); //} if (model.IsDriver == true && model.DriveLicenseStateID == 0) { ModelState.AddModelError("DriveLicenseStateID", DataAnnotations.MustInputDriveLicenseStateID); } //if (model.IsDriver == true && model.DriveTypeID.Equals("0")) //{ // ModelState.AddModelError("DriveTypeID", DataAnnotations.MustInputDriveTypeID); //} //if (model.IsCarrier == true && string.IsNullOrEmpty(model.EmergePhone)) //{ // ModelState.AddModelError("EmergePhone", DataAnnotations.NeedEmergePhone); //} //if (model.IsCarrier == true && string.IsNullOrEmpty(model.CarrierCode)) //{ // ModelState.AddModelError("CarrierCode", DataAnnotations.NeedCarrierCode); //} if (ModelState.IsValid) { var result = EmployeeInfoBLL.EditEmployeeInfo(model, base.CurrentUserID); base.DoLog(OperationTypeEnum.Edit, result, "EmployeeID:" + model.EmployeeID); return(Json(result)); } else { model.CertificateTypeSelectList = new SelectList(EmployeeInfoBLL.GetCertificateTypes(), "CertificateTypeID", "CertificateTypeName"); SelectList driveLicenseStateSelectList = new SelectList(EmployeeInfoBLL.GetDriveLicenseStates(), "DriveLicenseStateID", "DriveLicenseStateName"); List <SelectListItem> liDriveLicenseState = new List <SelectListItem>(); liDriveLicenseState.Add(new SelectListItem { Text = DisplayText.PleaseSelect, Value = "0" }); liDriveLicenseState.AddRange(driveLicenseStateSelectList); model.DriveLicenseStateSelectList = liDriveLicenseState; SelectList driveTypeSelectList = new SelectList(EmployeeInfoBLL.GetDriveTypes(), "DriveTypeID", "DriveTypeName"); List <SelectListItem> liDriveType = new List <SelectListItem>(); liDriveType.Add(new SelectListItem { Text = DisplayText.PleaseSelect, Value = "0" }); liDriveType.AddRange(driveTypeSelectList); model.DriveTypeSelectList = liDriveType; return(PartialView("_EditEmployeeInfo", model)); } }