// 在此添加你的代码...
/// <summary>
/// 获取客户信息审核信息实体。
/// </summary>
/// <param name="approvalId"></param>
/// <param name="clear"></param>
/// <returns></returns>
public CustomerInfoApprovalModel GetCustomerInfoApprovalModelById(string approvalId, bool clear)
{
CustomerInfoApprovalModel result = null;
result = Retrieve(approvalId);
return(result);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
CustomerInfoApprovalModel customerinfoapproval = new CustomerInfoApprovalModel();
ret = DbUtil.Current.DeleteMultiple(customerinfoapproval, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="customerinfoapproval">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(CustomerInfoApprovalModel customerinfoapproval, ParameterCollection pc)
{
int ret = 0;
customerinfoapproval.ModifiedBy = SessionUtil.Current.UserId;
customerinfoapproval.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(customerinfoapproval, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="customerinfoapproval">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(CustomerInfoApprovalModel customerinfoapproval)
{
int ret = 0;
customerinfoapproval.ModifiedBy = SessionUtil.Current.UserId;
customerinfoapproval.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(customerinfoapproval);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="approvalid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string approvalid)
{
int ret = 0;
CustomerInfoApprovalModel customerinfoapproval = new CustomerInfoApprovalModel();
customerinfoapproval.ApprovalId = approvalid;
ret = DbUtil.Current.Delete(customerinfoapproval);
return(ret);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <CustomerInfoApprovalModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <CustomerInfoApprovalModel> customerinfoapprovals = new List <CustomerInfoApprovalModel>();
CustomerInfoApprovalModel customerinfoapproval = new CustomerInfoApprovalModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(customerinfoapproval, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
customerinfoapproval = new CustomerInfoApprovalModel();
customerinfoapproval.ConvertFrom(dt, i);
customerinfoapprovals.Add(customerinfoapproval);
}
return(customerinfoapprovals);
}
/// <summary>
/// 创建客户审批信息。
/// </summary>
/// <param name="approvalInfo"></param>
/// <param name="message"></param>
/// <returns></returns>
public bool CreateCustomerInfoApproval(CustomerInfoApprovalModel approvalInfo, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
approvalInfo.Status = 0;
if (Create(approvalInfo) == 1)
{
result = true;
message = "成功创建客户信息修改审批项目";
}
return(result);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="approvalid"></param>
/// <returns>实体</returns>
public CustomerInfoApprovalModel Retrieve(string approvalid)
{
CustomerInfoApprovalModel customerinfoapproval = new CustomerInfoApprovalModel();
customerinfoapproval.ApprovalId = approvalid;
DataTable dt = DbUtil.Current.Retrieve(customerinfoapproval);
if (dt.Rows.Count < 1)
{
return(null);
}
customerinfoapproval.ConvertFrom(dt);
return(customerinfoapproval);
}
/// <summary>
/// 更新指定客户信息修改审批记录。
/// </summary>
/// <param name="idList"></param>
/// <param name="status"></param>
/// <param name="message"></param>
/// <returns></returns>
public bool UpdateCustomerApprovalStatus(List <string> idList, string approvalDescription, int status, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
if (idList == null || idList.Count == 0)
{
return(false);
}
try
{
BeginTransaction();
string sql = "update customer_info_approval set status = $status$, description = $description$ where approval_id = $id$";
string updateCustomerSQL = "update customer_basic_info set level = $level$ where customer_id = $customer_id$";
ParameterCollection pc = new ParameterCollection();
pc.Add("status", status);
pc.Add("id", "");
pc.Add("customer_id", "");
pc.Add("level", "");
pc.Add("description", (approvalDescription == null) ? "" : approvalDescription);
for (int i = 0; i < idList.Count; i++)
{
pc["id"].Value = idList[i];
CustomerInfoApprovalModel approvalInfo = Retrieve(idList[i]);
if (approvalInfo == null)
{
message = "操作失败，不存在的客户信息修改审批ID";
return(false);
}
if (ExecuteNonQuery(sql, pc) != 1)
{
RollbackTransaction();
message = "更新审批记录失败，请与管理员联系";
LogUtil.Debug(string.Format("更新ID为【{0}】的客户信息修改审批记录状态失败", approvalInfo.ApprovalId));
return(false);
}
else
{
pc["customer_id"].Value = approvalInfo.CustomerId;
if (status == 2)
{
pc["level"].Value = approvalInfo.NewDataId;
}
else if (status == 1)
{
pc["level"].Value = approvalInfo.OldData;
}
if (ExecuteNonQuery(updateCustomerSQL, pc) != 1)
{
RollbackTransaction();
message = "更新客户等级信息失败，请与管理员联系";
LogUtil.Debug(string.Format("更新ID为【{0}】的客户信息修改审核记录状态失败，客户ID为【{1}】", approvalInfo.ApprovalId, approvalInfo.CustomerId));
return(false);
}
else
{
CustomerMemoInfoModel memoInfo = new CustomerMemoInfoModel();
memoInfo.CustomerId = approvalInfo.CustomerId;
if (status == 1)
{
memoInfo.Memo = string.Format("客户信息修改审核未通过，“{0}”原值【{1}】改为【{2}】, {3}", approvalInfo.UpdateFieldName, approvalInfo.NewData, approvalInfo.OldData, approvalDescription);
}
else if (status == 2)
{
memoInfo.Memo = string.Format("客户信息修改审核通过，“{0}”原值【{1}】改为【{2}】, {3}", approvalInfo.UpdateFieldName, approvalInfo.OldData, approvalInfo.NewData, approvalDescription);
}
memoInfo.MemoId = GetGuid();
memoInfo.Status = 0;
if (CustomerMemoInfoService.Instance.CreateMemoInfo(memoInfo, out message) == false)
{
RollbackTransaction();
return(false);
}
CustomerInfoService.Instance.GetCustomerDomainModelById(approvalInfo.CustomerId, true);
}
}
}
CommitTransaction();
message = "成功提交客户审核信息";
result = true;
}
catch (Exception ex)
{
RollbackTransaction();
LogUtil.Error("通过客户信息修改审批异常", ex);
throw ex;
}
return(result);
}
