/// <summary> /// 文书名称信息 /// </summary> /// <param name="siteId">门店编号</param> /// <returns>门店信息对象</returns> public virtual TBCase Get(string caseId) { TBCase tbCase = null; try { string strSQL = string.Format(@"SELECT CaseId,CaseReason,CaseFrom,CasePersonName,CasePersonSex ,CasePersonAge ,CasePersonAddress,CasePersonRepresentative,CasePersonCompanyName ,CasePersonCompanyLegalPerson,CasePersonCompanyLegalRepresentative" + " ,CasePersonCompanyLegalAgent,convert(varchar, CaseOpenDate, 111) as CaseOpenDate,convert(varchar, CaseCloseDate, 111)as CaseCloseDate ,CaseFillingDate,CaseExpirationDate,CaseExecutive,StationName ,CaseProcessPersonOne,CaseProcessPersonOneEnforcementNumberOne" + " ,CaseProcessPersonTwo,CaseProcessPersonOneEnforcementNumberTwo ,CaseProcessPersonThree ,CaseProcessPersonOneEnforcementNumberThree ,CaseCarNo ,CaseResult ,CaseTypeName ,CaseStateName ,CreateUserName,CreateDate from TBCase a where a.CaseId=@CaseId"); Param param = new Param(); param.Clear(); param.Add("@CaseId", caseId); db.Open(); ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param); if (dr.Read()) { tbCase = ReadData(dr); } dr.Close(); } catch (Exception e) { throw e; } finally { db.Close(); } return(tbCase); }
/// <summary> /// 加载指定执法文书名称信息 /// <param name="siteId">执法文书名称编号</param> /// </summary> public void Load(string tbCaseId) { try { TBCase tbCase = tbCaseDAO.Get(tbCaseId); WebJson.ToJson(context, tbCase); } catch (Exception e) { Message.error(context, e.Message); } }
/// <summary> /// 获取执法文书名称信息 /// <param name="siteId">执法文书名称编号</param> /// </summary> /// <returns>执法文书名称信息对象</returns> public TBCase Get(string tbCaseId) { TBCase tbCase = new TBCase(); try { tbCase = tbCaseDAO.Get(tbCaseId); } catch (Exception e) { Message.error(context, e.Message); } return(tbCase); }
/// <summary> /// 修改门店信息 /// </summary> /// <param name="tbSite">门店信息</param> public virtual void Edit(TBCase tbCase) { try { db.Open(); Edit(db, tbCase); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 修改执法文书名称信息 /// <param name="tbSite">执法文书名称信息</param> /// </summary> public void Edit(TBCase tbCase) { //判断是否帐号重复 try { tbCaseDAO.Edit(tbCase); Message.success(context, "案件信息修改成功"); loginSession.Log(tbCase.CaseId + "[" + tbCase.CaseId + "]案件信息修改成功"); } catch (Exception e) { Message.error(context, "案件信息修改失败"); loginSession.Log(e.Message); } }
public void Load(string carNo, string stationName) { try { TBCase tbCase = new TBCase(); tbCase.CaseId = DateTime.Now.ToString("yyyyMMddhhmmssfff"); tbCase.StationName = stationName; tbCase.CaseCarNo = carNo; tbCase.CasePersonSex = "男"; WebJson.ToJson(context, tbCase); } catch (Exception e) { Message.error(context, e.Message); } }
/// <summary> /// 读取执法文书类型信息 /// </summary> /// <param name="dr">记录指针</param> /// <returns>门店信息对象</returns> protected virtual TBCase ReadData(ComDataReader dr) { TBCase tbCase = new TBCase(); tbCase.CaseId = dr["CaseId"].ToString();// tbCase.CaseReason = dr["CaseReason"].ToString(); tbCase.CaseFrom = dr["CaseFrom"].ToString(); tbCase.CasePersonName = dr["CasePersonName"].ToString(); tbCase.CasePersonSex = dr["CasePersonSex"].ToString(); // tbCase.CasePersonAge = dr["CasePersonAge"].ToString(); // tbCase.CasePersonAddress = dr["CasePersonAddress"].ToString(); // tbCase.CasePersonRepresentative = dr["CasePersonRepresentative"].ToString(); // tbCase.CasePersonCompanyName = dr["CasePersonCompanyName"].ToString(); // tbCase.CasePersonCompanyLegalPerson = dr["CasePersonCompanyLegalPerson"].ToString(); // tbCase.CasePersonCompanyLegalAgent = dr["CasePersonCompanyLegalAgent"].ToString(); // tbCase.CasePersonCompanyLegalRepresentative = dr["CasePersonCompanyLegalRepresentative"].ToString(); // //tbCase.CaseOpenDate = dr["CaseOpenDate"].ToString();// if (dr["CaseOpenDate"] == null) { tbCase.CaseOpenDate = "";//转账日期 } else { tbCase.CaseOpenDate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["CaseOpenDate"]); //转账日期 } tbCase.CaseCloseDate = dr["CaseCloseDate"].ToString(); // tbCase.CaseFillingDate = dr["CaseFillingDate"].ToString(); // tbCase.CaseExpirationDate = dr["CaseExpirationDate"].ToString(); // tbCase.CaseExecutive = dr["CaseExecutive"].ToString(); // tbCase.StationName = dr["StationName"].ToString(); // tbCase.CaseProcessPersonOne = dr["CaseProcessPersonOne"].ToString(); // tbCase.CaseProcessPersonOneEnforcementNumberOne = dr["CaseProcessPersonOneEnforcementNumberOne"].ToString(); // tbCase.CaseProcessPersonTwo = dr["CaseProcessPersonTwo"].ToString(); // tbCase.CaseProcessPersonOneEnforcementNumberTwo = dr["CaseProcessPersonOneEnforcementNumberTwo"].ToString(); // tbCase.CaseProcessPersonThree = dr["CaseProcessPersonThree"].ToString(); // tbCase.CaseProcessPersonOneEnforcementNumberThree = dr["CaseProcessPersonOneEnforcementNumberThree"].ToString(); // tbCase.CaseCarNo = dr["CaseCarNo"].ToString(); // tbCase.CaseResult = dr["CaseResult"].ToString(); // tbCase.CaseTypeName = dr["CaseTypeName"].ToString(); // tbCase.CaseStateName = dr["CaseStateName"].ToString(); // tbCase.CreateDate = dr["CreateDate"].ToString(); // tbCase.CreateUserName = dr["CreateUserName"].ToString(); // return(tbCase); }
/// <summary> /// 修改门店信息 /// </summary> /// <param name="data">数据库连接</param> /// <param name="tbSite">门店信息</param> public virtual void Edit(DataAccess data, TBCase tbCase) { string strSQL = "update TBCase set CaseReason=@CaseReason, CaseFrom=@CaseFrom,CasePersonName=@CasePersonName, CasePersonAddress=@CasePersonAddress," + " CasePersonAge=@CasePersonAge, CasePersonSex=@CasePersonSex, CasePersonRepresentative=@CasePersonRepresentative,CasePersonCompanyName=@CasePersonCompanyName," + "CasePersonCompanyLegalPerson=@CasePersonCompanyLegalPerson,CasePersonCompanyLegalRepresentative=@CasePersonCompanyLegalRepresentative,CasePersonCompanyLegalAgent=@CasePersonCompanyLegalAgent,CaseOpenDate=@CaseOpenDate, CaseCloseDate=@CaseCloseDate," + " CaseFillingDate=@CaseFillingDate, CaseExecutive=@CaseExecutive,CaseProcessPersonOne=@CaseProcessPersonOne, CaseProcessPersonOneEnforcementNumberOne=@CaseProcessPersonOneEnforcementNumberOne, CaseProcessPersonTwo=@CaseProcessPersonTwo," + " CaseProcessPersonOneEnforcementNumberTwo=@CaseProcessPersonOneEnforcementNumberTwo, CaseProcessPersonThree=@CaseProcessPersonThree, CaseProcessPersonOneEnforcementNumberThree=@CaseProcessPersonOneEnforcementNumberThree where CaseId=@CaseId"; Param param = new Param(); param.Clear(); param.Add("@CaseId", tbCase.CaseId); //文书类型编号 param.Add("@CaseReason", tbCase.CaseReason); //文书类型名称 param.Add("@CaseFrom", tbCase.CaseFrom); param.Add("@CasePersonName", tbCase.CasePersonName); param.Add("@CasePersonAddress", tbCase.CasePersonAddress); param.Add("@CasePersonAge", tbCase.CasePersonAge); param.Add("@CasePersonSex", tbCase.CasePersonSex); param.Add("@CasePersonRepresentative", tbCase.CasePersonRepresentative); param.Add("@CasePersonCompanyName", tbCase.CasePersonCompanyName); param.Add("@CasePersonCompanyLegalPerson", tbCase.CasePersonCompanyLegalPerson); param.Add("@CasePersonCompanyLegalRepresentative", tbCase.CasePersonCompanyLegalRepresentative); param.Add("@CasePersonCompanyLegalAgent", tbCase.CasePersonCompanyLegalAgent); param.Add("@CaseOpenDate", tbCase.CaseOpenDate); param.Add("@CaseCloseDate", tbCase.CaseCloseDate); param.Add("@CaseFillingDate", tbCase.CaseFillingDate); param.Add("@CaseExecutive", tbCase.CaseExecutive); //param.Add("@StationName", tbCase.StationName); param.Add("@CaseProcessPersonOne", tbCase.CaseProcessPersonOne); param.Add("@CaseProcessPersonOneEnforcementNumberOne", tbCase.CaseProcessPersonOneEnforcementNumberOne); param.Add("@CaseProcessPersonTwo", tbCase.CaseProcessPersonTwo); param.Add("@CaseProcessPersonOneEnforcementNumberTwo", tbCase.CaseProcessPersonOneEnforcementNumberTwo); param.Add("@CaseProcessPersonThree", tbCase.CaseProcessPersonThree); param.Add("@CaseProcessPersonOneEnforcementNumberThree", tbCase.CaseProcessPersonOneEnforcementNumberThree); //param.Add("@CaseCarNo", tbCase.CaseCarNo); //param.Add("@CaseResult", tbCase.CaseResult); //param.Add("@CaseTypeName", tbCase.CaseTypeName); //param.Add("@CaseStateName", tbCase.CaseStateName); //param.Add("@CreateDate", tbCase.CreateDate); //param.Add("@CreateUserName", tbCase.CreateUserName); data.ExecuteNonQuery(CommandType.Text, strSQL, param); param.Clear(); }
/// <summary> /// 增加执法文书名称信息 /// <param name="tbSite">执法文书名称信息</param> /// </summary> public void Add(TBCase tbCase) { //判断名称是否重复 if (tbCaseDAO.Exist("CaseId", tbCase.CaseId)) { Message.error(context, "案件编号重复请重新输入!"); return; } try { tbCaseDAO.Add(tbCase); Message.success(context, "案件增加成功"); loginSession.Log(tbCase.CaseId + "案件增加成功"); } catch (Exception e) { Message.error(context, "案件增加失败"); loginSession.Log(e.Message); } }
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接 /// <summary> /// 新增文案类型 /// </summary> /// <param name="data"></param> /// <param name="tbCase"></param> public virtual void Add(DataAccess data, TBCase tbCase) { string strSQL = "insert into TBCase (CaseId,CaseReason, CaseFrom, CasePersonName, CasePersonAddress," + " CasePersonAge, CasePersonSex, CasePersonRepresentative,CasePersonCompanyName,CasePersonCompanyLegalPerson,CasePersonCompanyLegalRepresentative,CasePersonCompanyLegalAgent, CaseOpenDate, CaseCloseDate," + " CaseFillingDate, CaseExecutive, StationName, CaseProcessPersonOne, CaseProcessPersonOneEnforcementNumberOne, CaseProcessPersonTwo," + " CaseProcessPersonOneEnforcementNumberTwo, CaseProcessPersonThree, CaseProcessPersonOneEnforcementNumberThree,CaseCarNo," + " CaseResult, CaseTypeName, CaseStateName,CaseStatus,CreateUserName, CreateDate) values(@CaseId,@CaseReason,@CaseFrom,@CasePersonName,@CasePersonAddress," + "@CasePersonAge,@CasePersonSex,@CasePersonRepresentative,@CasePersonCompanyName,@CasePersonCompanyLegalPerson,@CasePersonCompanyLegalRepresentative,@CasePersonCompanyLegalAgent,@CaseOpenDate,@CaseCloseDate," + "@CaseFillingDate,@CaseExecutive,@StationName,@CaseProcessPersonOne,@CaseProcessPersonOneEnforcementNumberOne,@CaseProcessPersonTwo," + "@CaseProcessPersonOneEnforcementNumberTwo,@CaseProcessPersonThree,@CaseProcessPersonOneEnforcementNumberThree,@CaseCarNo," + "@CaseResult,@CaseTypeName,@CaseStateName,@CaseStatus,@CreateUserName,@CreateDate)"; Param param = new Param(); param.Clear(); param.Add("@CaseId", tbCase.CaseId); //文书类型编号 param.Add("@CaseReason", tbCase.CaseReason); //文书类型名称 param.Add("@CaseFrom", tbCase.CaseFrom); param.Add("@CasePersonName", tbCase.CasePersonName); param.Add("@CasePersonAddress", tbCase.CasePersonAddress); param.Add("@CasePersonAge", tbCase.CasePersonAge); param.Add("@CasePersonSex", tbCase.CasePersonSex); param.Add("@CasePersonRepresentative", tbCase.CasePersonRepresentative); param.Add("@CasePersonCompanyName", tbCase.CasePersonCompanyName); param.Add("@CasePersonCompanyLegalPerson", tbCase.CasePersonCompanyLegalPerson); param.Add("@CasePersonCompanyLegalRepresentative", tbCase.CasePersonCompanyLegalRepresentative); param.Add("@CasePersonCompanyLegalAgent", tbCase.CasePersonCompanyLegalAgent); param.Add("@CaseOpenDate", tbCase.CaseOpenDate); param.Add("@CaseCloseDate", tbCase.CaseCloseDate); param.Add("@CaseFillingDate", tbCase.CaseFillingDate); param.Add("@CaseExecutive", tbCase.CaseExecutive); param.Add("@StationName", tbCase.StationName); param.Add("@CaseProcessPersonOne", tbCase.CaseProcessPersonOne); param.Add("@CaseProcessPersonOneEnforcementNumberOne", tbCase.CaseProcessPersonOneEnforcementNumberOne); param.Add("@CaseProcessPersonTwo", tbCase.CaseProcessPersonTwo); param.Add("@CaseProcessPersonOneEnforcementNumberTwo", tbCase.CaseProcessPersonOneEnforcementNumberTwo); param.Add("@CaseProcessPersonThree", tbCase.CaseProcessPersonThree); param.Add("@CaseProcessPersonOneEnforcementNumberThree", tbCase.CaseProcessPersonOneEnforcementNumberThree); param.Add("@CaseCarNo", tbCase.CaseCarNo); param.Add("@CaseResult", tbCase.CaseResult); //param.Add("@CaseTypeName", tbCase.CaseTypeName); param.Add("@CaseStateName", tbCase.CaseStateName); param.Add("@CaseStatus", 0); param.Add("@CreateDate", tbCase.CreateDate); param.Add("@CreateUserName", tbCase.CreateUserName); PunishmentType punishmentType; if (Enum.TryParse(tbCase.CaseTypeName, out punishmentType)) { //tbCase.CaseTypeName = Enum.GetName(typeof(PunishmentType), punishmentType); param.Add("@CaseTypeName", Enum.GetName(typeof(PunishmentType), punishmentType)); } param.Add("@PunishmentType", tbCase.CaseTypeName); //添加文书类型,文书名称配置副本 strSQL += @"declare @i int,@typeCount int,@j int,@nameCount int select [EnforcementTypeId] ,[EnforcementTypeName] ,[F1] ,[F2] ,[CreateDate] ,[PunishmentType] ,[Statu] into #t from TBEnforcementType where [PunishmentType]=@PunishmentType order by createdate desc select * from #t set @i=1 set @typeCount=(select count(*) from #t) while @i<=@typeCount begin insert into TBCase_EnforcementType (Id,CaseId,[EnforcementTypeId],[EnforcementTypeName],[F1],[F2],[CreateDate],[PunishmentType],[Statu]) select top 1 NEWID(),@CaseId, [EnforcementTypeId],[EnforcementTypeName],[F1],[F2],[CreateDate],[PunishmentType],[Statu] from #t delete top (1) from #t set @i=@i+1 end DROP TABLE #t select [EnforcementNameId] ,[EnforcementTypeId] ,[EnforcementName] ,[IsEmpty] ,[FillingPerson] ,[FillingTime] ,[F1] ,[CreateDate] ,[Statu] ,[EnforcementTemplateId] into #t1 from(select * from TBEnForcementName where [EnforcementTypeId] in (select [EnforcementTypeId] from TBEnforcementType where [PunishmentType]=@PunishmentType) ) t order by createdate desc select * from #t1 set @j=1 set @nameCount=(select count(*) from #t1) while @j<=@nameCount begin insert into TBCase_EnforementName (Id,CaseId,[EnforcementNameId] ,[EnforcementTypeId] ,[EnforcementName] ,[IsEmpty] ,[FillingPerson] ,[FillingTime] ,[F1] ,[CreateDate] ,[Statu] ,[EnforcementTemplateId]) select top 1 NEWID(),@CaseId, [EnforcementNameId] ,[EnforcementTypeId] ,[EnforcementName] ,[IsEmpty] ,[FillingPerson] ,[FillingTime] ,[F1] ,[CreateDate] ,[Statu] ,[EnforcementTemplateId] from #t1 delete top (1) from #t1 set @j=@j+1 end DROP TABLE #t1 update TBCase set CaseCurrentTypeId=(select top 1 EnforcementTypeId from TBCase_EnforcementType where caseId=@CaseId order by [EnforcementTypeId]), CaseStateName=(select top 1 EnforcementTypeName from TBCase_EnforcementType where caseId=@CaseId order by [EnforcementTypeId]) where caseId=@CaseId update TBCase_EnforcementType set statu=2 where EnforcementTypeId=(select top 1 EnforcementTypeId from TBCase_EnforcementType where caseId=@CaseId order by [EnforcementTypeId]) and caseId=@CaseId"; data.ExecuteNonQuery(CommandType.Text, strSQL, param); param.Clear(); }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "TodoCase"); if (!loginUser.Pass)//权限验证 { return; } CaseBLL bll = new CaseBLL(context, loginUser); if (context.Request["action"] == "caseGridLoad") { //加载DataGrid int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); string tbCaseId = context.Request["tbCaseId"]; string tbCaseReason = context.Request["tbCaseReason"]; string openDateFrom = context.Request["openDateFrom"]; string openDateTo = context.Request["openDateTo"]; string closeDateFrom = context.Request["closeDateFrom"]; string closeDateTo = context.Request["closeDateTo"]; string caseState = context.Request["caseState"]; string caseCarNo = context.Request["caseCarNo"]; string caseType = context.Request["caseType"]; bll.LoadGrid(page, rows, tbCaseId, tbCaseReason, openDateFrom, openDateTo, closeDateFrom, closeDateTo, caseState, caseCarNo, caseType, 0); } else if (context.Request["action"] == "stationListLoad") { Combobox com = new Combobox(context, loginUser); com.StationCombobox(); } else if (context.Request["action"] == "load") { var caseId = context.Request["caseId"]; //加载信息 bll.Load(caseId); } else if (context.Request["action"] == "edit") { //修改 TBCase tbCase = new TBCase(); tbCase.CaseId = context.Request["CaseId"].ToString();// tbCase.CaseReason = context.Request["CaseReason"].ToString(); tbCase.CaseFrom = context.Request["CaseFrom"].ToString(); tbCase.CasePersonName = context.Request["CasePersonName"].ToString(); tbCase.CasePersonSex = context.Request["CasePersonSex"].ToString(); // tbCase.CasePersonAge = context.Request["CasePersonAge"].ToString(); // tbCase.CasePersonAddress = context.Request["CasePersonAddress"].ToString(); // tbCase.CasePersonRepresentative = context.Request["CasePersonRepresentative"].ToString(); // tbCase.CasePersonCompanyName = context.Request["CasePersonCompanyName"].ToString(); // tbCase.CasePersonCompanyLegalPerson = context.Request["CasePersonCompanyLegalPerson"].ToString(); // tbCase.CasePersonCompanyLegalRepresentative = context.Request["CasePersonCompanyLegalRepresentative"].ToString(); // tbCase.CasePersonCompanyLegalAgent = context.Request["CasePersonCompanyLegalAgent"].ToString(); // tbCase.CaseOpenDate = context.Request["CaseOpenDate"].ToString(); // tbCase.CaseCloseDate = context.Request["CaseCloseDate"].ToString(); // tbCase.CaseFillingDate = context.Request["CaseFillingDate"].ToString(); // tbCase.CaseExpirationDate = context.Request["CaseExpirationDate"].ToString(); // tbCase.CaseExecutive = context.Request["CaseExecutive"].ToString(); // //tbCase.StationName = context.Request["StationName"].ToString();// tbCase.CaseProcessPersonOne = context.Request["CaseProcessPersonOne"].ToString(); // tbCase.CaseProcessPersonOneEnforcementNumberOne = context.Request["CaseProcessPersonOneEnforcementNumberOne"].ToString(); // tbCase.CaseProcessPersonTwo = context.Request["CaseProcessPersonTwo"].ToString(); // tbCase.CaseProcessPersonOneEnforcementNumberTwo = context.Request["CaseProcessPersonOneEnforcementNumberTwo"].ToString(); // tbCase.CaseProcessPersonThree = context.Request["CaseProcessPersonThree"].ToString(); // tbCase.CaseProcessPersonOneEnforcementNumberThree = context.Request["CaseProcessPersonOneEnforcementNumberThree"].ToString(); // // tbCase.CaseCarNo = context.Request["CaseCarNo"].ToString(); //tbCase.CaseResult = context.Request["CaseResult"].ToString();// //tbCase.CaseTypeName = context.Request["caseType"].ToString();// //tbCase.CaseStateName = "立案";// //tbCase.CreateDate = DateTime.Now.ToString();// //tbCase.CreateUserName = loginUser.UserName;// bll.Edit(tbCase); // bll.Edit(tbEnforcementName); } else if (context.Request["action"] == "delete") { //删除 string caseId = context.Request["caseId"]; bll.Delete(caseId); } } catch (Exception e) { Message.error(context, e.Message); } }