public bool CreateCustomerPhoneInfo(string phoneNumber, string customerId, out string message)
{
message = "操作失败，请与管理员联系";
if (string.IsNullOrEmpty(phoneNumber) || string.IsNullOrEmpty(customerId))
{
message = "参数错误，联系号码或客户ID不能为空";
return(false);
}
CustomerDomainModel customerInfo = CustomerInfoService.Instance.GetCustomerDomainModelById(customerId, false);
if (customerInfo == null)
{
message = "操作失败，不存在的客户ID";
return(false);
}
CustomerPhoneInfoModel phoneInfo = new CustomerPhoneInfoModel();
phoneInfo.PhoneNumber = phoneNumber;
phoneInfo.CustomerId = customerId;
return(CreateCustomerPhoneInfo(phoneInfo, out message));
}
public bool CreateContactInfo(CustomerContactInfoModel contactInfo, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
CustomerDomainModel customer = CustomerInfoService.Instance.GetCustomerDomainModelById(contactInfo.CustomerId, false);
if (customer == null)
{
message = "操作失败，目标客户不存在";
return(false);
}
if (contactInfo != null)
{
contactInfo.ContactId = GetGuid();
PhoneLocationInfoModel loc = PhoneLocationInfoService.Instance.GetLocationInfo(contactInfo.CustomerPhone, false);
if (loc != null)
{
contactInfo.FromCityId = loc.ChinaId;
contactInfo.FromCityName = loc.City;
}
try
{
BeginTransaction();
if (Create(contactInfo) == 1)
{
if (contactInfo.CustomerPhone != "")
{
CustomerPhoneInfoModel phoneInfo = new CustomerPhoneInfoModel();
phoneInfo.CustomerId = contactInfo.CustomerId;
phoneInfo.PhoneNumber = contactInfo.CustomerPhone;
if (!CustomerPhoneInfoService.Instance.CreateCustomerPhoneInfo(phoneInfo, out message))
{
RollbackTransaction();
message = "添加客户联系号码失败";
return(false);
}
}
CommitTransaction();
result = true;
message = "成功创建客户联系记录";
CustomerInfoService.Instance.GetCustomerDomainModelById(contactInfo.CustomerId, true);
}
}
catch (Exception ex)
{
RollbackTransaction();
LogUtil.Error("建客户联系记录异常", ex);
throw ex;
}
}
return(result);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
CustomerPhoneInfoModel customerphoneinfo = new CustomerPhoneInfoModel();
ret = DbUtil.Current.DeleteMultiple(customerphoneinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="customerphoneinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(CustomerPhoneInfoModel customerphoneinfo, ParameterCollection pc)
{
int ret = 0;
customerphoneinfo.ModifiedBy = SessionUtil.Current.UserId;
customerphoneinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(customerphoneinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="customerphoneinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(CustomerPhoneInfoModel customerphoneinfo)
{
int ret = 0;
customerphoneinfo.ModifiedBy = SessionUtil.Current.UserId;
customerphoneinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(customerphoneinfo);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="phoneid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string phoneid)
{
int ret = 0;
CustomerPhoneInfoModel customerphoneinfo = new CustomerPhoneInfoModel();
customerphoneinfo.PhoneId = phoneid;
ret = DbUtil.Current.Delete(customerphoneinfo);
return(ret);
}
public bool CreateCustomerPhoneInfo(CustomerPhoneInfoModel phoneInfo, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
if (phoneInfo == null || string.IsNullOrEmpty(phoneInfo.CustomerId) || string.IsNullOrEmpty(phoneInfo.PhoneNumber))
{
message = "添加客户联系号码参数错误，请与管理员联系";
return(false);
}
string checkExistsSQL = "SELECT COUNT(1) FROM customer_phone_info WHERE phone_number = $phoneNumber$ AND customer_id = $CustomerId$";
ParameterCollection pc = new ParameterCollection();
pc.Add("CustomerId", phoneInfo.CustomerId);
pc.Add("phoneNumber", phoneInfo.PhoneNumber);
bool exists = ExecuteScalar(checkExistsSQL, pc).ToString() != "0";
if (exists)
{
message = "操作中止，该联系号码已经存在";
return(true);
}
phoneInfo.PhoneId = GetGuid();
phoneInfo.CallStatus = CustomDataInfoService.Instance.GetCustomDataDomainModelByName("号码状态", false).GetCustomDataValueDomainByDataValue("正常").ValueId;
phoneInfo.PhoneType = CustomDataInfoService.Instance.GetCustomDataDomainModelByName("号码类型", false).GetCustomDataValueDomainByDataValue("其他电话").ValueId;
phoneInfo.Status = 0;
PhoneLocationInfoModel loc = PhoneLocationInfoService.Instance.GetLocationInfo(phoneInfo.PhoneNumber, false);
if (loc != null)
{
phoneInfo.FromCityId = loc.ChinaId.ToString();
phoneInfo.FromCityName = loc.City;
}
else
{
message = "填写号码无法判断归属地，请检查。如果是固定电话，请加上区号";
//return false;
}
if (Create(phoneInfo) == 1)
{
message = "成功添加客户联系号码";
return(true);
}
return(result);
}
// 在此添加你的代码...
public string GetOutCallNumber(CustomerPhoneInfoModel phoneInfo)
{
if (phoneInfo == null)
{
return("");
}
if (Framework.Utilities.RegexUtil.IsMobilePhone(phoneInfo.PhoneNumber))
{
return((phoneInfo.FromCityId == "472") ? "9" + phoneInfo.PhoneNumber : "90" + phoneInfo.PhoneNumber);
}
else
{
return((phoneInfo.FromCityId == "472") ? "9" + phoneInfo.PhoneNumber : "9" + phoneInfo.PhoneNumber);
}
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <CustomerPhoneInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <CustomerPhoneInfoModel> customerphoneinfos = new List <CustomerPhoneInfoModel>();
CustomerPhoneInfoModel customerphoneinfo = new CustomerPhoneInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(customerphoneinfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
customerphoneinfo = new CustomerPhoneInfoModel();
customerphoneinfo.ConvertFrom(dt, i);
customerphoneinfos.Add(customerphoneinfo);
}
return(customerphoneinfos);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="phoneid"></param>
/// <returns>实体</returns>
public CustomerPhoneInfoModel Retrieve(string phoneid)
{
CustomerPhoneInfoModel customerphoneinfo = new CustomerPhoneInfoModel();
customerphoneinfo.PhoneId = phoneid;
DataTable dt = DbUtil.Current.Retrieve(customerphoneinfo);
if (dt.Rows.Count < 1)
{
return(null);
}
customerphoneinfo.ConvertFrom(dt);
return(customerphoneinfo);
}
public bool UpdateCustomerPhoneInfo(string oldphoneNumber, string phoneNumber, string customerId, out string message)
{
bool result = false;
if (string.IsNullOrEmpty(oldphoneNumber))
{
if (CreateCustomerPhoneInfo(phoneNumber, customerId, out message) == true)
{
message = "成功更新客户联系号码";
result = true;
return(result);
}
else
{
message = "更新客户联系号码参数错误，请与管理员联系";
return(false);
}
}
message = "操作失败，请与管理员联系";
if (string.IsNullOrEmpty(phoneNumber) || string.IsNullOrEmpty(customerId))
{
message = "参数错误，联系号码或客户ID不能为空";
return(false);
}
CustomerDomainModel customerInfo = CustomerInfoService.Instance.GetCustomerDomainModelById(customerId, false);
if (customerInfo == null)
{
message = "操作失败，不存在的客户ID";
return(false);
}
CustomerPhoneInfoModel phoneInfo = new CustomerPhoneInfoModel();
phoneInfo.PhoneNumber = phoneNumber;
phoneInfo.CustomerId = customerId;
string checkExistsSQL = "SELECT * FROM customer_phone_info WHERE phone_number = $oldphoneNumber$ AND customer_id = $CustomerId$";
ParameterCollection pc = new ParameterCollection();
pc.Add("CustomerId", phoneInfo.CustomerId);
pc.Add("oldphoneNumber", oldphoneNumber);
string phoneid = ExecuteScalar(checkExistsSQL, pc).ToString();
if (string.IsNullOrEmpty(phoneid))
{
message = "更新客户联系号码参数错误，请与管理员联系";
return(false);
}
phoneInfo.PhoneId = phoneid;
phoneInfo.CallStatus = CustomDataInfoService.Instance.GetCustomDataDomainModelByName("号码状态", false).GetCustomDataValueDomainByDataValue("正常").ValueId;
phoneInfo.PhoneType = CustomDataInfoService.Instance.GetCustomDataDomainModelByName("号码类型", false).GetCustomDataValueDomainByDataValue("其他电话").ValueId;
phoneInfo.Status = 0;
PhoneLocationInfoModel loc = PhoneLocationInfoService.Instance.GetLocationInfo(phoneInfo.PhoneNumber, false);
if (loc != null)
{
phoneInfo.FromCityId = loc.ChinaId.ToString();
phoneInfo.FromCityName = loc.City;
}
else
{
message = "填写号码无法判断归属地，请检查。如果是固定电话，请加上区号";
//return false;
}
if (Update(phoneInfo) == 1)
{
message = "成功更新客户联系号码";
return(true);
}
return(result);
}
