/// <summary>
/// 获取UKey信息
/// </summary>
/// <param name="uKeyId">加密狗编号</param>
/// <returns>UKey信息对象</returns>
public virtual TBUKey Get(string uKeyId)
{
TBUKey tbUKey = null;
try
{
string strSQL = "select * from TBUKey where uKeyId=@uKeyId";
Param param = new Param();
param.Clear();
param.Add("@uKeyId", uKeyId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbUKey = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbUKey);
}
/// <summary>
/// 回收UKey信息
/// <param name="data">数据库连接</param>
/// <param name="tbUKey">UKey信息</param>
/// </summary>
public void RecycleEdit(DataAccess data, TBUKey tbUKey)
{
string strSQL = "update TBUKey set status=@status,siteId='',agentId='' where uKeyId=@uKeyId ";
Param param = new Param();
param.Clear();
param.Add("@status", tbUKey.status); //当前状态
param.Add("@uKeyId", tbUKey.uKeyId); //加密狗编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改UKey信息
/// <param name="data">数据库连接</param>
/// <param name="tbUKey">UKey信息</param>
/// </summary>
public void Edit(DataAccess data, TBUKey tbUKey)
{
string strSQL = "update TBUKey set status=:status where uKeyId=:uKeyId";
Param param = new Param();
param.Clear();
param.Add(":status", tbUKey.status); //当前状态
param.Add(":uKeyId", tbUKey.uKeyId); //加密狗编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 加载指定UKey信息
/// <param name="uKeyId">加密狗编号</param>
/// </summary>
public void Load(string uKeyId)
{
try
{
TBUKey tbUKey = tbUKeyDAO.Get(uKeyId);
WebJson.ToJson(context, tbUKey);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 读取UKey信息信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>UKey信息对象</returns>
protected virtual TBUKey ReadData(ComDataReader dr)
{
TBUKey tbUKey = new TBUKey();
tbUKey.uKeyId = dr["uKeyId"].ToString(); //加密狗编号
tbUKey.chipId = dr["chipId"].ToString(); //内置编号
tbUKey.data = dr["data"].ToString(); //加密数据
tbUKey.status = dr["status"].ToString(); //当前状态
tbUKey.siteId = dr["siteId"].ToString(); //门店编号
tbUKey.agentId = dr["agentId"].ToString(); //代理商编号
return(tbUKey);
}
/// <summary>
/// 修改UKey信息
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbUKey">UKey信息</param>
public virtual void Edit(DataAccess data, TBUKey tbUKey)
{
string strSQL = "update TBUKey set chipId=@chipId,data=@data,status=@status,siteId=@siteId,agentId=@agentId where uKeyId=@uKeyId";
Param param = new Param();
param.Clear();
param.Add("@chipId", tbUKey.chipId); //内置编号
param.Add("@data", tbUKey.data); //加密数据
param.Add("@status", tbUKey.status); //当前状态
param.Add("@siteId", tbUKey.siteId); //门店编号
param.Add("@agentId", tbUKey.agentId); //代理商编号
param.Add("@uKeyId", tbUKey.uKeyId); //加密狗编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加UKey信息
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbUKey">UKey信息</param>
public virtual void Add(DataAccess data, TBUKey tbUKey)
{
string strSQL = "insert into TBUKey (uKeyId,chipId,data,status,siteId,agentId) values (@uKeyId,@chipId,@data,@status,@siteId,@agentId)";
Param param = new Param();
param.Clear();
param.Add("@uKeyId", tbUKey.uKeyId); //加密狗编号
param.Add("@chipId", tbUKey.chipId); //内置编号
param.Add("@data", tbUKey.data); //加密数据
param.Add("@status", tbUKey.status); //当前状态
param.Add("@siteId", tbUKey.siteId); //门店编号
param.Add("@agentId", tbUKey.agentId); //代理商编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 激活
/// </summary>
/// <param name="uKeyId"></param>
public void Activation(string uKeyId, string rowSiteId, string userId, string userName)
{
ComTransaction trans = null;
try
{
Param param = null;
List <TBUKey> ukeyList = GetList("select * from TBUKey where siteId=" + rowSiteId + " and status='" + (int)UKeyStatus.Activation + "' and ukeyId!='" + uKeyId + "'", param);
TBUKey tbUKeyAc = Get(uKeyId);
db.Open();
trans = db.BeginTransaction();
//讲已经激活的修改为已领并记录日志
foreach (var tbUKey in ukeyList)
{
tbUKey.status = ((int)UKeyStatus.Draw).ToString();
Edit(db, tbUKey);
TBUKeyLog tbUKeyLog = new TBUKeyLog();
tbUKeyLog.uKeyId = tbUKey.uKeyId; //终端号
tbUKeyLog.operateType = "1"; //操作类型
tbUKeyLog.summary = "发放到[代理商编号:" + tbUKey.agentId + ",门店编号:" + tbUKey.siteId + "]";
tbUKeyLog.operateTime = DateTime.Now.ToString(); //操作时间
tbUKeyLog.operatorId = userId; //操作人编号
tbUKeyLog.operatorName = userName; //操作人名称
new TBUKeyLogDAO().Add(db, tbUKeyLog);
}
//激活
tbUKeyAc.status = ((int)UKeyStatus.Activation).ToString();
Edit(db, tbUKeyAc);
TBUKeyLog tbUKeyLogA = new TBUKeyLog();
tbUKeyLogA.uKeyId = tbUKeyAc.uKeyId; //终端号
tbUKeyLogA.operateType = "1"; //操作类型
tbUKeyLogA.summary = "发放到[代理商编号:" + tbUKeyAc.agentId + ",门店编号:" + tbUKeyAc.siteId + "]";
tbUKeyLogA.operateTime = DateTime.Now.ToString(); //操作时间
tbUKeyLogA.operatorId = userId; //操作人编号
tbUKeyLogA.operatorName = userName; //操作人名称
new TBUKeyLogDAO().Add(db, tbUKeyLogA);
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 修改UKey信息
/// </summary>
/// <param name="tbUKey">UKey信息</param>
public virtual void Edit(TBUKey tbUKey)
{
try
{
db.Open();
Edit(db, tbUKey);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加UKey信息
/// <param name="tbUKey">UKey信息</param>
/// </summary>
public void Add(TBUKey tbUKey)
{
try
{
db.Open();
Add(db, tbUKey);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
