/// <summary>
/// 获取卡片
/// <param name="cardId">卡号</param>
/// </summary>
/// <returns>卡片对象</returns>
public TBCard Get(string cardId)
{
TBCard tbCard = null;
try
{
string strSQL = "select * from TBCard where cardId=:cardId";
Param param = new Param();
param.Clear();
param.Add(":cardId", cardId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbCard = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbCard);
}
// <summary>
/// 修改卡片
/// <param name="data">数据库连接</param>
/// <param name="tbCard">卡片</param>
/// </summary>
public void RecycleEdit(DataAccess data, TBCard tbCard)
{
string strSQL = "update TBCard set status=@status,agentId='',siteId='' where cardId=@cardId";
Param param = new Param();
param.Clear();
param.Add("@status", tbCard.status); //当前状态
param.Add("@cardId", tbCard.cardId); //卡号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 加载指定卡片
/// <param name="cardId">卡号</param>
/// </summary>
public void Load(string cardId)
{
try
{
TBCard tbCard = tbCardDAO.Get(cardId);
WebJson.ToJson(context, tbCard);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 修改卡片
/// <param name="data">数据库连接</param>
/// <param name="tbCard">卡片</param>
/// </summary>
public void Edit(DataAccess data, TBCard tbCard)
{
string strSQL = "update TBCard set status=:status,agentId=:agentId,siteId=:siteId where cardId=:cardId";
Param param = new Param();
param.Clear();
param.Add(":status", tbCard.status); //当前状态
param.Add(":cardId", tbCard.cardId); //卡号
param.Add(":agentId", tbCard.agentId); //当前状态
param.Add(":siteId", tbCard.siteId); //卡号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改卡片
/// <param name="tbCard">卡片</param>
/// </summary>
public void Edit(TBCard tbCard)
{
try
{
tbCardDAO.Edit(tbCard);
Message.success(context, "卡片操作成功");
loginSession.Log(tbCard.cardId + "卡片操作成功");
}
catch (Exception e)
{
Message.error(context, "卡片操作失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 修改卡片
/// <param name="tbCard">卡片</param>
/// </summary>
public void Edit(TBCard tbCard)
{
try
{
db.Open();
Edit(db, tbCard);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加卡片
/// </summary>
/// <param name="tbCard">卡片</param>
public virtual void Add(TBCard tbCard)
{
try
{
db.Open();
Add(db, tbCard);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加卡片
/// <param name="data">数据库连接</param>
/// <param name="tbCard">卡片</param>
/// </summary>
public void Add(DataAccess data, TBCard tbCard)
{
string strSQL = "insert into TBCard (cardId,chipId,cardType,status,validateData,supplierDate,supplierCode,supplierBatch,siteId,agentId) values (:cardId,:chipId,:cardType,:status,:validateData,To_date(:supplierDate,'yyyy-mm-dd hh24:mi:ss'),:supplierCode,:supplierBatch,:siteId,:agentId)";
Param param = new Param();
param.Clear();
param.Add(":cardId", tbCard.cardId); //卡号
param.Add(":chipId", tbCard.chipId); //芯片序号
param.Add(":cardType", tbCard.cardType); //卡类型
param.Add(":status", tbCard.status); //当前状态
param.Add(":validateData", tbCard.validateData); //验证数据
param.Add(":supplierDate", tbCard.supplierDate); //出厂时间
param.Add(":supplierCode", tbCard.supplierCode); //厂家代码
param.Add(":supplierBatch", tbCard.supplierBatch); //厂家批次号
param.Add(":siteId", tbCard.siteId); //门店编号
param.Add(":agentId", tbCard.agentId); //代理商编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改卡片
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbCard">卡片</param>
public virtual void Edit(DataAccess data, TBCard tbCard)
{
string strSQL = "update TBCard set chipId=@chipId,cardType=@cardType,status=@status,validateData=@validateData,supplierDate=@supplierDate,supplierCode=@supplierCode,supplierBatch=@supplierBatch,siteId=@siteId,agentId=@agentId,createDate=To_date(@createDate,'yyyy-mm-dd hh24:mi:ss') where cardId=@cardId";
Param param = new Param();
param.Clear();
param.Add("@chipId", tbCard.chipId); //芯片序号
param.Add("@cardType", tbCard.cardType); //卡类型
param.Add("@status", tbCard.status); //当前状态
param.Add("@validateData", tbCard.validateData); //验证数据
param.Add("@supplierDate", tbCard.supplierDate); //出厂日期
param.Add("@supplierCode", tbCard.supplierCode); //厂家代码
param.Add("@supplierBatch", tbCard.supplierBatch); //厂家批次号
param.Add("@siteId", tbCard.siteId); //门店编号
param.Add("@agentId", tbCard.agentId); //代理商编号
param.Add("@createDate", tbCard.createDate); //创建时间
param.Add("@cardId", tbCard.cardId); //卡号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加卡片
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbCard">卡片</param>
public virtual void Add(DataAccess data, TBCard tbCard)
{
string strSQL = "insert into TBCard (cardId,chipId,cardType,status,validateData,supplierDate,supplierCode,supplierBatch,siteId,agentId,createDate) values (@cardId,@chipId,@cardType,@status,@validateData,@supplierDate,@supplierCode,@supplierBatch,@siteId,@agentId,To_date(@createDate,'yyyy-mm-dd hh24:mi:ss'))";
Param param = new Param();
param.Clear();
param.Add("@cardId", tbCard.cardId); //卡号
param.Add("@chipId", tbCard.chipId); //芯片序号
param.Add("@cardType", tbCard.cardType); //卡类型
param.Add("@status", tbCard.status); //当前状态
param.Add("@validateData", tbCard.validateData); //验证数据
param.Add("@supplierDate", tbCard.supplierDate); //出厂日期
param.Add("@supplierCode", tbCard.supplierCode); //厂家代码
param.Add("@supplierBatch", tbCard.supplierBatch); //厂家批次号
param.Add("@siteId", tbCard.siteId); //门店编号
param.Add("@agentId", tbCard.agentId); //代理商编号
param.Add("@createDate", tbCard.createDate); //创建时间
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 读取卡片信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>卡片对象</returns>
private TBCard ReadData(ComDataReader dr)
{
TBCard tbCard = new TBCard();
tbCard.cardId = dr["cardId"].ToString(); //卡号
tbCard.chipId = dr["chipId"].ToString(); //芯片序号
tbCard.cardType = dr["cardType"].ToString(); //卡类型
tbCard.status = dr["status"].ToString(); //当前状态
tbCard.validateData = dr["validateData"].ToString(); //验证数据
if (dr["supplierDate"] == null)
{
tbCard.supplierDate = "";//出厂时间
}
else
{
tbCard.supplierDate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["supplierDate"]); //出厂时间
}
tbCard.supplierCode = dr["supplierCode"].ToString(); //厂家代码
tbCard.supplierBatch = dr["supplierBatch"].ToString(); //厂家批次号
tbCard.siteId = dr["siteId"].ToString(); //门店编号
tbCard.agentId = dr["agentId"].ToString(); //代理商编号
return(tbCard);
}
