/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_LSAJBD GetModel(string YJXH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select GH,BMSAH,YJXH,MC,AJMC,AJLBBM,AJLBMC,YJKSSJ,YJJSSJ,YJZH,YJMM,JDSJ,JDR,JDRGH,JDBMBM,JDBMMC,JDDWBM,JDDWMC,SFSC,YJSQDH,DWBM from YX_DZJZ_LSAJBD "); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where YJXH=:YJXH "); OracleParameter[] parameters = { new OracleParameter(":YJXH", OracleType.VarChar, 50) }; parameters[0].Value = YJXH; EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD(); DataSet ds = null; try { ds = DbHelperOra.Query(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public EDRS.Model.YX_DZJZ_LSAJBD GetModel(string YJXH)", "EDRS.OracleDAL.YX_DZJZ_LSAJBD", strSql.ToString(), parameters); } if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private Dictionary <object, object> LSAJBD(EDRS.Model.YX_DZJZ_LSAJBD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YX_DZJZ_LSAJBD("); strSql.Append("GH,BMSAH,MC,AJMC,AJLBBM,AJLBMC,YJKSSJ,YJJSSJ,YJZH,YJMM,JDSJ,JDR,JDRGH,JDBMBM,JDBMMC,JDDWBM,JDDWMC,SFSC,YJSQDH,DWBM)"); strSql.Append(" values ("); strSql.Append(":GH,:BMSAH,:MC,:AJMC,:AJLBBM,:AJLBMC,:YJKSSJ,:YJJSSJ,:YJZH,:YJMM,:JDSJ,:JDR,:JDRGH,:JDBMBM,:JDBMMC,:JDDWBM,:JDDWMC,:SFSC,:YJSQDH,:DWBM)"); OracleParameter[] parameters = { new OracleParameter(":GH", OracleType.VarChar, 100), new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":MC", OracleType.VarChar, 60), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLBBM", OracleType.VarChar, 50), new OracleParameter(":AJLBMC", OracleType.VarChar, 50), new OracleParameter(":YJKSSJ", OracleType.DateTime), new OracleParameter(":YJJSSJ", OracleType.DateTime), new OracleParameter(":YJZH", OracleType.VarChar, 100), new OracleParameter(":YJMM", OracleType.Char, 8), new OracleParameter(":JDSJ", OracleType.DateTime), new OracleParameter(":JDR", OracleType.VarChar, 60), new OracleParameter(":JDRGH", OracleType.Char, 4), new OracleParameter(":JDBMBM", OracleType.Char, 4), new OracleParameter(":JDBMMC", OracleType.VarChar, 300), new OracleParameter(":JDDWBM", OracleType.VarChar, 50), new OracleParameter(":JDDWMC", OracleType.VarChar, 300), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":YJSQDH", OracleType.VarChar, 50), new OracleParameter(":DWBM", OracleType.VarChar, 50) }; parameters[0].Value = model.GH; parameters[1].Value = model.BMSAH; parameters[2].Value = model.MC; parameters[3].Value = model.AJMC; parameters[4].Value = model.AJLBBM; parameters[5].Value = model.AJLBMC; parameters[6].Value = model.YJKSSJ; parameters[7].Value = model.YJJSSJ; parameters[8].Value = model.YJZH; parameters[9].Value = model.YJMM; parameters[10].Value = model.JDSJ; parameters[11].Value = model.JDR; parameters[12].Value = model.JDRGH; parameters[13].Value = model.JDBMBM; parameters[14].Value = model.JDBMMC; parameters[15].Value = model.JDDWBM; parameters[16].Value = model.JDDWMC; parameters[17].Value = model.SFSC; parameters[18].Value = model.YJSQDH; parameters[19].Value = model.DWBM; Dictionary <object, object> hash = new Dictionary <object, object>(); hash.Add(strSql.ToString(), parameters); return(hash); }
/// <summary> /// 增加多条数据 /// </summary> public bool AddList(List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList, EDRS.Model.YX_DZJZ_LSAJBD lsajbdModel, string yjxh) { int count = 0; //Hashtable hash = new Hashtable(); Dictionary <object, object> hash = new Dictionary <object, object>(); // hash = LSAJBD(lsajbdModel); StringBuilder strSql = new StringBuilder(); strSql.Append(" update YX_DZJZ_LSAJWJFP set SFSC='Y' where YJXH=:YJXHUP "); OracleParameter[] parameters1 = { new OracleParameter(":YJXHUP", OracleType.VarChar, 50) }; parameters1[0].Value = yjxh; hash.Add(strSql.ToString(), parameters1); foreach (EDRS.Model.YX_DZJZ_LSAJWJFP model in modelList) { strSql.Clear(); strSql.Append(" insert into YX_DZJZ_LSAJWJFP("); strSql.Append("YJXH,WJXH,SFSC)"); strSql.Append(" values ("); strSql.Append(":YJXH" + count + ",:WJXH" + count + ",:SFSC" + count + ")"); OracleParameter[] parameters = { new OracleParameter(":YJXH" + count, OracleType.VarChar, 50), new OracleParameter(":WJXH" + count, OracleType.VarChar, 100), new OracleParameter(":SFSC" + count, OracleType.Char, 1) }; parameters[0].Value = yjxh; parameters[1].Value = model.WJXH; parameters[2].Value = "N"; hash.Add(strSql.ToString(), parameters); count++; } try { return(DbHelperOra.ExecuteSqlTran(hash)); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddList(List<EDRS.Model.YX_DZJZ_LSAJWJFP> modelList)", "EDRS.OracleDAL.YX_DZJZ_LSAJWJFP"); } return(false); }
public void ProcessRequest(HttpContext context) { string action = context.Request.Params["action"]; switch (action) { case "Time": EDRS.Model.YX_DZJZ_LSAJBD model = context.Session["YjData"] as EDRS.Model.YX_DZJZ_LSAJBD; if (model != null && model.YJJSSJ != null && model.YJJSSJ.Value.CompareTo(DateTime.Now) > 0) { TimeSpan ts = model.YJJSSJ.Value.Subtract(DateTime.Now); context.Response.Write((ts.Days > 0 ? ts.Days + "天 " : "") + ts.Hours.ToString().PadLeft(2, '0') + ":" + ts.Minutes.ToString().PadLeft(2, '0') + ":" + ts.Seconds.ToString().PadLeft(2, '0')); } else { context.Session["YjData"] = null; context.Response.Write("N"); } break; } }
public string submitapplyall() { EDRS.BLL.YX_DZJZ_JZMLWJ bll = new EDRS.BLL.YX_DZJZ_JZMLWJ(Request); EDRS.BLL.YX_DZJZ_WJSQDY BLLSQ = new EDRS.BLL.YX_DZJZ_WJSQDY(Request); string idstr = Request.Form["idstr[]"]; string yjxh = Request.Form["yjxh"]; if (!string.IsNullOrEmpty(idstr)) { #region 申请打印 EDRS.BLL.YX_DZJZ_LSAJBD dbbll = new EDRS.BLL.YX_DZJZ_LSAJBD(Request); //获取部门部门受案号 EDRS.Model.YX_DZJZ_LSAJBD dbmodel = dbbll.GetModel(yjxh); //判断该申请打印是否存在 EDRS.Model.YX_DZJZ_WJSQDY model = BLLSQ.GetModelByYJXH(yjxh); if (model != null) { model.SQSJ = DateTime.Now; model.DYR = ""; model.DYRGH = ""; model.DYSJ = null; } else { model = new EDRS.Model.YX_DZJZ_WJSQDY(); model.BMSAH = dbmodel.BMSAH; model.DYBMBM = ""; //打印部门编码 model.DYBMMC = ""; model.DYDWBM = ""; model.DYDWMC = ""; model.DYFS = null; //打印份数 model.DYFY = null; //打印费用 model.DYR = ""; //打印人 model.DYRGH = ""; //打印人工号 model.DYSJ = null; //打印时间 model.LSZH = Request.Form["lszh"]; //律师证号 model.DYSQDH = DateTime.Now.ToString("yyyyMMddHHmmssfff") + model.LSZH; model.JZWJBH = ""; //文件编号 model.SFSC = "N"; model.SQFS = 1; //申请份数 model.SQSJ = DateTime.Now; //申请时间 model.YJXH = yjxh; //阅卷序号 model.XH = Guid.NewGuid().ToString(); } #endregion #region 申请打印记录 List <EDRS.Model.YX_DZJZ_WJSQDYJL> sqjlList = new List <EDRS.Model.YX_DZJZ_WJSQDYJL>(); string[] idarr = idstr.Split(','); //根据序号获取打印记录 DataSet ds = BLLSQ.GetListDYJL(" and XH ='" + model.XH + "'"); EDRS.Model.YX_DZJZ_WJSQDYJL sqjlModel = null; for (int i = 0; i < idarr.Length; i++) { DataRow[] dr = null; if (ds != null) { dr = ds.Tables[0].Select("WJXH='" + idarr[i] + "'"); } if (dr == null || dr.Length == 0) { sqjlModel = new EDRS.Model.YX_DZJZ_WJSQDYJL(); sqjlModel.WJXH = idarr[i]; sqjlModel.XH = model.XH; sqjlModel.YJXH = model.YJXH; sqjlModel.ADDTIME = DateTime.Now; sqjlModel.SFSC = "N"; sqjlList.Add(sqjlModel); } } #endregion if (BLLSQ.AddListJL(sqjlList, model, model.XH)) { return(ReturnString.JsonToString(Prompt.win, "提交申请成功", null)); } else { return(ReturnString.JsonToString(Prompt.error, "提交申请失败", 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 != 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> /// 增加多条数据 /// </summary> public bool AddList(EDRS.Model.YX_DZJZ_LSYJSQ lsyjsqModel, EDRS.Model.YX_DZJZ_LSAJBD lsajbdModel, List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList, EDRS.Model.YX_DZJZ_LSGL lsglModel) { int count = 0; Dictionary <object, object> hash = new Dictionary <object, object>(); StringBuilder strSql = new StringBuilder(); strSql.Append(" update YX_DZJZ_LSAJWJFP set SFSC='Y' where YJXH=:YJXHUP "); OracleParameter[] parameters1 = { new OracleParameter(":YJXHUP", OracleType.VarChar, 50) }; parameters1[0].Value = lsajbdModel.YJXH; hash.Add(strSql.ToString(), parameters1); #region 阅卷人信息 strSql.Clear(); strSql.Append("insert into YX_DZJZ_LSGL("); strSql.Append("LSZH,LSXM,LSDW,LSDWDZ,LSDWYZHM,LSLXDH,LSSJ,DELXR,DELXRDH,LSZGYXSJ,SFDXZG,LSXXBZ,CJSJ,ZHYCYJSJ,SFSC)"); strSql.Append(" values ("); strSql.Append(":LSZH,:LSXM,:LSDW,:LSDWDZ,:LSDWYZHM,:LSLXDH,:LSSJ,:DELXR,:DELXRDH,:LSZGYXSJ,:SFDXZG,:LSXXBZ,:CJSJ,:ZHYCYJSJ,:SFSC)"); OracleParameter[] parameters4 = { new OracleParameter(":LSZH", OracleType.VarChar, 100), new OracleParameter(":LSXM", OracleType.VarChar, 60), new OracleParameter(":LSDW", OracleType.VarChar, 300), new OracleParameter(":LSDWDZ", OracleType.VarChar, 300), new OracleParameter(":LSDWYZHM", OracleType.Char, 6), new OracleParameter(":LSLXDH", OracleType.VarChar, 50), new OracleParameter(":LSSJ", OracleType.VarChar, 50), new OracleParameter(":DELXR", OracleType.VarChar, 60), new OracleParameter(":DELXRDH", OracleType.VarChar, 50), new OracleParameter(":LSZGYXSJ", OracleType.DateTime), new OracleParameter(":SFDXZG", OracleType.Char, 1), new OracleParameter(":LSXXBZ", OracleType.VarChar, 300), new OracleParameter(":CJSJ", OracleType.DateTime), new OracleParameter(":ZHYCYJSJ", OracleType.DateTime), new OracleParameter(":SFSC", OracleType.Char, 1) }; parameters4[0].Value = lsglModel.LSZH; parameters4[1].Value = lsglModel.LSXM; parameters4[2].Value = lsglModel.LSDW; parameters4[3].Value = lsglModel.LSDWDZ; parameters4[4].Value = lsglModel.LSDWYZHM; parameters4[5].Value = lsglModel.LSLXDH; parameters4[6].Value = lsglModel.LSSJ; parameters4[7].Value = lsglModel.DELXR; parameters4[8].Value = lsglModel.DELXRDH; parameters4[9].Value = lsglModel.LSZGYXSJ ?? (object)DBNull.Value; parameters4[10].Value = lsglModel.SFDXZG; parameters4[11].Value = lsglModel.LSXXBZ; parameters4[12].Value = lsglModel.CJSJ; parameters4[13].Value = lsglModel.ZHYCYJSJ ?? (object)DBNull.Value; parameters4[14].Value = lsglModel.SFSC; hash.Add(strSql.ToString(), parameters4); #endregion #region 律师申请 strSql.Clear(); strSql.Append("insert into YX_DZJZ_LSYJSQ("); strSql.Append("LSZH,SQSJ,SQSM,SFSC,SHRGH,SHR,SHSM,SHSJ,YJSQDM,SQDZT,YJSQDH)"); strSql.Append(" values ("); strSql.Append(":LSZH,:SQSJ,:SQSM,:SFSC,:SHRGH,:SHR,:SHSM,:SHSJ,:YJSQDM,:SQDZT,:YJSQDH)"); OracleParameter[] parameters2 = { new OracleParameter(":LSZH", OracleType.VarChar, 100), new OracleParameter(":SQSJ", OracleType.DateTime), new OracleParameter(":SQSM", OracleType.VarChar, 300), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":SHRGH", OracleType.Char, 4), new OracleParameter(":SHR", OracleType.VarChar, 60), new OracleParameter(":SHSM", OracleType.VarChar, 300), new OracleParameter(":SHSJ", OracleType.DateTime), new OracleParameter(":YJSQDM", OracleType.VarChar, 300), new OracleParameter(":SQDZT", OracleType.Char, 5), new OracleParameter(":YJSQDH", OracleType.VarChar, 50) }; parameters2[0].Value = (object)lsyjsqModel.LSZH ?? DBNull.Value; parameters2[1].Value = (object)lsyjsqModel.SQSJ ?? DBNull.Value; parameters2[2].Value = (object)lsyjsqModel.SQSM ?? DBNull.Value; parameters2[3].Value = (object)lsyjsqModel.SFSC ?? DBNull.Value; parameters2[4].Value = (object)lsyjsqModel.SHRGH ?? DBNull.Value; parameters2[5].Value = (object)lsyjsqModel.SHR ?? DBNull.Value; parameters2[6].Value = (object)lsyjsqModel.SHSM ?? DBNull.Value; parameters2[7].Value = (object)lsyjsqModel.SHSJ ?? DBNull.Value; parameters2[8].Value = (object)lsyjsqModel.YJSQDM ?? DBNull.Value; parameters2[9].Value = (object)lsyjsqModel.SQDZT ?? DBNull.Value; parameters2[10].Value = lsyjsqModel.YJSQDH; hash.Add(strSql.ToString(), parameters2); #endregion #region 律师阅卷绑定 strSql.Clear(); strSql.Append("insert into YX_DZJZ_LSAJBD("); strSql.Append("GH,BMSAH,MC,AJMC,AJLBBM,AJLBMC,YJKSSJ,YJJSSJ,YJZH,YJMM,JDSJ,JDR,JDRGH,JDBMBM,JDBMMC,JDDWBM,JDDWMC,SFSC,YJSQDH,YJXH,DWBM)"); strSql.Append(" values ("); strSql.Append(":GH,:BMSAH,:MC,:AJMC,:AJLBBM,:AJLBMC,:YJKSSJ,:YJJSSJ,:YJZH,:YJMM,:JDSJ,:JDR,:JDRGH,:JDBMBM,:JDBMMC,:JDDWBM,:JDDWMC,:SFSC,:YJSQDH,:YJXH,:DWBM)"); OracleParameter[] parameters3 = { new OracleParameter(":GH", OracleType.VarChar, 100), new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":MC", OracleType.VarChar, 60), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLBBM", OracleType.VarChar, 50), new OracleParameter(":AJLBMC", OracleType.VarChar, 50), new OracleParameter(":YJKSSJ", OracleType.DateTime), new OracleParameter(":YJJSSJ", OracleType.DateTime), new OracleParameter(":YJZH", OracleType.VarChar, 100), new OracleParameter(":YJMM", OracleType.Char, 8), new OracleParameter(":JDSJ", OracleType.DateTime), new OracleParameter(":JDR", OracleType.VarChar, 60), new OracleParameter(":JDRGH", OracleType.Char, 4), new OracleParameter(":JDBMBM", OracleType.Char, 4), new OracleParameter(":JDBMMC", OracleType.VarChar, 300), new OracleParameter(":JDDWBM", OracleType.VarChar, 50), new OracleParameter(":JDDWMC", OracleType.VarChar, 300), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":YJSQDH", OracleType.VarChar, 50), new OracleParameter(":YJXH", OracleType.VarChar, 50), new OracleParameter(":DWBM", OracleType.VarChar, 50) }; parameters3[0].Value = lsajbdModel.GH ?? ""; parameters3[1].Value = lsajbdModel.BMSAH ?? ""; parameters3[2].Value = lsajbdModel.MC ?? ""; parameters3[3].Value = lsajbdModel.AJMC ?? ""; parameters3[4].Value = lsajbdModel.AJLBBM ?? ""; parameters3[5].Value = lsajbdModel.AJLBMC ?? ""; parameters3[6].Value = lsajbdModel.YJKSSJ ?? (object)DBNull.Value; parameters3[7].Value = lsajbdModel.YJJSSJ ?? (object)DBNull.Value; parameters3[8].Value = lsajbdModel.YJZH ?? ""; parameters3[9].Value = lsajbdModel.YJMM ?? ""; parameters3[10].Value = lsajbdModel.JDSJ; parameters3[11].Value = lsajbdModel.JDR ?? ""; parameters3[12].Value = lsajbdModel.JDRGH ?? ""; parameters3[13].Value = lsajbdModel.JDBMBM ?? ""; parameters3[14].Value = lsajbdModel.JDBMMC ?? ""; parameters3[15].Value = lsajbdModel.JDDWBM ?? ""; parameters3[16].Value = lsajbdModel.JDDWMC ?? ""; parameters3[17].Value = lsajbdModel.SFSC ?? ""; parameters3[18].Value = lsajbdModel.YJSQDH ?? ""; parameters3[19].Value = lsajbdModel.YJXH ?? ""; parameters3[20].Value = lsajbdModel.DWBM ?? ""; hash.Add(strSql.ToString(), parameters3); #endregion #region 律师阅卷文件绑定 foreach (EDRS.Model.YX_DZJZ_LSAJWJFP model in modelList) { strSql.Clear(); strSql.Append(" insert into YX_DZJZ_LSAJWJFP("); strSql.Append("YJXH,WJXH,SFSC)"); strSql.Append(" values ("); strSql.AppendFormat(":YJXH{0},:WJXH{0},:SFSC{0})", count); OracleParameter[] parameters = { new OracleParameter(":YJXH" + count, OracleType.VarChar, 50), new OracleParameter(":WJXH" + count, OracleType.VarChar, 100), new OracleParameter(":SFSC" + count, OracleType.Char, 1) }; parameters[0].Value = lsajbdModel.YJXH; parameters[1].Value = model.WJXH; parameters[2].Value = "N"; hash.Add(strSql.ToString(), parameters); count++; } #endregion try { return(DbHelperOra.ExecuteSqlTran(hash)); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddList(EDRS.Model.YX_DZJZ_LSYJSQ lsyjsqModel, EDRS.Model.YX_DZJZ_LSAJBD lsajbdModel, List<EDRS.Model.YX_DZJZ_LSAJWJFP> modelList)", "EDRS.OracleDAL.YX_DZJZ_LSAJBD"); } return(false); }
/// <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)); }
public object[] SetYjKh(string kh, string yjxh) { if (string.IsNullOrEmpty(kh) || string.IsNullOrEmpty(yjxh)) { return(new object[] { false, "卡号和阅卷序号不能为空" }); } EDRS.BLL.YX_DZJZ_LSAJBD bll = new EDRS.BLL.YX_DZJZ_LSAJBD(HttpContext.Current.Request); try { DataSet ds = bll.GetYZYJZH(" and JDBMMC=:JDBMMC", new object[] { kh }); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { DataRow[] dr = ds.Tables[0].Select("SQDZT='X'"); if (dr.Length > 0) { return new object[] { false, "该卡正在使用" } } ; } EDRS.Model.YX_DZJZ_LSAJBD model = bll.GetModel(yjxh); if (model != null) { model.JDBMMC = kh; try { if (bll.Update(model)) { EDRS.BLL.YX_DZJZ_LSYJSQ bllsq = new EDRS.BLL.YX_DZJZ_LSYJSQ(HttpContext.Current.Request); List <EDRS.Model.YX_DZJZ_LSYJSQ> list = bllsq.GetModelList(" and LSZH=:LSZH", new object[] { model.GH }); if (list != null && list.Count > 0) { list[0].SQDZT = "X"; if (bllsq.Update(list[0])) { return new object[] { true, "写卡成功" } } ; else { model.JDBMMC = ""; bll.Update(model); } } } } catch (Exception ex) { return(new object[] { false, ex.Message }); } return(new object[] { false, "写卡失败" }); } return(new object[] { false, "阅卷信息不存在" }); } } catch (Exception ex) { return(new object[] { false, ex.Message }); } return(new object[] { false, "验证卡号失败" }); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.YX_DZJZ_LSAJBD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YX_DZJZ_LSAJBD("); strSql.Append("GH,BMSAH,MC,AJMC,AJLBBM,AJLBMC,YJKSSJ,YJJSSJ,YJZH,YJMM,JDSJ,JDR,JDRGH,JDBMBM,JDBMMC,JDDWBM,JDDWMC,SFSC,YJSQDH,YJXH,DWBM)"); strSql.Append(" values ("); strSql.Append(":GH,:BMSAH,:MC,:AJMC,:AJLBBM,:AJLBMC,:YJKSSJ,:YJJSSJ,:YJZH,:YJMM,:JDSJ,:JDR,:JDRGH,:JDBMBM,:JDBMMC,:JDDWBM,:JDDWMC,:SFSC,:YJSQDH,:YJXH,:DWBM)"); OracleParameter[] parameters = { new OracleParameter(":GH", OracleType.VarChar, 100), new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":MC", OracleType.VarChar, 60), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLBBM", OracleType.VarChar, 50), new OracleParameter(":AJLBMC", OracleType.VarChar, 50), new OracleParameter(":YJKSSJ", OracleType.DateTime), new OracleParameter(":YJJSSJ", OracleType.DateTime), new OracleParameter(":YJZH", OracleType.VarChar, 100), new OracleParameter(":YJMM", OracleType.Char, 8), new OracleParameter(":JDSJ", OracleType.DateTime), new OracleParameter(":JDR", OracleType.VarChar, 60), new OracleParameter(":JDRGH", OracleType.Char, 4), new OracleParameter(":JDBMBM", OracleType.Char, 4), new OracleParameter(":JDBMMC", OracleType.VarChar, 300), new OracleParameter(":JDDWBM", OracleType.VarChar, 50), new OracleParameter(":JDDWMC", OracleType.VarChar, 300), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":YJSQDH", OracleType.VarChar, 50), new OracleParameter(":YJXH", OracleType.VarChar, 50), new OracleParameter(":DWBM", OracleType.VarChar, 50) }; parameters[0].Value = model.GH ?? ""; parameters[1].Value = model.BMSAH ?? ""; parameters[2].Value = model.MC ?? ""; parameters[3].Value = model.AJMC ?? ""; parameters[4].Value = model.AJLBBM ?? ""; parameters[5].Value = model.AJLBMC ?? ""; parameters[6].Value = model.YJKSSJ; parameters[7].Value = model.YJJSSJ; parameters[8].Value = model.YJZH ?? ""; parameters[9].Value = model.YJMM ?? ""; parameters[10].Value = model.JDSJ; parameters[11].Value = model.JDR ?? ""; parameters[12].Value = model.JDRGH ?? ""; parameters[13].Value = model.JDBMBM ?? ""; parameters[14].Value = model.JDBMMC ?? ""; parameters[15].Value = model.JDDWBM ?? ""; parameters[16].Value = model.JDDWMC ?? ""; parameters[17].Value = model.SFSC ?? ""; parameters[18].Value = model.YJSQDH ?? ""; parameters[19].Value = model.YJXH ?? ""; parameters[20].Value = model.DWBM ?? ""; int rows = 0; try { rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.YX_DZJZ_LSAJBD model)", "EDRS.OracleDAL.YX_DZJZ_LSAJBD", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_LSAJBD DataRowToModel(DataRow row) { EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD(); if (row != null) { if (row["GH"] != null) { model.GH = row["GH"].ToString(); } if (row["DWBM"] != null) { model.DWBM = row["DWBM"].ToString(); } if (row["BMSAH"] != null) { model.BMSAH = row["BMSAH"].ToString(); } if (row["YJXH"] != null && row["YJXH"].ToString() != "") { model.YJXH = row["YJXH"].ToString(); } if (row["MC"] != null) { model.MC = row["MC"].ToString(); } if (row["AJMC"] != null) { model.AJMC = row["AJMC"].ToString(); } if (row["AJLBBM"] != null) { model.AJLBBM = row["AJLBBM"].ToString(); } if (row["AJLBMC"] != null) { model.AJLBMC = row["AJLBMC"].ToString(); } if (row["YJKSSJ"] != null && row["YJKSSJ"].ToString() != "") { model.YJKSSJ = DateTime.Parse(row["YJKSSJ"].ToString()); } if (row["YJJSSJ"] != null && row["YJJSSJ"].ToString() != "") { model.YJJSSJ = DateTime.Parse(row["YJJSSJ"].ToString()); } if (row["YJZH"] != null) { model.YJZH = row["YJZH"].ToString(); } if (row["YJMM"] != null) { model.YJMM = row["YJMM"].ToString(); } if (row["JDSJ"] != null && row["JDSJ"].ToString() != "") { model.JDSJ = DateTime.Parse(row["JDSJ"].ToString()); } if (row["JDR"] != null) { model.JDR = row["JDR"].ToString(); } if (row["JDRGH"] != null) { model.JDRGH = row["JDRGH"].ToString(); } if (row["JDBMBM"] != null) { model.JDBMBM = row["JDBMBM"].ToString(); } if (row["JDBMMC"] != null) { model.JDBMMC = row["JDBMMC"].ToString(); } if (row["JDDWBM"] != null) { model.JDDWBM = row["JDDWBM"].ToString(); } if (row["JDDWMC"] != null) { model.JDDWMC = row["JDDWMC"].ToString(); } if (row["SFSC"] != null) { model.SFSC = row["SFSC"].ToString(); } if (row["YJSQDH"] != null) { model.YJSQDH = row["YJSQDH"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.YX_DZJZ_LSAJBD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update YX_DZJZ_LSAJBD set "); strSql.Append("MC=:MC,"); strSql.Append("AJMC=:AJMC,"); strSql.Append("AJLBBM=:AJLBBM,"); strSql.Append("AJLBMC=:AJLBMC,"); strSql.Append("YJKSSJ=:YJKSSJ,"); strSql.Append("YJJSSJ=:YJJSSJ,"); strSql.Append("YJZH=:YJZH,"); strSql.Append("YJMM=:YJMM,"); strSql.Append("JDSJ=:JDSJ,"); strSql.Append("JDR=:JDR,"); strSql.Append("JDRGH=:JDRGH,"); strSql.Append("JDBMBM=:JDBMBM,"); strSql.Append("JDBMMC=:JDBMMC,"); strSql.Append("JDDWBM=:JDDWBM,"); strSql.Append("JDDWMC=:JDDWMC,"); strSql.Append("SFSC=:SFSC,"); strSql.Append("YJSQDH=:YJSQDH,"); strSql.Append("GH=:GH,"); strSql.Append("BMSAH=:BMSAH,"); strSql.Append("DWBM=:DWBM"); strSql.Append(" where YJXH=:YJXH "); OracleParameter[] parameters = { new OracleParameter(":MC", OracleType.VarChar, 60), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLBBM", OracleType.VarChar, 50), new OracleParameter(":AJLBMC", OracleType.VarChar, 50), new OracleParameter(":YJKSSJ", OracleType.DateTime), new OracleParameter(":YJJSSJ", OracleType.DateTime), new OracleParameter(":YJZH", OracleType.VarChar, 100), new OracleParameter(":YJMM", OracleType.Char, 8), new OracleParameter(":JDSJ", OracleType.DateTime), new OracleParameter(":JDR", OracleType.VarChar, 60), new OracleParameter(":JDRGH", OracleType.Char, 4), new OracleParameter(":JDBMBM", OracleType.Char, 4), new OracleParameter(":JDBMMC", OracleType.VarChar, 300), new OracleParameter(":JDDWBM", OracleType.VarChar, 50), new OracleParameter(":JDDWMC", OracleType.VarChar, 300), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":YJSQDH", OracleType.VarChar, 50), new OracleParameter(":GH", OracleType.VarChar, 100), new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":YJXH", OracleType.VarChar, 50), new OracleParameter(":DWBM", OracleType.VarChar, 50) }; parameters[0].Value = model.MC ?? (object)DBNull.Value; parameters[1].Value = model.AJMC ?? (object)DBNull.Value; parameters[2].Value = model.AJLBBM ?? (object)DBNull.Value; parameters[3].Value = model.AJLBMC ?? (object)DBNull.Value; parameters[4].Value = model.YJKSSJ ?? (object)DBNull.Value; parameters[5].Value = model.YJJSSJ ?? (object)DBNull.Value; parameters[6].Value = model.YJZH ?? (object)DBNull.Value; parameters[7].Value = model.YJMM ?? (object)DBNull.Value; parameters[8].Value = model.JDSJ ?? (object)DBNull.Value; parameters[9].Value = model.JDR ?? (object)DBNull.Value; parameters[10].Value = model.JDRGH ?? (object)DBNull.Value; parameters[11].Value = model.JDBMBM ?? (object)DBNull.Value; parameters[12].Value = model.JDBMMC ?? (object)DBNull.Value; parameters[13].Value = model.JDDWBM ?? (object)DBNull.Value; parameters[14].Value = model.JDDWMC ?? (object)DBNull.Value; parameters[15].Value = model.SFSC ?? (object)DBNull.Value; parameters[16].Value = model.YJSQDH ?? (object)DBNull.Value; parameters[17].Value = model.GH ?? (object)DBNull.Value; parameters[18].Value = model.BMSAH ?? (object)DBNull.Value; parameters[19].Value = model.YJXH ?? (object)DBNull.Value; parameters[20].Value = model.DWBM ?? (object)DBNull.Value; int rows = 0; try { rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.YX_DZJZ_LSAJBD model)", "EDRS.OracleDAL.YX_DZJZ_LSAJBD", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <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)); }