Exemplo n.º 1
0
        /// <summary>
        /// 描述:
        /// </summary>
        /// <param name="model"></param>
        /// <param name="loginUser"></param>
        /// <returns></returns>
        public static ActionFactorAnalysisViewModel SaveFactorAnalysis(ProblemActionFactorAnalysisModel model, UserLoginInfo loginUser)
        {
            var result = new ActionFactorAnalysisViewModel()
            {
                IsSuccess = true
            };

            try
            {
                //add
                if (model.Id == 0)
                {
                    //add
                    model.PAFIsValid         = 1;
                    model.PAFCreateUserNo    = loginUser.JobNum;
                    model.PAFCreateUserName  = loginUser.UserName;
                    model.PAFCreateTime      = DateTime.Now;
                    model.PAFOperateUserNo   = loginUser.JobNum;
                    model.PAFOperateUserName = loginUser.UserName;
                    model.PAFOperateTime     = DateTime.Now;
                    model.Id       = _actionfactoranalysisDal.Insert(model);
                    result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO
                    result.data    = model;
                    LogBusiness.Problemfollow(model.PAFProblemNo, "Add FactorAnalysis", "FactorAnalysis", string.Empty);
                }
                else
                {
                    //Update
                    model.PAFIsValid         = 1;
                    model.PAFOperateUserNo   = loginUser.JobNum;
                    model.PAFOperateUserName = loginUser.UserName;
                    model.PAFOperateTime     = DateTime.Now;
                    _actionfactoranalysisDal.Update(model);
                    result.Message = EncryptHelper.DesEncrypt(model.Id.ToString()); //TODO
                    result.data    = model;
                    LogBusiness.Problemfollow(model.PAFProblemNo, "Edit FactorAnalysis", "FactorAnalysis", string.Empty);
                }
            }
            catch (Exception ex)
            {
                result.IsSuccess = false;
                result.Message   = ex.Message;
            }
            return(result);
        }
        public bool Update(ProblemActionFactorAnalysisModel 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.PAFType))
            {
                paramsql.Append(" [PAFType] = @PAFType ,");
                param.Add(new SqlParameter("@PAFType", model.PAFType));
            }
            if (!string.IsNullOrEmpty(model.PAFPossibleCause))
            {
                paramsql.Append(" [PAFPossibleCause] = @PAFPossibleCause ,");
                param.Add(new SqlParameter("@PAFPossibleCause", model.PAFPossibleCause));
            }
            if (!string.IsNullOrEmpty(model.PAFWhat))
            {
                paramsql.Append(" [PAFWhat] = @PAFWhat ,");
                param.Add(new SqlParameter("@PAFWhat", model.PAFWhat));
            }
            if (!string.IsNullOrEmpty(model.PAFWhoNo))
            {
                paramsql.Append(" [PAFWhoNo] = @PAFWhoNo ,");
                param.Add(new SqlParameter("@PAFWhoNo", model.PAFWhoNo));
            }
            if (!string.IsNullOrEmpty(model.PAFWho))
            {
                paramsql.Append(" [PAFWho] = @PAFWho ,");
                param.Add(new SqlParameter("@PAFWho", model.PAFWho));
            }
            if (model.PAFValidatedDate != null && model.PAFValidatedDate > Convert.ToDateTime("0001-01-01 00:00:00"))
            {
                paramsql.Append(" [PAFValidatedDate] = @PAFValidatedDate ,");
                param.Add(new SqlParameter("@PAFValidatedDate", model.PAFValidatedDate));
            }

            if (!string.IsNullOrEmpty(model.PAFPotentialCause))
            {
                paramsql.Append(" [PAFPotentialCause] = @PAFPotentialCause ,");
                param.Add(new SqlParameter("@PAFPotentialCause", model.PAFPotentialCause));
            }
            paramsql.Append(" [PAFIsValid] = @PAFIsValid ,");
            param.Add(new SqlParameter("@PAFIsValid", model.PAFIsValid));

            if (!string.IsNullOrEmpty(model.PAFCreateUserNo))
            {
                paramsql.Append(" [PAFCreateUserNo] = @PAFCreateUserNo ,");
                param.Add(new SqlParameter("@PAFCreateUserNo", model.PAFCreateUserNo));
            }
            if (!string.IsNullOrEmpty(model.PAFCreateUserName))
            {
                paramsql.Append(" [PAFCreateUserName] = @PAFCreateUserName ,");
                param.Add(new SqlParameter("@PAFCreateUserName", model.PAFCreateUserName));
            }
            if (model.PAFCreateTime != null && model.PAFCreateTime > Convert.ToDateTime("0001-01-01 00:00:00"))
            {
                paramsql.Append(" [PAFCreateTime] = @PAFCreateTime ,");
                param.Add(new SqlParameter("@PAFCreateTime", model.PAFCreateTime));
            }
            if (!string.IsNullOrEmpty(model.PAFOperateUserNo))
            {
                paramsql.Append(" [PAFOperateUserNo] = @PAFOperateUserNo ,");
                param.Add(new SqlParameter("@PAFOperateUserNo", model.PAFOperateUserNo));
            }
            if (!string.IsNullOrEmpty(model.PAFOperateUserName))
            {
                paramsql.Append(" [PAFOperateUserName] = @PAFOperateUserName ,");
                param.Add(new SqlParameter("@PAFOperateUserName", model.PAFOperateUserName));
            }
            if (model.PAFOperateTime != null && model.PAFOperateTime > Convert.ToDateTime("0001-01-01 00:00:00"))
            {
                paramsql.Append(" [PAFOperateTime] = @PAFOperateTime ,");
                param.Add(new SqlParameter("@PAFOperateTime", model.PAFOperateTime));
            }
            if (model.PAFProblemId > 0)
            {
                paramsql.Append(" [PAFProblemId] = @PAFProblemId ,");
                param.Add(new SqlParameter("@PAFProblemId", model.PAFProblemId));
            }
            #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(ProblemActionFactorAnalysisModel model)
        {
            var sql = @"INSERT INTO " + tableName +
                      @" ([PAFType]
                   ,[PAFPossibleCause]
                   ,[PAFWhat]
                   ,[PAFWhoNo]
                   ,[PAFWho]
                   ,[PAFValidatedDate]
                   ,[PAFPotentialCause]
                   ,[PAFIsValid]
                   ,[PAFCreateUserNo]
                   ,[PAFCreateUserName]
                   ,[PAFCreateTime]
                   ,[PAFOperateUserNo]
                   ,[PAFOperateUserName]
                   ,[PAFOperateTime]
                   ,[PAFProblemId])" +
                      @" VALUES (@PAFType
                   ,@PAFPossibleCause
                   ,@PAFWhat
                   ,@PAFWhoNo
                   ,@PAFWho
                   ,@PAFValidatedDate
                   ,@PAFPotentialCause
                   ,@PAFIsValid
                   ,@PAFCreateUserNo
                   ,@PAFCreateUserName
                   ,@PAFCreateTime
                   ,@PAFOperateUserNo
                   ,@PAFOperateUserName
                   ,@PAFOperateTime
                   ,@PAFProblemId) " +
                      "  select id = scope_identity()";

            SqlParameter[] para =
            {
                new SqlParameter("@PAFType",            model.PAFType),
                new SqlParameter("@PAFPossibleCause",   model.PAFPossibleCause),
                new SqlParameter("@PAFWhat",            string.IsNullOrEmpty(model.PAFWhat)?string.Empty:model.PAFWhat),
                new SqlParameter("@PAFWhoNo",           string.IsNullOrEmpty(model.PAFWhoNo)?string.Empty:model.PAFWhoNo),
                new SqlParameter("@PAFWho",             string.IsNullOrEmpty(model.PAFWho)?string.Empty:model.PAFWho),
                new SqlParameter("@PAFValidatedDate",   model.PAFValidatedDate ?? Convert.ToDateTime("1900-1-1")),
                new SqlParameter("@PAFPotentialCause",  string.IsNullOrEmpty(model.PAFPotentialCause)?string.Empty:model.PAFPotentialCause),
                new SqlParameter("@PAFIsValid",         model.PAFIsValid),
                new SqlParameter("@PAFCreateUserNo",    model.PAFCreateUserNo),
                new SqlParameter("@PAFCreateUserName",  model.PAFCreateUserName),
                new SqlParameter("@PAFCreateTime",      model.PAFCreateTime),
                new SqlParameter("@PAFOperateUserNo",   model.PAFOperateUserNo),
                new SqlParameter("@PAFOperateUserName", model.PAFOperateUserName),
                new SqlParameter("@PAFOperateTime",     model.PAFOperateTime),
                new SqlParameter("@PAFProblemId",       model.PAFProblemId)
            };
            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);
        }