/// <summary>
/// 获取退款明细
/// <param name="Column_1">Column_1</param>
/// </summary>
/// <returns>退款明细对象</returns>
public virtual TTClientRecharge2 Get(string Column_1)
{
TTClientRecharge2 ttClientRecharge2=null;
try
{
string strSQL = "select * from TTClientRecharge2 where Column_1=@Column_1";
Param param = new Param();
param.Clear();
param.Add("@Column_1", Column_1);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttClientRecharge2=ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return ttClientRecharge2;
}
/// <summary>
/// 修改退款明细
/// <param name="data">数据库连接</param>
/// <param name="ttClientRecharge2">退款明细</param>
/// </summary>
public virtual void Edit(DataAccess data,TTClientRecharge2 ttClientRecharge2)
{
string strSQL = "update TTClientRecharge2 set where Column_1=@Column_1";
Param param = new Param();
param.Clear();
param.Add("@Column_1", ttClientRecharge2.Column_1);//Column_1
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加退款明细
/// <param name="data">数据库连接</param>
/// <param name="ttClientRecharge2">退款明细</param>
/// </summary>
public virtual void Add(DataAccess data,TTClientRecharge2 ttClientRecharge2)
{
string strSQL = "insert into TTClientRecharge2 (Column_1) values (@Column_1)";
Param param = new Param();
param.Clear();
param.Add("@Column_1", ttClientRecharge2.Column_1);//Column_1
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改退款明细
/// <param name="ttClientRecharge2">退款明细</param>
/// </summary>
public virtual void Edit(TTClientRecharge2 ttClientRecharge2)
{
try
{
db.Open();
Edit(db,ttClientRecharge2);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 读取退款明细信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>退款明细对象</returns>
protected virtual TTClientRecharge2 ReadData(ComDataReader dr)
{
TTClientRecharge2 ttClientRecharge2= new TTClientRecharge2();
ttClientRecharge2.Column_1= dr["Column_1"].ToString();//Column_1
return ttClientRecharge2;
}
