/// <summary>
/// 获取客户账户交易
/// </summary>
/// <param name="tradeId">交易流水</param>
/// <returns>客户账户交易对象</returns>
public virtual TTClientTrade Get(string tradeId)
{
TTClientTrade ttClientTrade = null;
try
{
string strSQL = "select * from TTClientTrade where tradeId=@tradeId";
Param param = new Param();
param.Clear();
param.Add("@tradeId", tradeId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttClientTrade = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttClientTrade);
}
/// <summary>
/// 加载指定客户账户交易
/// </summary>
/// <param name="tradeId">交易流水</param>
public void Load(string tradeId)
{
try
{
TTClientTrade ttClientTrade = ttClientTradeDAO.Get(tradeId);
WebJson.ToJson(context, ttClientTrade);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 修改客户账户交易
/// </summary>
/// <param name="ttClientTrade">客户账户交易</param>
public void Edit(TTClientTrade ttClientTrade)
{
try
{
ttClientTradeDAO.Edit(ttClientTrade);
Message.success(context, "客户账户交易修改成功");
loginSession.Log("XXXXXX客户账户交易修改成功");
}
catch (Exception e)
{
Message.error(context, "客户账户交易修改失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 修改客户账户交易
/// </summary>
/// <param name="ttClientTrade">客户账户交易</param>
public virtual void Edit(TTClientTrade ttClientTrade)
{
try
{
db.Open();
Edit(db, ttClientTrade);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 修改客户账户交易
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="ttClientTrade">客户账户交易</param>
public virtual void Edit(DataAccess data, TTClientTrade ttClientTrade)
{
string strSQL = "update TTClientTrade set cardId=@cardId,clientId=@clientId,clientName=@clientName,agentId=@agentId,siteId=@siteId,tradeType=@tradeType,fee=@fee,remark=@remark,changeTime=@changeTime,createTime=To_date(@createTime,'yyyy-mm-dd hh24:mi:ss') where tradeId=@tradeId";
Param param = new Param();
param.Clear();
param.Add("@cardId", ttClientTrade.cardId); //卡号
param.Add("@clientId", ttClientTrade.clientId); //客户编号
param.Add("@clientName", ttClientTrade.clientName); //客户名称
param.Add("@agentId", ttClientTrade.agentId); //代理商编号
param.Add("@siteId", ttClientTrade.siteId); //门店编号
param.Add("@tradeType", ttClientTrade.tradeType); //交易类型
param.Add("@fee", ttClientTrade.fee); //发生金额
param.Add("@remark", ttClientTrade.remark); //信息摘要
param.Add("@changeTime", ttClientTrade.changeTime); //发生时间
param.Add("@createTime", ttClientTrade.createTime); //创建时间
param.Add("@tradeId", ttClientTrade.tradeId); //交易流水
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加客户账户交易
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="ttClientTrade">客户账户交易</param>
public virtual void Add(DataAccess data, TTClientTrade ttClientTrade)
{
string strSQL = "insert into TTClientTrade (tradeId,cardId,clientId,clientName,agentId,siteId,tradeType,fee,remark,changeTime,createTime) values (@tradeId,@cardId,@clientId,@clientName,@agentId,@siteId,@tradeType,@fee,@remark,@changeTime,To_date(@createTime,'yyyy-mm-dd hh24:mi:ss'))";
Param param = new Param();
param.Clear();
param.Add("@tradeId", ttClientTrade.tradeId); //交易流水
param.Add("@cardId", ttClientTrade.cardId); //卡号
param.Add("@clientId", ttClientTrade.clientId); //客户编号
param.Add("@clientName", ttClientTrade.clientName); //客户名称
param.Add("@agentId", ttClientTrade.agentId); //代理商编号
param.Add("@siteId", ttClientTrade.siteId); //门店编号
param.Add("@tradeType", ttClientTrade.tradeType); //交易类型
param.Add("@fee", ttClientTrade.fee); //发生金额
param.Add("@remark", ttClientTrade.remark); //信息摘要
param.Add("@changeTime", ttClientTrade.changeTime); //发生时间
param.Add("@createTime", ttClientTrade.createTime); //创建时间
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 读取客户账户交易信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>客户账户交易对象</returns>
protected virtual TTClientTrade ReadData(ComDataReader dr)
{
TTClientTrade ttClientTrade = new TTClientTrade();
ttClientTrade.tradeId = dr["tradeId"].ToString(); //交易流水
ttClientTrade.cardId = dr["cardId"].ToString(); //卡号
ttClientTrade.clientId = long.Parse(dr["clientId"].ToString()); //客户编号
ttClientTrade.clientName = dr["clientName"].ToString(); //客户名称
ttClientTrade.agentId = dr["agentId"].ToString(); //代理商编号
ttClientTrade.siteId = dr["siteId"].ToString(); //门店编号
ttClientTrade.tradeType = dr["tradeType"].ToString(); //交易类型
ttClientTrade.fee = double.Parse(dr["fee"].ToString()); //发生金额
ttClientTrade.remark = dr["remark"].ToString(); //信息摘要
ttClientTrade.changeTime = dr["changeTime"].ToString(); //发生时间
if (dr["createTime"] == null)
{
ttClientTrade.createTime = "";//创建时间
}
else
{
ttClientTrade.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]);//创建时间
}
return(ttClientTrade);
}