/// <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);
}
