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