/// <summary>
/// 新增客户信息
/// </summary>
/// <param name="customerInfo">客户信息</param>
public void Add(CustomerInfo customerInfo)
{
try
{
customer.Add(customerInfo);
}
catch (Exception ex)
{
BusinessExceptionHandler.HandlerException("新增客户信息失败！", ex);
}
}
/// <summary>
/// 新增客户信息
/// </summary>
/// <param name="customerInfo">客户信息对象</param>
public void Add(CustomerInfo customerInfo)
{
string commandText = "INSERT INTO Customer(Id,Owner,OwnerAddress,UserName,Sex,Alias,Tel,Mobile,"
+ "UserAddress,Email,WeChat,FreeTime,PreferSupport,PreferSale,PreferDrink,Character,SaleType,"
+ "CreateDate,UpdateDate,Creator,Operator,Valid)VALUES(@Id,@Owner,@OwnerAddress,@UserName,"
+ "@Sex,@Alias,@Tel,@Mobile,@UserAddress,@Email,@WeChat,@FreeTime,@PreferSupport,@PreferSale,"
+ "@PreferDrink,@Character,@SaleType,@CreateDate,@UpdateDate,@Creator,@Operator,@Valid)";
try
{
base.Execute(commandText, connectionString: CarManageConfig.Instance.ConnectionString,
param: customerInfo);
}
catch (Exception ex)
{
DataAccessExceptionHandler.HandlerException("新增客户信息失败！", ex);
}
}
/// <summary>
/// 更新客户信息
/// </summary>
/// <param name="customerInfo">客户信息信息对象</param>
public void Update(CustomerInfo customerInfo)
{
try
{
customer.Update(customerInfo);
}
catch (Exception ex)
{
BusinessExceptionHandler.HandlerException("更新客户信息失败！", ex);
}
}
/// <summary>
/// 查询客户信息
/// </summary>
/// <returns>客户信息集合</returns>
public List<CustomerInfo> Search(CustomerInfo queryInfo)
{
List<CustomerInfo> customerList = new List<CustomerInfo>();
try
{
customerList = customer.Search(queryInfo);
}
catch (Exception ex)
{
BusinessExceptionHandler.HandlerException("查询客户信息失败！", ex);
}
return customerList;
}
/// <summary>
/// 更新客户信息
/// </summary>
/// <param name="customerInfo">客户信息对象</param>
public void Update(CustomerInfo customerInfo)
{
string commandText = "UPDATE Customer SET "
+ "Owner=@Owner,OwnerAddress=@OwnerAddress,UserName=@UserName,Sex=@Sex,Alias=@Alias,Tel=@Tel,"
+ "Mobile=@Mobile,UserAddress=@UserAddress,Email=@Email,WeChat=@WeChat,FreeTime=@FreeTime,"
+ "PreferSupport=@PreferSupport,PreferSale=@PreferSale,PreferDrink=@PreferDrink,Character=@Character,"
+ "SaleType=@SaleType,CreateDate=@CreateDate,UpdateDate=@UpdateDate,Creator=@Creator,Operator=@Operator,"
+ "Valid=@Valid WHERE Id=@Id";
try
{
base.Execute(commandText, connectionString: CarManageConfig.Instance.ConnectionString,
param: customerInfo);
}
catch (Exception ex)
{
DataAccessExceptionHandler.HandlerException("更新客户信息失败！", ex);
}
}
/// <summary>
/// 获得所有客户信息集合
/// </summary>
/// <returns>客户信息集合</returns>
public List<CustomerInfo> Search(CustomerInfo queryInfo)
{
IDbConnection connection = null;
List<CustomerInfo> customerList = new List<CustomerInfo>();
try
{
string field = "*";
string table = "Customer";
string order = "ORDER BY Id";
StringBuilder filter = new StringBuilder();
#region 查询条件
#endregion
string filterText = string.Empty;
if (filter.Length > 0)
{
filterText = filter.ToString().TrimStart(' ').Remove(0, 3).Insert(0, " WHERE ");
}
string commandText = string.Format("SELECT COUNT(*) FROM Customer {0}", filterText);
connection = base.CreateConnection(CarManageConfig.Instance.ConnectionString);
queryInfo.TotalCount = base.ExecuteObject<int>(commandText: commandText,
connection: connection, param: queryInfo);
if (queryInfo.TotalCount.Equals(0))
return customerList;
int pageCount = queryInfo.TotalCount / queryInfo.PageSize + 1;
if (queryInfo.TotalCount % queryInfo.PageSize != 0)
pageCount++;
int startIndex = queryInfo.PageIndex * queryInfo.PageSize;
commandText = string.Format("SELECT {0} FROM {1} WHERE {2} ORDER BY {3} LIMIT {4},{5}",
field, table, filterText, order, startIndex, queryInfo.PageSize);
customerList = base.Query<CustomerInfo>(commandText, connection, param: queryInfo).ToList();
}
catch (Exception ex)
{
DataAccessExceptionHandler.HandlerException(
"查询客户信息失败！", ex);
}
finally
{
CloseConnection(connection);
}
return customerList;
}
public void Save()
{
CustomerInfo customerInfo = new CustomerInfo();
if (!string.IsNullOrEmpty(CustomerId))
customerInfo = customer.Load(CustomerId);
else
{
customerInfo.Id = Guid.NewGuid().ToString();
customerInfo.CreateDate = DateTime.Now;
customerInfo.Creator = CarManageConfig.Instance.UserData.UserName;
}
customerInfo.Owner = CommonUtil.FilterInput(txtOwner.Text);
customerInfo.OwnerAddress = CommonUtil.FilterInput(txtOwnerAddress.Text);
customerInfo.UserName = CommonUtil.FilterInput(txtUserName.Text);
customerInfo.UserAddress = CommonUtil.FilterInput(txtUserAddress.Text);
if (!CommonUtil.IsNullOrEmpty(cbxSex.SelectedValue))
customerInfo.Sex = ConvertUtil.ToEnum<Sex>(cbxSex.SelectedValue);
if (!CommonUtil.IsNullOrEmpty(cbxAlias.SelectedValue))
customerInfo.Alias = cbxAlias.SelectedValue.ToString();
customerInfo.Tel = CommonUtil.FilterInput(txtTel.Text);
customerInfo.Mobile = CommonUtil.FilterInput(txtMobile.Text);
customerInfo.Email = CommonUtil.FilterInput(txtEmail.Text);
customerInfo.WeChat = CommonUtil.FilterInput(txtWeChat.Text);
if (!CommonUtil.IsNullOrEmpty(cbxFreeTime.SelectedValue))
customerInfo.FreeTime = ConvertUtil.ToEnum<FreeTime>(cbxFreeTime.SelectedValue);
if (!CommonUtil.IsNullOrEmpty(cbxPreferSupport.SelectedValue))
customerInfo.PreferSupport = cbxPreferSupport.SelectedValue.ToString();
if (!CommonUtil.IsNullOrEmpty(cbxPreferSale.SelectedValue))
customerInfo.PreferSale = cbxPreferSale.SelectedValue.ToString();
if (!CommonUtil.IsNullOrEmpty(cbxPreferDrink.SelectedValue))
customerInfo.PreferDrink = cbxPreferSale.SelectedValue.ToString();
if (!CommonUtil.IsNullOrEmpty(cbxCharacter.SelectedValue))
customerInfo.Character = ConvertUtil.ToEnum<CustomerCharacter>(cbxCharacter.SelectedValue);
if (!CommonUtil.IsNullOrEmpty(cbxSaleType.SelectedValue))
customerInfo.SaleType = cbxSaleType.SelectedValue.ToString();
customerInfo.UpdateDate = DateTime.Now;
customerInfo.Operator = CarManageConfig.Instance.UserData.UserName;
if (string.IsNullOrEmpty(CustomerId))
customer.Add(customerInfo);
else
customer.Update(customerInfo);
}