/// <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); } }