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