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