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