/// <summary>
/// 获取卡片日志
/// <param name="logId">日志编号</param>
/// </summary>
/// <returns>卡片日志对象</returns>
public TBCardLog Get(long logId)
{
TBCardLog tbCardLog = null;
try
{
string strSQL = "select * from TBCardLog where logId=:logId";
Param param = new Param();
param.Clear();
param.Add(":logId", logId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbCardLog = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbCardLog);
}
/// <summary>
/// 事务处理卡片回收
/// </summary>
/// <param name="tbCardList"></param>
/// <param name="userId"></param>
/// <param name="userName"></param>
public string Recycle(List <TBCard> tbCardList, string userId, string userName)
{
ComTransaction trans = null;
string cardId = "";
db.Open();
foreach (var card in tbCardList)
{
try
{
trans = db.BeginTransaction();
card.status = ((int)CardStatus.StayUsed).ToString();
RecycleEdit(db, card);
TBCardLog tbCardLog = new TBCardLog();
tbCardLog.cardId = card.cardId; //卡号
tbCardLog.operateType = "2"; //操作类型
tbCardLog.summary = "回收[代理商编号:" + card.agentId + ",门店编号:" + card.siteId + "]";
tbCardLog.operateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //操作时间
tbCardLog.operatorId = userId; //操作人编号
tbCardLog.operatorName = userName; //操作人名称
new TBCardLogDAO().Add(db, tbCardLog);
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
cardId = card.cardId;
throw e;
}
}
db.Close();
return(cardId);
}
/// <summary>
/// 修改卡片日志
/// <param name="data">数据库连接</param>
/// <param name="tbCardLog">卡片日志</param>
/// </summary>
public void Edit(DataAccess data, TBCardLog tbCardLog)
{
string strSQL = "update TBCardLog set cardId=:cardId,operateType=:operateType,summary=:summary,operateTime=To_date(:operateTime,'yyyy-mm-dd hh24:mi:ss'),operatorId=:operatorId,operatorName=:operatorName where logId=:logId";
Param param = new Param();
param.Clear();
param.Add(":cardId", tbCardLog.cardId); //卡号
param.Add(":operateType", tbCardLog.operateType); //操作类型
param.Add(":summary", tbCardLog.summary); //操作说明
param.Add(":operateTime", tbCardLog.operateTime); //操作时间
param.Add(":operatorId", tbCardLog.operatorId); //操作人编号
param.Add(":operatorName", tbCardLog.operatorName); //操作人名称
param.Add(":logId", tbCardLog.logId); //日志编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
private DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加卡片日志
/// <param name="data">数据库连接</param>
/// <param name="tbCardLog">卡片日志</param>
/// </summary>
public void Add(DataAccess data, TBCardLog tbCardLog)
{
string strSQL = "insert into TBCardLog (logId,cardId,operateType,summary,operateTime,operatorId,operatorName) values (SCardLog_logId.Nextval,:cardId,:operateType,:summary,To_date(:operateTime,'yyyy-mm-dd hh24:mi:ss'),:operatorId,:operatorName)";
Param param = new Param();
param.Clear();
//param.Add(":logId", tbCardLog.logId);//日志编号
param.Add(":cardId", tbCardLog.cardId); //卡号
param.Add(":operateType", tbCardLog.operateType); //操作类型
param.Add(":summary", tbCardLog.summary); //操作说明
param.Add(":operateTime", tbCardLog.operateTime); //操作时间
param.Add(":operatorId", tbCardLog.operatorId); //操作人编号
param.Add(":operatorName", tbCardLog.operatorName); //操作人名称
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改卡片日志
/// <param name="tbCardLog">卡片日志</param>
/// </summary>
public void Edit(TBCardLog tbCardLog)
{
try
{
db.Open();
Edit(db, tbCardLog);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加卡片日志
/// </summary>
/// <param name="tbCardLog">卡片日志</param>
public virtual void Add(TBCardLog tbCardLog)
{
try
{
db.Open();
Add(db, tbCardLog);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 读取卡片日志信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>卡片日志对象</returns>
private TBCardLog ReadData(ComDataReader dr)
{
TBCardLog tbCardLog = new TBCardLog();
tbCardLog.logId = long.Parse(dr["logId"].ToString()); //日志编号
tbCardLog.cardId = dr["cardId"].ToString(); //卡号
tbCardLog.operateType = dr["operateType"].ToString(); //操作类型
tbCardLog.summary = dr["summary"].ToString(); //操作说明
if (dr["operateTime"] == null)
{
tbCardLog.operateTime = "";//操作时间
}
else
{
tbCardLog.operateTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["operateTime"]); //操作时间
}
tbCardLog.operatorId = dr["operatorId"].ToString(); //操作人编号
tbCardLog.operatorName = dr["operatorName"].ToString(); //操作人名称
return(tbCardLog);
}
/// <summary>
/// 事务处理卡片发放
/// </summary>
/// <param name="tbCardList"></param>
/// <param name="userId"></param>
/// <param name="userName"></param>
public void Grant(List <TBCard> tbCardList, string userId, string userName, string siteId)
{
ComTransaction trans = null;
try
{
db.Open();
trans = db.BeginTransaction();
string agentId = new TBSiteDAO().Get(siteId).agentId;
foreach (var card in tbCardList)
{
card.status = ((int)CardStatus.StayBinding).ToString();
card.agentId = agentId;
card.siteId = siteId;
TBCardLog tbCardLog = new TBCardLog();
tbCardLog.cardId = card.cardId; //卡号
tbCardLog.operateType = "2"; //操作类型
tbCardLog.summary = "发放到[代理商编号:" + agentId + ",门店编号:" + siteId + "]";
tbCardLog.operateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //操作时间
tbCardLog.operatorId = userId; //操作人编号
tbCardLog.operatorName = userName; //操作人名称
Edit(db, card);
new TBCardLogDAO().Add(db, tbCardLog);
}
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
finally
{
db.Close();
}
}
