/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
private string DelData()
{
string ids = Request.Form["id"];
string[] id = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
ids = "";
for (int i = 0; i < id.Length; i++)
{
ids += "'" + id[i].Trim() + "'";
if (i < id.Length - 1)
{
ids += ",";
}
}
YX_DZJZ_FMDY bll = new YX_DZJZ_FMDY(this.Request);
if (bll.DeleteList(ids))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "删除封面打印成功", Request.Form["cs"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "删除数据成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "删除封面打印失败", Request.Form["cs"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "删除数据失败", null));
}
/// <summary>
/// 绑定列表
/// </summary>
/// <returns></returns>
public string ListBind()
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["key"];
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
string where = string.Empty;
object[] values = new object[1];
if (!string.IsNullOrEmpty(key))
{
where += " and BT like :BT ";
values[0] = "%" + key + "%";
}
EDRS.BLL.YX_DZJZ_FMDY bll = new EDRS.BLL.YX_DZJZ_FMDY(this.Request);
DataSet ds = bll.GetListByPage(where, "", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "绑定打印封面数据成功", UserInfo, UserRole, this.Request);
int count = bll.GetRecordCount(where, values);
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}");
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "绑定打印封面数据未找到信息", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到信息", null));
}
/// <summary>
/// 根据律师证号获取数据
/// </summary>
/// <param name="DWBM"></param>
/// <returns></returns>
private string GetModel(string lszh)
{
if (string.IsNullOrEmpty(lszh))
{
lszh = Request.Form.Get("id");
if (string.IsNullOrEmpty(lszh))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
EDRS.BLL.YX_DZJZ_LSGL bll = new EDRS.BLL.YX_DZJZ_LSGL(this.Request);
DataSet ds = bll.GetListfile(" and YX_DZJZ_LSGL.LSZH='" + lszh + "'", null);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
if (dt != null && dt.Columns.Count > 0 && dt.Rows.Count > 0)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息成功", "", UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(dt));
}
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
/// <summary>
/// 绑定列表
/// </summary>
/// <returns></returns>
public string ListBind()
{
int count = 0;
DataTable dt = GetList(ref count);
if (dt != null && dt.Rows.Count > 0)
{
string type = Request["type"];
if (type == "Graph")
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "单位卷宗制作情况统计图形获取成功", UserInfo, UserRole, this.Request);
return(StatisticsDataHelper.GetGraph(dt, new String[] { "AJNUM", "YZZNUM", "WZZNUM", "JNUM", "MLNUM", "WJNUM", "WJYNUM" }, "DWMC"));
}
else
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "单位卷宗制作情况统计数据获取成功", UserInfo, UserRole, this.Request);
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(dt) + "}");
}
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "未找到单位卷宗制作情况统计信息", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到单位卷宗制作情况统计信息", null));
}
/// <summary>
/// 解除卷宗案件基本信息锁定状态
/// </summary>
/// <returns></returns>
private string RomIsLock()
{
string bmsahs = Request.Form["bmsahs"];
if (bmsahs == null || string.IsNullOrEmpty(bmsahs))
{
return ReturnString.JsonToString(Prompt.error, "解锁参数不正确", null);
}
string[] str = bmsahs.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries);
List<EDRS.Model.YX_DZJZ_JZJBXX> modelList = new List<EDRS.Model.YX_DZJZ_JZJBXX>();
for (int i = 0; i < str.Length; i++)
{
EDRS.Model.YX_DZJZ_JZJBXX model = new EDRS.Model.YX_DZJZ_JZJBXX();
model.BMSAH = str[i];
model.JZXGH = "";
model.ZHXGSJ = DateTime.Now;
model.ZZZT = "-1";
modelList.Add(model);
}
YX_DZJZ_JZJBXX bll = new YX_DZJZ_JZJBXX(this.Request);
if (bll.LockByModelList(modelList))
{
OperateLog.AddLogList(OperateLog.LogType.案件卷宗制作Web, "卷宗解锁成功", str, UserInfo, UserRole, this.Request);
return ReturnString.JsonToString(Prompt.win, "解锁成功", null);
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "卷宗解锁失败", bmsahs, UserInfo, UserRole, this.Request);
return ReturnString.JsonToString(Prompt.error, "解锁失败", null);
}
/// <summary>
/// 根据编号获取数据
/// </summary>
/// <returns></returns>
private string GetModelOrParentList(string DWBM, string BMBM)
{
if (string.IsNullOrEmpty(BMBM))
{
BMBM = Request["id"];
if (string.IsNullOrEmpty(BMBM))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
DWBM = Request["did"];
if (string.IsNullOrEmpty(DWBM))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request);
EDRS.Model.XT_ZZJG_BMBM model = bll.GetModel(DWBM, BMBM);
if (model != null)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "根据部门编号获取部门成功", model.BMMC, UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "根据部门编号获取部门失败", Request["bmmc"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
private string DelData()
{
string ids = Request.Form["BMBM"];
string dwbm = Request.Form["DWBM"];
string[] id = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
ids = "";
for (int i = 0; i < id.Length; i++)
{
ids += "'" + id[i].Trim() + "'";
if (i < id.Length - 1)
{
ids += ",";
}
}
XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request);
//string where = " and SFSC='N' and FBMBM in (" + ids + ")";
//if (bll.GetRecordCount(" and SFSC='N' and FBMBM in (" + ids + ")") == 0)
if (bll.GetBmbmCount(dwbm, ids) == 0)
{
if (!string.IsNullOrEmpty(dwbm) && bll.DeleteListLogic(ids, "'" + dwbm + "'"))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "删除部门成功", Request.Form["bmmc"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "删除数据成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "删除部门失败", Request.Form["bmmc"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "删除数据失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "未找到删除部门信息", Request.Form["bmmc"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "该部门正在被使用，无法删除！", null));
}
/// <summary>
/// 修改配置数据
/// </summary>
/// <returns></returns>
private string UpData()
{
string pzbm = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(pzbm))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
YX_DZJZ_FMDY bll = new YX_DZJZ_FMDY(this.Request);
EDRS.Model.YX_DZJZ_FMDY model = bll.GetModel(pzbm);
if (model != null)
{
model.BT = Request.Form.Get("txt_bt");
model.FBT = Request.Form.Get("txt_fbt");
model.AJMC = Request.Form.Get("txt_ajmc");
model.AJBH = Request.Form.Get("txt_ajbh");
model.FZXYR = Request.Form.Get("txt_fzxyr");
if (!string.IsNullOrEmpty(Request.Form.Get("txt_lasj")))
{
model.LASJ = Convert.ToDateTime(Request.Form.Get("txt_lasj"));
}
if (!string.IsNullOrEmpty(Request.Form.Get("txt_jasj")))
{
model.JASJ = Convert.ToDateTime(Request.Form.Get("txt_jasj"));
}
model.LJDW = Request.Form.Get("txt_ljdw");
model.LJR = Request.Form.Get("txt_ljr");
model.SHR = Request.Form.Get("txt_shr");
model.BAGJ = string.IsNullOrEmpty(Request.Form.Get("txt_bagj")) ? 0 : int.Parse(Request.Form.Get("txt_bagj"));
model.DJJ = Request.Form.Get("txt_djj");
model.GJY = string.IsNullOrEmpty(Request.Form.Get("txt_gjy")) ? 0 : int.Parse(Request.Form.Get("txt_gjy"));
model.CZRGH = UserInfo.GH;
model.CZR = UserInfo.MC;
model.CZSJ = DateTime.Now;
model.CZIP = Request.ServerVariables["REMOTE_ADDR"];
model.CZLX = "";
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "修改方面打印成功", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "修改方面打印失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "修改方面打印未找到信息", Request.Form.Get("txt_cs"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
/// <summary>
/// 添加单位数据
/// </summary>
/// <returns></returns>
private string AddData()
{
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "添加模板配置验证失败" + msg, Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
string number = "00000001";
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
DataSet ds = bll.GetListByPage("", "DOSSIERTYPEVALUEMEMBER desc", 0, 1);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
number = ds.Tables[0].Rows[0]["DOSSIERTYPEVALUEMEMBER"].ToString();
number = (int.Parse(number) + 1).ToString().PadLeft(8, '0');
}
EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB();
model.DossierTypeValueMember = number;
model.CaseInfoTypeID = Request.Form.Get("tree_ajtype_val") ?? "";
model.CaseInfoTypeName = Request.Form.Get("tree_ajtype");
model.DossierParentMember = Request.Form.Get("key_parent") ?? "";
model.UnitID = UserInfo.DWBM;
model.SSLBBM = Request.Form.Get("tree_sslb_val") ?? "";
model.SSLBMC = Request.Form.Get("tree_sslb") ?? "";
if (string.IsNullOrEmpty(Request.Form.Get("txt_rank")))
{
model.SortIndex = 1;
}
else
{
model.SortIndex = int.Parse(Request.Form.Get("txt_rank"));
}
model.DossierTypeDisplayMember = Request.Form.Get("txt_name");
model.DossierEvidenceValueMember = "";
model.Category = Request.Form.Get("hidd_Category");
if (bool.Parse(Request.Form.Get("chk_autoFound_ar")))
{
model.Auto = "Y";
}
else
{
model.Auto = "N";
}
if (bll.Add(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "添加模板配置成功", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", number));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "添加模板配置失败", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
/// <summary>
/// 添加人员功能权限数据
/// </summary>
/// <returns></returns>
private string AddData()
{
string msg = string.Empty;
string gnid = Request["gns"];
string ghs = Request["ghs"];
string[] arrghs = ghs.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
string[] arrgns = gnid.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
List <EDRS.Model.XT_QX_RYGNFP> modelList = new List <EDRS.Model.XT_QX_RYGNFP>();
string where = string.Empty;
string wghs = string.Empty;
string wgnbms = string.Empty;
for (int j = 0; j < arrgns.Length; j++)
{
for (int i = 0; i < arrghs.Length; i++)
{
EDRS.Model.XT_QX_RYGNFP model = new EDRS.Model.XT_QX_RYGNFP();
model.DWBM = UserInfo.DWBM;
model.GH = arrghs[i];
model.GNBM = arrgns[j];
model.BMBM = "0 ";
//model.GNCS = "";
model.BZ = "";
modelList.Add(model);
if (j == 0)
{
wghs += "'" + arrghs[i] + "'";
if (i < arrghs.Length - 1)
{
wghs += ",";
}
}
}
wgnbms += "'" + arrgns[j] + "'";
if (j < arrgns.Length - 1)
{
wgnbms += ",";
}
}
EDRS.BLL.XT_QX_RYGNFP bll = new EDRS.BLL.XT_QX_RYGNFP(this.Request);
List <EDRS.Model.XT_QX_RYGNFP> modelList2 = bll.GetModelList(" and DWBM = '" + UserInfo.DWBM + "' and GH in (" + wghs + ") and GNBM in (" + wgnbms + ")");
List <EDRS.Model.XT_QX_RYGNFP> modelList3 = modelList.Except(modelList2, new XT_QX_RYGNFPListEquality()).ToList();
if (modelList3.Count == 0 || bll.AddList(modelList3))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "添加人员功能权限成功", "工号：" + ghs, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "添加人员功能权限失败", "工号：" + ghs, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="dwbm"></param>
/// <returns></returns>
private string UpData()
{
string dwbm = Request.Form.Get("key_hidd_up");
if (string.IsNullOrEmpty(dwbm) || !Regex.IsMatch(dwbm, @"^[A-Za-z0-9]{1,8}$"))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingUpFrom(ref msg))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置验证失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
EDRS.Model.XY_DZJZ_MBPZB model = bll.GetModel(dwbm);
if (model != null)
{
model.CaseInfoTypeID = Request.Form.Get("tree_ajtype_up_val");
model.CaseInfoTypeName = Request.Form.Get("tree_ajtype_up") ?? "";
model.DossierTypeDisplayMember = Request.Form.Get("txt_name_up");
model.SSLBBM = Request.Form.Get("tree_sslb_up_val") ?? "";
model.SSLBMC = Request.Form.Get("tree_sslb_up") ?? "";
if (string.IsNullOrEmpty(Request.Form.Get("txt_rank_up")))
{
model.SortIndex = 1;
}
else
{
model.SortIndex = int.Parse(Request.Form.Get("txt_rank_up"));
}
if (bool.Parse(Request.Form.Get("chk_autoFound_up_ar")))
{
model.Auto = "Y";
}
else
{
model.Auto = "N";
}
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置成功", Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置未找到修改信息" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
public void GetBusinessReport(HttpContext context)
{
string strWhere = "";
List <object> values = new List <object>();
string pageIndex = context.Request["page"];
string pageSize = context.Request["pagesize"];
string unit = context.Request["unit"]; //承办单位
string timebegin = context.Request["timebegin"]; //开始日期
string timeend = context.Request["timeend"]; //结束日期
string count_start = context.Request["count_start"];
string count_end = context.Request["count_end"];
if (!string.IsNullOrEmpty(unit))
{
strWhere += " AND CBDW_MC LIKE '%" + unit + "%'";
}
if (!string.IsNullOrEmpty(timebegin))
{
strWhere += " and CJSJ >= to_date('" + Convert.ToDateTime(timebegin).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(timeend))
{
strWhere += " and CJSJ <= to_date('" + Convert.ToDateTime(timeend).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
string havingWhere = " HAVING 1=1 ";
if (Convert.ToInt32(count_start) > 0)
{
havingWhere += " AND SUM(CASE WHEN ISREGARD > 0 THEN 1 ELSE 0 END) >=" + count_start;
}
if (Convert.ToInt32(count_end) > 0)
{
havingWhere += " AND SUM(CASE WHEN ISREGARD > 0 THEN 1 ELSE 0 END) <=" + count_end;
}
string qxWhere = " AND trim(DWBM) = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0";
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(context.Request);
int count = 0;
DataSet ds = bll.GetCaseBusinessReport(strWhere, havingWhere, qxWhere, Convert.ToInt32(pageSize), Convert.ToInt32(pageIndex), "", out count, values.ToArray());
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
OperateLog.AddLog(OperateLog.LogType.卷宗业务情况统计Web, "查询卷宗业务情况统计成功！", UserInfo, UserRole, context.Request);
//获取json数据
string json = "{\"Rows\":" + ds.Tables[0].ToDatagridJson() + ",\"Total\":" + count + "}";// EDRS.Common.JsonHelper.JsonString(ds.Tables[0]);
context.Response.Write(json);
}
else
{
OperateLog.AddLog(OperateLog.LogType.卷宗业务情况统计Web, "查询卷宗业务情况统计失败！", UserInfo, UserRole, context.Request);
//获取json数据
string json = "{\"Rows\":" + "[]" + ",\"Total\":" + count + "}";// EDRS.Common.JsonHelper.JsonString(ds.Tables[0]);
context.Response.Write(json);
}
}
/// <summary>
/// 绑定列表
/// </summary>
/// <returns></returns>
public string ListBind()
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["key"];
string ajmc = Request["ajmc"];
string gh = Request["gh"];
string mc = Request["mc"];
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
string where = " and T.SFSC='N'";
object[] values = new object[6];
if (!string.IsNullOrEmpty(key))
{
where += " and t.BMSAH like :BMSAH";
values[0] = "%" + key + "%";
}
if (!string.IsNullOrEmpty(ajmc))
{
where += " and AJMC like :AJMC";
values[1] = "%" + ajmc + "%";
}
if (!string.IsNullOrEmpty(gh))
{
where += " and GH like :GH";
values[2] = "%" + gh + "%";
}
if (!string.IsNullOrEmpty(mc))
{
where += " and MC like :MC";
values[3] = "%" + mc + "%";
}
where += " and JDRGH = :JDRGH";
where += " and JDDWBM=:JDDWBM";
values[4] = UserInfo.GH;
values[5] = UserInfo.DWBM;
EDRS.BLL.YX_DZJZ_LSAJBD bll = new EDRS.BLL.YX_DZJZ_LSAJBD(this.Request);
DataSet ds = bll.GetListByPage(where, "YJJSSJ desc,JDSJ desc", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "获取阅卷绑定列表成功", UserInfo, UserRole, this.Request);
int count = bll.GetRecordCount(where, values);
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}");
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "获取阅卷绑定列表-未找到信息", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到阅卷绑定信息", null));
}
private string UpDate2()
{
string dwbm = Request["dwbm"];
string sslbbm = Request["sslbbm"];
string ajlbbm = Request["ajlbbm"];
List <object> param = new List <object>();
string strWhere = " and unitID=:dwbm";
param.Add(dwbm);
strWhere += " and CASEINFOTYPEID=:CASEINFOTYPEID";
param.Add(ajlbbm);
strWhere += " and sslbbm=:sslbbm";
param.Add(sslbbm);
EDRS.BLL.XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(Request);
DataSet ds = bll.GetList(strWhere, param.ToArray());
EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB();
string msg = string.Empty;
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
model = bll.GetModel(dr["DOSSIERTYPEVALUEMEMBER"].ToString());
if (model != null)
{
if (string.IsNullOrEmpty(Request.Form.Get("txt_rank")))
{
model.SortIndex = 1;
}
else
{
model.SortIndex = int.Parse(Request.Form.Get("txt_rank"));
}
if (bool.Parse(Request.Form.Get("chk_autoFound_ar")))
{
model.Auto = "Y";
}
else
{
model.Auto = "N";
}
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置成功", Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置未找到修改信息" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
/// <summary>
/// 绑定列表
/// </summary>
/// <returns></returns>
public string ListBind()
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["key"];
string dwbm = Request["dwbm"];
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
string where = string.Empty;
object[] values = new object[1];
if (!string.IsNullOrEmpty(key))
{
//设备型号
where += " and DEVTYPE like :DEVTYPE ";
values[0] = "%" + key + "%";
}
if (!string.IsNullOrEmpty(dwbm))
{
dwbm = dwbm.Replace(";", ",");
where += " and DWBM in (" + StringPlus.ReplaceSingle(dwbm) + ")";
}
EDRS.BLL.XY_DZJZ_SBDJ bll = new EDRS.BLL.XY_DZJZ_SBDJ(this.Request);
string jsbms = string.Empty;
for (int i = 0; i < this.UserRole.Count; i++)
{
if (i > 0)
{
jsbms += ",";
}
jsbms += this.UserRole[i].JSBM;
}
DataSet ds = bll.GetListByPage(this.UserInfo.DWBM, jsbms, where, "", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.设备登记Web, "绑定设备登记列表成功", UserInfo, UserRole, this.Request);
int count = bll.GetRecordCount(this.UserInfo.DWBM, jsbms, where, values);
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}");
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.设备登记Web, "获取设备登记列表无数据", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "未找到设备登记", null));
}
/// <summary>
/// 数据绑定
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="key"></param>
/// <param name="casename"></param>
/// <param name="dutyman"></param>
/// <param name="relevance"></param>
/// <param name="timebegin"></param>
/// <param name="timeend"></param>
/// <returns></returns>
//[WebMethod]
public string ListBind()
{
string page = Request["page"];
string rows = Request["pagesize"];
string bmsah = Request["key"];
string jzmc = Request["casename"];
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
string where = string.Empty;
object[] values = new object[7];
string isLogck = "\"IsLock\":true";
if (!string.IsNullOrEmpty(isLogck))
{
where += " and JZXGH like :JZXGH";
values[0] = "%" + isLogck + "%";
}
where += " and T.SFSC='N'";
where += " and (DWBM in(select distinct trim(QXBM) from xt_dm_qx a join XT_QX_RYJSFP b on trim(a.jsbm) = b.jsbm and trim(a.bmbm)=b.bmbm and trim(a.dwbm)=b.dwbm and gh=:GH1 and b.dwbm=:DWBM1 and a.qxlx=0) and aj.AJLB_BM in ( select trim(QXBM) from xt_dm_qx a join XT_QX_RYJSFP b on trim(a.jsbm) = b.jsbm and trim(a.bmbm)=b.bmbm and trim(a.dwbm)=b.dwbm and gh=:GH2 and b.dwbm=:DWBM2 and a.qxlx=1)) ";
values[1] = base.UserInfo.GH;
values[2] = base.UserInfo.DWBM;
values[3] = base.UserInfo.GH;
values[4] = base.UserInfo.DWBM;
if (!string.IsNullOrEmpty(jzmc))
{
where += " and JZMC like :JZMC";
values[5] = "%" + jzmc + "%";
}
if (!string.IsNullOrEmpty(bmsah))
{
where += " and T.BMSAH like :BMSAH";
values[6] = "%" + bmsah + "%";
}
YX_DZJZ_JZJBXX bll = new YX_DZJZ_JZJBXX(this.Request);
DataSet ds = bll.GetListByPagePower(where, "", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
int count = bll.GetRecordCountPower(where, values);
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "卷宗解锁查询", UserInfo, UserRole, this.Request);
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(dt) + "}");
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "卷宗解锁查询未找到数据", UserInfo, UserRole, this.Request);
return("{\"Total\":" + 0 + ",\"Rows\":[]}");
}
private DataSet GetMakeCaseData()
{
string pageIndex = Request["page"];
string pageSize = Request["pagesize"];
//where
string b_date = Request["b_date"];
string e_date = Request["e_date"];
string username = Request["username"];
string unit = Request["txt_unit"];
string where = "";
List <object> values = new List <object>();
if (!string.IsNullOrEmpty(b_date))
{
//JZ.Cjsj（创建时间） / JZ.JZSCSJ（上传时间）
where += " and JZ.Cjsj >= to_date('" + Convert.ToDateTime(b_date).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(e_date))
{
where += " and JZ.Cjsj <= to_date('" + Convert.ToDateTime(e_date).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(username))
{
where += " and JZ.JZSCRXM LIKE ";
where += "'%" + username + "%'";
}
if (!string.IsNullOrEmpty(unit))
{
where += " and CBDW_MC LIKE ";
where += "'%" + unit + "%'";
}
//单位权限
//List<string> unitRoleList = GetDwBm(UserRole.DWBM, UserRole.BMBM, UserRole.JSBM);
string qxWhere = " AND DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0";
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(Request);
int count;
DataSet ds = bll.GetCaseByPerson(where, qxWhere, Convert.ToInt32(pageSize), Convert.ToInt32(pageIndex), "", out count, values.ToArray());
if (ds == null)
{
OperateLog.AddLog(OperateLog.LogType.卷宗制作工作量统计Web, "查询卷宗制作工作量统计图表数据失败！", UserInfo, UserRole, Request);
}
else
{
OperateLog.AddLog(OperateLog.LogType.卷宗制作工作量统计Web, "查询卷宗制作工作量统计图表数据成功！", UserInfo, UserRole, Request);
}
return(ds);
}
/// <summary>
/// 提交申请
/// </summary>
/// <returns></returns>
private string AddData()
{
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(this.Request);
//DataSet ds = bll.GetList(" and SFSC='N' and SQDZT<>'N' and YJSQDH=:YJSQDH", new string[] { Request.Form["txt_yjsqdh"] });
//if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
// return ReturnString.JsonToString(Prompt.error, "该阅卷申请单号已被申请过", null);
string zh = Request.Form["LSZH"];
if (string.IsNullOrEmpty(zh))
{
return(ReturnString.JsonToString(Prompt.error, "请选择律师姓名", null));
}
string dm = Request.Form["txt_yjsqdm"];
if (string.IsNullOrEmpty(dm))
{
return(ReturnString.JsonToString(Prompt.error, "申请单名不能为空", null));
}
Random random = new Random();
EDRS.Model.YX_DZJZ_LSYJSQ model = new EDRS.Model.YX_DZJZ_LSYJSQ();
model.LSZH = Request.Form["LSZH"];
model.YJSQDH = random.Next(100000, 999999).ToString();
model.SQSJ = DateTime.Now;
model.SQSM = Request.Form["txt_sqsm"];
model.SFSC = "N";
model.SHRGH = UserInfo.GH;
model.SHR = UserInfo.MC;
model.SHSM = "";
model.SHSJ = DateTime.Now;
model.YJSQDM = dm;
model.SQDZT = "T";
if (bll.Add(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "提交阅卷申请成功", model.YJSQDH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "提交阅卷申请失败", model.YJSQDH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
private DataSet GetBusinessReport()
{
string strWhere = "";
List <object> values = new List <object>();
string pageIndex = Request["page"];
string pageSize = Request["pagesize"];
string unit = Request["unit"]; //承办单位
string timebegin = Request["timebegin"]; //开始日期
string timeend = Request["timeend"]; //结束日期
string count_start = Request["count_start"];
string count_end = Request["count_end"];
if (!string.IsNullOrEmpty(unit))
{
strWhere += " AND CBDW_MC LIKE '%" + unit + "%'";
}
if (!string.IsNullOrEmpty(timebegin))
{
strWhere += " and CJSJ >= to_date('" + Convert.ToDateTime(timebegin).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(timeend))
{
strWhere += " and CJSJ <= to_date('" + Convert.ToDateTime(timeend).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
string qxWhere = " AND DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0";
string havingWhere = " HAVING 1=1 ";
if (Convert.ToInt32(count_start) > 0)
{
havingWhere += " AND SUM(CASE WHEN ISREGARD > 0 THEN 1 ELSE 0 END) >=" + count_start;
}
if (Convert.ToInt32(count_end) > 0)
{
havingWhere += " AND SUM(CASE WHEN ISREGARD > 0 THEN 1 ELSE 0 END) <=" + count_end;
}
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(Request);
int count = 0;
DataSet ds = bll.GetCaseBusinessReport(strWhere, havingWhere, qxWhere, Convert.ToInt32(pageSize), Convert.ToInt32(pageIndex), "", out count, values.ToArray());
if (ds == null)
{
OperateLog.AddLog(OperateLog.LogType.卷宗业务情况统计Web, "查询卷宗业务情况统计图表数据失败！", UserInfo, UserRole, Request);
}
else
{
OperateLog.AddLog(OperateLog.LogType.卷宗业务情况统计Web, "查询卷宗业务情况统计图表数据成功！", UserInfo, UserRole, Request);
}
return(ds);
}
/// <summary>
/// 调用客户端添加案件信息
/// </summary>
/// <returns></returns>
private string IAddData()
{
try
{
string strstring = "abc_2@" + base.UserInfo.DWBM + "@" + base.UserInfo.MC + "@" + GetConfigById(EnumConfig.卷宗文件上传地址).CONFIGVALUE + "@" + UserInfo.GH + "@" + UserInfo.DWMC;
strstring = DESEncrypt.Encrypt(strstring);
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "调用添加" + ((VersionName)0).ToString() + "接口", "", UserInfo, UserRole, this.Request);
return("{\"parm\":\"" + strstring + "\"}");
}
catch (Exception)
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "调用添加" + ((VersionName)0).ToString() + "接口出现错误", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "调用接口出现错误", null));
}
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
private string DelData()
{
string gh = Request.Form["gh"];
EDRS.BLL.XT_QX_RYGNFP bll = new EDRS.BLL.XT_QX_RYGNFP(this.Request);
if (!string.IsNullOrEmpty(gh) && bll.DeleteList(StringPlus.ReplaceSingle(gh)))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "删除人员功能权限成功", Request.Form["bmmc"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "删除人员功能权限成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "删除人员功能权限失败", Request.Form["bmmc"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "删除人员功能权限失败", null));
}
/// <summary>
/// 修改类别
/// </summary>
/// <returns></returns>
private string UpData()
{
string ajlbbm = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(ajlbbm))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
XT_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request);
EDRS.Model.XT_DZJZ_SSLB model = bll.GetModel(ajlbbm);
string lbbm = string.Empty;
if (model != null)
{
lbbm = model.SSLBBM;
model.SSLBMC = Request.Form.Get("txt_name");
model.SSLBSX = Convert.ToDecimal(Request.Form.Get("txt_sx"));
model.SSLBSM = Request.Form.Get("txt_sm");
if (bll.Update(model))
{
System.Collections.Hashtable hssql = new System.Collections.Hashtable();
hssql.Add(string.Format("update xy_dzjz_mbpzb set sslbmc='{0}',DossierTypeDisplayMember='{0}' where sslbbm='{1}'", model.SSLBMC, lbbm), null);
XY_DZJZ_MBPZB bllmb = new XY_DZJZ_MBPZB(this.Request);
bllmb.Update(hssql);
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改所属类别成功", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改所属类别失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改所属类别未找到信息", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
/// <summary>
/// 绑定列表
/// </summary>
/// <returns></returns>
private string ListBind()
{
int count;
DataTable ds = GetListBind(out count);
if (ds != null && ds.Rows.Count > 0)
{
//获取json数据
OperateLog.AddLog(OperateLog.LogType.卷宗制作工作量统计Web, "查询卷宗制作工作量统计列表成功！", UserInfo, UserRole, Request);
return("{\"Rows\":" + JsonHelper.JsonString(ds) + ",\"Total\":" + count + "}");
}
else
{
OperateLog.AddLog(OperateLog.LogType.卷宗制作工作量统计Web, "查询卷宗制作工作量统计列表失败！", UserInfo, UserRole, Request);
return("{\"Rows\":" + "[]" + ",\"Total\":" + count + "}");
}
}
private string AddTemp()
{
Cyvation.CCQE.Web.ZZJGHandler.JsonResult resultJson = new Cyvation.CCQE.Web.ZZJGHandler.JsonResult();
try
{
string jsonText = Request.Params["jsonText"]; //保存模板的json集合
string _sslbbm = Request.Params["sslbbm"]; //所属类别
string _sslbmc = Request.Params["sslbmc"]; //所属类别
string _ajlbbm = Request.Params["ajlbbm"]; //案件类别
string _ajlbmc = Request.Params["ajlbmc"]; //案件类别
EDRS.Model.XT_DM_QX model = new EDRS.Model.XT_DM_QX();
EDRS.BLL.XY_DZJZ_MBPZB bll = new EDRS.BLL.XY_DZJZ_MBPZB(Request);
JavaScriptSerializer jsonH = new JavaScriptSerializer();
List <TemplateModel> list = jsonH.Deserialize(jsonText, typeof(List <TemplateModel>)) as List <TemplateModel>;
//将list 转换为 list<dictionary>
List <Dictionary <string, string> > tempList = new List <Dictionary <string, string> >();
foreach (TemplateModel tmodel in list)
{
Dictionary <string, string> tempModel = new Dictionary <string, string>();
tempModel["id"] = tmodel.id;
tempModel["text"] = tmodel.text;
tempModel["parentId"] = tmodel.parentId;
tempModel["SortIndex"] = tmodel.SortIndex;
tempModel["auto"] = tmodel.auto;
tempList.Add(tempModel);
}
bool result = bll.AddList(tempList, UserInfo.DWBM, _ajlbbm, _ajlbmc, _sslbbm, _sslbmc);// bll.AddDW(list, _jsbm, _dwbm, _bmbm);
resultJson.isTrue = true;
resultJson.errorMsg = resultJson.isTrue ? "操作成功！" : "操作失败，请稍后重试！";
if (result)
{
OperateLog.AddLog(OperateLog.LogType.角色权限管理Web, "新增模板配置成功！", _sslbbm, UserInfo, UserRole, Request);
}
else
{
OperateLog.AddLog(OperateLog.LogType.角色权限管理Web, "新增模板配置失败！", _sslbbm, UserInfo, UserRole, Request);
}
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(null, "", ex.Message, "ADDDWQX", "ZZJGHandler");
}
return(resultJson.ToJsonString());
}
private DataSet GetUnitCaseData()
{
string where = "";
List <object> values = new List <object>();
string pageIndex = Request["page"];
string pageSize = Request["pagesize"];
string key = Request["key"]; //部门受案号
string unit = Request["unit"]; //承办单位
string timebegin = Request["timebegin"]; //开始日期
string timeend = Request["timeend"]; //结束日期
if (!string.IsNullOrEmpty(unit))
{
where += " and CBDW_MC like ";
where += "'%" + unit + "%'";
}
//strWhere += " and (select count(1) from yx_dzjz_jzml y where y.Bmsah=T1.Bmsah) > 0";//已关联
if (!string.IsNullOrEmpty(timebegin))
{
where += " and SLRQ >= to_date('" + Convert.ToDateTime(timebegin).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(timeend))
{
where += " and SLRQ <= to_date('" + Convert.ToDateTime(timeend).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
//单位权限
//List<string> unitRoleList = GetDwBm(UserRole.DWBM, UserRole.BMBM, UserRole.JSBM);
string qxWhere = " AND DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0";
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(Request);
int count;
//1-8 修改存储过程
DataSet ds = bll.GetCaseGroupByUnit(where, UserInfo.DWBM, UserInfo.GH, Convert.ToInt32(pageSize), Convert.ToInt32(pageIndex), "", out count, values.ToArray());
if (ds == null)
{
OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "查询单位卷宗统计图表数据失败！", UserInfo, UserRole, Request);
}
else
{
OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "查询单位卷宗统计图表数据成功！", UserInfo, UserRole, Request);
}
return(ds);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="dwbm"></param>
/// <returns></returns>
private string UpData()
{
string id = Request.Form.Get("key_hidd");
string uid = Request.Form.Get("hidd_unitNumber").Trim();
if (string.IsNullOrEmpty(id) || !Regex.IsMatch(id, @"^[A-Za-z0-9]{1,8}$"))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
if (string.IsNullOrEmpty(uid) || !Regex.IsMatch(id, @"^[A-Za-z0-9]{1,8}$"))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
//if (!ProvingFrom(ref msg))
// return ReturnString.JsonToString(Prompt.error, msg, null);
XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request);
EDRS.Model.XT_ZZJG_BMBM model = bll.GetModel(uid, id);
if (model != null)
{
model.BMMC = Request.Form.Get("txt_name").Trim();
model.BMJC = Request.Form.Get("txt_abbreviation").Trim();
//model.BMAHJC = Request.Form.Get("txt_abbreviationNum1").Trim();
//model.BMWHJC = Request.Form.Get("txt_abbreviationNum2").Trim();
//model.SFLSJG = Request.Form.Get("txt_temporary") == null ? "N" : "Y";
//model.SFCBBM = Request.Form.Get("txt_undertake") == null ? "0" : "1";
//model.BMXH = Convert.ToDecimal(Request.Form.Get("txt_number").Trim());
model.BZ = Request.Form.Get("txt_remark").Trim();
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "修改部门成功", model.BMMC, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "修改部门失败", model.BMMC, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "未找到修改部门信息", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
/// <summary>
/// 绑定数据列表
/// </summary>
/// <returns></returns>
private string ListBindGn()
{
string page = Request["page"];
string rows = Request["pagesize"];
string key = Request["key"];
string gn = Request["gn"];
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
string where = string.Empty;
object[] values = new object[7];
where += " and T.SFSC=:SFSC";
values[0] = "N";
where += " and b.DWBM=:DWBM";
values[1] = UserInfo.DWBM;
if (!string.IsNullOrEmpty(key))
{
where += " and( T.MC like :MC or T.GH like :GH or T.DLBM like :DLBM or T.GZZH like :GZZH)";
values[2] = "%" + key + "%";
values[3] = "%" + key + "%";
values[4] = "%" + key + "%";
values[5] = "%" + key + "%";
}
if (!string.IsNullOrEmpty(gn))
{
where += " and b.GNBM=:GNBM";
values[6] = gn;
}
EDRS.BLL.XT_ZZJG_RYBM bll = new EDRS.BLL.XT_ZZJG_RYBM(this.Request);
DataSet ds = bll.GetListByPageAndGn(where, "", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "获取人员功能权限成功", UserInfo, UserRole, this.Request);
int count = bll.GetRecordCountAndGn(where, values);
return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}");
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.功能权限管理Web, "获取人员功能权限未找到数据", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "", null));
}
/// <summary>
#endregion
#region 根据律师证号获取律师附件信息
/// 根据律师证号获取律师附件信息
/// </summary>
/// <returns></returns>
private string GetLsFile()
{
string lszh = Request.Form["lszh"];
EDRS.BLL.YX_DZJZ_LSZZWJ bll = new YX_DZJZ_LSZZWJ(this.Request);
List <string> filestr = bll.GetList(lszh);
if (filestr.Count > 0)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "根据编号获取律师附件成功", "", UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(filestr));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "根据编号获取律师附件失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
/// <summary>
/// 修改配置数据
/// </summary>
/// <returns></returns>
private string UpData()
{
string pzbm = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(pzbm))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
XY_DZJZ_XTPZ bll = new XY_DZJZ_XTPZ(this.Request);
EDRS.Model.XY_DZJZ_XTPZ model = bll.GetModel(pzbm);
if (model != null)
{
model.CONFIGID = Convert.ToInt32(Request.Form["slct_type_val"]);
model.CONFIGNAME = Enum.Parse(typeof(EnumConfig), Request.Form["slct_type_val"], true).ToString();
if (!string.IsNullOrEmpty(Request.Form["txt_value_val"]))
{
model.CONFIGVALUE = Request.Form["txt_value_val"];
}
else
{
model.CONFIGVALUE = Request.Form["txt_value"];
}
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改参数配置成功", model.CONFIGNAME, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功，重新登录生效", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改参数配置失败", model.CONFIGNAME, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改参数配置未找到信息", Request.Form.Get("txt_cs"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
/// <summary>
/// 打印
/// </summary>
/// <returns></returns>
private string PrintFileByXh()
{
//申请序号
string xh = Request.Form.Get("xh");
//选择文件文件序号
string param = Request.Form.Get("param");
if (string.IsNullOrEmpty(xh) || string.IsNullOrEmpty(param))
{
return(ReturnString.JsonToString(Prompt.error, "打印未获取到参数", null));
}
string[] paramArr = param.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
if (paramArr.Length == 0)
{
return(ReturnString.JsonToString(Prompt.error, "请选择需要打印的文件页", null));
}
else
{
//设置文件是需要打印的
List <EDRS.Model.YX_DZJZ_WJSQDYJL> listModel = new List <EDRS.Model.YX_DZJZ_WJSQDYJL>();
EDRS.Model.YX_DZJZ_WJSQDYJL model = null;
//循环构造集合
for (int i = 0; i < paramArr.Length; i++)
{
model = new EDRS.Model.YX_DZJZ_WJSQDYJL();
model.WJXH = paramArr[i];
model.XH = xh;
model.SFXYDY = "Y";
listModel.Add(model);
}
EDRS.BLL.YX_DZJZ_WJSQDY bll = new EDRS.BLL.YX_DZJZ_WJSQDY(Request);
if (bll.UpdateListJl(listModel))
{
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "打印律师申请文件页成功", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "打印成功", null));
}
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "打印律师申请文件页失败", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "打印失败", null));
}
}