/// <summary> /// 描述: /// </summary> /// <param name="model"></param> /// <param name="loginUser"></param> /// <returns></returns> public static ActionCorrectiveViewModel SaveActionCorrective(ProblemActionCorrectiveModel model, UserLoginInfo loginUser) { var result = new ActionCorrectiveViewModel() { IsSuccess = true }; try { //add if (model.Id == 0) { //add model.PACIsValid = 1; model.PACCreateUserNo = loginUser.JobNum; model.PACCreateUserName = loginUser.UserName; model.PACCreateTime = DateTime.Now; model.PACOperateUserNo = loginUser.JobNum; model.PACOperateUserName = loginUser.UserName; model.PACOperateTime = DateTime.Now; model.PACAttachmentDownloadUrl = string.IsNullOrEmpty(model.PACAttachmentUrl) ? string.Empty : UploadHelper.GetDownLoadUrl(model.PACAttachmentUrl); model.Id = _actioncorrectiveDal.Insert(model); result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO result.data = model; LogBusiness.Problemfollow(model.PACProblemNo, "Add ActionCorrective", "ActionCorrective", string.Empty); } else { //Update model.PACIsValid = 1; model.PACOperateUserNo = loginUser.JobNum; model.PACOperateUserName = loginUser.UserName; model.PACOperateTime = DateTime.Now; model.PACAttachmentDownloadUrl = string.IsNullOrEmpty(model.PACAttachmentUrl) ? string.Empty : UploadHelper.GetDownLoadUrl(model.PACAttachmentUrl); _actioncorrectiveDal.Update(model); result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO result.data = model; LogBusiness.Problemfollow(model.PACProblemNo, "Edit ActionCorrective", "ActionCorrective", string.Empty); } } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; } return(result); }
/// <summary> /// 插入数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(ProblemActionCorrectiveModel model) { var sql = @"INSERT INTO " + tableName + @"([PACWhat] ,[PACWhoNo] ,[PACWho] ,[PACPlanDate] ,[PACActualDate] ,[PACWhere] ,[PACAttachment] ,[PACAttachmentUrl] ,[PACStatus] ,[PACComment] ,[PACIsValid] ,[PACCreateUserNo] ,[PACCreateUserName] ,[PACCreateTime] ,[PACOperateUserNo] ,[PACOperateUserName] ,[PACOperateTime] ,[PACProblemId])" + @" VALUES (@PACWhat ,@PACWhoNo ,@PACWho ,@PACPlanDate ,@PACActualDate ,@PACWhere ,@PACAttachment ,@PACAttachmentUrl ,@PACStatus ,@PACComment ,@PACIsValid ,@PACCreateUserNo ,@PACCreateUserName ,@PACCreateTime ,@PACOperateUserNo ,@PACOperateUserName ,@PACOperateTime ,@PACProblemId)" + "select id = scope_identity()"; SqlParameter[] para = { new SqlParameter("@PACWhat", string.IsNullOrEmpty(model.PACWhat) ? string.Empty : model.PACWhat), new SqlParameter("@PACWhoNo", string.IsNullOrEmpty(model.PACWhoNo)?string.Empty : model.PACWhoNo), new SqlParameter("@PACWho", string.IsNullOrEmpty(model.PACWho) ? string.Empty : model.PACWho), new SqlParameter("@PACPlanDate", model.PACPlanDate ?? Convert.ToDateTime("1900-1-1")), new SqlParameter("@PACActualDate", model.PACActualDate ?? Convert.ToDateTime("1900-1-1")), new SqlParameter("@PACWhere", string.IsNullOrEmpty(model.PACWhere) ? string.Empty : model.PACWhere), new SqlParameter("@PACAttachment", string.IsNullOrEmpty(model.PACAttachment) ? string.Empty : (model.PACAttachment.Equals("D")? string.Empty:model.PACAttachment)), new SqlParameter("@PACAttachmentUrl", string.IsNullOrEmpty(model.PACAttachmentUrl) ? string.Empty : (model.PACAttachmentUrl.Equals("D")? string.Empty:model.PACAttachmentUrl)), new SqlParameter("@PACStatus", string.IsNullOrEmpty(model.PACStatus) ? string.Empty : model.PACStatus), new SqlParameter("@PACComment", string.IsNullOrEmpty(model.PACComment) ? string.Empty : model.PACComment), new SqlParameter("@PACIsValid", model.PACIsValid), new SqlParameter("@PACCreateUserNo", model.PACCreateUserNo), new SqlParameter("@PACCreateUserName", model.PACCreateUserName), new SqlParameter("@PACCreateTime", model.PACCreateTime), new SqlParameter("@PACOperateUserNo", model.PACOperateUserNo), new SqlParameter("@PACOperateUserName", model.PACOperateUserName), new SqlParameter("@PACOperateTime", model.PACOperateTime), new SqlParameter("@PACProblemId", model.PACProblemId), }; var result = 0; var ds = ExecuteDataSet(CommandType.Text, sql.ToString(), null, para); if (ds != null && ds.Tables.Count > 0) { var Idstring = ds.Tables[0].Rows[0][0].ToString(); result = string.IsNullOrEmpty(Idstring) ? 0 : Convert.ToInt32(Idstring); } return(result); }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(ProblemActionCorrectiveModel model) { if (model.Id == 0) { return(false); } var upsql = new StringBuilder(); var paramsql = new StringBuilder(); var param = new List <SqlParameter>(); upsql.Append(string.Format("UPDATE {0} SET ", tableName)); #region param if (!string.IsNullOrEmpty(model.PACWhat)) { paramsql.Append(" [PACWhat] = @PACWhat ,"); param.Add(new SqlParameter("@PACWhat", model.PACWhat)); } if (!string.IsNullOrEmpty(model.PACWho)) { paramsql.Append(" [PACWho] = @PACWho ,"); param.Add(new SqlParameter("@PACWho", model.PACWho)); } if (!string.IsNullOrEmpty(model.PACWhoNo)) { paramsql.Append(" [PACWhoNo] = @PACWhoNo ,"); param.Add(new SqlParameter("@PACWhoNo", model.PACWhoNo)); } if (model.PACPlanDate != null) { paramsql.Append(" [PACPlanDate] = @PACPlanDate ,"); param.Add(new SqlParameter("@PACPlanDate", model.PACPlanDate)); } if (model.PACActualDate != null) { paramsql.Append(" [PACActualDate] = @PACActualDate ,"); param.Add(new SqlParameter("@PACActualDate", model.PACActualDate)); } if (!string.IsNullOrEmpty(model.PACWhere)) { paramsql.Append(" [PACWhere] = @PACWhere ,"); param.Add(new SqlParameter("@PACWhere", model.PACWhere)); } if (!string.IsNullOrEmpty(model.PACAttachment)) { if (model.PACAttachment.Equals("D")) { paramsql.Append(" [PACAttachment] = '' ,"); } else { paramsql.Append(" [PACAttachment] = @PACAttachment ,"); param.Add(new SqlParameter("@PACAttachment", model.PACAttachment)); } } if (!string.IsNullOrEmpty(model.PACAttachmentUrl)) { if (model.PACAttachmentUrl.Equals("D")) { paramsql.Append(" [PACAttachmentUrl] = '' ,"); } else { paramsql.Append(" [PACAttachmentUrl] = @PACAttachmentUrl ,"); param.Add(new SqlParameter("@PACAttachmentUrl", model.PACAttachmentUrl)); } } if (!string.IsNullOrEmpty(model.PACStatus)) { paramsql.Append(" [PACStatus] = @PACStatus ,"); param.Add(new SqlParameter("@PACStatus", model.PACStatus)); } if (!string.IsNullOrEmpty(model.PACComment)) { paramsql.Append(" [PACComment] = @PACComment ,"); param.Add(new SqlParameter("@PACComment", model.PACComment)); } if (model.PACIsValid != null) { paramsql.Append(" [PACIsValid] = @PACIsValid ,"); param.Add(new SqlParameter("@PACIsValid", model.PACIsValid)); } if (!string.IsNullOrEmpty(model.PACCreateUserNo)) { paramsql.Append(" [PACCreateUserNo] = @PACreateUserNo ,"); param.Add(new SqlParameter("@PACCreateUserNo", model.PACCreateUserNo)); } if (!string.IsNullOrEmpty(model.PACCreateUserName)) { paramsql.Append(" [PACCreateUserName] = @PACCreateUserName ,"); param.Add(new SqlParameter("@PACCreateUserName", model.PACCreateUserName)); } if (model.PACCreateTime != null) { paramsql.Append(" [PACCreateTime] = @PACCreateTime ,"); param.Add(new SqlParameter("@PACCreateTime", model.PACCreateTime)); } if (!string.IsNullOrEmpty(model.PACOperateUserNo)) { paramsql.Append(" [PACOperateUserNo] = @PACOperateUserNo ,"); param.Add(new SqlParameter("@PACOperateUserNo", model.PACOperateUserNo)); } if (!string.IsNullOrEmpty(model.PACOperateUserName)) { paramsql.Append(" [PACOperateUserName] = @PACOperateUserName ,"); param.Add(new SqlParameter("@PACOperateUserName", model.PACOperateUserName)); } if (model.PACOperateTime != null) { paramsql.Append(" [PACOperateTime] = @PACOperateTime ,"); param.Add(new SqlParameter("@PACOperateTime", model.PACOperateTime)); } #endregion if (param.Count == 0) { return(false); } var paramsqlresult = paramsql.ToString(); paramsqlresult = paramsqlresult.Remove(paramsqlresult.Length - 1, 1); upsql.Append(string.Format("{0} WHERE Id = @Id ", paramsqlresult)); param.Add(new SqlParameter("@Id", model.Id)); return(ExecteNonQuery(CommandType.Text, upsql.ToString(), null, param) > 0); }