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