/// <summary> /// 文书名称信息 /// </summary> /// <param name="siteId">门店编号</param> /// <returns>门店信息对象</returns> public virtual TBEnforcementName Get(string EnforcementNameId) { TBEnforcementName tbSite = null; try { string strSQL = string.Format(@"select n.EnforcementName,n.IsEmpty,n.F1, t.EnforcementTypeName from TBEnforcementName n ,TBEnforcementType t where n.statu=1 and t.statu=1 and t.EnforcementTypeId=n.EnforcementTypeId and n.EnforcementNameId=@EnforcementNameId"); Param param = new Param(); param.Clear(); param.Add("@EnforcementNameId", EnforcementNameId); 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="dr">记录指针</param> /// <returns>门店信息对象</returns> protected virtual TBEnforcementName ReadData(ComDataReader dr) { TBEnforcementName tbEnforcementName = new TBEnforcementName(); tbEnforcementName.EnforcementNameId = dr["EnforcementNameId"].ToString();// tbEnforcementName.EnforcementTypeId = dr["EnforcementTypeId"].ToString(); tbEnforcementName.F1 = dr["F1"].ToString(); tbEnforcementName.EnforcementName = dr["EnforcementName"].ToString(); // tbEnforcementName.IsEmpty = dr["IsEmpty"].ToString(); // return(tbEnforcementName); }
/// <summary> /// 加载指定执法文书名称信息 /// <param name="siteId">执法文书名称编号</param> /// </summary> public void Load(string EnforcementTypeId) { try { TBEnforcementName tbEnforcementName = tbEnforcementNameDAO.Get(EnforcementTypeId); WebJson.ToJson(context, tbEnforcementName); } catch (Exception e) { Message.error(context, e.Message); } }
/// <summary> /// 修改门店信息 /// </summary> /// <param name="data">数据库连接</param> /// <param name="tbSite">门店信息</param> public virtual void Edit(DataAccess data, TBEnforcementName tbEnforcementName) { string strSQL = "update TBEnForcementName set EnforcementName=@EnforcementName,IsEmpty=@IsEmpty where EnforcementNameId=@EnforcementNameId"; Param param = new Param(); param.Clear(); param.Add("@EnforcementName", tbEnforcementName.EnforcementName); param.Add("@IsEmpty", tbEnforcementName.IsEmpty); //param.Add("@FillingPerson", tbEnforcementName.FillingPerson); //param.Add("@FillingTime", tbEnforcementName.FillingTime); param.Add("@EnforcementNameId", tbEnforcementName.EnforcementNameId); data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 获取执法文书名称信息 /// <param name="siteId">执法文书名称编号</param> /// </summary> /// <returns>执法文书名称信息对象</returns> public TBEnforcementName Get(string EnforcementNameId) { TBEnforcementName tbEnforcementName = new TBEnforcementName(); try { tbEnforcementName = tbEnforcementNameDAO.Get(EnforcementNameId); } catch (Exception e) { Message.error(context, e.Message); } return(tbEnforcementName); }
/// <summary> /// 修改门店信息 /// </summary> /// <param name="tbSite">门店信息</param> public virtual void Edit(TBEnforcementName tbEnforcementName) { try { db.Open(); Edit(db, tbEnforcementName); } catch (Exception e) { throw e; } finally { db.Close(); } }
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接 /// <summary> /// 新增文案类型 /// </summary> /// <param name="data"></param> /// <param name="tbEnforcementName"></param> public virtual void Add(DataAccess data, TBEnforcementName tbEnforcementName) { string strSQL = "insert into TBEnForcementName (EnforcementNameId,EnforcementTypeId,EnforcementName,IsEmpty,EnforcementTemplateId) values(@EnforcementNameId,@EnforcementTypeId,@EnforcementName,@IsEmpty,@EnforcementTemplateId)"; Param param = new Param(); param.Clear(); param.Add("@EnforcementNameId", tbEnforcementName.EnforcementNameId); //文书类型编号 param.Add("@EnforcementTypeId", tbEnforcementName.EnforcementTypeId); //文书类型名称 param.Add("@EnforcementName", tbEnforcementName.EnforcementName); param.Add("@IsEmpty", tbEnforcementName.IsEmpty); param.Add("@EnforcementTemplateId", tbEnforcementName.EnforcementTemplateId); //param.Add("@FillingPerson", tbEnforcementName.FillingPerson); //param.Add("@FillingTime", tbEnforcementName.FillingTime); data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 增加执法文书名称信息 /// <param name="tbSite">执法文书名称信息</param> /// </summary> public void Add(TBEnforcementName tbEnforcementName) { //判断名称是否重复 if (tbEnforcementNameDAO.Exist("EnforcementName", tbEnforcementName.EnforcementName)) { Message.error(context, "执法文书名称重复请重新输入!"); return; } try { tbEnforcementName.EnforcementNameId = commonDao.GetMaxNo("TBEnForcementName", "", 6); tbEnforcementName.IsEmpty = tbEnforcementName.IsEmpty == null ? "0" : "1"; tbEnforcementNameDAO.Add(tbEnforcementName); Message.success(context, "执法文书名称信息增加成功"); loginSession.Log(tbEnforcementName.EnforcementName + "执法文书名称增加成功"); } catch (Exception e) { Message.error(context, "执法文书名称信息增加失败"); loginSession.Log(e.Message); } }
/// <summary> /// 修改执法文书名称信息 /// <param name="tbSite">执法文书名称信息</param> /// </summary> public void Edit(TBEnforcementName tbEnforcementName) { //判断是否帐号重复 List <TBEnforcementName> list = tbEnforcementNameDAO.GetList("EnforcementName", tbEnforcementName.EnforcementName); if (list.Count > 0 && !tbEnforcementName.EnforcementName.Equals(list[0].EnforcementName)) { Message.error(context, "名称重复请重新输入!"); return; } try { tbEnforcementNameDAO.Edit(tbEnforcementName); Message.success(context, "执法文书名称信息修改成功"); loginSession.Log(tbEnforcementName.EnforcementName + "[" + tbEnforcementName.EnforcementNameId + "]执法文书名称信息修改成功"); } catch (Exception e) { Message.error(context, "执法文书名称信息修改失败"); loginSession.Log(e.Message); } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "EnforcementName"); if (!loginUser.Pass)//权限验证 { return; } EnforcementNameBLL bll = new EnforcementNameBLL(context, loginUser); if (context.Request["action"] == "gridLoad") { //加载DataGrid int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); string EnforcementNameId = context.Request["EnforcementNameId"]; string EnforcementName = context.Request["EnforcementName"]; string EnforcementTypeId = context.Request["EnforcementTypeId"]; bll.LoadGrid(page, rows, EnforcementNameId, EnforcementName, EnforcementTypeId); } else if (context.Request["action"] == "EnforcementTypeListLoad") { Combobox com = new Combobox(context, loginUser); com.EnforcementTypeCombobox(); } else if (context.Request["action"] == "TemplateListLoad") { Combobox com = new Combobox(context, loginUser); com.EnforcementTemplateCombobox(); } else if (context.Request["action"] == "load") { //加载信息 bll.Load(context.Request["EnforcementNameId"]); } else if (context.Request["action"] == "add") { //增加 TBEnforcementName tbEnforcementName = new TBEnforcementName(); // tbEnforcementName.EnforcementNameId = context.Request["EnforcementNameId"]; tbEnforcementName.EnforcementName = context.Request["EnforcementName"]; tbEnforcementName.EnforcementTypeId = context.Request["EnforcementTypeId"]; // tbEnforcementName.FillingTime = context.Request["FillingTime"]; // tbEnforcementName.FillingPerson = context.Request["FillPerson"]; tbEnforcementName.IsEmpty = context.Request["IsEmpty"]; tbEnforcementName.F1 = context.Request["F1"]; tbEnforcementName.EnforcementTemplateId = context.Request["EnforcementTemplateId"]; bll.Add(tbEnforcementName); } else if (context.Request["action"] == "edit") { //修改 TBEnforcementName tbEnforcementName = new TBEnforcementName(); tbEnforcementName.EnforcementNameId = context.Request["EnforcementNameId"]; tbEnforcementName.EnforcementName = context.Request["EnforcementName"]; tbEnforcementName.EnforcementTypeId = context.Request["EnforcementTypeId"]; tbEnforcementName.FillingTime = context.Request["FillingTime"]; tbEnforcementName.FillingPerson = context.Request["FillingPerson"]; tbEnforcementName.IsEmpty = context.Request["IsEmpty"]; tbEnforcementName.F1 = context.Request["F1"]; bll.Edit(tbEnforcementName); } else if (context.Request["action"] == "delete") { //删除 string EnforcementNameId = context.Request["EnforcementNameId"]; bll.Delete(EnforcementNameId); } } catch (Exception e) { Message.error(context, e.Message); } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "AddCase"); if (!loginUser.Pass)//权限验证 { return; } CaseBLL bll = new CaseBLL(context, loginUser); if (context.Request["action"] == "carGridLoad") { //加载DataGrid int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); string stationName = context.Request["stationName"]; string carNo = context.Request["carNo"]; string fromDate = context.Request["fromDate"]; string toDate = context.Request["toDate"]; string axialType = context.Request["axialType"]; bll.LoadCarGrid(page, rows, stationName, carNo, fromDate, toDate, axialType); } else if (context.Request["action"] == "stationListLoad") { Combobox com = new Combobox(context, loginUser); com.StationCombobox(); } else if (context.Request["action"] == "load") { var carNo = context.Request["carNo"]; var stationName = context.Request["stationName"]; //加载信息 bll.Load(carNo, stationName); } else if (context.Request["action"] == "add") { //增加 TBCase tbCase = new TBCase(); tbCase.CaseId = context.Request["CaseId"];// tbCase.CaseReason = context.Request["CaseReason"]; tbCase.CaseFrom = context.Request["CaseFrom"]; tbCase.CasePersonName = context.Request["CasePersonName"]; tbCase.CasePersonSex = context.Request["CasePersonSex"]; // tbCase.CasePersonAge = context.Request["CasePersonAge"]; // tbCase.CasePersonAddress = context.Request["CasePersonAddress"]; // tbCase.CasePersonRepresentative = context.Request["CasePersonRepresentative"]; // tbCase.CasePersonCompanyName = context.Request["CasePersonCompanyName"]; // tbCase.CasePersonCompanyLegalPerson = context.Request["CasePersonCompanyLegalPerson"]; // tbCase.CasePersonCompanyLegalRepresentative = context.Request["CasePersonCompanyLegalRepresentative"]; // tbCase.CasePersonCompanyLegalAgent = context.Request["CasePersonCompanyLegalAgent"]; // tbCase.CaseOpenDate = context.Request["CaseOpenDate"]; // tbCase.CaseCloseDate = context.Request["CaseCloseDate"]; // tbCase.CaseFillingDate = context.Request["CaseFillingDate"]; // tbCase.CaseExpirationDate = context.Request["CaseExpirationDate"]; // tbCase.CaseExecutive = context.Request["CaseExecutive"]; // tbCase.StationName = context.Request["StationName"]; // tbCase.CaseProcessPersonOne = context.Request["CaseProcessPersonOne"]; // tbCase.CaseProcessPersonOneEnforcementNumberOne = context.Request["CaseProcessPersonOneEnforcementNumberOne"]; // tbCase.CaseProcessPersonTwo = context.Request["CaseProcessPersonTwo"]; // tbCase.CaseProcessPersonOneEnforcementNumberTwo = context.Request["CaseProcessPersonOneEnforcementNumberTwo"]; // tbCase.CaseProcessPersonThree = context.Request["CaseProcessPersonThree"]; // tbCase.CaseProcessPersonOneEnforcementNumberThree = context.Request["CaseProcessPersonOneEnforcementNumberThree"]; // tbCase.CaseCarNo = context.Request["CaseCarNo"]; tbCase.CaseResult = context.Request["CaseResult"]; // //tbCase.CaseTypeName = context.Request["caseType"];// tbCase.CaseTypeName = context.Request["caseType"]; tbCase.CaseStateName = "立案"; // tbCase.CreateDate = DateTime.Now.ToString(); // tbCase.CreateUserName = loginUser.UserName; // bll.Add(tbCase); } else if (context.Request["action"] == "edit") { //修改 TBEnforcementName tbEnforcementName = new TBEnforcementName(); tbEnforcementName.EnforcementNameId = context.Request["EnforcementNameId"]; tbEnforcementName.EnforcementName = context.Request["EnforcementName"]; tbEnforcementName.EnforcementTypeId = context.Request["EnforcementTypeId"]; tbEnforcementName.FillingTime = context.Request["FillingTime"]; tbEnforcementName.FillingPerson = context.Request["FillingPerson"]; tbEnforcementName.IsEmpty = context.Request["IsEmpty"]; tbEnforcementName.F1 = context.Request["F1"]; // bll.Edit(tbEnforcementName); } else if (context.Request["action"] == "delete") { //删除 string EnforcementNameId = context.Request["EnforcementNameId"]; bll.Delete(EnforcementNameId); } } catch (Exception e) { Message.error(context, e.Message); } }