/// <summary> /// 描述:新增问题质量报警 /// </summary> /// <param name="model"></param> /// <param name="loginUser"></param> /// <returns></returns> public static QualityAlertViewModel SaveQualityAlert(ProblemQualityAlertModel model, UserLoginInfo loginUser) { var result = new QualityAlertViewModel() { IsSuccess = true }; try { //add if (model.Id == 0) { //add model.PQIsValid = 1; model.PQCreateUserNo = loginUser.JobNum; model.PQCreateUserName = loginUser.UserName; model.PQCreateTime = DateTime.Now; model.PQOperateUserNo = loginUser.JobNum; model.PQOperateUserName = loginUser.UserName; model.PQOperateTime = DateTime.Now; model.PQAttachmentDownloadUrl = string.IsNullOrEmpty(model.PQAttachmentUrl) ? string.Empty : UploadHelper.GetDownLoadUrl(model.PQAttachmentUrl); model.Id = _qualityalertDal.Insert(model); result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO result.data = model; LogBusiness.Problemfollow(model.PQProblemNo, "Add QualityAlert", "QualityAlert", string.Empty); } else { //Update model.PQIsValid = 1; model.PQOperateUserNo = loginUser.JobNum; model.PQOperateUserName = loginUser.UserName; model.PQOperateTime = DateTime.Now; model.PQAttachmentDownloadUrl = string.IsNullOrEmpty(model.PQAttachmentUrl) ? string.Empty : UploadHelper.GetDownLoadUrl(model.PQAttachmentUrl); _qualityalertDal.Update(model); result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO result.data = model; LogBusiness.Problemfollow(model.PQProblemNo, "Edit QualityAlert", "QualityAlert", string.Empty); } } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; } return(result); }
/// <summary> /// 描述:获取质量报警信息 /// </summary> /// <param name="materialId">物料Id</param> /// <returns></returns> public ProblemQualityAlertModel GetQualityAlertById(int id) { var material = new ProblemQualityAlertModel(); SqlParameter[] para = { new SqlParameter("@Id", id) }; var sql = @"SELECT TOP 1 [Id] ,[PQProblemId] ,[PQWhat] ,[PQWhoNo] ,[PQWho] ,[PQPlanDate] ,[PQActualDate] ,[PQAttachment] ,[PQAttachmentUrl] ,[PQIsValid] ,[PQCreateUserNo] ,[PQCreateUserName] ,[PQCreateTime] ,[PQOperateUserNo] ,[PQOperateUserName] ,[PQOperateTime] FROM " + tableName + " with(NOLOCK) WHERE Id=@Id"; var ds = ExecuteDataSet(CommandType.Text, sql.ToString(), null, para); if (ds != null && ds.Tables.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; material = DataConvertHelper.DataTableToList <ProblemQualityAlertModel>(dt)[0]; } else { return(null); } return(material); }
public bool Update(ProblemQualityAlertModel 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.PQWhat)) { paramsql.Append(" [PQWhat] = @PQWhat ,"); param.Add(new SqlParameter("@PQWhat", model.PQWhat)); } if (!string.IsNullOrEmpty(model.PQWhoNo)) { paramsql.Append(" [PQWhoNo] = @PQWhoNo ,"); param.Add(new SqlParameter("@PQWhoNo", model.PQWhoNo)); } if (!string.IsNullOrEmpty(model.PQWho)) { paramsql.Append(" [PQWho] = @PQWho ,"); param.Add(new SqlParameter("@PQWho", model.PQWho)); } if (model.PQPlanDate != null) { paramsql.Append(" [PQPlanDate] = @PQPlanDate ,"); param.Add(new SqlParameter("@PQPlanDate", model.PQPlanDate)); } if (model.PQActualDate != null) { paramsql.Append(" [PQActualDate] = @PQActualDate ,"); param.Add(new SqlParameter("@PQActualDate", model.PQActualDate)); } if (!string.IsNullOrEmpty(model.PQAttachment)) { if (model.PQAttachment.Equals("D")) { paramsql.Append(" [PQAttachment] = '' ,"); } else { paramsql.Append(" [PQAttachment] = @PQAttachment ,"); param.Add(new SqlParameter("@PQAttachment", model.PQAttachment)); } } if (!string.IsNullOrEmpty(model.PQAttachmentUrl)) { if (model.PQAttachmentUrl.Equals("D")) { paramsql.Append(" [PQAttachmentUrl] = '' ,"); } else { paramsql.Append(" [PQAttachmentUrl] = @PQAttachmentUrl ,"); param.Add(new SqlParameter("@PQAttachmentUrl", model.PQAttachmentUrl)); } } if (model.PQIsValid != null) { paramsql.Append(" [PQIsValid] = @PQIsValid ,"); param.Add(new SqlParameter("@PQIsValid", model.PQIsValid)); } if (!string.IsNullOrEmpty(model.PQCreateUserNo)) { paramsql.Append(" [PQCreateUserNo] = @PQCreateUserNo ,"); param.Add(new SqlParameter("@PQCreateUserNo", model.PQCreateUserNo)); } if (!string.IsNullOrEmpty(model.PQCreateUserName)) { paramsql.Append(" [PQCreateUserName] = @PQCreateUserName ,"); param.Add(new SqlParameter("@PQCreateUserName", model.PQCreateUserName)); } if (model.PQCreateTime != null) { paramsql.Append(" [PQCreateTime] = @PQCreateTime ,"); param.Add(new SqlParameter("@PQCreateTime", model.PQCreateTime)); } if (!string.IsNullOrEmpty(model.PQOperateUserNo)) { paramsql.Append(" [PQOperateUserNo] = @PQOperateUserNo ,"); param.Add(new SqlParameter("@PQOperateUserNo", model.PQOperateUserNo)); } if (!string.IsNullOrEmpty(model.PQOperateUserName)) { paramsql.Append(" [PQOperateUserName] = @PQOperateUserName ,"); param.Add(new SqlParameter("@PQOperateUserName", model.PQOperateUserName)); } if (model.PQOperateTime != null) { paramsql.Append(" [PQOperateTime] = @PQOperateTime ,"); param.Add(new SqlParameter("@PQOperateTime", model.PQOperateTime)); } #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); }
/// <summary> /// 插入数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(ProblemQualityAlertModel model) { var sql = @"INSERT INTO " + tableName + @"([PQProblemId] ,[PQWhat] ,[PQWhoNo] ,[PQWho] ,[PQPlanDate] ,[PQActualDate] ,[PQAttachment] ,[PQAttachmentUrl] ,[PQIsValid] ,[PQCreateUserNo] ,[PQCreateUserName] ,[PQCreateTime] ,[PQOperateUserNo] ,[PQOperateUserName] ,[PQOperateTime]) VALUES (@PQProblemId ,@PQWhat ,@PQWhoNo ,@PQWho ,@PQPlanDate ,@PQActualDate ,@PQAttachment ,@PQAttachmentUrl ,@PQIsValid ,@PQCreateUserNo ,@PQCreateUserName ,@PQCreateTime ,@PQOperateUserNo ,@PQOperateUserName ,@PQOperateTime) " + " select id = scope_identity()"; SqlParameter[] para = { new SqlParameter("@PQProblemId", model.PQProblemId), new SqlParameter("@PQWhat", string.IsNullOrEmpty(model.PQWhat)?string.Empty:model.PQWhat), new SqlParameter("@PQWhoNo", string.IsNullOrEmpty(model.PQWhoNo)?string.Empty:model.PQWhoNo), new SqlParameter("@PQWho", string.IsNullOrEmpty(model.PQWho)?string.Empty:model.PQWho), new SqlParameter("@PQPlanDate", model.PQPlanDate ?? Convert.ToDateTime("1900-1-1")), new SqlParameter("@PQActualDate", model.PQActualDate ?? Convert.ToDateTime("1900-1-1")), new SqlParameter("@PQAttachment", string.IsNullOrEmpty(model.PQAttachment) ? string.Empty : (model.PQAttachment.Equals("D")? string.Empty:model.PQAttachment)), new SqlParameter("@PQAttachmentUrl", string.IsNullOrEmpty(model.PQAttachmentUrl) ? string.Empty : (model.PQAttachmentUrl.Equals("D")? string.Empty:model.PQAttachmentUrl)), new SqlParameter("@PQIsValid", model.PQIsValid), new SqlParameter("@PQCreateUserNo", model.PQCreateUserNo), new SqlParameter("@PQCreateUserName", model.PQCreateUserName), new SqlParameter("@PQCreateTime", model.PQCreateTime), new SqlParameter("@PQOperateUserNo", model.PQOperateUserNo), new SqlParameter("@PQOperateUserName", model.PQOperateUserName), new SqlParameter("@PQOperateTime", model.PQOperateTime), }; 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); }