protected void Page_Load(object sender, EventArgs e)
{
string type = Request["t"];
if (!string.IsNullOrEmpty(type))
{
Response.ContentEncoding = Encoding.UTF8;
Response.ContentType = "application/json";
if (type.Equals("GetMlTree"))
{
Response.Write(GetMlTree());
}
if (type.Equals("AddData"))
{
Response.Write(AddData());
}
if (type.Equals("ListBind"))
{
//权限状态
EDRS.BLL.TYYW_GG_AJJBXX bll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
string data = bll.ListBin(this.Request, UserInfo.DWBM, UserInfo.GH, base.GetBmBm(), Jsbms, base.GetJsQxzt());
//OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "案件数据查询", UserInfo, UserRole, this.Request);
Response.Write(data);
}
if (type.Equals("getPeople"))
{
Response.Write(GetPeople());
}
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string type = Request["t"];
if (!string.IsNullOrEmpty(type))
{
Response.ContentEncoding = Encoding.UTF8;
Response.ContentType = "application/json";
if (type.Equals("ListBind"))
{
EDRS.BLL.TYYW_GG_AJJBXX bll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
string data = bll.ListBin(this.Request, UserInfo.DWBM, UserInfo.GH, Bmbms, Jsbms);
Response.Write(data);
}
if (type.Equals("DeriveData"))
{
Response.Write(DeriveData());
}
Response.End();
}
}
/// <summary>
/// 保存分配案件文件
/// </summary>
/// <returns></returns>
private string AddData()
{
string json = Request.Form["json"];
string yjxh = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); //"山东省院捕受[2015]37000000054号";
string lssq = Request.Form["lssq"];
string[] lssqs = null;
if (string.IsNullOrEmpty(lssq))
{
return(ReturnString.JsonToString(Prompt.error, "请先填写律师阅卷申请信息！", null));
}
lssqs = lssq.Split(new string[] { "|&|" }, StringSplitOptions.None);
if (lssqs == null || lssqs.Length != 4)
{
return(ReturnString.JsonToString(Prompt.error, "您填写的律师阅卷申请信息不正确！", null));
}
string rybm = "";// Request.Form["lszh_hidd"];
// string[] rybms = rybm.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries);
//if(rybms.Length != 2)
// return ReturnString.JsonToString(Prompt.error, "请选择阅卷人！", null);
if (Request.Form["txt_yjkssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjkssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "请设置阅卷开始时间！", null));
}
if (Request.Form["txt_yjjssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjjssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "请设置阅卷结束时间！", null));
}
if (Convert.ToDateTime(Request.Form["txt_yjkssj"]) > Convert.ToDateTime(Request.Form["txt_yjjssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "结束时间不能小于开始时间！", null));
}
EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
EDRS.Model.TYYW_GG_AJJBXX ajmodel = ajbll.GetModel(Request.Form["key_hidd"]);
if (ajmodel == null)
{
return(ReturnString.JsonToString(Prompt.error, "分配失败，" + ((VersionName)0).ToString() + "不存在！", null));
}
//json = json.Replace("id", "_wjxh").Replace("MLLX", "_fpbm").Replace("text", "_sfsc").Replace("PARENTID", "_yjxh");
#region 律师阅卷申请
EDRS.Model.YX_DZJZ_LSYJSQ modelLsyjsq = new EDRS.Model.YX_DZJZ_LSYJSQ();
modelLsyjsq.LSZH = lssqs[0];
modelLsyjsq.YJSQDH = Guid.NewGuid().ToString();
modelLsyjsq.SQSJ = DateTime.Now;
modelLsyjsq.SQSM = lssqs[2];
modelLsyjsq.SFSC = "N";
modelLsyjsq.SHRGH = UserInfo.GH;
modelLsyjsq.SHR = UserInfo.MC;
modelLsyjsq.SHSM = "";
modelLsyjsq.SHSJ = DateTime.Now;
modelLsyjsq.YJSQDM = lssqs[1];
modelLsyjsq.SQDZT = "Y";
#endregion
#region 律师阅卷绑定
Random random = new Random();
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
model.GH = lssqs[0];
model.BMSAH = ajmodel.BMSAH;
model.YJXH = yjxh;
model.MC = lssqs[3];
model.AJMC = ajmodel.AJMC;
model.AJLBBM = ajmodel.AJLB_BM;
model.AJLBMC = ajmodel.AJLB_MC;
model.YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]);
model.YJJSSJ = Convert.ToDateTime(Request.Form["txt_yjjssj"]);
model.YJZH = lssqs[0];
model.YJMM = random.Next(100000, 999999).ToString();
model.JDSJ = DateTime.Now;
model.JDR = UserInfo.MC;
model.JDRGH = UserInfo.GH;
model.JDBMBM = "";
model.JDBMMC = "";
model.JDDWBM = UserInfo.DWBM;
model.JDDWMC = UserInfo.DWMC;
model.SFSC = "N";
model.YJSQDH = modelLsyjsq.YJSQDH;
model.JZZTXS = "";
model.DWBM = UserInfo.DWBM;
#endregion
#region 律师阅卷绑定文件
List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList = JsonHelper.JsonToList <EDRS.Model.YX_DZJZ_LSAJWJFP>(json);
#endregion
EDRS.BLL.YX_DZJZ_LSAJBD bllBD = new EDRS.BLL.YX_DZJZ_LSAJBD(Request);
try
{
if (bllBD.AddList(modelLsyjsq, model, modelList))
{
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配成功", "", UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//return ReturnString.JsonToString(Prompt.win, "分配成功！", null);
}
catch (Exception ex)
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(ex.Message), null));
}
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
/// <summary>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
EDRS.BLL.TYYW_GG_AJJBXX bll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
DataTable dt = bll.ListBinTable(Request, UserInfo.DWBM, UserInfo.GH);
if (dt != null && dt.Rows.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (dt.Rows.Count > 0)
{
dt.Columns["ZZZT"].ColumnName = "制作状态";
dt.Columns["BMSAH"].ColumnName = "案号名称";
dt.Columns["AJMC"].ColumnName = "案由";
//dt.Columns["AJBH"].ColumnName = "案件编号";
//dt.Columns["WSBH"].ColumnName = "文书编号";
//dt.Columns["WSMC"].ColumnName = "文书名称";
dt.Columns["AJLB_MC"].ColumnName = "案件类别";
//dt.Columns["XYR"].ColumnName = "嫌疑人姓名";
dt.Columns["SARQ"].ColumnName = "收案日期";
dt.Columns["JARQ"].ColumnName = "结案日期";
dt.Columns["GDRQ"].ColumnName = "归档日期";
if (dt.Columns.Contains("CBDW_MC"))
{
dt.Columns["CBDW_MC"].ColumnName = "单位";
}
if (dt.Columns.Contains("AJ_DWMC"))
{
dt.Columns["AJ_DWMC"].ColumnName = "单位";
}
dt.Columns["CBR"].ColumnName = "承办人";
DataTable dtCopy = dt.Copy();
for (int i = 0; i < dt.Columns.Count; i++)
{
if (!Regex.IsMatch(dt.Columns[i].ColumnName.ToString(), @"[\u4e00-\u9fbb]+"))
{
dtCopy.Columns.Remove(dt.Columns[i].ColumnName.ToString());
}
}
object zzzt;
object[] desc;
for (int i = 0; i < dtCopy.Rows.Count; i++)
{
zzzt = Enum.Parse(typeof(EnumZzzt), dtCopy.Rows[i]["制作状态"].ToString(), true);
desc = zzzt.GetType().GetField(zzzt.ToString()).GetCustomAttributes(typeof(DescriptionAttribute), true);
if (desc != null && desc.Length > 0)
{
dtCopy.Rows[i]["制作状态"] = (desc[0] as DescriptionAttribute).Description;
}
}
msg = DataToExcel_Ex.Export(dtCopy, "案件基本情况", Server.MapPath("/" + ExcelFolder + "/" + filename));
// filename = dte.DataExcel(dt, ((VersionName)0).ToString()+"基本情况", FilePath, nameList, valueList);
}
if (string.IsNullOrEmpty(msg))
{
return(ReturnString.JsonToString(Prompt.win, "/" + ExcelFolder + "/" + filename, null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(msg), null));
}
}
return(ReturnString.JsonToString(Prompt.error, "导出失败", null));
}
private void GetAJReportByUnit(HttpContext context)
{
string strWhere = "";
List <object> values = new List <object>();
int pageIndex = Convert.ToInt32(context.Request["page"]);
int pageSize = Convert.ToInt32(context.Request["pagesize"]);
string key = context.Request["key"]; //部门受案号
string timebegin = context.Request["timebegin"]; //开始日期
string timeend = context.Request["timeend"]; //结束日期
string unit = context.Request["unit"]; //承办单位
string ywbm = context.Request["ywbm"];
string caseajlb = context.Request["caseajlb"];
//排序
string sortname = context.Request["sortname"];
string sortorder = context.Request["sortorder"];
if (string.IsNullOrEmpty(sortname) || sortname.ToLower() == "cbdw_mc")
{
sortname = "CBDW_BM";
}
sortname += " " + sortorder;
// string qxWhere = "";
// qxWhere = " AND DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0";
//选中时，筛选单位，否则查询所有有权限数据
EDRS.BLL.XT_DM_QX bllQx = new EDRS.BLL.XT_DM_QX(context.Request);
if (!string.IsNullOrEmpty(unit))
{
string dwbms = unit.Replace(";", ",");
strWhere += " and CBDW_BM in (" + StringPlus.ReplaceSingle(dwbms) + ")";
}
else if (string.IsNullOrEmpty(unit))
{
//DataSet dsDwQx = bllQx.GetDwList(base.Jsbms, base.UserInfo.DWBM, base.Bmbms, "");
//if (dsDwQx != null && dsDwQx.Tables.Count > 0 && dsDwQx.Tables[0].Rows.Count > 0)
//{
// string dwbms = "";
// foreach (DataRow dr in dsDwQx.Tables[0].Rows)
// {
// dwbms += dr["QXBM"] + ",";
// }
// strWhere += " and AJ.CBDW_BM in (" + StringPlus.ReplaceSingle(dwbms.Substring(0, dwbms.Length - 1)) + ")";
strWhere += " and AJ.CBDW_BM in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=0 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
//// where_dw = " and jz.dwbm in (" + StringPlus.ReplaceSingle(dwbms.Substring(0, dwbms.Length - 1)) + ")";
//}
//else
// strWhere += " and AJ.CBDW_BM = " + base.UserInfo.DWBM;
}
//案件类别
if (!string.IsNullOrEmpty(caseajlb))
{
string caseajlbs = caseajlb.Replace(";", ",");
strWhere += " and trim(AJ.AJLB_BM) in (" + caseajlbs + ")";
}
else if (string.IsNullOrEmpty(caseajlb))
{
//DataSet dsLbQx = bllQx.GetLBList(base.Jsbms, base.UserInfo.DWBM, base.Bmbms, "");
//if (dsLbQx != null && dsLbQx.Tables.Count > 0 && dsLbQx.Tables[0].Rows.Count > 0)
//{
// string ajlbs = "";
// foreach (DataRow dr in dsLbQx.Tables[0].Rows)
// {
// ajlbs += dr["QXBM"] + ",";
// }
// strWhere += " and trim(aj.ajlb_bm) in (" + StringPlus.ReplaceSingle(ajlbs.Substring(0, ajlbs.Length - 1)) + ")";
strWhere += " and trim(aj.ajlb_bm) in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=1 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
//}
}
//业务
if (!string.IsNullOrEmpty(ywbm))
{
strWhere += " and LB.YWBM='" + StringPlus.ReplaceSingle(ywbm) + "'";
}
//strWhere += " and (select count(1) from yx_dzjz_jzml y where y.Bmsah=T1.Bmsah) > 0";//已关联
if (!string.IsNullOrEmpty(timebegin))
{
strWhere += " and aj.cjsj >= to_date('" + Convert.ToDateTime(timebegin).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(timeend))
{
strWhere += " and aj.cjsj <= to_date('" + Convert.ToDateTime(timeend).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
//单位权限
//List<string> unitRoleList = GetDwBm(context,UserRole.DWBM, UserRole.BMBM, UserRole.JSBM);
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(context.Request);
int count = 0;
//1-8 修改存储过程
DataSet ds = bll.GetCaseGroupByUnit(strWhere, UserInfo.DWBM, UserInfo.GH, (pageSize * pageIndex), (pageSize * pageIndex) - pageSize + 1, sortname, out count, values.ToArray());
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0].Copy();
//读取配置文件中的配置
int?isLocalAjxx = EDRS.Common.ConfigHelper.GetConfigInt("IsLocalAjxx");
if (isLocalAjxx == 1)
{
string msg = "";
DateTime?b_date = null;
if (!string.IsNullOrEmpty(timebegin))
{
b_date = Convert.ToDateTime(timebegin);
}
DateTime?e_date = null;
if (!string.IsNullOrEmpty(timeend))
{
e_date = Convert.ToDateTime(timeend);
}
EDRS.Common.IceServicePrx iceprx = new IceServicePrx();
EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(context.Request);
msg = ajbll.GetConfiguration(UserInfo.DWBM, UserInfo.GH, iceprx);
if (!string.IsNullOrEmpty(msg))
{
context.Response.Write(msg);
}
foreach (DataRow dr in dt.Rows)
{
dr["AJNUM"] = iceprx.GetAjjbxxCount(null, dr["CBDW_BM"].ToString(), b_date, e_date, true, out msg);
dr["WZNUM"] = int.Parse(dr["AJNUM"].ToString()) - int.Parse(dr["ZZNUM"].ToString());
dr["ZZLNUM"] = Math.Round((decimal.Parse(dr["ZZNUM"].ToString()) / decimal.Parse(dr["AJNUM"].ToString())) * 100, 2);
}
}
//获取json数据
OperateLog.AddLog(OperateLog.LogType.卷宗业务情况Web, "查询单位卷宗统计列表数据成功！", UserInfo, UserRole, context.Request);
string json = "{\"Rows\":" + dt.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>
private string AddData()
{
string json = Request.Form["json"];
string yjxh = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); //"山东省院捕受[2015]37000000054号";
string rybm = Request.Form["lszh_hidd"];
string[] rybms = rybm.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (rybms.Length != 2)
{
return(ReturnString.JsonToString(Prompt.error, "请选择阅卷人！", null));
}
if (Request.Form["txt_yjkssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjkssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "请设置阅卷开始时间！", null));
}
if (Request.Form["txt_yjjssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjjssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "请设置阅卷结束时间！", null));
}
if (Convert.ToDateTime(Request.Form["txt_yjkssj"]) > Convert.ToDateTime(Request.Form["txt_yjjssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "结束时间不能小于开始时间！", null));
}
EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
EDRS.Model.TYYW_GG_AJJBXX ajmodel = ajbll.GetModel(Request.Form["key_hidd"]);
if (ajmodel == null)
{
return(ReturnString.JsonToString(Prompt.error, "分配失败，" + ((VersionName)0).ToString() + "不存在！", null));
}
//json = json.Replace("id", "_wjxh").Replace("MLLX", "_fpbm").Replace("text", "_sfsc").Replace("PARENTID", "_yjxh");
Random random = new Random();
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
model.GH = rybms[0];
model.BMSAH = ajmodel.BMSAH;
model.YJXH = yjxh;
model.MC = Request.Form["txt_lsxm"];
model.AJMC = ajmodel.AJMC;
model.AJLBBM = ajmodel.AJLB_BM;
model.AJLBMC = ajmodel.AJLB_MC;
model.YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]);
model.YJJSSJ = Convert.ToDateTime(Request.Form["txt_yjjssj"]);
model.YJZH = random.Next(100000, 999999).ToString();
model.YJMM = random.Next(100000, 999999).ToString();
model.JDSJ = DateTime.Now;
model.JDR = UserInfo.MC;
model.JDRGH = UserInfo.GH;
model.JDBMBM = "";
model.JDBMMC = "";
model.JDDWBM = UserInfo.DWBM;
model.JDDWMC = UserInfo.DWMC;
model.SFSC = "N";
model.YJSQDH = "";//Request.Form["yjsqdh"];
model.JZZTXS = "";
model.DWBM = rybms[1];
EDRS.BLL.YX_DZJZ_LSAJBD bllBD = new EDRS.BLL.YX_DZJZ_LSAJBD(Request);
List <EDRS.Model.YX_DZJZ_LSAJBD> listModel = bllBD.GetModelList(" and YJXH=:YJXH", new object[] { Request.Form["yjxh"] });
if (listModel == null || listModel.Count == 0)
{
if (!bllBD.Add(model))
{
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
}
else
{
yjxh = listModel[0].YJXH;
listModel[0].BMSAH = ajmodel.BMSAH;
listModel[0].GH = rybms[0];
listModel[0].DWBM = rybms[1];
listModel[0].MC = Request.Form["txt_lsxm"];
listModel[0].AJMC = ajmodel.AJMC;
listModel[0].AJLBBM = ajmodel.AJLB_BM;
listModel[0].AJLBMC = ajmodel.AJLB_MC;
listModel[0].YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]);
listModel[0].YJJSSJ = Convert.ToDateTime(Request.Form["txt_yjjssj"]);
if (!bllBD.Update(listModel[0]))
{
return(ReturnString.JsonToString(Prompt.error, "修改分配失败！", null));
}
}
List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList = JsonHelper.JsonToList <EDRS.Model.YX_DZJZ_LSAJWJFP>(json);
if (modelList != null && modelList.Count > 0)
{
EDRS.BLL.YX_DZJZ_LSAJWJFP bll = new EDRS.BLL.YX_DZJZ_LSAJWJFP(Request);
if (bll.AddList(modelList, model, yjxh))
{
return(ReturnString.JsonToString(Prompt.win, "分配成功！", null));
}
}
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
/// <summary>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
//权限状态
EDRS.BLL.TYYW_GG_AJJBXX bll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
DataTable dt = bll.ListBinTable(Request, UserInfo.DWBM, UserInfo.GH, base.GetJsQxzt(), base.GetBmBm());
if (dt != null && dt.Rows.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (dt.Rows.Count > 0)
{
if (dt.Columns.Contains("ISREGARD"))
{
dt.Columns.Remove("ISREGARD");
}
if (dt.Columns.Contains("SFZZ"))
{
dt.Columns.Remove("SFZZ");
}
dt.Columns.Remove("RO");
dt.Columns.Remove("JZSCRXM");
dt.Columns.Remove("CJSJ");
dt.Columns.Remove("GGCJSJ");
dt.Columns.Remove("BMSAH");
dt.Columns.Remove("CBBM_MC");
dt.Columns.Remove("DQJD");
dt.Columns.Remove("AJZT");
dt.Columns.Remove("DQRQ");
dt.Columns.Remove("BJRQ");
dt.Columns.Remove("WCRQ");
dt.Columns.Remove("GDRQ");
dt.Columns.Remove("AJLB_BM");
dt.Columns.Remove("CBDW_BM");
dt.Columns.Remove("SFZH");
dt.Columns.Remove("TARYXX");
dt.Columns.Remove("SHR");
dt.Columns.Remove("ZJS");
dt.Columns.Remove("DJJ");
dt.Columns.Remove("ZYS");
dt.Columns.Remove("JZPZ");
dt.Columns.Remove("JZSHRBH");
dt.Columns.Remove("JZSHR");
dt.Columns.Remove("JZSHSJ");
dt.Columns.Remove("JZBH");
dt.Columns["ZZZT"].ColumnName = "制作状态";
dt.Columns["AJMC"].ColumnName = "案件名称";
dt.Columns["AJBH"].ColumnName = "案件编号";
dt.Columns["WSBH"].ColumnName = "文书编号";
dt.Columns["WSMC"].ColumnName = "文书名称";
dt.Columns["AJLB_MC"].ColumnName = "案件类别";
dt.Columns["XYR"].ColumnName = "嫌疑人姓名";
dt.Columns["SLRQ"].ColumnName = "立案时间";
if (dt.Columns.Contains("CBDW_MC"))
{
dt.Columns["CBDW_MC"].ColumnName = "立卷单位";
}
if (dt.Columns.Contains("AJ_DWMC"))
{
dt.Columns["AJ_DWMC"].ColumnName = "立卷单位";
}
dt.Columns["CBR"].ColumnName = "立卷人";
object zzzt;
object[] desc;
for (int i = 0; i < dt.Rows.Count; i++)
{
zzzt = Enum.Parse(typeof(EnumZzzt), dt.Rows[i]["制作状态"].ToString(), true);
desc = zzzt.GetType().GetField(zzzt.ToString()).GetCustomAttributes(typeof(DescriptionAttribute), true);
if (desc != null && desc.Length > 0)
{
dt.Rows[i]["制作状态"] = (desc[0] as DescriptionAttribute).Description;
}
}
msg = DataToExcel_Ex.Export(dt, "案件基本情况", Server.MapPath("/" + ExcelFolder + "/" + filename));
// filename = dte.DataExcel(dt, ((VersionName)0).ToString()+"基本情况", FilePath, nameList, valueList);
}
if (string.IsNullOrEmpty(msg))
{
return(ReturnString.JsonToString(Prompt.win, "/" + ExcelFolder + "/" + filename, null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(msg), null));
}
}
return(ReturnString.JsonToString(Prompt.error, "导出失败", null));
}
/// <summary>
/// 保存分配案件文件
/// </summary>
/// <returns></returns>
private string AddData()
{
string json = Request.Form["json"];
string yjxh = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); //"山东省院捕受[2015]37000000054号";
string lssq = Request.Form["lssq"];
string[] lssqs = null;
if (string.IsNullOrEmpty(lssq))
{
return(ReturnString.JsonToString(Prompt.error, "请先填写阅卷登记信息！", null));
}
lssqs = lssq.Split(new string[] { "|&|" }, StringSplitOptions.None);
if (lssqs == null || lssqs.Length != 8)
{
return(ReturnString.JsonToString(Prompt.error, "填写的阅卷登记信息不正确！", null));
}
string rybm = "";// Request.Form["lszh_hidd"];
// string[] rybms = rybm.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries);
//if(rybms.Length != 2)
// return ReturnString.JsonToString(Prompt.error, "请选择阅卷人！", null);
/* 2016-9-6 取消设置阅卷时间
* if (Request.Form["txt_yjkssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjkssj"]))
* return ReturnString.JsonToString(Prompt.error, "请设置阅卷开始时间！", null);
* if (Request.Form["txt_yjjssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjjssj"]))
* return ReturnString.JsonToString(Prompt.error, "请设置阅卷结束时间！", null);
* if (Convert.ToDateTime(Request.Form["txt_yjkssj"]) > Convert.ToDateTime(Request.Form["txt_yjjssj"]))
* return ReturnString.JsonToString(Prompt.error, "结束时间不能小于开始时间！", null);
*/
EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
EDRS.Model.TYYW_GG_AJJBXX ajmodel = ajbll.GetModel(Request.Form["key_hidd"]);
if (ajmodel == null)
{
return(ReturnString.JsonToString(Prompt.error, "分配失败，" + ((VersionName)0).ToString() + "不存在！", null));
}
//json = json.Replace("id", "_wjxh").Replace("MLLX", "_fpbm").Replace("text", "_sfsc").Replace("PARENTID", "_yjxh");
#region 阅卷人信息
// localStorage['lssq'] = $("#txt_yjr").val() + "|&|" + zjlx + "|&|" + $("#txt_zjh").val() + "|&|" + yjrsf + "|&|" + cxyy + "|&|" + shr + "|&|" + shbm + "|&|" + $("#txt_shr").val();
EDRS.Model.YX_DZJZ_LSGL lsglModel = new EDRS.Model.YX_DZJZ_LSGL();
lsglModel.LSZH = Guid.NewGuid().ToString();
lsglModel.LSXM = lssqs[0]; //阅卷人
lsglModel.LSDW = lssqs[1]; //证件类型
lsglModel.LSDWDZ = lssqs[3]; //阅卷人身份
lsglModel.LSDWYZHM = "";
lsglModel.LSLXDH = lssqs[2]; //证件号
lsglModel.LSSJ = "";
lsglModel.DELXR = lssqs[4]; //查询原因
lsglModel.DELXRDH = "";
// lsglModel.LSZGYXSJ = ;
lsglModel.SFDXZG = "N";
lsglModel.LSXXBZ = "";
lsglModel.CJSJ = DateTime.Now;
lsglModel.ZHYCYJSJ = null;
lsglModel.SFSC = "N";
#endregion
#region 律师阅卷申请
EDRS.Model.YX_DZJZ_LSYJSQ modelLsyjsq = new EDRS.Model.YX_DZJZ_LSYJSQ();
modelLsyjsq.LSZH = lsglModel.LSZH;
modelLsyjsq.YJSQDH = Guid.NewGuid().ToString();
modelLsyjsq.SQSJ = DateTime.Now;
modelLsyjsq.SQSM = lssqs[6]; //审核部门
modelLsyjsq.SFSC = "N";
modelLsyjsq.SHRGH = lssqs[5]; //审核人工号
modelLsyjsq.SHR = lssqs[7]; //审核人
modelLsyjsq.SHSM = "";
modelLsyjsq.SHSJ = null;
modelLsyjsq.YJSQDM = "";
modelLsyjsq.SQDZT = "T";
#endregion
#region 律师阅卷绑定
Random random = new Random();
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
model.GH = lsglModel.LSZH;
model.BMSAH = ajmodel.BMSAH;
model.YJXH = yjxh;
model.MC = lssqs[0];
model.AJMC = ajmodel.AJMC;
model.AJLBBM = ajmodel.AJLB_BM;
model.AJLBMC = ajmodel.AJLB_MC;
model.YJKSSJ = DateTime.Now; // Convert.ToDateTime(Request.Form["txt_yjkssj"]);
model.YJJSSJ = null; // Convert.ToDateTime(Request.Form["txt_yjjssj"]);
model.YJZH = lssqs[0];
model.YJMM = random.Next(100000, 999999).ToString();
model.JDSJ = DateTime.Now;
model.JDR = UserInfo.MC;
model.JDRGH = UserInfo.GH;
model.JDBMBM = "";
model.JDBMMC = "";
model.JDDWBM = UserInfo.DWBM;
model.JDDWMC = UserInfo.DWMC;
model.SFSC = "N";
model.YJSQDH = modelLsyjsq.YJSQDH;
model.JZZTXS = "";
model.DWBM = UserInfo.DWBM;
#endregion
#region 律师阅卷绑定文件
List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList = JsonHelper.JsonToList <EDRS.Model.YX_DZJZ_LSAJWJFP>(json);
#endregion
EDRS.BLL.YX_DZJZ_LSAJBD bllBD = new EDRS.BLL.YX_DZJZ_LSAJBD(Request);
try
{
if (bllBD.AddList(modelLsyjsq, model, modelList, lsglModel))
{
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配成功", "", UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//return ReturnString.JsonToString(Prompt.win, "分配成功！", null);
}
catch (Exception ex)
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(ex.Message), null));
}
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
/// <summary>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
string strWhere = "";
List <object> values = new List <object>();
int pageIndex = Convert.ToInt32(Request["page"]);
int pageSize = Convert.ToInt32(Request["pagesize"]);
string key = Request["key"]; //部门受案号
string timebegin = Request["timebegin"]; //开始日期
string timeend = Request["timeend"]; //结束日期
string unit = Request["unit"]; //承办单位
string ywbm = Request["ywbm"];
string caseajlb = Request["caseajlb"];
//排序
string sortname = Request["sortname"];
string sortorder = Request["sortorder"];
if (string.IsNullOrEmpty(sortname) || sortname.ToLower() == "cbdw_mc")
{
sortname = "CBDW_BM";
}
sortname += " " + sortorder;
// string qxWhere = "";
// qxWhere = " AND DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0";
//选中时，筛选单位，否则查询所有有权限数据
EDRS.BLL.XT_DM_QX bllQx = new EDRS.BLL.XT_DM_QX(Request);
if (!string.IsNullOrEmpty(unit))
{
string dwbms = unit.Replace(";", ",");
strWhere += " and CBDW_BM in (" + StringPlus.ReplaceSingle(dwbms) + ")";
}
else if (string.IsNullOrEmpty(unit))
{
strWhere += " and AJ.CBDW_BM in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=0 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
}
//案件类别
if (!string.IsNullOrEmpty(caseajlb))
{
string caseajlbs = caseajlb.Replace(";", ",");
strWhere += " and trim(AJ.AJLB_BM) in (" + caseajlbs + ")";
}
else if (string.IsNullOrEmpty(caseajlb))
{
strWhere += " and trim(aj.ajlb_bm) in (select distinct QXBM FROM XT_DM_QX where 1=1 AND JSBM IN (" + base.Jsbms + ") AND QXLX=1 AND trim(DWBM) = '" + base.UserInfo.DWBM + "' AND BMBM in (" + base.Bmbms + ") )";
}
//业务
if (!string.IsNullOrEmpty(ywbm))
{
strWhere += " and LB.YWBM='" + StringPlus.ReplaceSingle(ywbm) + "'";
}
//strWhere += " and (select count(1) from yx_dzjz_jzml y where y.Bmsah=T1.Bmsah) > 0";//已关联
if (!string.IsNullOrEmpty(timebegin))
{
strWhere += " and aj.cjsj >= to_date('" + Convert.ToDateTime(timebegin).ToShortDateString() + "','yyyy-mm-dd')";
}
if (!string.IsNullOrEmpty(timeend))
{
strWhere += " and aj.cjsj <= to_date('" + Convert.ToDateTime(timeend).AddDays(1).ToShortDateString() + "','yyyy-mm-dd')";
}
EDRS.BLL.EDRS_Report bll = new EDRS.BLL.EDRS_Report(Request);
int count = 0;
//1-8 修改存储过程
DataSet ds = bll.GetCaseGroupByUnit(strWhere, UserInfo.DWBM, UserInfo.GH, (pageSize * pageIndex), (pageSize * pageIndex) - pageSize + 1, sortname, out count, values.ToArray());
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0].Copy();
//读取配置文件中的配置
int?isLocalAjxx = EDRS.Common.ConfigHelper.GetConfigInt("IsLocalAjxx");
if (isLocalAjxx == 1)
{
string msg = "";
DateTime?b_date = null;
if (!string.IsNullOrEmpty(timebegin))
{
b_date = Convert.ToDateTime(timebegin);
}
DateTime?e_date = null;
if (!string.IsNullOrEmpty(timeend))
{
e_date = Convert.ToDateTime(timeend);
}
EDRS.Common.IceServicePrx iceprx = new IceServicePrx();
EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
msg = ajbll.GetConfiguration(UserInfo.DWBM, UserInfo.GH, iceprx);
if (!string.IsNullOrEmpty(msg))
{
ReturnString.JsonToString(Prompt.error, msg, null);
}
foreach (DataRow dr in dt.Rows)
{
dr["AJNUM"] = iceprx.GetAjjbxxCount(null, dr["CBDW_BM"].ToString(), b_date, e_date, true, out msg);
dr["WZNUM"] = int.Parse(dr["AJNUM"].ToString()) - int.Parse(dr["ZZNUM"].ToString());
dr["ZZLNUM"] = Math.Round((decimal.Parse(dr["ZZNUM"].ToString()) / decimal.Parse(dr["AJNUM"].ToString())) * 100, 2);
}
}
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
//生成列的中文对应表
//Dictionary<string, string> nameList = new Dictionary<string, string>();
//nameList.Add("CBDW_MC", "承办单位");
//nameList.Add("AJNUM", ((VersionName)0).ToString()+ "受理数");
//nameList.Add("ZZNUM", "已制作数");
//nameList.Add("WZNUM", "未制作数");
//nameList.Add("ZZLNUM", "制作率");
//Dictionary<string, object> valueList = new Dictionary<string, object>();
//valueList.Add("ZZLNUM", "%");
//利用excel对象
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msgs = string.Empty;
if (dt.Rows.Count > 0)
{
dt.Columns.Remove("Ro");
dt.Columns.Remove("CBDW_BM");
dt.Columns["CBDW_MC"].ColumnName = "承办单位";
dt.Columns["AJNUM"].ColumnName = ((VersionName)0).ToString() + "受理数";
dt.Columns["ZZNUM"].ColumnName = "已制作数";
dt.Columns["WZNUM"].ColumnName = "未制作数";
dt.Columns["ZZLNUM"].ColumnName = "制作率";
msgs = DataToExcel_Ex.Export(dt, "卷宗制作率统计", Server.MapPath("/" + ExcelFolder + "/" + filename));
//filename = dte.DataExcel(dt, "卷宗制作率统计", FilePath, nameList, valueList);
}
if (string.IsNullOrEmpty(msgs))
{
return(ReturnString.JsonToString(Prompt.win, "/" + ExcelFolder + "/" + filename, null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(msgs), null));
}
}
return(ReturnString.JsonToString(Prompt.error, "导出失败", null));
}
