/// <summary> /// 描述: /// </summary> /// <param name="model"></param> /// <param name="loginUser"></param> /// <returns></returns> public static StandardizationViewModel SaveStandardization(ProblemStandardizationModel model, UserLoginInfo loginUser) { var result = new StandardizationViewModel() { IsSuccess = true }; try { //add if (model.Id == 0) { //add model.PSIsValid = 1; model.PSCreateUserNo = loginUser.JobNum; model.PSCreateUserName = loginUser.UserName; model.PSCreateTime = DateTime.Now; model.PSOperateUserNo = loginUser.JobNum; model.PSOperateUserName = loginUser.UserName; model.PSOperateTime = DateTime.Now; model.PSAttachmentDownloadUrl = string.IsNullOrEmpty(model.PSAttachmentUrl) ? string.Empty : UploadHelper.GetDownLoadUrl(model.PSAttachmentUrl); model.Id = _standardizationDal.Insert(model); result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO result.data = model; LogBusiness.Problemfollow(model.PSProblemNo, "Add Standardization", "Standardization", string.Empty); } else { //Update model.PSIsValid = 1; model.PSOperateUserNo = loginUser.JobNum; model.PSOperateUserName = loginUser.UserName; model.PSOperateTime = DateTime.Now; model.PSAttachmentDownloadUrl = string.IsNullOrEmpty(model.PSAttachmentUrl) ? string.Empty : UploadHelper.GetDownLoadUrl(model.PSAttachmentUrl); _standardizationDal.Update(model); result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO result.data = model; LogBusiness.Problemfollow(model.PSProblemNo, "Edit Standardization", "Standardization", 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(ProblemStandardizationModel model) { var sql = @"INSERT INTO " + tableName + @" ( [PSItemName] ,[PSItemNameNo] ,[PSNeedUpdate] ,[PSWhoNo] ,[PSWho] ,[PSPlanDate] ,[PSActualDate] ,[PSDocNo] ,[PSChangeContent] ,[PSOldVersion] ,[PSNewVersion] ,[PSAttachment] ,[PSAttachmentUrl] ,[PSIsValid] ,[PSCreateUserNo] ,[PSCreateUserName] ,[PSCreateTime] ,[PSOperateUserNo] ,[PSOperateUserName] ,[PSOperateTime] ,[PSProblemId])" + @" VALUES (@PSItemName ,@PSItemNameNo ,@PSNeedUpdate ,@PSWhoNo ,@PSWho ,@PSPlanDate ,@PSActualDate ,@PSDocNo ,@PSChangeContent ,@PSOldVersion ,@PSNewVersion ,@PSAttachment ,@PSAttachmentUrl ,@PSIsValid ,@PSCreateUserNo ,@PSCreateUserName ,@PSCreateTime ,@PSOperateUserNo ,@PSOperateUserName ,@PSOperateTime ,@PSProblemId )" + " select id = scope_identity()"; SqlParameter[] para = { new SqlParameter("@PSItemName", string.IsNullOrEmpty(model.PSItemName)?string.Empty:model.PSItemName), new SqlParameter("@PSItemNameNo", model.PSItemNameNo), new SqlParameter("@PSNeedUpdate", model.PSNeedUpdate ?? 0), new SqlParameter("@PSWhoNo ", string.IsNullOrEmpty(model.PSWhoNo)?string.Empty:model.PSWhoNo), new SqlParameter("@PSWho ", string.IsNullOrEmpty(model.PSWho)?string.Empty:model.PSWho), new SqlParameter("@PSPlanDate", model.PSPlanDate ?? Convert.ToDateTime("1900-1-1")), new SqlParameter("@PSActualDate", model.PSActualDate ?? Convert.ToDateTime("1900-1-1")), new SqlParameter("@PSDocNo", string.IsNullOrEmpty(model.PSDocNo)?string.Empty:model.PSDocNo), new SqlParameter("@PSChangeContent", string.IsNullOrEmpty(model.PSChangeContent)?string.Empty:model.PSChangeContent), new SqlParameter("@PSOldVersion", string.IsNullOrEmpty(model.PSOldVersion)?string.Empty:model.PSOldVersion), new SqlParameter("@PSNewVersion", string.IsNullOrEmpty(model.PSNewVersion)?string.Empty:model.PSNewVersion), new SqlParameter("@PSAttachment", string.IsNullOrEmpty(model.PSAttachment)?string.Empty: (model.PSAttachment.Equals("D")? string.Empty:model.PSAttachment)), new SqlParameter("@PSAttachmentUrl", string.IsNullOrEmpty(model.PSAttachmentUrl)?string.Empty: (model.PSAttachmentUrl.Equals("D")? string.Empty:model.PSAttachmentUrl)), new SqlParameter("@PSIsValid", model.PSIsValid), new SqlParameter("@PSCreateUserNo", string.IsNullOrEmpty(model.PSCreateUserNo)?string.Empty:model.PSCreateUserNo), new SqlParameter("@PSCreateUserName", string.IsNullOrEmpty(model.PSCreateUserName)?string.Empty:model.PSCreateUserName), new SqlParameter("@PSCreateTime", model.PSCreateTime), new SqlParameter("@PSOperateUserNo", string.IsNullOrEmpty(model.PSOperateUserNo)?string.Empty:model.PSOperateUserNo), new SqlParameter("@PSOperateUserName", string.IsNullOrEmpty(model.PSOperateUserName)?string.Empty:model.PSOperateUserName), new SqlParameter("@PSOperateTime", model.PSOperateTime), new SqlParameter("@PSProblemId", model.PSProblemId) }; 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(ProblemStandardizationModel 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.PSItemName)) { paramsql.Append(" [PSItemName] = @PSItemName ,"); param.Add(new SqlParameter("@PSItemName ", model.PSItemName)); } if (model.PSItemNameNo > 0) { paramsql.Append(" [PSItemNameNo] = @PSItemNameNo ,"); param.Add(new SqlParameter("@PSItemNameNo", model.PSItemNameNo)); } if (model.PSNeedUpdate != null) { paramsql.Append(" [PSNeedUpdate] = @PSNeedUpdate ,"); param.Add(new SqlParameter("@PSNeedUpdate ", model.PSNeedUpdate)); } if (!string.IsNullOrEmpty(model.PSWho)) { paramsql.Append(" [PSWho] = @PSWho ,"); param.Add(new SqlParameter("@PSWho ", model.PSWho)); } if (!string.IsNullOrEmpty(model.PSWhoNo)) { paramsql.Append(" [PSWhoNo ] = @PSWhoNo ,"); param.Add(new SqlParameter("@PSWhoNo ", model.PSWhoNo)); } if (model.PSPlanDate != null && model.PSPlanDate > Convert.ToDateTime("0001-01-01 00:00:00")) { paramsql.Append(" [PSPlanDate] = @PSPlanDate ,"); param.Add(new SqlParameter("@PSPlanDate", model.PSPlanDate)); } if (model.PSActualDate != null && model.PSActualDate > Convert.ToDateTime("0001-01-01 00:00:00")) { paramsql.Append(" [PSActualDate] = @PSActualDate ,"); param.Add(new SqlParameter("@PSActualDate", model.PSActualDate)); } if (!string.IsNullOrEmpty(model.PSDocNo)) { paramsql.Append(" [PSDocNo] = @PSDocNo ,"); param.Add(new SqlParameter("@PSDocNo", model.PSDocNo)); } if (!string.IsNullOrEmpty(model.PSChangeContent)) { paramsql.Append(" [PSChangeContent] = @PSChangeContent ,"); param.Add(new SqlParameter("@PSChangeContent", model.PSChangeContent)); } if (!string.IsNullOrEmpty(model.PSOldVersion)) { paramsql.Append(" [PSOldVersion] = @PSOldVersion ,"); param.Add(new SqlParameter("@PSOldVersion", model.PSOldVersion)); } if (!string.IsNullOrEmpty(model.PSNewVersion)) { paramsql.Append(" [PSNewVersion] = @PSNewVersion ,"); param.Add(new SqlParameter("@PSNewVersion", model.PSNewVersion)); } if (!string.IsNullOrEmpty(model.PSAttachment)) { if (model.PSAttachment.Equals("D")) { paramsql.Append(" [PSAttachment] = '' ,"); } else { paramsql.Append(" [PSAttachment] = @PSAttachment ,"); param.Add(new SqlParameter("@PSAttachment", model.PSAttachment)); } } if (!string.IsNullOrEmpty(model.PSAttachmentUrl)) { if (model.PSAttachmentUrl.Equals("D")) { paramsql.Append(" [PSAttachmentUrl] = '' ,"); } else { paramsql.Append(" [PSAttachmentUrl] = @PSAttachmentUrl ,"); param.Add(new SqlParameter("@PSAttachmentUrl", model.PSAttachmentUrl)); } } if (model.PSIsValid != null) { paramsql.Append(" [PSIsValid] = @PSIsValid ,"); param.Add(new SqlParameter("@PSIsValid", model.PSIsValid)); } if (!string.IsNullOrEmpty(model.PSCreateUserNo)) { paramsql.Append(" [PSCreateUserNo] = @PSCreateUserNo ,"); param.Add(new SqlParameter("@PSCreateUserNo", model.PSCreateUserNo)); } if (!string.IsNullOrEmpty(model.PSCreateUserName)) { paramsql.Append(" [PSCreateUserName] = @PSCreateUserName ,"); param.Add(new SqlParameter("@PSCreateUserName", model.PSCreateUserName)); } if (model.PSCreateTime != null && model.PSCreateTime > Convert.ToDateTime("0001-01-01 00:00:00")) { paramsql.Append(" [PSCreateTime] = @PSCreateTime ,"); param.Add(new SqlParameter("@PSCreateTime", model.PSCreateTime)); } if (!string.IsNullOrEmpty(model.PSOperateUserNo)) { paramsql.Append(" [PSOperateUserNo] = @PSOperateUserNo ,"); param.Add(new SqlParameter("@PSOperateUserNo", model.PSOperateUserNo)); } if (!string.IsNullOrEmpty(model.PSOperateUserName)) { paramsql.Append(" [PSOperateUserName] = @PSOperateUserName ,"); param.Add(new SqlParameter("@PSOperateUserName", model.PSOperateUserName)); } if (model.PSOperateTime != null && model.PSOperateTime > Convert.ToDateTime("0001-01-01 00:00:00")) { paramsql.Append(" [PSOperateTime] = @PSOperateTime ,"); param.Add(new SqlParameter("@PSOperateTime", model.PSOperateTime)); } if (model.PSProblemId > 0) { paramsql.Append(" [PSProblemId] = @PSProblemId ,"); param.Add(new SqlParameter("@PSProblemId", model.PSProblemId)); } #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); }