/// <summary>
/// 根据卡号获取客户信息
/// <param name="cardId">客户卡号</param>
/// </summary>
/// <returns>客户信息对象</returns>
public TBClient GetByCard(long cardId)
{
TBClient tbClient = null;
tbClient = tbClientDAO.GetByCard(cardId);
return(tbClient);
}
/// <summary>
/// 根据卡号获取客户信息
/// <param name="cardId">客户卡号</param>
/// </summary>
/// <returns>客户信息对象</returns>
public TBClient GetByCard(long cardId)
{
TBClient tbClient = null;
try
{
string strSQL = "select * from TBClient where status='0' and cardId=@cardId";
Param param = new Param();
param.Clear();
param.Add("@cardId", cardId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbClient = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbClient);
}
/// <summary>
/// 修改客户信息
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbClient">客户信息</param>
public virtual void Edit(DataAccess data, TBClient tbClient)
{
string strSQL = "update TBClient set agentId=@agentId,siteId=@siteId,balance=@balance,lockFee=@lockFee,status=@status,points=@points,createTime=To_date(@createTime,'yyyy-mm-dd hh24:mi:ss'),operatorName=@operatorName,operatorId=@operatorId,cardId=@cardId,clientName=@clientName,IDNumber=@IDNumber,telephone=@telephone,password=@password,refererClientId=@refererClientId,refererCardId=@refererCardId,refererRebate=@refererRebate,refererValidDate=@refererValidDate,remark=@remark where clientId=@clientId";
Param param = new Param();
param.Clear();
param.Add("@agentId", tbClient.agentId); //代理商编号
param.Add("@siteId", tbClient.siteId); //门店编号
param.Add("@balance", tbClient.balance); //账户余额
param.Add("@lockFee", tbClient.lockFee); //冻结金额
param.Add("@status", tbClient.status); //使用状态
param.Add("@points", tbClient.points); //客户积分
param.Add("@createTime", tbClient.createTime); //创建时间
param.Add("@operatorName", tbClient.operatorName); //操作人名称
param.Add("@operatorId", tbClient.operatorId); //操作人编号
param.Add("@cardId", tbClient.cardId); //卡号
param.Add("@clientName", tbClient.clientName); //姓名
param.Add("@IDNumber", tbClient.IDNumber); //身份证号码
param.Add("@telephone", tbClient.telephone); //手机号
param.Add("@password", tbClient.password); //密码
param.Add("@refererClientId", tbClient.refererClientId); //推荐人编号
param.Add("@refererCardId", tbClient.refererCardId); //推荐人卡号
param.Add("@refererRebate", tbClient.refererRebate); //推荐人返点
param.Add("@refererValidDate", tbClient.refererValidDate); //推荐有效期
param.Add("@remark", tbClient.remark); //备注说明
param.Add("@clientId", tbClient.clientId); //客户编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 读取客户信息信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>客户信息对象</returns>
protected virtual TBClient ReadData(ComDataReader dr)
{
TBClient tbClient = new TBClient();
tbClient.clientId = long.Parse(dr["clientId"].ToString()); //客户编号
tbClient.agentId = dr["agentId"].ToString(); //代理商编号
tbClient.siteId = dr["siteId"].ToString(); //门店编号
tbClient.balance = double.Parse(dr["balance"].ToString()); //账户余额
tbClient.lockFee = double.Parse(dr["lockFee"].ToString()); //冻结金额
tbClient.status = dr["status"].ToString(); //使用状态
tbClient.points = long.Parse(dr["points"].ToString()); //客户积分
if (dr["createTime"] == null)
{
tbClient.createTime = "";//创建时间
}
else
{
tbClient.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]); //创建时间
}
tbClient.operatorName = dr["operatorName"].ToString(); //操作人名称
tbClient.operatorId = dr["operatorId"].ToString(); //操作人编号
tbClient.cardId = dr["cardId"].ToString(); //卡号
tbClient.clientName = dr["clientName"].ToString(); //姓名
tbClient.IDNumber = dr["IDNumber"].ToString(); //身份证号码
tbClient.telephone = dr["telephone"].ToString(); //手机号
tbClient.password = dr["password"].ToString(); //密码
tbClient.refererClientId = long.Parse(dr["refererClientId"].ToString()); //推荐人编号
tbClient.refererCardId = dr["refererCardId"].ToString(); //推荐人卡号
tbClient.refererRebate = double.Parse(dr["refererRebate"].ToString()); //推荐人返点
tbClient.refererValidDate = dr["refererValidDate"].ToString(); //推荐有效期
tbClient.remark = dr["remark"].ToString(); //备注说明
return(tbClient);
}
/// <summary>
/// 修改客户信息
/// <param name="data">数据库连接</param>
/// <param name="tbClient">客户信息</param>
/// </summary>
public void Edit(DataAccess data, TBClient tbClient)
{
string strSQL = "update TBClient set agentId=:agentId,siteId=:siteId,balance=:balance,lockFee=:lockFee,status=:status,points=:points,sumRecharge=:sumRecharge,sumTakeCash=:sumTakeCash,sumConsume=:sumConsume,sumReturnAward=:sumReturnAward,sumBigAward=:sumBigAward,createTime=To_date(:createTime,'yyyy-mm-dd hh24:mi:ss'),operatorName=:operatorName,operatorId=:operatorId,cardId=:cardId,clientName=:clientName,IDNumber=:IDNumber,telephone=:telephone,password=:password,refererCardId=:refererCardId,remark=:remark where clientId=:clientId";
Param param = new Param();
param.Clear();
param.Add(":agentId", tbClient.agentId); //代理商编号
param.Add(":siteId", tbClient.siteId); //快开厅编号
param.Add(":balance", tbClient.balance); //账户余额
param.Add(":lockFee", tbClient.lockFee); //冻结金额
param.Add(":status", tbClient.status); //使用状态
param.Add(":points", tbClient.points); //客户积分
param.Add(":sumRecharge", tbClient.sumRecharge); //充值总额
param.Add(":sumTakeCash", tbClient.sumTakeCash); //提现总额
param.Add(":sumConsume", tbClient.sumConsume); //消费总额
param.Add(":sumReturnAward", tbClient.sumReturnAward); //返奖总额
param.Add(":sumBigAward", tbClient.sumBigAward); //大奖总额
param.Add(":createTime", tbClient.createTime); //创建时间
param.Add(":operatorName", tbClient.operatorName); //操作人名称
param.Add(":operatorId", tbClient.operatorId); //操作人编号
param.Add(":cardId", tbClient.cardId); //卡号
param.Add(":clientName", tbClient.clientName); //姓名
param.Add(":IDNumber", tbClient.IDNumber); //身份证号码
param.Add(":telephone", tbClient.telephone); //手机号
param.Add(":password", tbClient.password); //密码
param.Add(":refererCardId", tbClient.refererCardId); //推荐人卡号
param.Add(":remark", tbClient.remark); //备注说明
param.Add(":clientId", tbClient.clientId); //客户编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 读取客户信息信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>客户信息对象</returns>
private TBClient ReadData(ComDataReader dr)
{
TBClient tbClient = new TBClient();
tbClient.clientId = long.Parse(dr["clientId"].ToString()); //客户编号
tbClient.agentId = dr["agentId"].ToString(); //代理商编号
tbClient.siteId = dr["siteId"].ToString(); //快开厅编号
tbClient.balance = double.Parse(dr["balance"].ToString()); //账户余额
tbClient.lockFee = double.Parse(dr["lockFee"].ToString()); //冻结金额
tbClient.status = dr["status"].ToString(); //使用状态
tbClient.points = long.Parse(dr["points"].ToString()); //客户积分
tbClient.sumRecharge = double.Parse(dr["sumRecharge"].ToString()); //充值总额
tbClient.sumTakeCash = double.Parse(dr["sumTakeCash"].ToString()); //提现总额
tbClient.sumConsume = double.Parse(dr["sumConsume"].ToString()); //消费总额
tbClient.sumReturnAward = double.Parse(dr["sumReturnAward"].ToString()); //返奖总额
tbClient.sumBigAward = double.Parse(dr["sumBigAward"].ToString()); //大奖总额
if (dr["createTime"] == null)
{
tbClient.createTime = "";//创建时间
}
else
{
tbClient.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]); //创建时间
}
tbClient.operatorName = dr["operatorName"].ToString(); //操作人名称
tbClient.operatorId = dr["operatorId"].ToString(); //操作人编号
tbClient.cardId = dr["cardId"].ToString(); //卡号
tbClient.clientName = dr["clientName"].ToString(); //姓名
tbClient.IDNumber = dr["IDNumber"].ToString(); //身份证号码
tbClient.telephone = dr["telephone"].ToString(); //手机号
tbClient.password = dr["password"].ToString(); //密码
tbClient.refererCardId = dr["refererCardId"].ToString(); //推荐人卡号
tbClient.remark = dr["remark"].ToString(); //备注说明
return(tbClient);
}
/// <summary>
/// 加载指定客户信息
/// <param name="clientId">客户编号</param>
/// </summary>
public void Load(long clientId)
{
try
{
TBClient tbClient = tbClientDAO.Get(clientId);
WebJson.ToJson(context, tbClient);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 修改客户信息
/// <param name="tbClient">客户信息</param>
/// </summary>
public void Edit(TBClient tbClient)
{
try
{
tbClientDAO.Edit(tbClient);
Message.success(context, "客户信息修改成功");
loginSession.Log("XXXXXX客户信息修改成功");
}
catch (Exception e)
{
Message.error(context, "客户信息修改失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 增加客户信息
/// </summary>
/// <param name="tbClient">客户信息</param>
public virtual void Add(TBClient tbClient)
{
try
{
db.Open();
Add(db, tbClient);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 修改客户信息
/// <param name="tbClient">客户信息</param>
/// </summary>
public void Edit(TBClient tbClient)
{
try
{
db.Open();
Edit(db, tbClient);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
private void buscar_client()
{
String userName = null;
userName = bd.resultatComanda("Select nom from clients where " + CcomboBox.Text + " = " + TBClient.Text);
userName += " " + bd.resultatComanda("Select cognom1 from clients where " + CcomboBox.Text + " = " + TBClient.Text);
if (userName == null || userName == "" || userName == " ")
{
MessageBox.Show("Client incorrecte");
TBClient.Text = "";
TBClient.Focus();
}
else
{
mostrarTicket(userName);
}
}
