/// <summary>
/// 获取终端日志
/// <param name="logId">日志编号</param>
/// </summary>
/// <returns>终端日志对象</returns>
public TBTerminalLog Get(long logId)
{
TBTerminalLog tbTerminalLog = null;
try
{
string strSQL = "select * from TBTerminalLog 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())
{
tbTerminalLog = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbTerminalLog);
}
/// <summary>
/// 事务处理终端回收
/// </summary>
/// <param name="tbTBTerminalList"></param>
/// <param name="userId"></param>
/// <param name="userName"></param>
public void Recycle(List <TBTerminal> tbTBTerminalList, string userId, string userName)
{
ComTransaction trans = null;
try
{
db.Open();
trans = db.BeginTransaction();
foreach (var terminal in tbTBTerminalList)
{
terminal.status = ((int)TerminalStatus.InStore).ToString();
RecycleEdit(db, terminal);
TBTerminalLog tbTerminalLog = new TBTerminalLog();
tbTerminalLog.terminalId = terminal.terminalId; //终端号
tbTerminalLog.operateType = "1"; //操作类型
tbTerminalLog.summary = "回收[代理商编号:" + terminal.agentId + ",门店编号:" + terminal.siteId + "]";
tbTerminalLog.operateTime = DateTime.Now.ToString(); //操作时间
tbTerminalLog.operatorId = userId; //操作人编号
tbTerminalLog.operatorName = userName; //操作人名称
new TBTerminalLogDAO().Add(db, tbTerminalLog);
}
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 加载指定终端日志
/// <param name="logId">日志编号</param>
/// </summary>
public void Load(long logId)
{
try
{
TBTerminalLog tbTerminalLog = tbTerminalLogDAO.Get(logId);
WebJson.ToJson(context, tbTerminalLog);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 增加终端日志
/// <param name="tbTerminalLog">终端日志</param>
/// </summary>
public void Add(TBTerminalLog tbTerminalLog)
{
try
{
tbTerminalLogDAO.Add(tbTerminalLog);
Message.success(context, "终端日志增加成功");
loginSession.Log("XXXXXX终端日志增加成功");
}
catch (Exception e)
{
Message.error(context, "终端日志增加失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 修改终端日志
/// <param name="data">数据库连接</param>
/// <param name="tbTerminalLog">终端日志</param>
/// </summary>
public void Edit(DataAccess data, TBTerminalLog tbTerminalLog)
{
string strSQL = "update TBTerminalLog set terminalId=:terminalId,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(":terminalId", tbTerminalLog.terminalId); //终端编号
param.Add(":operateType", tbTerminalLog.operateType); //操作类型
param.Add(":summary", tbTerminalLog.summary); //操作说明
param.Add(":operateTime", tbTerminalLog.operateTime); //操作时间
param.Add(":operatorId", tbTerminalLog.operatorId); //操作人编号
param.Add(":operatorName", tbTerminalLog.operatorName); //操作人名称
param.Add(":logId", tbTerminalLog.logId); //日志编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
private DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加终端日志
/// <param name="data">数据库连接</param>
/// <param name="tbTerminalLog">终端日志</param>
/// </summary>
public void Add(DataAccess data, TBTerminalLog tbTerminalLog)
{
string strSQL = "insert into TBTerminalLog (logId,terminalId,operateType,summary,operateTime,operatorId,operatorName) values (STerminalLog_logId.Nextval,:terminalId,:operateType,:summary,To_date(:operateTime,'yyyy-mm-dd hh24:mi:ss'),:operatorId,:operatorName)";
Param param = new Param();
param.Clear();
//param.Add(":logId", tbTerminalLog.logId);//日志编号
param.Add(":terminalId", tbTerminalLog.terminalId); //终端编号
param.Add(":operateType", tbTerminalLog.operateType); //操作类型
param.Add(":summary", tbTerminalLog.summary); //操作说明
param.Add(":operateTime", tbTerminalLog.operateTime); //操作时间
param.Add(":operatorId", tbTerminalLog.operatorId); //操作人编号
param.Add(":operatorName", tbTerminalLog.operatorName); //操作人名称
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改终端日志
/// <param name="tbTerminalLog">终端日志</param>
/// </summary>
public void Edit(TBTerminalLog tbTerminalLog)
{
try
{
db.Open();
Edit(db, tbTerminalLog);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加终端日志
/// </summary>
/// <param name="tbTerminalLog">终端日志</param>
public virtual void Add(TBTerminalLog tbTerminalLog)
{
try
{
db.Open();
Add(db, tbTerminalLog);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 读取终端日志信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>终端日志对象</returns>
private TBTerminalLog ReadData(ComDataReader dr)
{
TBTerminalLog tbTerminalLog = new TBTerminalLog();
tbTerminalLog.logId = long.Parse(dr["logId"].ToString()); //日志编号
tbTerminalLog.terminalId = dr["terminalId"].ToString(); //终端编号
tbTerminalLog.operateType = dr["operateType"].ToString(); //操作类型
tbTerminalLog.summary = dr["summary"].ToString(); //操作说明
if (dr["operateTime"] == null)
{
tbTerminalLog.operateTime = "";//操作时间
}
else
{
tbTerminalLog.operateTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["operateTime"]); //操作时间
}
tbTerminalLog.operatorId = dr["operatorId"].ToString(); //操作人编号
tbTerminalLog.operatorName = dr["operatorName"].ToString(); //操作人名称
return(tbTerminalLog);
}
