/// <summary> /// 描述: /// </summary> /// <param name="model"></param> /// <param name="loginUser"></param> /// <returns></returns> public static ActionContainmentViewModel SaveActionContainment(ProblemActionContainmentModel model, UserLoginInfo loginUser) { var result = new ActionContainmentViewModel() { 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 = _actioncontainmentDal.Insert(model); result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO result.data = model; LogBusiness.Problemfollow(model.PACProblemNo, "Add ActionContainment", "ActionContainment", 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); _actioncontainmentDal.Update(model); result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO result.data = model; LogBusiness.Problemfollow(model.PACProblemNo, "Edit ActionContainment", "ActionContainment", string.Empty); } } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; } return(result); }
/// <summary> /// insert Table /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(ProblemActionContainmentModel model) { StringBuilder sql = new StringBuilder(); sql.AppendFormat(@" INSERT INTO {0} ([PACWhat] ,[PACCheck] ,[PACWho] ,[PACWhoNo] ,[PACPlanDate] ,[PACVarificationDate] ,[PACWhere] ,[PACAttachment] ,[PACAttachmentUrl] ,[PACEffeective] ,[PACComment] ,[PACIsValid] ,[PACCreateUserNo] ,[PACCreateUserName] ,[PACCreateTime] ,[PACOperateUserNo] ,[PACOperateUserName] ,[PACOperateTime] ,[PACProblemId]) VALUES ( @PACWhat , @PACCheck , @PACWho , @PACWhoNo , @PACPlanDate , @PACVarificationDate , @PACWhere , @PACAttachment , @PACAttachmentUrl , @PACEffeective , @PACComment , @PACIsValid , @PACCreateUserNo , @PACCreateUserName , @PACCreateTime , @PACOperateUserNo , @PACOperateUserName , @PACOperateTime , @PACProblemId ) select id = scope_identity() ", tableName); SqlParameter[] para = { new SqlParameter("@PACWhat", string.IsNullOrEmpty(model.PACWhat)?string.Empty:model.PACWhat), new SqlParameter("@PACCheck", string.IsNullOrEmpty(model.PACCheck) ? string.Empty : model.PACCheck), new SqlParameter("@PACWho", string.IsNullOrEmpty(model.PACWho) ? string.Empty : model.PACWho), new SqlParameter("@PACWhoNo", string.IsNullOrEmpty(model.PACWhoNo) ? string.Empty : model.PACWhoNo), new SqlParameter("@PACPlanDate", model.PACPlanDate ?? Convert.ToDateTime("1900-1-1")), new SqlParameter("@PACVarificationDate", model.PACVarificationDate ?? 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.PACAttachment.Equals("D")? string.Empty:model.PACAttachment)), new SqlParameter("@PACEffeective", model.PACEffeective ?? 0), 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> /// update model /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(ProblemActionContainmentModel 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.PACCheck)) { paramsql.Append(" [PACCheck] = @PACCheck ,"); param.Add(new SqlParameter("@PACCheck", model.PACCheck)); } 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.PACVarificationDate != null) { paramsql.Append(" [PACVarificationDate] = @PACVarificationDate ,"); param.Add(new SqlParameter("@PACVarificationDate", model.PACVarificationDate)); } 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 (model.PACEffeective != null) { paramsql.Append(" [PACEffeective] = @PACEffeective ,"); param.Add(new SqlParameter("@PACEffeective", model.PACEffeective)); } 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] = @PACCreateUserNo ,"); 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); }