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