/// <summary>
/// 读取终端信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>终端对象</returns>
protected virtual TBTerminal ReadData(ComDataReader dr)
{
TBTerminal tbTerminal = new TBTerminal();
tbTerminal.terminalId = dr["terminalId"].ToString(); //终端编号
tbTerminal.status = dr["status"].ToString(); //当前状态
tbTerminal.terminalType = dr["terminalType"].ToString(); //终端类型
if (dr["supplierDate"] == null)
{
tbTerminal.supplierDate = "";//出厂时间
}
else
{
tbTerminal.supplierDate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["supplierDate"]); //出厂时间
}
tbTerminal.supplierCode = dr["supplierCode"].ToString(); //厂家代码
tbTerminal.supplierBatch = dr["supplierBatch"].ToString(); //厂家批次号
tbTerminal.siteId = dr["siteId"].ToString(); //门店编号
tbTerminal.agentId = dr["agentId"].ToString(); //代理商编号
if (dr["checkTime"] == null)
{
tbTerminal.checkTime = "";//最新心跳时间
}
else
{
tbTerminal.checkTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["checkTime"]); //最新心跳时间
}
tbTerminal.touchscreenVersion = dr["touchscreenVersion"].ToString(); //触屏版本
tbTerminal.updateStatus = dr["updateStatus"].ToString(); //更新状态
return(tbTerminal);
}
/// <summary>
/// 获取终端
/// <param name="terminalId">终端编号</param>
/// </summary>
/// <returns>终端对象</returns>
public TBTerminal Get(string terminalId)
{
TBTerminal tbTerminal = null;
try
{
string strSQL = "select * from TBTerminal where terminalId=:terminalId";
Param param = new Param();
param.Clear();
param.Add(":terminalId", terminalId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbTerminal = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbTerminal);
}
public void ProcessRequest(HttpContext context)
{
try
{
LoginUser loginUser = new LoginUser(context, "TerminalStore");
TerminalBLL bll = new TerminalBLL(context, loginUser);
if (!loginUser.Pass)//权限验证
{
return;
}
//增加
if (context.Request["action"] == "add")
{
TBTerminal tbTerminal = new TBTerminal();
tbTerminal.terminalId = context.Request["terminalId"]; //终端编号
tbTerminal.status = ((int)TerminalStatus.InStore).ToString(); //当前状态
tbTerminal.terminalType = context.Request["terminalType"]; //终端类型
tbTerminal.supplierDate = context.Request["supplierDate"]; //出厂时间
tbTerminal.supplierCode = context.Request["supplierCode"]; //厂家代码
tbTerminal.supplierBatch = context.Request["supplierBatch"]; //厂家批次号
bll.Add(tbTerminal);
return;
}
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 修改终端
/// <param name="data">数据库连接</param>
/// <param name="tbTerminal">终端</param>
/// </summary>
public void RecycleEdit(DataAccess data, TBTerminal tbTerminal)
{
string strSQL = "update TBTerminal set status=@status,siteId='',agentId='' where terminalId=@terminalId";
Param param = new Param();
param.Clear();
param.Add("@status", tbTerminal.status); //当前状态
param.Add("@terminalId", tbTerminal.terminalId); //终端编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改终端
/// <param name="data">数据库连接</param>
/// <param name="tbTerminal">终端</param>
/// </summary>
public void Edit(DataAccess data, TBTerminal tbTerminal)
{
string strSQL = "update TBTerminal set status=:status,siteId=:siteId,agentId=:agentId where terminalId=:terminalId";
Param param = new Param();
param.Clear();
param.Add(":status", tbTerminal.status); //当前状态
param.Add(":siteId", tbTerminal.siteId); //门店编号
param.Add(":agentId", tbTerminal.agentId); //代理商编号
param.Add(":terminalId", tbTerminal.terminalId); //终端编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 加载指定终端
/// <param name="terminalId">终端编号</param>
/// </summary>
public void Load(string terminalId)
{
try
{
TBTerminal tbTerminal = tbTerminalDAO.Get(terminalId);
tbTerminal.updateStatus = "1".Equals(tbTerminal.updateStatus) ? "on" : "off";
WebJson.ToJson(context, tbTerminal);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 增加终端
/// <param name="data">数据库连接</param>
/// <param name="tbTerminal">终端</param>
/// </summary>
public void Add(DataAccess data, TBTerminal tbTerminal)
{
string strSQL = "insert into TBTerminal (terminalId,status,terminalType,supplierDate,supplierCode,supplierBatch) values (:terminalId,:status,:terminalType,To_date(:supplierDate,'yyyy-mm-dd hh24:mi:ss'),:supplierCode,:supplierBatch)";
Param param = new Param();
param.Clear();
param.Add(":terminalId", tbTerminal.terminalId); //终端编号
param.Add(":status", tbTerminal.status); //当前状态
param.Add(":terminalType", tbTerminal.terminalType); //终端类型
param.Add(":supplierDate", tbTerminal.supplierDate); //出厂时间
param.Add(":supplierCode", tbTerminal.supplierCode); //厂家代码
param.Add(":supplierBatch", tbTerminal.supplierBatch); //厂家批次号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改终端
/// <param name="tbTerminal">终端</param>
/// </summary>
public void Maintence(TBTerminal tbTerminal)
{
try
{
tbTerminalDAO.Maintence(tbTerminal);
Message.success(context, "终端操作成功");
loginSession.Log(tbTerminal.terminalId + "终端操作成功");
}
catch (Exception e)
{
Message.error(context, "终端操作失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 修改更新状态
/// <param name="tbTerminal">终端</param>
/// </summary>
public void EditUpdateStatus(TBTerminal tbTerminal)
{
try
{
tbTerminal.updateStatus = tbTerminal.updateStatus == null ? "0" : "1";
tbTerminalDAO.EditUpdateStatus(tbTerminal);
Message.success(context, "终端操作成功");
loginSession.Log(tbTerminal.terminalId + "终端操作成功");
}
catch (Exception e)
{
Message.error(context, "终端操作失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 增加终端
/// </summary>
/// <param name="tbTerminal">终端</param>
public virtual void Add(TBTerminal tbTerminal)
{
try
{
db.Open();
Add(db, tbTerminal);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 修改终端
/// <param name="tbTerminal">终端</param>
/// </summary>
public void Edit(TBTerminal tbTerminal)
{
try
{
db.Open();
Edit(db, tbTerminal);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加终端
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbTerminal">终端</param>
public virtual void Add(DataAccess data, TBTerminal tbTerminal)
{
string strSQL = "insert into TBTerminal (terminalId,status,terminalType,supplierDate,supplierCode,supplierBatch,siteId,agentId,checkTime,touchscreenVersion,updateStatus) values (@terminalId,@status,@terminalType,To_date(@supplierDate,'yyyy-mm-dd hh24:mi:ss'),@supplierCode,@supplierBatch,@siteId,@agentId,To_date(@checkTime,'yyyy-mm-dd hh24:mi:ss'),@touchscreenVersion,@updateStatus)";
Param param = new Param();
param.Clear();
param.Add("@terminalId", tbTerminal.terminalId); //终端编号
param.Add("@status", tbTerminal.status); //当前状态
param.Add("@terminalType", tbTerminal.terminalType); //终端类型
param.Add("@supplierDate", tbTerminal.supplierDate); //出厂时间
param.Add("@supplierCode", tbTerminal.supplierCode); //厂家代码
param.Add("@supplierBatch", tbTerminal.supplierBatch); //厂家批次号
param.Add("@siteId", tbTerminal.siteId); //门店编号
param.Add("@agentId", tbTerminal.agentId); //代理商编号
param.Add("@checkTime", tbTerminal.checkTime); //最新心跳时间
param.Add("@touchscreenVersion", tbTerminal.touchscreenVersion); //触屏版本
param.Add("@updateStatus", tbTerminal.updateStatus); //更新状态
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改终端
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbTerminal">终端</param>
public virtual void Edit(DataAccess data, TBTerminal tbTerminal)
{
string strSQL = "update TBTerminal set status=@status,terminalType=@terminalType,supplierDate=To_date(@supplierDate,'yyyy-mm-dd hh24:mi:ss'),supplierCode=@supplierCode,supplierBatch=@supplierBatch,siteId=@siteId,agentId=@agentId,checkTime=To_date(@checkTime,'yyyy-mm-dd hh24:mi:ss'),touchscreenVersion=@touchscreenVersion,updateStatus=@updateStatus where terminalId=@terminalId";
Param param = new Param();
param.Clear();
param.Add("@status", tbTerminal.status); //当前状态
param.Add("@terminalType", tbTerminal.terminalType); //终端类型
param.Add("@supplierDate", tbTerminal.supplierDate); //出厂时间
param.Add("@supplierCode", tbTerminal.supplierCode); //厂家代码
param.Add("@supplierBatch", tbTerminal.supplierBatch); //厂家批次号
param.Add("@siteId", tbTerminal.siteId); //门店编号
param.Add("@agentId", tbTerminal.agentId); //代理商编号
param.Add("@checkTime", tbTerminal.checkTime); //最新心跳时间
param.Add("@touchscreenVersion", tbTerminal.touchscreenVersion); //触屏版本
param.Add("@updateStatus", tbTerminal.updateStatus); //更新状态
param.Add("@terminalId", tbTerminal.terminalId); //终端编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 增加终端
/// <param name="tbTerminal">终端</param>
/// </summary>
public void Add(TBTerminal tbTerminal)
{
//判断是否帐号重复
if (tbTerminalDAO.Exist("terminalId", tbTerminal.terminalId))
{
Message.error(context, "终端号重复请重新输入！");
return;
}
try
{
tbTerminalDAO.Add(tbTerminal);
Message.success(context, "终端入库成功");
loginSession.Log(tbTerminal.terminalId + "终端入库成功");
}
catch (Exception e)
{
Message.error(context, "终端入库失败");
loginSession.Log(e.Message);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
LoginUser loginUser = new LoginUser(context, "TerminalStore");
TerminalBLL bll = new TerminalBLL(context, loginUser);
if (!loginUser.Pass)//权限验证
{
return;
}
//加载DataGrid
if (context.Request["action"] == "gridLoad")
{
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
string terminalId = context.Request["terminalId"];
string status = context.Request["status"];
string supplierCode = context.Request["supplierCode"];
string supplierBatch = context.Request["supplierBatch"];
bll.LoadGrid(page, rows, terminalId, "0", supplierCode, supplierBatch, "", "");
return;
}
//增加
if (context.Request["action"] == "add")
{
TBTerminal tbTerminal = new TBTerminal();
tbTerminal.terminalId = context.Request["terminalId"]; //终端编号
tbTerminal.status = ((int)TerminalStatus.InStore).ToString(); //当前状态
tbTerminal.terminalType = context.Request["terminalType"]; //终端类型
tbTerminal.supplierDate = context.Request["supplierDate"]; //出厂时间
tbTerminal.supplierCode = context.Request["supplierCode"]; //厂家代码
tbTerminal.supplierBatch = context.Request["supplierBatch"]; //厂家批次号
bll.Add(tbTerminal);
return;
}
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 读取终端信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>终端对象</returns>
private TBTerminal ReadData(ComDataReader dr)
{
TBTerminal tbTerminal = new TBTerminal();
tbTerminal.terminalId = dr["terminalId"].ToString(); //终端编号
tbTerminal.status = dr["status"].ToString(); //当前状态
tbTerminal.terminalType = dr["terminalType"].ToString(); //终端类型
if (dr["supplierDate"] == null)
{
tbTerminal.supplierDate = "";//出厂时间
}
else
{
tbTerminal.supplierDate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["supplierDate"]); //出厂时间
}
tbTerminal.supplierCode = dr["supplierCode"].ToString(); //厂家代码
tbTerminal.supplierBatch = dr["supplierBatch"].ToString(); //厂家批次号
tbTerminal.siteId = dr["siteId"].ToString(); //门店编号
tbTerminal.agentId = dr["agentId"].ToString(); //代理商编号
return(tbTerminal);
}
/// <summary>
/// 终端更新状态
/// <param name="tbTerminal">终端</param>
/// </summary>
public void EditUpdateStatus(TBTerminal tbTerminal)
{
try
{
db.Open();
string strSQL = "update TBTerminal set updateStatus=@updateStatus where terminalId=@terminalId";
Param param = new Param();
param.Clear();
param.Add("@updateStatus", tbTerminal.updateStatus); //更新状态
param.Add("@terminalId", tbTerminal.terminalId); //终端编号
db.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
public void ProcessRequest(HttpContext context)
{
try
{
LoginUser loginUser = new LoginUser(context, "TerminalSearch");
TerminalBLL bll = new TerminalBLL(context, loginUser);
if (!loginUser.Pass)//权限验证
{
return;
}
//加载DataGrid
if (context.Request["action"] == "gridLoad")
{
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
string terminalId = context.Request["terminalId"];
string status = context.Request["status"];
string supplierCode = context.Request["supplierCode"];
string supplierBatch = context.Request["supplierBatch"];
bll.LoadGrid(page, rows, terminalId, status, supplierCode, supplierBatch);
return;
}
if (context.Request["action"] == "ddlSiteListLoad")
{
bll.SiteCombobox();
return;
}
if (context.Request["action"] == "ddlStatusListLoad")
{
bll.TerminalStatusCombobox();
return;
}
//加载信息
if (context.Request["action"] == "load")
{
string terminalId = context.Request["terminalId"];//终端编号
bll.Load(terminalId);
return;
}
//增加
if (context.Request["action"] == "add")
{
TBTerminal tbTerminal = new TBTerminal();
tbTerminal.terminalId = context.Request["terminalId"]; //终端编号
tbTerminal.status = ((int)TerminalStatus.InStore).ToString(); //当前状态
tbTerminal.terminalType = context.Request["terminalType"]; //终端类型
tbTerminal.supplierDate = context.Request["supplierDate"]; //出厂时间
tbTerminal.supplierCode = context.Request["supplierCode"]; //厂家代码
tbTerminal.supplierBatch = context.Request["supplierBatch"]; //厂家批次号
bll.Add(tbTerminal);
return;
}
//发放
if (context.Request["action"] == "grent")
{
string siteId = context.Request["siteId"]; //快开厅编号
string startTerminalId = context.Request["startTerminalId"]; //起始终端号
string endTerminalId = context.Request["endTerminalId"]; //结束终端号
int terminalNum = int.Parse(context.Request["terminalNum"]); //终端数量
bll.Grant(siteId, startTerminalId, endTerminalId, terminalNum);
return;
}
//修改
if (context.Request["action"] == "edit")
{
TBTerminal tbTerminal = new TBTerminal();
tbTerminal.terminalId = context.Request["terminalId"]; //终端编号
tbTerminal.status = context.Request["status"]; //当前状态
tbTerminal.terminalType = context.Request["terminalType"]; //终端类型
tbTerminal.supplierDate = context.Request["supplierDate"]; //出厂时间
tbTerminal.supplierCode = context.Request["supplierCode"]; //厂家代码
tbTerminal.supplierBatch = context.Request["supplierBatch"]; //厂家批次号
tbTerminal.siteId = context.Request["siteId"]; //门店编号
tbTerminal.agentId = context.Request["agentId"]; //代理商编号
bll.Edit(tbTerminal);
return;
}
//删除
if (context.Request["action"] == "delete")
{
string terminalId = context.Request["terminalId"];//终端编号
bll.Delete(terminalId);
return;
}
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
LoginUser loginUser = new LoginUser(context, "TerminalSearch");
TerminalBLL bll = new TerminalBLL(context, loginUser);
if (!loginUser.Pass)//权限验证
{
return;
}
//加载DataGrid
if (context.Request["action"] == "gridLoad")
{
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
string siteId = context.Request["siteId"];
string terminalId = context.Request["terminalId"];
string status = context.Request["status"];
string supplierCode = context.Request["supplierCode"];
string supplierBatch = context.Request["supplierBatch"];
bll.LoadGrid(page, rows, terminalId, status, supplierCode, supplierBatch, "", siteId);
return;
}
if (context.Request["action"] == "ddlSiteListLoad")
{
Combobox com = new Combobox(context, loginUser);
com.SiteAllCombobox();
}
if (context.Request["action"] == "ddlStatusListLoad")
{
Combobox com = new Combobox(context, loginUser);
com.TerminalStatusCombobox();
}
//加载信息
if (context.Request["action"] == "load")
{
string terminalId = context.Request["terminalId"];//终端编号
bll.Load(terminalId);
return;
}
//回收
if (context.Request["action"] == "recycle")
{
string startTerminalId = context.Request["startTerminalId"]; //起始终端号
string endTerminalId = context.Request["endTerminalId"]; //结束终端号
int terminalNum = int.Parse(context.Request["terminalNum"]); //终端数量
bll.Recycle(startTerminalId, endTerminalId, terminalNum);
return;
}
//修改
if (context.Request["action"] == "edit")
{
TBTerminal tbTerminal = new TBTerminal();
tbTerminal.terminalId = context.Request["terminalId"]; //终端编号
tbTerminal.status = (int.Parse(context.Request["status"])).ToString(); //状态
bll.Maintence(tbTerminal);
return;
}
//修改
if (context.Request["action"] == "updateStatusEdit")
{
TBTerminal tbTerminal = new TBTerminal();
tbTerminal.terminalId = context.Request["terminalId"]; //终端编号
tbTerminal.updateStatus = context.Request["updateStatus"]; //更新状态
bll.EditUpdateStatus(tbTerminal);
return;
}
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
