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