/// <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(); } }