/// <summary>
/// 获取门店信息
/// </summary>
/// <param name="siteId">门店编号</param>
/// <returns>门店信息对象</returns>
public virtual TBEnforcementType Get(string EnforcementTypeId)
{
TBEnforcementType tbSite = null;
try
{
string strSQL = "select * from tbEnforcementType where statu=1 and EnforcementTypeId=@EnforcementTypeId";
Param param = new Param();
param.Clear();
param.Add("@EnforcementTypeId", EnforcementTypeId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbSite = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbSite);
}
/// <summary>
/// 修改门店信息
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbSite">门店信息</param>
public virtual void Edit(DataAccess data, TBEnforcementType tbEnforcementType)
{
string strSQL = "update TBEnforcementType set EnforcementTypeName=@EnforcementTypeName , PunishmentType=@PunishmentType where EnforcementTypeId=@EnforcementTypeId";
Param param = new Param();
param.Clear();
param.Add("@EnforcementTypeId", tbEnforcementType.EnforcementTypeId); //代理商编号
param.Add("@EnforcementTypeName", tbEnforcementType.EnforcementTypeName); //门店名称
param.Add("@PunishmentType", tbEnforcementType.PunishmentType); //门店名称
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加门店信息
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbSite">门店信息</param>
public virtual void Add(DataAccess data, TBEnforcementType tbEnforcementType)
{
string strSQL = "insert into TBEnforcementType (EnforcementTypeId,EnforcementTypeName,PunishmentType) values(@EnforcementTypeId,@EnforcementTypeName,@PunishmentType)";
Param param = new Param();
param.Clear();
param.Add("@EnforcementTypeId", tbEnforcementType.EnforcementTypeId); //文书类型编号
param.Add("@EnforcementTypeName", tbEnforcementType.EnforcementTypeName); //文书类型名称
param.Add("@PunishmentType", tbEnforcementType.PunishmentType); //文书处罚类型
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 加载指定执法文书类型信息
/// <param name="siteId">执法文书类型编号</param>
/// </summary>
public void Load(string EnforcementTypeId)
{
try
{
TBEnforcementType tbEnforcementType = tbEnforcementTypeDAO.Get(EnforcementTypeId);
WebJson.ToJson(context, tbEnforcementType);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 读取执法文书类型信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>门店信息对象</returns>
protected virtual TBEnforcementType ReadData(ComDataReader dr)
{
TBEnforcementType tbEnforcementType = new TBEnforcementType();
tbEnforcementType.EnforcementTypeId = dr["ENFORCEMENTTYPEID"].ToString();//
tbEnforcementType.EnforcementTypeName = dr["ENFORCEMENTTYPENAME"].ToString();
tbEnforcementType.F1 = dr["F1"].ToString();
tbEnforcementType.F2 = dr["F2"].ToString();
tbEnforcementType.CreateDate = dr["CREATEDATE"].ToString(); //
tbEnforcementType.PunishmentType = dr["PUNISHMENTTYPE"].ToString(); //
return(tbEnforcementType);
}
/// <summary>
/// 获取执法文书类型信息
/// <param name="siteId">执法文书类型编号</param>
/// </summary>
/// <returns>执法文书类型信息对象</returns>
public TBEnforcementType Get(string EnforcementTypeId)
{
TBEnforcementType tbEnforcementType = new TBEnforcementType();
try
{
tbEnforcementType = tbEnforcementTypeDAO.Get(EnforcementTypeId);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
return(tbEnforcementType);
}
/// <summary>
/// 修改门店信息
/// </summary>
/// <param name="tbSite">门店信息</param>
public virtual void Edit(TBEnforcementType tbEnforcementType)
{
try
{
db.Open();
Edit(db, tbEnforcementType);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加执法文书类型信息
/// <param name="tbSite">执法文书类型信息</param>
/// </summary>
public void Add(TBEnforcementType tbEnforcementType)
{
//判断名称是否重复
if (tbEnforcementTypeDAO.Exist("EnforcementTypeName", tbEnforcementType.EnforcementTypeName))
{
Message.error(context, "执法文书名称重复请重新输入！");
return;
}
try
{
tbEnforcementType.EnforcementTypeId = commonDao.GetMaxNo("TBEnforcementType", "", 6);
tbEnforcementTypeDAO.Add(tbEnforcementType);
Message.success(context, "执法文书类型信息增加成功");
loginSession.Log(tbEnforcementType.EnforcementTypeName + "执法文书类型增加成功");
}
catch (Exception e)
{
Message.error(context, "执法文书类型信息增加失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 修改执法文书类型信息
/// <param name="tbSite">执法文书类型信息</param>
/// </summary>
public void Edit(TBEnforcementType tbEnforcementType)
{
//判断是否帐号重复
List <TBEnforcementType> list = tbEnforcementTypeDAO.GetList("EnforcementTypeName", tbEnforcementType.EnforcementTypeName);
if (list.Count > 0 && !tbEnforcementType.EnforcementTypeId.Equals(list[0].EnforcementTypeId))
{
Message.error(context, "名称重复请重新输入！");
return;
}
try
{
tbEnforcementTypeDAO.Edit(tbEnforcementType);
Message.success(context, "执法文书类型信息修改成功");
loginSession.Log(tbEnforcementType.EnforcementTypeName + "[" + tbEnforcementType.EnforcementTypeId + "]执法文书类型信息修改成功");
}
catch (Exception e)
{
Message.error(context, "执法文书类型信息修改失败");
loginSession.Log(e.Message);
}
}
public List <TBEnforcementType> GetCaseTypeIdHash(string caseId)
{
List <TBEnforcementType> hashCaseTypeId = new List <TBEnforcementType>();
hashCaseTypeId.Clear();
string strSQL = " select * from TBCase_EnforcementType where CaseId=@caseId";
Param param = new Param();
param.Clear();
param.Add("@caseId", caseId);
try
{
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
while (dr.Read())
{
var item = new TBEnforcementType()
{
EnforcementTypeId = dr["EnforcementTypeId"].ToString(),
EnforcementTypeName = dr["EnforcementTypeName"].ToString()
};
hashCaseTypeId.Add(item);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
param.Clear();
db.Close();
}
return(hashCaseTypeId);
}
public void ProcessRequest(HttpContext context)
{
try
{
LoginUser loginUser = new LoginUser(context, "EnforcementType");
if (!loginUser.Pass)//权限验证
{
return;
}
EnforcementTypeBLL bll = new EnforcementTypeBLL(context, loginUser);
if (context.Request["action"] == "gridLoad")
{
//加载DataGrid
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
string EnforcementTypeId = context.Request["EnforcementTypeId"];
string EnforcementTypeName = context.Request["EnforcementTypeName"];
string PunishmentTypeId = context.Request["PunishmentTypeId"];
bll.LoadGrid(page, rows, EnforcementTypeId, EnforcementTypeName, PunishmentTypeId);
}
else if (context.Request["action"] == "load")
{
//加载信息
bll.Load(context.Request["EnforcementTypeId"]);
}
else if (context.Request["action"] == "PunishmentTypeListLoad")
{
//夹在所属处罚类型
Combobox com = new Combobox(context, loginUser);
com.PunishmentTypeCombobox();
}
else if (context.Request["action"] == "add")
{
//增加
TBEnforcementType tbEnforcementType = new TBEnforcementType();
tbEnforcementType.EnforcementTypeId = context.Request["EnforcementTypeId"];
tbEnforcementType.EnforcementTypeName = context.Request["EnforcementTypeName"];
tbEnforcementType.PunishmentType = context.Request["PunishmentType"];
bll.Add(tbEnforcementType);
}
else if (context.Request["action"] == "edit")
{
//修改
TBEnforcementType tbEnforcementType = new TBEnforcementType();
tbEnforcementType.EnforcementTypeId = context.Request["EnforcementTypeId"];
tbEnforcementType.EnforcementTypeName = context.Request["EnforcementTypeName"];
tbEnforcementType.PunishmentType = context.Request["PunishmentType"];
bll.Edit(tbEnforcementType);
}
else if (context.Request["action"] == "delete")
{
//删除
string siteId = context.Request["EnforcementTypeId"];
bll.Delete(siteId);
}
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
