/// <summary>
/// 获取最大值表
/// </summary>
/// <param name="tabName">表名</param>
/// <returns>最大值表对象</returns>
public virtual TSMax Get(string tabName)
{
TSMax tsMax = null;
try
{
string strSQL = "select * from TSMax where tabName=@tabName";
Param param = new Param();
param.Clear();
param.Add("@tabName", tabName);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsMax = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsMax);
}
/// <summary>
/// 读取最大值表信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>最大值表对象</returns>
protected virtual TSMax ReadData(ComDataReader dr)
{
TSMax tsMax = new TSMax();
tsMax.tabName = dr["tabName"].ToString(); //表名
tsMax.codex = dr["codex"].ToString(); //规则
tsMax.userValue = long.Parse(dr["userValue"].ToString()); //流水值
tsMax.remark = dr["remark"].ToString(); //备注
return(tsMax);
}
/// <summary>
/// 修改最大值表
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tsMax">最大值表</param>
public virtual void Edit(DataAccess data, TSMax tsMax)
{
string strSQL = "update TSMax set codex=@codex,userValue=@userValue,remark=@remark where tabName=@tabName";
Param param = new Param();
param.Clear();
param.Add("@codex", tsMax.codex); //规则
param.Add("@userValue", tsMax.userValue); //流水值
param.Add("@remark", tsMax.remark); //备注
param.Add("@tabName", tsMax.tabName); //表名
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加最大值表
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tsMax">最大值表</param>
public virtual void Add(DataAccess data, TSMax tsMax)
{
string strSQL = "insert into TSMax (tabName,codex,userValue,remark) values (@tabName,@codex,@userValue,@remark)";
Param param = new Param();
param.Clear();
param.Add("@tabName", tsMax.tabName); //表名
param.Add("@codex", tsMax.codex); //规则
param.Add("@userValue", tsMax.userValue); //流水值
param.Add("@remark", tsMax.remark); //备注
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 加载指定最大值表
/// <param name="tabName">表名</param>
/// </summary>
public void Load(string tabName)
{
try
{
TSMax tsMax = tsMaxDAO.Get(tabName);
WebJson.ToJson(context, tsMax);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 修改最大值表
/// <param name="tsMax">最大值表</param>
/// </summary>
public void Edit(TSMax tsMax)
{
try
{
tsMaxDAO.Edit(tsMax);
Message.success(context, "最大值表修改成功");
loginSession.Log("XXXXXX最大值表修改成功");
}
catch (Exception e)
{
Message.error(context, "最大值表修改失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 修改最大值表
/// </summary>
/// <param name="tsMax">最大值表</param>
public virtual void Edit(TSMax tsMax)
{
try
{
db.Open();
Edit(db, tsMax);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加最大值表
/// <param name="tsMax">最大值表</param>
/// </summary>
public void Add(TSMax tsMax)
{
try
{
db.Open();
Add(db, tsMax);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
