/// <summary> /// 删除 /// </summary> /// <param name="pc">pc</param> /// <returns>影响的记录行数</returns> public int DeleteMultiple(ParameterCollection pc) { int ret = 0; CustomerMemoInfoModel customermemoinfo = new CustomerMemoInfoModel(); ret = DbUtil.Current.DeleteMultiple(customermemoinfo, pc); return(ret); }
/// <summary> /// 更新 /// </summary> /// <param name="customermemoinfo">实体</param> /// <param name="pc">pc</param> /// <returns>影响的记录行数</returns> public int UpdateMultiple(CustomerMemoInfoModel customermemoinfo, ParameterCollection pc) { int ret = 0; customermemoinfo.ModifiedBy = SessionUtil.Current.UserId; customermemoinfo.ModifiedOn = DateTime.Now; ret = DbUtil.Current.UpdateMultiple(customermemoinfo, pc); return(ret); }
/// <summary> /// 更新 /// </summary> /// <param name="customermemoinfo">实体</param> /// <returns>影响的记录行数</returns> public int Update(CustomerMemoInfoModel customermemoinfo) { int ret = 0; customermemoinfo.ModifiedBy = SessionUtil.Current.UserId; customermemoinfo.ModifiedOn = DateTime.Now; ret = DbUtil.Current.Update(customermemoinfo); return(ret); }
/// <summary> /// 删除 /// </summary> /// <param name="memoid"></param> /// <returns>影响的记录行数</returns> public int Delete(string memoid) { int ret = 0; CustomerMemoInfoModel customermemoinfo = new CustomerMemoInfoModel(); customermemoinfo.MemoId = memoid; ret = DbUtil.Current.Delete(customermemoinfo); return(ret); }
/// <summary> /// 根据条件获取实体集合 /// </summary> /// <param name="pc">pc</param> /// <param name="obc">obc</param> /// <returns>实体</returns> public List <CustomerMemoInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc) { List <CustomerMemoInfoModel> customermemoinfos = new List <CustomerMemoInfoModel>(); CustomerMemoInfoModel customermemoinfo = new CustomerMemoInfoModel(); DataTable dt = DbUtil.Current.RetrieveMultiple(customermemoinfo, pc, obc); for (int i = 0; i < dt.Rows.Count; i++) { customermemoinfo = new CustomerMemoInfoModel(); customermemoinfo.ConvertFrom(dt, i); customermemoinfos.Add(customermemoinfo); } return(customermemoinfos); }
/// <summary> /// 根据主键获取实体 /// </summary> /// <param name="memoid"></param> /// <returns>实体</returns> public CustomerMemoInfoModel Retrieve(string memoid) { CustomerMemoInfoModel customermemoinfo = new CustomerMemoInfoModel(); customermemoinfo.MemoId = memoid; DataTable dt = DbUtil.Current.Retrieve(customermemoinfo); if (dt.Rows.Count < 1) { return(null); } customermemoinfo.ConvertFrom(dt); return(customermemoinfo); }
// 在此添加你的代码... public bool CreateMemoInfo(CustomerMemoInfoModel memoInfo, out string message) { bool result = false; message = "操作失败,请与管理员联系"; if (memoInfo == null) { return(false); } memoInfo.MemoId = GetGuid(); if (Create(memoInfo) == 1) { result = true; message = "成功创建客户备注信息"; CustomerInfoService.Instance.GetCustomerDomainModelById(memoInfo.CustomerId, true); } return(result); }
/// <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); }