/// <summary>
/// 读取推荐人佣金结算信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>推荐人佣金结算对象</returns>
protected virtual TTClientRecharge4 ReadData(ComDataReader dr)
{
TTClientRecharge4 ttClientRecharge4 = new TTClientRecharge4();
ttClientRecharge4.Column_1 = dr["Column_1"].ToString();//Column_1
return(ttClientRecharge4);
}
/// <summary>
/// 获取推荐人佣金结算
/// <param name="Column_1">Column_1</param>
/// </summary>
/// <returns>推荐人佣金结算对象</returns>
public virtual TTClientRecharge4 Get(string Column_1)
{
TTClientRecharge4 ttClientRecharge4 = null;
try
{
string strSQL = "select * from TTClientRecharge4 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())
{
ttClientRecharge4 = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttClientRecharge4);
}
/// <summary>
/// 修改推荐人佣金结算
/// <param name="data">数据库连接</param>
/// <param name="ttClientRecharge4">推荐人佣金结算</param>
/// </summary>
public virtual void Edit(DataAccess data, TTClientRecharge4 ttClientRecharge4)
{
string strSQL = "update TTClientRecharge4 set where Column_1=@Column_1";
Param param = new Param();
param.Clear();
param.Add("@Column_1", ttClientRecharge4.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="ttClientRecharge4">推荐人佣金结算</param>
/// </summary>
public virtual void Add(DataAccess data, TTClientRecharge4 ttClientRecharge4)
{
string strSQL = "insert into TTClientRecharge4 (Column_1) values (@Column_1)";
Param param = new Param();
param.Clear();
param.Add("@Column_1", ttClientRecharge4.Column_1);//Column_1
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改推荐人佣金结算
/// <param name="ttClientRecharge4">推荐人佣金结算</param>
/// </summary>
public virtual void Edit(TTClientRecharge4 ttClientRecharge4)
{
try
{
db.Open();
Edit(db, ttClientRecharge4);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
