/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.TYYW_GG_AJJBXX GetModel(string BMSAH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AJBH,jz.WSBH,jz.WSMC,ZZZT,t.BMSAH,TYSAH,SFSC,SFYGXTSJ,CBDW_BM,CBDW_MC,FQDWBM,FQL,CJSJ,ZHXGSJ,SLRQ,AJMC,AJLB_BM,AJLB_MC,ZCJG_DWDM,ZCJG_DWMC,YSDW_DWDM,YSDW_DWMC,YSWSWH,YSAY_AYDM,YSAY_AYMC,YSQTAY_AYDMS,YSQTAY_AYMCS,CBRGH,CBR,CBBM_BM,CBBM_MC,AJZT,SFSWAJ,SFDBAJ,ZXHD_MC,WCRQ,GDRQ,GDRGH,GDR,AQZY,DQJD,BLKSRQ,BLTS,DQRQ,BJRQ,YJZT,JYYJZT,JYYJHCQXYRGS,LCSLBH,FXDJ,SFGZAJ,FZ,YSYJ_DM,YSYJ_MC,SFJBAJ,ZXHD_DM,DQYJJD,YASCSSJD_DM,YASCSSJD_MC,YSRJDH,XYR,SFZH,TARYXX,SHR,ZJS,DJJ,ZYS from TYYW_GG_AJJBXX t left join (select BMSAH,AJBH,WSBH,WSMC,ZZZT,JZPZ from yx_dzjz_jzjbxx) jz on(t.Bmsah = jz.BMSAH)"); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where t.BMSAH=:BMSAH "); OracleParameter[] parameters = { new OracleParameter(":BMSAH", OracleType.VarChar, 100) }; parameters[0].Value = BMSAH; EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX(); 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.TYYW_GG_AJJBXX GetModel(string BMSAH)", "EDRS.OracleDAL.TYYW_GG_AJJBXX", strSql.ToString(), parameters); } if (ds != null && ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 根据编号获取数据 /// </summary> /// <returns></returns> public string GetModel(string BMSAH) { if (string.IsNullOrEmpty(BMSAH)) { BMSAH = Request["id"]; if (string.IsNullOrEmpty(BMSAH)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request); EDRS.Model.TYYW_GG_AJJBXX model = jzajxx.GetModel(BMSAH); if (model != null) { return(JsonHelper.JsonString(model)); } 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.TYYW_GG_AJJBXX model, EDRS.Model.TYYW_GG_AJJBXXKZ modelkz, EDRS.Model.YX_DZJZ_JZJBXX modeljbxx) { System.Collections.Hashtable hash = new System.Collections.Hashtable(); StringBuilder strSql = new StringBuilder(); if (model != null) { #region 案件基本信息 strSql.Append("insert into TYYW_GG_AJJBXX("); strSql.Append("BMSAH,TYSAH,SFSC,SFYGXTSJ,CBDW_BM,CBDW_MC,FQDWBM,FQL,CJSJ,ZHXGSJ,SLRQ,AJMC,AJLB_BM,AJLB_MC,ZCJG_DWDM,ZCJG_DWMC,YSDW_DWDM,YSDW_DWMC,YSWSWH,YSAY_AYDM,YSAY_AYMC,YSQTAY_AYDMS,YSQTAY_AYMCS,CBRGH,CBR,CBBM_BM,CBBM_MC,AJZT,SFSWAJ,SFDBAJ,ZXHD_MC,WCRQ,GDRQ,GDRGH,GDR,AQZY,DQJD,BLKSRQ,BLTS,DQRQ,BJRQ,YJZT,JYYJZT,JYYJHCQXYRGS,LCSLBH,FXDJ,SFGZAJ,FZ,YSYJ_DM,YSYJ_MC,SFJBAJ,ZXHD_DM,DQYJJD,YASCSSJD_DM,YASCSSJD_MC,YSRJDH,XYR,SFZH,TARYXX,SHR,SHSJ,ZJS,DJJ,ZYS)"); strSql.Append(" values ("); strSql.Append(":BMSAH,:TYSAH,:SFSC,:SFYGXTSJ,:CBDW_BM,:CBDW_MC,:FQDWBM,:FQL,:CJSJ,:ZHXGSJ,:SLRQ,:AJMC,:AJLB_BM,:AJLB_MC,:ZCJG_DWDM,:ZCJG_DWMC,:YSDW_DWDM,:YSDW_DWMC,:YSWSWH,:YSAY_AYDM,:YSAY_AYMC,:YSQTAY_AYDMS,:YSQTAY_AYMCS,:CBRGH,:CBR,:CBBM_BM,:CBBM_MC,:AJZT,:SFSWAJ,:SFDBAJ,:ZXHD_MC,:WCRQ,:GDRQ,:GDRGH,:GDR,:AQZY,:DQJD,:BLKSRQ,:BLTS,:DQRQ,:BJRQ,:YJZT,:JYYJZT,:JYYJHCQXYRGS,:LCSLBH,:FXDJ,:SFGZAJ,:FZ,:YSYJ_DM,:YSYJ_MC,:SFJBAJ,:ZXHD_DM,:DQYJJD,:YASCSSJD_DM,:YASCSSJD_MC,:YSRJDH,:XYR,:SFZH,:TARYXX,:SHR,:SHSJ,:ZJS,:DJJ,:ZYS)"); OracleParameter[] parameters = { new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":TYSAH", OracleType.Char, 17), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":SFYGXTSJ", OracleType.Char, 1), new OracleParameter(":CBDW_BM", OracleType.VarChar, 50), new OracleParameter(":CBDW_MC", OracleType.VarChar, 300), new OracleParameter(":FQDWBM", OracleType.Number, 4), new OracleParameter(":FQL", OracleType.VarChar, 6), new OracleParameter(":CJSJ", OracleType.DateTime), new OracleParameter(":ZHXGSJ", OracleType.DateTime), new OracleParameter(":SLRQ", OracleType.DateTime), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLB_BM", OracleType.VarChar, 50), new OracleParameter(":AJLB_MC", OracleType.VarChar, 300), new OracleParameter(":ZCJG_DWDM", OracleType.Char, 13), new OracleParameter(":ZCJG_DWMC", OracleType.VarChar, 300), new OracleParameter(":YSDW_DWDM", OracleType.Char, 13), new OracleParameter(":YSDW_DWMC", OracleType.VarChar, 300), new OracleParameter(":YSWSWH", OracleType.VarChar, 300), new OracleParameter(":YSAY_AYDM", OracleType.Char, 13), new OracleParameter(":YSAY_AYMC", OracleType.VarChar, 300), new OracleParameter(":YSQTAY_AYDMS", OracleType.VarChar, 130), new OracleParameter(":YSQTAY_AYMCS", OracleType.VarChar, 3000), new OracleParameter(":CBRGH", OracleType.Char, 4), new OracleParameter(":CBR", OracleType.VarChar, 60), new OracleParameter(":CBBM_BM", OracleType.Char, 4), new OracleParameter(":CBBM_MC", OracleType.VarChar, 300), new OracleParameter(":AJZT", OracleType.Char, 1), new OracleParameter(":SFSWAJ", OracleType.Char, 1), new OracleParameter(":SFDBAJ", OracleType.Char, 1), new OracleParameter(":ZXHD_MC", OracleType.VarChar, 300), new OracleParameter(":WCRQ", OracleType.DateTime), new OracleParameter(":GDRQ", OracleType.DateTime), new OracleParameter(":GDRGH", OracleType.Char, 4), new OracleParameter(":GDR", OracleType.VarChar, 60), new OracleParameter(":AQZY", OracleType.VarChar, 4000), new OracleParameter(":DQJD", OracleType.VarChar, 3000), new OracleParameter(":BLKSRQ", OracleType.DateTime), new OracleParameter(":BLTS", OracleType.Number, 4), new OracleParameter(":DQRQ", OracleType.DateTime), new OracleParameter(":BJRQ", OracleType.DateTime), new OracleParameter(":YJZT", OracleType.Char, 1), new OracleParameter(":JYYJZT", OracleType.Char, 1), new OracleParameter(":JYYJHCQXYRGS", OracleType.Number, 4), new OracleParameter(":LCSLBH", OracleType.Char, 2), new OracleParameter(":FXDJ", OracleType.Char, 1), new OracleParameter(":SFGZAJ", OracleType.Char, 1), new OracleParameter(":FZ", OracleType.VarChar, 4000), new OracleParameter(":YSYJ_DM", OracleType.Char, 13), new OracleParameter(":YSYJ_MC", OracleType.VarChar, 300), new OracleParameter(":SFJBAJ", OracleType.Char, 1), new OracleParameter(":ZXHD_DM", OracleType.Char, 13), new OracleParameter(":DQYJJD", OracleType.VarChar, 300), new OracleParameter(":YASCSSJD_DM", OracleType.Char, 13), new OracleParameter(":YASCSSJD_MC", OracleType.VarChar, 300), new OracleParameter(":YSRJDH", OracleType.VarChar, 300), new OracleParameter(":XYR", OracleType.VarChar, 500), new OracleParameter(":SFZH", OracleType.VarChar, 100), new OracleParameter(":TARYXX", OracleType.VarChar, 2000), new OracleParameter(":SHR", OracleType.VarChar, 100), new OracleParameter(":SHSJ", OracleType.DateTime), new OracleParameter(":ZJS", OracleType.Number, 18), new OracleParameter(":DJJ", OracleType.VarChar, 100), new OracleParameter(":ZYS", OracleType.Number, 18) }; parameters[0].Value = model.BMSAH ?? ""; parameters[1].Value = model.TYSAH ?? ""; parameters[2].Value = model.SFSC ?? ""; parameters[3].Value = model.SFYGXTSJ ?? ""; parameters[4].Value = model.CBDW_BM ?? ""; parameters[5].Value = model.CBDW_MC ?? ""; parameters[6].Value = model.FQDWBM; parameters[7].Value = model.FQL ?? ""; parameters[8].Value = model.CJSJ; parameters[9].Value = model.ZHXGSJ; parameters[10].Value = model.SLRQ; parameters[11].Value = model.AJMC ?? ""; parameters[12].Value = model.AJLB_BM ?? ""; parameters[13].Value = model.AJLB_MC ?? ""; parameters[14].Value = model.ZCJG_DWDM ?? ""; parameters[15].Value = model.ZCJG_DWMC ?? ""; parameters[16].Value = model.YSDW_DWDM ?? ""; parameters[17].Value = model.YSDW_DWMC ?? ""; parameters[18].Value = model.YSWSWH ?? ""; parameters[19].Value = model.YSAY_AYDM ?? ""; parameters[20].Value = model.YSAY_AYMC ?? ""; parameters[21].Value = model.YSQTAY_AYDMS ?? ""; parameters[22].Value = model.YSQTAY_AYMCS ?? ""; parameters[23].Value = model.CBRGH ?? ""; parameters[24].Value = model.CBR ?? ""; parameters[25].Value = model.CBBM_BM ?? ""; parameters[26].Value = model.CBBM_MC ?? ""; parameters[27].Value = model.AJZT ?? ""; parameters[28].Value = model.SFSWAJ ?? ""; parameters[29].Value = model.SFDBAJ ?? ""; parameters[30].Value = model.ZXHD_MC ?? ""; parameters[31].Value = model.WCRQ ?? Convert.ToDateTime("1900-01-01"); parameters[32].Value = model.GDRQ ?? Convert.ToDateTime("1900-01-01"); parameters[33].Value = model.GDRGH ?? ""; parameters[34].Value = model.GDR ?? ""; parameters[35].Value = model.AQZY ?? ""; parameters[36].Value = model.DQJD ?? ""; parameters[37].Value = model.BLKSRQ ?? Convert.ToDateTime("1900-01-01"); parameters[38].Value = model.BLTS ?? 0; parameters[39].Value = model.DQRQ ?? Convert.ToDateTime("1900-01-01"); parameters[40].Value = model.BJRQ ?? Convert.ToDateTime("1900-01-01"); parameters[41].Value = model.YJZT ?? ""; parameters[42].Value = model.JYYJZT ?? ""; parameters[43].Value = model.JYYJHCQXYRGS ?? 0; parameters[44].Value = model.LCSLBH ?? ""; parameters[45].Value = model.FXDJ ?? ""; parameters[46].Value = model.SFGZAJ ?? ""; parameters[47].Value = model.FZ ?? ""; parameters[48].Value = model.YSYJ_DM ?? ""; parameters[49].Value = model.YSYJ_MC ?? ""; parameters[50].Value = model.SFJBAJ ?? ""; parameters[51].Value = model.ZXHD_DM ?? ""; parameters[52].Value = model.DQYJJD ?? ""; parameters[53].Value = model.YASCSSJD_DM ?? ""; parameters[54].Value = model.YASCSSJD_MC ?? ""; parameters[55].Value = model.YSRJDH ?? ""; parameters[56].Value = model.XYR ?? ""; parameters[57].Value = model.SFZH ?? ""; parameters[58].Value = model.TARYXX ?? ""; parameters[59].Value = model.SHR ?? ""; parameters[60].Value = model.SHSJ ?? DateTime.Now; parameters[61].Value = model.ZJS; parameters[62].Value = model.DJJ ?? ""; parameters[63].Value = model.ZYS; hash.Add(strSql.ToString(), parameters); #endregion } if (modelkz != null) { #region 案件基本信息扩展 strSql.Clear(); strSql.Append("insert into TYYW_GG_AJJBXXKZ("); strSql.Append("AHMC,AY,SAJG,YG,BG,YYR,SQZXR,BZXR,SARQ,JARQ,CJJG,ZXBD,SLJG,ZXJG,JAFS,GLDAXLH,HYTCY,CBR,SJY,ZCS,DJC,YS,GDRQ,YWT,BGQX,AJLBBM,H,NF,YWLBBM,YWLBMC,DWBM,DWMC,DWJC,AJLBMC,QAH,MLH,JH,CZRGH,CZRMC,CZSJ)"); strSql.Append(" values ("); strSql.Append(":AHMC,:AY,:SAJG,:YG,:BG,:YYR,:SQZXR,:BZXR,:SARQ,:JARQ,:CJJG,:ZXBD,:SLJG,:ZXJG,:JAFS,:GLDAXLH,:HYTCY,:CBR,:SJY,:ZCS,:DJC,:YS,:GDRQ,:YWT,:BGQX,:AJLBBM,:H,:NF,:YWLBBM,:YWLBMC,:DWBM,:DWMC,:DWJC,:AJLBMC,:QAH,:MLH,:JH,:CZRGH,:CZRMC,:CZSJ)"); OracleParameter[] parameterskz = { new OracleParameter(":AHMC", OracleType.VarChar, 200), new OracleParameter(":AY", OracleType.VarChar, 500), new OracleParameter(":SAJG", OracleType.VarChar, 200), new OracleParameter(":YG", OracleType.VarChar, 200), new OracleParameter(":BG", OracleType.VarChar, 200), new OracleParameter(":YYR", OracleType.VarChar, 200), new OracleParameter(":SQZXR", OracleType.VarChar, 50), new OracleParameter(":BZXR", OracleType.VarChar, 50), new OracleParameter(":SARQ", OracleType.DateTime), new OracleParameter(":JARQ", OracleType.DateTime), new OracleParameter(":CJJG", OracleType.VarChar, 200), new OracleParameter(":ZXBD", OracleType.VarChar, 200), new OracleParameter(":SLJG", OracleType.VarChar, 4000), new OracleParameter(":ZXJG", OracleType.VarChar, 4000), new OracleParameter(":JAFS", OracleType.VarChar, 200), new OracleParameter(":GLDAXLH", OracleType.VarChar, 200), new OracleParameter(":HYTCY", OracleType.VarChar, 200), new OracleParameter(":CBR", OracleType.VarChar, 50), new OracleParameter(":SJY", OracleType.VarChar, 50), new OracleParameter(":ZCS", OracleType.Number), new OracleParameter(":DJC", OracleType.Number), new OracleParameter(":YS", OracleType.Number), new OracleParameter(":GDRQ", OracleType.DateTime), new OracleParameter(":YWT", OracleType.VarChar, 200), new OracleParameter(":BGQX", OracleType.VarChar, 20), new OracleParameter(":AJLBBM", OracleType.VarChar, 20), new OracleParameter(":H", OracleType.Number), new OracleParameter(":NF", OracleType.VarChar, 4), new OracleParameter(":YWLBBM", OracleType.VarChar, 20), new OracleParameter(":YWLBMC", OracleType.VarChar, 50), new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":DWMC", OracleType.VarChar, 500), new OracleParameter(":DWJC", OracleType.VarChar, 200), new OracleParameter(":AJLBMC", OracleType.VarChar, 200), new OracleParameter(":QAH", OracleType.VarChar, 20), new OracleParameter(":MLH", OracleType.VarChar, 20), new OracleParameter(":JH", OracleType.VarChar, 20), new OracleParameter(":CZRGH", OracleType.VarChar, 20), new OracleParameter(":CZRMC", OracleType.VarChar, 100), new OracleParameter(":CZSJ", OracleType.DateTime) }; parameterskz[0].Value = modelkz.AHMC ?? ""; parameterskz[1].Value = modelkz.AY ?? ""; parameterskz[2].Value = modelkz.SAJG ?? ""; parameterskz[3].Value = modelkz.YG ?? ""; parameterskz[4].Value = modelkz.BG ?? ""; parameterskz[5].Value = modelkz.YYR ?? ""; parameterskz[6].Value = modelkz.SQZXR ?? ""; parameterskz[7].Value = modelkz.BZXR ?? ""; parameterskz[8].Value = modelkz.SARQ; parameterskz[9].Value = modelkz.JARQ; parameterskz[10].Value = modelkz.CJJG ?? ""; parameterskz[11].Value = modelkz.ZXBD ?? ""; parameterskz[12].Value = modelkz.SLJG ?? ""; parameterskz[13].Value = modelkz.ZXJG ?? ""; parameterskz[14].Value = modelkz.JAFS ?? ""; parameterskz[15].Value = modelkz.GLDAXLH ?? ""; parameterskz[16].Value = modelkz.HYTCY ?? ""; parameterskz[17].Value = modelkz.CBR ?? ""; parameterskz[18].Value = modelkz.SJY ?? ""; parameterskz[19].Value = modelkz.ZCS; parameterskz[20].Value = modelkz.DJC; parameterskz[21].Value = modelkz.YS; parameterskz[22].Value = modelkz.GDRQ; parameterskz[23].Value = modelkz.YWT ?? ""; parameterskz[24].Value = modelkz.BGQX ?? ""; parameterskz[25].Value = modelkz.AJLBBM ?? ""; parameterskz[26].Value = modelkz.H; parameterskz[27].Value = modelkz.NF; parameterskz[28].Value = modelkz.YWLBBM ?? ""; parameterskz[29].Value = modelkz.YWLBMC ?? ""; parameterskz[30].Value = modelkz.DWBM ?? ""; parameterskz[31].Value = modelkz.DWMC ?? ""; parameterskz[32].Value = modelkz.DWJC ?? ""; parameterskz[33].Value = modelkz.AJLBMC ?? ""; parameterskz[34].Value = modelkz.QAH ?? ""; parameterskz[35].Value = modelkz.MLH ?? ""; parameterskz[36].Value = modelkz.JH ?? ""; parameterskz[37].Value = modelkz.CZRGH ?? ""; parameterskz[38].Value = modelkz.CZRMC ?? ""; parameterskz[39].Value = modelkz.CZSJ; hash.Add(strSql.ToString(), parameterskz); #endregion } if (modeljbxx != null) { #region 卷宗基本信息 strSql.Clear(); strSql.Append("insert into YX_DZJZ_JZJBXX("); strSql.Append("JZBH,SFSC,CJSJ,ZHXGSJ,FQDWBM,FQL,DWBM,BMSAH,TYSAH,JZMC,JZLJ,JZSCSJ,JZSCRGH,JZSCRXM,JZMS,JZXGH,SFKYGX,GXYWBMJH,MRSFGKPZ, ACCOMPLICES, AJMB_BM, AJMB_MC, IDNUMBER, ISRECORD, SUSPECTNAME,WSBH,AJBH,ZZZT,JZPZ,JZSHRBH,JZSHR,JZSHSJ,WSMC,SMAJLA,SMAJCD,LAZZZT)"); strSql.Append(" values ("); strSql.Append(":JZBH,:SFSC,:CJSJ,:ZHXGSJ,:FQDWBM,:FQL,:DWBM,:BMSAH,:TYSAH,:JZMC,:JZLJ,:JZSCSJ,:JZSCRGH,:JZSCRXM,:JZMS,:JZXGH,:SFKYGX,:GXYWBMJH,:MRSFGKPZ, :ACCOMPLICES, :AJMB_BM, :AJMB_MC, :IDNUMBER, :ISRECORD, :SUSPECTNAME, :WSBH, :AJBH, :ZZZT,:JZPZ,:JZSHRBH,:JZSHR,:JZSHSJ,:WSMC,:SMAJLA,:SMAJCD,:LAZZZT)"); OracleParameter[] parametersjbxx = { new OracleParameter(":JZBH", OracleType.Char, 14), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":CJSJ", OracleType.DateTime), new OracleParameter(":ZHXGSJ", OracleType.DateTime), new OracleParameter(":FQDWBM", OracleType.VarChar, 50), new OracleParameter(":FQL", OracleType.VarChar, 6), new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":TYSAH", OracleType.Char, 17), new OracleParameter(":JZMC", OracleType.VarChar, 300), new OracleParameter(":JZLJ", OracleType.VarChar, 500), new OracleParameter(":JZSCSJ", OracleType.DateTime), new OracleParameter(":JZSCRGH", OracleType.Char, 4), new OracleParameter(":JZSCRXM", OracleType.VarChar, 60), new OracleParameter(":JZMS", OracleType.VarChar, 500), new OracleParameter(":JZXGH", OracleType.Clob, 4000), new OracleParameter(":SFKYGX", OracleType.Char, 1), new OracleParameter(":GXYWBMJH", OracleType.VarChar, 300), new OracleParameter(":MRSFGKPZ", OracleType.Char, 1), new OracleParameter(":ACCOMPLICES", OracleType.VarChar, 2000), new OracleParameter(":AJMB_BM", OracleType.VarChar, 500), new OracleParameter(":AJMB_MC", OracleType.VarChar, 500), new OracleParameter(":IDNUMBER", OracleType.VarChar, 500), new OracleParameter(":ISRECORD", OracleType.VarChar, 10), new OracleParameter(":SUSPECTNAME", OracleType.VarChar, 500), new OracleParameter(":WSBH", OracleType.VarChar, 100), new OracleParameter(":AJBH", OracleType.VarChar, 100), new OracleParameter(":ZZZT", OracleType.VarChar, 10), new OracleParameter(":JZPZ", OracleType.VarChar, 4000), new OracleParameter(":JZSHRBH", OracleType.VarChar), new OracleParameter(":JZSHR", OracleType.VarChar), new OracleParameter(":JZSHSJ", OracleType.DateTime), new OracleParameter(":WSMC", OracleType.VarChar), new OracleParameter(":SMAJLA", OracleType.VarChar), new OracleParameter(":SMAJCD", OracleType.VarChar), new OracleParameter(":LAZZZT", OracleType.VarChar, 10) }; parametersjbxx[0].Value = modeljbxx.JZBH ?? ""; parametersjbxx[1].Value = modeljbxx.SFSC; parametersjbxx[2].Value = modeljbxx.CJSJ; parametersjbxx[3].Value = modeljbxx.ZHXGSJ; parametersjbxx[4].Value = modeljbxx.FQDWBM; parametersjbxx[5].Value = modeljbxx.FQL ?? ""; parametersjbxx[6].Value = modeljbxx.DWBM ?? ""; parametersjbxx[7].Value = modeljbxx.BMSAH ?? ""; parametersjbxx[8].Value = modeljbxx.TYSAH ?? ""; parametersjbxx[9].Value = modeljbxx.JZMC ?? ""; parametersjbxx[10].Value = modeljbxx.JZLJ ?? ""; parametersjbxx[11].Value = (object)modeljbxx.JZSCSJ ?? DBNull.Value; parametersjbxx[12].Value = modeljbxx.JZSCRGH ?? ""; parametersjbxx[13].Value = modeljbxx.JZSCRXM ?? ""; parametersjbxx[14].Value = modeljbxx.JZMS ?? ""; parametersjbxx[15].Value = modeljbxx.JZXGH; parametersjbxx[16].Value = modeljbxx.SFKYGX; parametersjbxx[17].Value = modeljbxx.GXYWBMJH ?? ""; parametersjbxx[18].Value = modeljbxx.MRSFGKPZ; parametersjbxx[19].Value = modeljbxx.Accomplices ?? ""; parametersjbxx[20].Value = modeljbxx.Ajmb_bm ?? ""; parametersjbxx[21].Value = modeljbxx.Ajmb_mc ?? ""; parametersjbxx[22].Value = modeljbxx.Idnumber ?? ""; parametersjbxx[23].Value = modeljbxx.Isrecord ?? ""; parametersjbxx[24].Value = modeljbxx.Suspectname ?? ""; parametersjbxx[25].Value = modeljbxx.WSBH ?? ""; parametersjbxx[26].Value = modeljbxx.AJBH ?? ""; parametersjbxx[27].Value = modeljbxx.ZZZT ?? ""; parametersjbxx[28].Value = modeljbxx.JZPZ ?? ""; parametersjbxx[29].Value = modeljbxx.JZSHRBH ?? ""; parametersjbxx[30].Value = modeljbxx.JZSHR ?? ""; parametersjbxx[31].Value = (object)modeljbxx.JZSHSJ ?? DBNull.Value; parametersjbxx[32].Value = modeljbxx.WSMC ?? ""; parametersjbxx[33].Value = modeljbxx.SMAJLA ?? ""; parametersjbxx[34].Value = modeljbxx.SMAJCD ?? ""; parametersjbxx[35].Value = modeljbxx.LAZZZT ?? ""; hash.Add(strSql.ToString(), parametersjbxx); #endregion } try { return(DbHelperOra.ExecuteSqlTran(hash)); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddList(EDRS.Model.TYYW_GG_AJJBXX model,EDRS.Model.TYYW_GG_AJJBXXKZ modelkz,EDRS.Model.YX_DZJZ_JZJBXX modeljbxx)", "EDRS.OracleDAL.TYYW_GG_AJJBXX"); } return(false); }
/// <summary> /// 修改一条数据 /// </summary> public bool UpdateList(EDRS.Model.TYYW_GG_AJJBXX model, EDRS.Model.TYYW_GG_AJJBXXKZ modelkz, EDRS.Model.YX_DZJZ_JZJBXX modeljbxx) { System.Collections.Hashtable hash = new System.Collections.Hashtable(); StringBuilder strSql = new StringBuilder(); if (model != null) { #region 案件基本信息 strSql.Append("update TYYW_GG_AJJBXX set "); strSql.Append("ZHXGSJ=:ZHXGSJ,SLRQ=:SLRQ,AJMC=:AJMC,AJLB_BM=:AJLB_BM,AJLB_MC=:AJLB_MC,CBRGH=:CBRGH,CBR=:CBR,BJRQ=:BJRQ where BMSAH=:BMSAH "); OracleParameter[] parameters = { new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":ZHXGSJ", OracleType.DateTime), new OracleParameter(":SLRQ", OracleType.DateTime), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLB_BM", OracleType.VarChar, 50), new OracleParameter(":AJLB_MC", OracleType.VarChar, 300), new OracleParameter(":CBRGH", OracleType.Char, 4), new OracleParameter(":CBR", OracleType.VarChar, 60), new OracleParameter(":BJRQ", OracleType.DateTime) }; parameters[0].Value = model.BMSAH ?? ""; parameters[1].Value = model.ZHXGSJ; parameters[2].Value = model.SLRQ; parameters[3].Value = model.AJMC ?? ""; parameters[4].Value = model.AJLB_BM ?? ""; parameters[5].Value = model.AJLB_MC ?? ""; parameters[6].Value = model.CBRGH ?? ""; parameters[7].Value = model.CBR ?? ""; parameters[8].Value = (object)model.BJRQ ?? DBNull.Value; hash.Add(strSql.ToString(), parameters); #endregion } if (modelkz != null) { #region 案件基本信息扩展 strSql.Clear(); strSql.Append("update TYYW_GG_AJJBXXKZ set "); strSql.Append("AY=:AY,SAJG=:SAJG,YG=:YG,BG=:BG,YYR=:YYR,SQZXR=:SQZXR,BZXR=:BZXR,SARQ=:SARQ,JARQ=:JARQ,CJJG=:CJJG,ZXBD=:ZXBD,SLJG=:SLJG,ZXJG=:ZXJG,JAFS=:JAFS,GLDAXLH=:GLDAXLH,HYTCY=:HYTCY,CBR=:CBR,SJY=:SJY,ZCS=:ZCS,DJC=:DJC,YS=:YS,GDRQ=:GDRQ,YWT=:YWT,BGQX=:BGQX,AJLBBM=:AJLBBM,H=:H,NF=:NF,YWLBBM=:YWLBBM,YWLBMC=:YWLBMC,DWBM=:DWBM,DWMC=:DWMC,DWJC=:DWJC,AJLBMC=:AJLBMC,QAH=:QAH,MLH=:MLH,JH=:JH where AHMC=:AHMC"); OracleParameter[] parameterskz = { new OracleParameter(":AHMC", OracleType.VarChar, 200), new OracleParameter(":AY", OracleType.VarChar, 500), new OracleParameter(":SAJG", OracleType.VarChar, 200), new OracleParameter(":YG", OracleType.VarChar, 200), new OracleParameter(":BG", OracleType.VarChar, 200), new OracleParameter(":YYR", OracleType.VarChar, 200), new OracleParameter(":SQZXR", OracleType.VarChar, 50), new OracleParameter(":BZXR", OracleType.VarChar, 50), new OracleParameter(":SARQ", OracleType.DateTime), new OracleParameter(":JARQ", OracleType.DateTime), new OracleParameter(":CJJG", OracleType.VarChar, 200), new OracleParameter(":ZXBD", OracleType.VarChar, 200), new OracleParameter(":SLJG", OracleType.VarChar, 4000), new OracleParameter(":ZXJG", OracleType.VarChar, 4000), new OracleParameter(":JAFS", OracleType.VarChar, 200), new OracleParameter(":GLDAXLH", OracleType.VarChar, 200), new OracleParameter(":HYTCY", OracleType.VarChar, 200), new OracleParameter(":CBR", OracleType.VarChar, 50), new OracleParameter(":SJY", OracleType.VarChar, 50), new OracleParameter(":ZCS", OracleType.Number), new OracleParameter(":DJC", OracleType.Number), new OracleParameter(":YS", OracleType.Number), new OracleParameter(":GDRQ", OracleType.DateTime), new OracleParameter(":YWT", OracleType.VarChar, 200), new OracleParameter(":BGQX", OracleType.VarChar, 20), new OracleParameter(":AJLBBM", OracleType.VarChar, 20), new OracleParameter(":H", OracleType.Number), new OracleParameter(":NF", OracleType.VarChar, 4), new OracleParameter(":YWLBBM", OracleType.VarChar, 20), new OracleParameter(":YWLBMC", OracleType.VarChar, 50), new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":DWMC", OracleType.VarChar, 500), new OracleParameter(":DWJC", OracleType.VarChar, 200), new OracleParameter(":AJLBMC", OracleType.VarChar, 200), new OracleParameter(":QAH", OracleType.VarChar, 20), new OracleParameter(":MLH", OracleType.VarChar, 20), new OracleParameter(":JH", OracleType.VarChar, 20) }; parameterskz[0].Value = modelkz.AHMC ?? ""; parameterskz[1].Value = modelkz.AY ?? ""; parameterskz[2].Value = modelkz.SAJG ?? ""; parameterskz[3].Value = modelkz.YG ?? ""; parameterskz[4].Value = modelkz.BG ?? ""; parameterskz[5].Value = modelkz.YYR ?? ""; parameterskz[6].Value = modelkz.SQZXR ?? ""; parameterskz[7].Value = modelkz.BZXR ?? ""; parameterskz[8].Value = modelkz.SARQ; parameterskz[9].Value = modelkz.JARQ; parameterskz[10].Value = modelkz.CJJG ?? ""; parameterskz[11].Value = modelkz.ZXBD ?? ""; parameterskz[12].Value = modelkz.SLJG ?? ""; parameterskz[13].Value = modelkz.ZXJG ?? ""; parameterskz[14].Value = modelkz.JAFS ?? ""; parameterskz[15].Value = modelkz.GLDAXLH ?? ""; parameterskz[16].Value = modelkz.HYTCY ?? ""; parameterskz[17].Value = modelkz.CBR ?? ""; parameterskz[18].Value = modelkz.SJY ?? ""; parameterskz[19].Value = modelkz.ZCS; parameterskz[20].Value = modelkz.DJC; parameterskz[21].Value = modelkz.YS; parameterskz[22].Value = modelkz.GDRQ; parameterskz[23].Value = modelkz.YWT ?? ""; parameterskz[24].Value = modelkz.BGQX ?? ""; parameterskz[25].Value = modelkz.AJLBBM ?? ""; parameterskz[26].Value = modelkz.H; parameterskz[27].Value = modelkz.NF; parameterskz[28].Value = modelkz.YWLBBM ?? ""; parameterskz[29].Value = modelkz.YWLBMC ?? ""; parameterskz[30].Value = modelkz.DWBM ?? ""; parameterskz[31].Value = modelkz.DWMC ?? ""; parameterskz[32].Value = modelkz.DWJC ?? ""; parameterskz[33].Value = modelkz.AJLBMC ?? ""; parameterskz[34].Value = modelkz.QAH ?? ""; parameterskz[35].Value = modelkz.MLH ?? ""; parameterskz[36].Value = modelkz.JH ?? ""; hash.Add(strSql.ToString(), parameterskz); #endregion } if (modeljbxx != null) { #region 卷宗基本信息 strSql.Clear(); strSql.Append("update YX_DZJZ_JZJBXX set "); strSql.AppendFormat("ZHXGSJ=:ZHXGSJ,JZMC=:JZMC,AJMB_BM= :AJMB_BM, AJMB_MC=:AJMB_MC {0}{1} where BMSAH=:BMSAH", (string.IsNullOrEmpty(modeljbxx.SMAJLA) ? "" : ",SMAJLA=:SMAJLA"), (string.IsNullOrEmpty(modeljbxx.SMAJCD) ? "" : ",SMAJCD=:SMAJCD")); System.Collections.Generic.List <OracleParameter> parametersjbxx = new System.Collections.Generic.List <OracleParameter>(); parametersjbxx.Add(new OracleParameter(":ZHXGSJ", modeljbxx.ZHXGSJ)); parametersjbxx.Add(new OracleParameter(":AJMB_BM", modeljbxx.Ajmb_bm ?? "")); parametersjbxx.Add(new OracleParameter(":AJMB_MC", modeljbxx.Ajmb_mc ?? "")); parametersjbxx.Add(new OracleParameter(":BMSAH", modeljbxx.BMSAH ?? "")); parametersjbxx.Add(new OracleParameter(":JZMC", modeljbxx.JZMC ?? "")); if (!string.IsNullOrEmpty(modeljbxx.SMAJLA)) { parametersjbxx.Add(new OracleParameter(":SMAJLA", modeljbxx.SMAJLA ?? "")); } if (!string.IsNullOrEmpty(modeljbxx.SMAJCD)) { parametersjbxx.Add(new OracleParameter(":SMAJCD", modeljbxx.SMAJCD ?? "")); } //OracleParameter[] parametersjbxx = { // new OracleParameter(":ZHXGSJ", OracleType.DateTime), // new OracleParameter(":AJMB_BM", OracleType.VarChar,500), // new OracleParameter(":AJMB_MC", OracleType.VarChar,500), // new OracleParameter(":BMSAH", OracleType.VarChar,100), // new OracleParameter(":JZMC", OracleType.VarChar,300), // new OracleParameter(":SMAJLA", OracleType.VarChar), // new OracleParameter(":SMAJCD", OracleType.VarChar), // }; //parametersjbxx[0].Value = modeljbxx.ZHXGSJ; //parametersjbxx[1].Value = modeljbxx.Ajmb_bm ?? ""; //parametersjbxx[2].Value = modeljbxx.Ajmb_mc ?? ""; //parametersjbxx[3].Value = modeljbxx.BMSAH ?? ""; //parametersjbxx[4].Value = modeljbxx.JZMC ?? ""; //parametersjbxx[5].Value = modeljbxx.SMAJLA ?? ""; //parametersjbxx[6].Value = modeljbxx.SMAJCD ?? ""; hash.Add(strSql.ToString(), parametersjbxx.ToArray()); #endregion } try { return(DbHelperOra.ExecuteSqlTran(hash)); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddList(EDRS.Model.TYYW_GG_AJJBXX model,EDRS.Model.TYYW_GG_AJJBXXKZ modelkz,EDRS.Model.YX_DZJZ_JZJBXX modeljbxx)", "EDRS.OracleDAL.TYYW_GG_AJJBXX"); } return(false); }
/// <summary> /// 添加案件信息 /// </summary> /// <returns></returns> private string AddData() { string ajmc = Request.Form.Get("txt_ajmc"); string lbmc = Request.Form.Get("txt_lbmc"); string xyr = Request.Form.Get("txt_xyr"); string sfzh = (string.IsNullOrEmpty(Request.Form.Get("txt_sfzh")) ? "" : Request.Form.Get("txt_sfzh")); string taryxx = (string.IsNullOrEmpty(Request.Form.Get("txt_taryxx")) ? "" : Request.Form.Get("txt_taryxx")); string ajlb = (string.IsNullOrEmpty(Request.Form.Get("txt_ajlb")) ? "" : Request.Form.Get("txt_ajlb")); string ajbh = Request.Form.Get("txt_ajbh"); //案件编号 string lasj = Request.Form.Get("txt_lasj"); //立案时间 string jasj = Request.Form.Get("txt_jasj"); //结案时间 string ladw = Request.Form.Get("txt_ladw_val"); //立卷单位 string ladw_mc = Request.Form.Get("txt_ladw"); //立卷单位名称 string ljr = Request.Form.Get("txt_lar_val"); //立卷人 string ljr_mc = Request.Form.Get("txt_lar"); //立卷人名称 string shr = Request.Form.Get("txt_shr"); //审核人 string zjs = (string.IsNullOrEmpty(Request.Form.Get("txt_zjs")) ? "0" : Request.Form.Get("txt_zjs")); //本案共卷 string djj = Request.Form.Get("txt_djj"); //第几卷 string djy = (string.IsNullOrEmpty(Request.Form.Get("txt_djy")) ? "0" : Request.Form.Get("txt_djy")); //第几页 string wsbh = Request.Form.Get("wsbh_hidd"); string wsmc = Request.Form.Get("txt_wsbh"); //案件编号 if (string.IsNullOrEmpty(ajbh)) { return(ReturnString.JsonToString(Prompt.error, "必须填写案件编号", null)); } //判断案件名称 if (string.IsNullOrEmpty(ajmc)) { return(ReturnString.JsonToString(Prompt.error, "必须填写案件名称", null)); } //判断案件类别 if (string.IsNullOrEmpty(ajlb)) { return(ReturnString.JsonToString(Prompt.error, "必须填写案件类别", null)); } //立案时间 if (string.IsNullOrEmpty(lasj)) { return(ReturnString.JsonToString(Prompt.error, "必须选择立案时间", null)); } //立卷单位 if (string.IsNullOrEmpty(ladw)) { return(ReturnString.JsonToString(Prompt.error, "必须选择立卷单位", null)); } EDRS.BLL.YX_DZJZ_JZJBXX jbxxbll = new YX_DZJZ_JZJBXX(Request); if (!string.IsNullOrEmpty(ajbh)) { string where = string.Empty; object[] param = null; if (string.IsNullOrEmpty(wsbh)) { where = " and ajbh = :ajbh and (wsbh is null or wsbh='') and SFSC='N'"; param = new object[] { ajbh }; } else { where = " and ajbh = :ajbh and wsbh=:wsbh and SFSC='N'"; param = new object[] { ajbh, wsbh }; } //if (!string.IsNullOrEmpty(wsbh)) //{ //where = " and ajbh like :ajbh and wsbh=:wsbh and SFSC='N'"; //param = new object[] { ajbh + "%", wsbh }; //} //else //{ // where = " and ajbh like :ajbh and SFSC='N'"; // param = new object[] { ajbh + "%" }; //} // List<EDRS.Model.YX_DZJZ_JZJBXX> list = jbxxbll.GetModelList(where, param); // int dataCount = jbxxbll.GetRecordCount(where, param); //if (dataCount > 0) //{ // return ReturnString.JsonToString(Prompt.error, "案件【" + ajbh + "】已存在,请不要重复添加!", null); //} DataSet ds = jbxxbll.GetList(where, param); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //{ // if (ds.Tables[0].Rows[i]["DWBM"].ToString() == UserInfo.DWBM) // { return(ReturnString.JsonToString(Prompt.error, "案件【" + ajbh + "】已存在,请不要重复添加,或者选择其它文书号!", null)); // } //} //ajbh += "_"+UserInfo.DWBM; } } //if (!string.IsNullOrEmpty(wsbh)) //{ // List<EDRS.Model.YX_DZJZ_JZJBXX> list = jbxxbll.GetModelList(" and wsbh=:wsbh and SFSC='N'", new object[] { wsbh }); // if (list != null && list.Count > 0) // { // return ReturnString.JsonToString(Prompt.error, "文书编号【" + wsbh + "】已存在,请不要重复添加!", null); // } //} if (!string.IsNullOrEmpty(ajmc) && !string.IsNullOrEmpty(ajlb))//&& !string.IsNullOrEmpty(ajbh) { //EDRS.BLL.XT_DM_AJLBBM ajlbbmBll = new XT_DM_AJLBBM(Request); //EDRS.Model.XT_DM_AJLBBM ajlbModel = ajlbbmBll.GetModel(ajlb); //if (ajlbModel != null) // lbjc = ajlbModel.AJSLJC; //if (string.IsNullOrEmpty(lbjc)) // lbjc = lbmc; string bmsahName = ajlb + "[" + DateTime.Now.Year + "]" + UserInfo.DWBM; string num = "00001号"; TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request); DataSet ds = jzajxx.GetListByPage(" and bmsah like '" + bmsahName + "%'", "bmsah desc", 1, 1, null); if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 1) { num = ds.Tables[0].Rows[0]["bmsah"].ToString().Replace(bmsahName, "").Replace("号", ""); num = (Convert.ToInt32(num) + 1).ToString().PadLeft(5, '0') + "号"; } EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX(); //山东省院起诉受[2015]37000000072号 model.BMSAH = bmsahName + num; model.TYSAH = Guid.NewGuid().ToString().ToUpper().Replace("-", ""); model.SFSC = "N"; model.SFYGXTSJ = "N"; model.FQDWBM = Convert.ToDecimal(UserInfo.DWBM.Substring(0, 4)); model.FQL = DateTime.Now.Year.ToString(); model.CJSJ = DateTime.Now; model.ZHXGSJ = DateTime.Now; model.SLRQ = (string.IsNullOrEmpty(lasj)? DateTime.Now : Convert.ToDateTime(lasj));// DateTime.Now; model.AJMC = ajmc; model.AJLB_BM = ajlb; model.AJLB_MC = lbmc; model.XYR = xyr; model.SFZH = sfzh; model.TARYXX = taryxx; if (!string.IsNullOrEmpty(jasj)) { model.BJRQ = Convert.ToDateTime(jasj); } if (!string.IsNullOrEmpty(ladw) && ladw != "null") { model.CBDW_BM = ladw; model.CBDW_MC = ladw_mc; } else { model.CBDW_BM = UserInfo.DWBM; model.CBDW_MC = UserInfo.DWMC; } model.CBR = ljr_mc; model.CBRGH = ljr; //2016-6-6 增字段 model.SHR = shr; //审核人 model.SHSJ = DateTime.Now; //审核时间 model.ZJS = Convert.ToDecimal(zjs); //总卷数 model.DJJ = djj; //第几卷 model.ZYS = Convert.ToDecimal(djy); //总页数 if (jzajxx.Add(model)) { string count = "0"; count = jbxxbll.GetRecordCount("", null).ToString(); count = count.PadLeft(5, '0'); EDRS.Model.YX_DZJZ_JZJBXX jbxxmodel = new EDRS.Model.YX_DZJZ_JZJBXX(); jbxxmodel.JZBH = DateTime.Now.ToString("yyyyMMddHHmmssfff"); jbxxmodel.SFSC = "N"; jbxxmodel.CJSJ = DateTime.Now; jbxxmodel.ZHXGSJ = DateTime.Now; jbxxmodel.FQDWBM = 0; jbxxmodel.FQL = ""; jbxxmodel.DWBM = model.CBDW_BM; jbxxmodel.BMSAH = model.BMSAH; jbxxmodel.TYSAH = UserInfo.DWBM + DateTime.Now.ToString("yyyyMM") + jbxxbll.GetRecordCount("", null) + count; jbxxmodel.JZMC = ajmc; jbxxmodel.JZLJ = ""; jbxxmodel.JZSCSJ = DateTime.Now; jbxxmodel.JZSCRGH = UserInfo.GH; jbxxmodel.JZSCRXM = UserInfo.MC; jbxxmodel.JZMS = ""; jbxxmodel.JZXGH = "0"; jbxxmodel.SFKYGX = ""; jbxxmodel.GXYWBMJH = ""; jbxxmodel.MRSFGKPZ = ""; jbxxmodel.Accomplices = taryxx; jbxxmodel.Ajmb_bm = ajlb; jbxxmodel.Ajmb_mc = lbmc; jbxxmodel.Idnumber = sfzh; jbxxmodel.Isrecord = "0"; jbxxmodel.Suspectname = xyr; jbxxmodel.WSBH = wsbh; jbxxmodel.AJBH = ajbh; jbxxmodel.WSMC = wsmc; jbxxmodel.ZZZT = "-1"; if (jbxxbll.Add(jbxxmodel)) { OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "成功", model.BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "添加" + ((VersionName)0).ToString() + "成功", null)); } else { jzajxx.Delete(model.BMSAH); } } OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "失败", model.BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "添加" + ((VersionName)0).ToString() + "失败", null)); } return(ReturnString.JsonToString(Prompt.error, "请将" + ((VersionName)0).ToString() + "信息填写完整", null)); }
/// <summary> /// 编辑数据 /// </summary> /// <returns></returns> public string UpData() { string ajmc = Request.Form.Get("txt_ajmc"); string lbmc = Request.Form.Get("txt_lbmc"); string xyr = Request.Form.Get("txt_xyr"); string sfzh = Request.Form.Get("txt_sfzh"); string taryxx = Request.Form.Get("txt_taryxx"); string ajlb = Request.Form.Get("txt_ajlb"); string bmsah = Request.Form.Get("hidd_bmsah"); string ajbh = Request.Form.Get("txt_ajbh"); //案件编号 string lasj = Request.Form.Get("txt_lasj"); //立案时间 string jasj = Request.Form.Get("txt_jasj"); //结案时间 string ladw = Request.Form.Get("txt_ladw_val"); //立卷单位 string ladw_mc = Request.Form.Get("txt_ladw"); //立卷单位名称 string ljr = Request.Form.Get("txt_lar_val"); //立卷人 string ljr_mc = Request.Form.Get("txt_lar"); //立卷人名称 string shr = Request.Form.Get("txt_shr"); //审核人 string zjs = (string.IsNullOrEmpty(Request.Form.Get("txt_zjs")) ? "0" : Request.Form.Get("txt_zjs")); //本案共卷 string djj = Request.Form.Get("txt_djj"); //第几卷 string djy = (string.IsNullOrEmpty(Request.Form.Get("txt_djy")) ? "0" : Request.Form.Get("txt_djy")); //第几页 string wsbh = Request.Form.Get("wsbh_hidd"); string wsmc = Request.Form.Get("txt_wsbh"); //txt_wsbh //案件编号 if (string.IsNullOrEmpty(ajbh)) { return(ReturnString.JsonToString(Prompt.error, "必须填写案件编号", null)); } //判断案件名称 if (string.IsNullOrEmpty(ajmc)) { return(ReturnString.JsonToString(Prompt.error, "必须填写案件名称", null)); } //判断案件类别 if (string.IsNullOrEmpty(ajlb)) { return(ReturnString.JsonToString(Prompt.error, "必须填写案件类别", null)); } //立案时间 if (string.IsNullOrEmpty(lasj)) { return(ReturnString.JsonToString(Prompt.error, "必须选择立案时间", null)); } //立卷单位 if (string.IsNullOrEmpty(ladw)) { return(ReturnString.JsonToString(Prompt.error, "必须选择立卷单位", null)); } if (string.IsNullOrEmpty(bmsah)) { return(ReturnString.JsonToString(Prompt.error, "未指定修改" + ((VersionName)0).ToString() + ",请重新选择修改" + ((VersionName)0).ToString(), null)); } YX_DZJZ_JZJBXX bll = new YX_DZJZ_JZJBXX(Request); if (!string.IsNullOrEmpty(ajbh)) { // List<EDRS.Model.YX_DZJZ_JZJBXX> list = bll.GetModelList(" and ajbh=:ajbh and wsbh=:wsbh and SFSC='N' and bmsah<>:bmsah ", new object[] { ajbh, wsbh ,bmsah}); int dataCount = bll.GetRecordCount(" and ajbh=:ajbh and wsbh=:wsbh and SFSC='N' and bmsah<>:bmsah ", new object[] { ajbh, wsbh, bmsah }); if (dataCount > 0) { return(ReturnString.JsonToString(Prompt.error, "案件信息【" + ajbh + "】已存在,请不要重复添加!", null)); } } if (!string.IsNullOrEmpty(ajmc) && !string.IsNullOrEmpty(ajlb)) { TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request); EDRS.Model.TYYW_GG_AJJBXX model = jzajxx.GetModel(bmsah); if (model != null) { model.AJMC = ajmc; model.AJLB_BM = ajlb; model.AJLB_MC = lbmc; model.XYR = xyr; model.SFZH = sfzh; model.TARYXX = taryxx; model.SLRQ = (string.IsNullOrEmpty(lasj) ? DateTime.Now : Convert.ToDateTime(lasj));// DateTime.Now; if (!string.IsNullOrEmpty(jasj)) { model.BJRQ = Convert.ToDateTime(jasj); } if (!string.IsNullOrEmpty(ladw) && ladw != "null") { model.CBDW_BM = ladw; model.CBDW_MC = ladw_mc; } model.CBR = ljr_mc; model.CBRGH = ljr; //2016-6-6 增字段 model.SHR = shr; //审核人 model.SHSJ = DateTime.Now; //审核时间 model.ZJS = Convert.ToDecimal(zjs); //总卷数 model.DJJ = djj; //第几卷 model.ZYS = Convert.ToDecimal(djy); //总页数 if (jzajxx.Update(model)) { List <EDRS.Model.YX_DZJZ_JZJBXX> list = bll.GetModelList(" and BMSAH ='" + bmsah + "'", null); if (list != null && list.Count > 0) { EDRS.Model.YX_DZJZ_JZJBXX jbxxModel = list[0]; jbxxModel.JZMC = ajmc; jbxxModel.Ajmb_bm = ajlb; jbxxModel.Ajmb_mc = lbmc; jbxxModel.WSBH = wsbh; jbxxModel.WSMC = wsmc; jbxxModel.ZHXGSJ = DateTime.Now; jbxxModel.DWBM = model.CBDW_BM; if (!bll.Update(jbxxModel)) { OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "卷宗基本信息修改失败", model.BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "卷宗基本信息修改失败", null)); } } OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "修改" + ((VersionName)0).ToString() + "成功", model.BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "修改" + ((VersionName)0).ToString() + "成功", null)); } OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "修改" + ((VersionName)0).ToString() + "失败", model.BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "修改" + ((VersionName)0).ToString() + "失败", null)); } return(ReturnString.JsonToString(Prompt.error, "修改" + ((VersionName)0).ToString() + "不存在", null)); } return(ReturnString.JsonToString(Prompt.error, "请将" + ((VersionName)0).ToString() + "信息填写完整", null)); }
/// <summary> /// 卷宗制作 /// </summary> /// <param name="BMSAH"></param> /// <returns></returns> private string GetMake(string BMSAH) { try { string dwbm = ""; string ajbh = ""; string wsbh = ""; string wsmc = ""; if (string.IsNullOrEmpty(BMSAH)) { BMSAH = Request["id"]; dwbm = Request["dwbm"]; ajbh = Request["ajbh"]; wsbh = Request["wsbh"]; wsmc = Request.Form["wsmc"]; if (string.IsNullOrEmpty(BMSAH)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } string type = Request["type"]; string interfaceType = Request["interfaceType"]; #region 原件导出和pdf导出控制按钮权限 if (interfaceType == "5") { if (!base.IsAnRole("caseinfomanage_yjdc")) { return(ReturnString.JsonToString(Prompt.error, "没有权限,请先设置权限", null)); } } if (interfaceType == "8") { if (!base.IsAnRole("caseinfomanage_pdfdc")) { return(ReturnString.JsonToString(Prompt.error, "没有权限,请先设置权限", null)); } } #endregion //判断是否为导出 if (type == "btn_derive") { type = "1"; } else { type = "0"; } TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request); EDRS.Model.TYYW_GG_AJJBXX model = jzajxx.GetModel(BMSAH); //读取配置文件中的配置 int?isLocalAjxx = ConfigHelper.GetConfigInt("IsLocalAjxx"); if (isLocalAjxx == 1) { if (model == null) { //本地数据不存在执行添加到本地 model = jzajxx.GetIceByModel(BMSAH, jzajxx.GetAjTypeBm(Request, UserInfo.DWBM, "", UserInfo.GH), GetUserRoleList(UserInfo.DWBM, UserInfo.GH), dwbm, UserInfo.GH); if (model == null || !jzajxx.Add(model)) { OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "制作添加本地数据失败", BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取" + ((VersionName)0).ToString() + "失败", null)); } } else { //本地数据存在执行更新本地数据 model = jzajxx.GetIceByModel(BMSAH, jzajxx.GetAjTypeBm(Request, UserInfo.DWBM, "", UserInfo.GH), GetUserRoleList(UserInfo.DWBM, UserInfo.GH), model.CBDW_BM, UserInfo.GH); if (model == null || !jzajxx.Update(model)) { OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "制作修改本地数据失败", BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取" + ((VersionName)0).ToString() + "失败", null)); } } } if (model != null) { //0制作,1导出 EDRS.Model.XY_DZJZ_XTPZ xtpz = GetConfigById(EnumConfig.卷宗文件上传地址); if (xtpz != null) { string bmbm = ""; string bmmc = ""; if (UserRole != null && UserRole.Count > 0) { bmbm = UserRole[0].BMBM; bmmc = UserRole[0].BMMC; } //string strstring = model.BMSAH + "_" + type + "@" + base.UserInfo.DWBM + "@" + base.UserInfo.MC + "@" + GetConfigById(EnumConfig.卷宗文件上传地址).CONFIGVALUE + "@" + UserInfo.GH + "@" + UserInfo.DWMC + "@" + bmbm + "@" + bmmc; //strstring = DESEncrypt.Encrypt(strstring); //string d = DESEncrypt.Decrypt(strstring); //OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "案件制作成功", model.BMSAH, UserInfo, UserRole, this.Request); XT_DZJZ_ZZCS zzcsbll = new XT_DZJZ_ZZCS(Request); string[] zks = new string[] { "BMSAH", "SFDC", "DWBM", "MC", "GH", "DWMC", "BMBM", "BMMC", "LJLX", "DZ1", "DZ2", "AJBH", "WSBH", "WSMC" }; string callBack = string.Empty; string linkType = string.Empty; List <EDRS.Model.XT_DZJZ_ZZCS> zzcsList = new List <EDRS.Model.XT_DZJZ_ZZCS>(); EDRS.Model.XT_DZJZ_ZZCS zzcsModel = null; string guid = Guid.NewGuid().ToString(); foreach (string dr in zks) { //制作参数(部门受案号,是否导出,单位编码,用户名称,单位名称,部门编码,部门名称,连接类型,文件上传地址,回调地址)<add key="ZzCsKey" value="BMSAH,SFDC,DWBM,MC,GH,DWMC,BMBM,BMMC,LJLX,DZ1,DZ2"/> zzcsModel = new EDRS.Model.XT_DZJZ_ZZCS(); zzcsModel.CSKEY = dr; zzcsModel.FZBS = guid; zzcsModel.DYSJ = DateTime.Now; switch (zzcsModel.CSKEY) { case "BMSAH": zzcsModel.CSVALUE = model.BMSAH; break; case "SFDC": zzcsModel.CSVALUE = type; break; case "DWBM": zzcsModel.CSVALUE = base.UserInfo.DWBM; break; case "MC": zzcsModel.CSVALUE = base.UserInfo.MC; break; case "GH": zzcsModel.CSVALUE = UserInfo.GH; break; case "DWMC": zzcsModel.CSVALUE = UserInfo.DWMC; break; case "BMBM": zzcsModel.CSVALUE = bmbm; break; case "BMMC": zzcsModel.CSVALUE = bmmc; break; case "LJLX": object obj = GetConfigById(EnumConfig.连接类型); if (obj != null) { linkType = zzcsModel.CSVALUE = ((EDRS.Model.XY_DZJZ_XTPZ)obj).CONFIGVALUE; } else { zzcsModel.CSVALUE = ""; } break; case "DZ1": zzcsModel.CSVALUE = xtpz.CONFIGVALUE; break; case "DZ2": object obj2 = GetConfigById(EnumConfig.路由映射地址); if (obj2 != null && obj2 != DBNull.Value) { callBack = zzcsModel.CSVALUE = ((EDRS.Model.XY_DZJZ_XTPZ)obj2).CONFIGVALUE; } else { zzcsModel.CSVALUE = ""; } break; case "AJBH": zzcsModel.CSVALUE = ajbh; break; case "WSBH": zzcsModel.CSVALUE = wsbh; break; case "WSMC": zzcsModel.CSVALUE = wsmc; break; } zzcsList.Add(zzcsModel); } if (zzcsbll.AddList(zzcsList)) { //string strstring = Request.Url.Authority + "@" + guid; //TH:2016-05-23 //string strstring = Request.Url.Authority + "@" + guid; string strstring = xtpz.CONFIGVALUE + "@" + linkType + "@" + callBack + "@" + guid + "@" + interfaceType; return("{\"parm\":\"" + DESEncrypt.Encrypt(strstring) + "\"}"); } } else { OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "未配置卷宗服务地址,请先到参数配置中配置", BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未配置卷宗服务地址,请先到参数配置中配置", null)); } } OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "制作失败", BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取" + ((VersionName)0).ToString() + "失败", null)); } catch (Exception ex) { OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "制作失败异常" + ex.Message, BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取" + ((VersionName)0).ToString() + "失败,错误:" + ex.Message.Replace("\"", ""), null)); } }
/// <summary> /// (测试)添加案件信息 /// </summary> /// <returns></returns> private void AddDataTest(int c, System.Web.HttpRequest req) { string ajmc = "测试案件名称" + c; string ajlb = "020911"; string lbmc = "盗窃枪支、弹药案";//020911 //3A1802 冒用他人边境管理区通行证 if (c % 4 == 0) { ajlb = "3A1802"; lbmc = "冒用他人边境管理区通行证"; } string xyr = "张某" + c; string sfzh = ""; string taryxx = ""; string ajbh = "ABCDE1" + c; //案件编号 string lasj = DateTime.Now.ToString(); //立案时间 string jasj = DateTime.Now.ToString(); //结案时间 string ladw = UserInfo.DWBM; //立卷单位 string ladw_mc = UserInfo.DWMC; //立卷单位名称 string ljr = UserInfo.GH; //立卷人 string ljr_mc = UserInfo.MC; //立卷人名称 string shr = ""; //审核人 string zjs = "10"; //本案共卷 string djj = ""; //第几卷 string djy = "0"; //第几页 string wsbh = "XXXX" + c; string wsmc = "XXXXX文书名称" + c; EDRS.BLL.YX_DZJZ_JZJBXX jbxxbll = new YX_DZJZ_JZJBXX(req); if (!string.IsNullOrEmpty(ajmc) && !string.IsNullOrEmpty(ajlb))//&& !string.IsNullOrEmpty(ajbh) { string bmsahName = ajlb + "[" + DateTime.Now.Year + "]" + UserInfo.DWBM; string num = "00001号"; TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(req); DataSet ds = jzajxx.GetListByPage(" and bmsah like '" + bmsahName + "%'", "bmsah desc", 1, 1, null); if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 1) { num = ds.Tables[0].Rows[0]["bmsah"].ToString().Replace(bmsahName, "").Replace("号", ""); num = (Convert.ToInt32(num) + 1).ToString().PadLeft(5, '0') + "号"; } EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX(); //山东省院起诉受[2015]37000000072号 model.BMSAH = bmsahName + num; model.TYSAH = Guid.NewGuid().ToString().ToUpper().Replace("-", ""); model.SFSC = "N"; model.SFYGXTSJ = "N"; model.CBDW_BM = UserInfo.DWBM; model.CBDW_MC = UserInfo.DWMC; model.FQDWBM = Convert.ToDecimal(UserInfo.DWBM.Substring(0, 4)); model.FQL = DateTime.Now.Year.ToString(); model.CJSJ = DateTime.Now; model.ZHXGSJ = DateTime.Now; model.SLRQ = (string.IsNullOrEmpty(lasj) ? DateTime.Now : Convert.ToDateTime(lasj));// DateTime.Now; model.AJMC = ajmc; model.AJLB_BM = ajlb; model.AJLB_MC = lbmc; model.XYR = xyr; model.SFZH = sfzh; model.TARYXX = taryxx; if (!string.IsNullOrEmpty(jasj)) { model.BJRQ = Convert.ToDateTime(jasj); } model.CBDW_BM = ladw; model.CBDW_MC = ladw_mc; model.CBR = ljr_mc; model.CBRGH = ljr; //2016-6-6 增字段 model.SHR = shr; //审核人 model.SHSJ = DateTime.Now; //审核时间 model.ZJS = Convert.ToDecimal(zjs); //总卷数 model.DJJ = djj; //第几卷 model.ZYS = Convert.ToDecimal(djy); //总页数 if (jzajxx.Add(model)) { string count = "0"; count = jbxxbll.GetRecordCount("", null).ToString(); count = count.PadLeft(5, '0'); EDRS.Model.YX_DZJZ_JZJBXX jbxxmodel = new EDRS.Model.YX_DZJZ_JZJBXX(); jbxxmodel.JZBH = DateTime.Now.ToString("yyyyMMddHHmmssfff"); jbxxmodel.SFSC = "N"; jbxxmodel.CJSJ = DateTime.Now; jbxxmodel.ZHXGSJ = DateTime.Now; jbxxmodel.FQDWBM = 0; jbxxmodel.FQL = ""; jbxxmodel.DWBM = UserInfo.DWBM; jbxxmodel.BMSAH = model.BMSAH; jbxxmodel.TYSAH = UserInfo.DWBM + DateTime.Now.ToString("yyyyMM") + jbxxbll.GetRecordCount("", null) + count; jbxxmodel.JZMC = ajmc; jbxxmodel.JZLJ = ""; jbxxmodel.JZSCSJ = DateTime.Now; jbxxmodel.JZSCRGH = UserInfo.GH; jbxxmodel.JZSCRXM = UserInfo.MC; jbxxmodel.JZMS = ""; jbxxmodel.JZXGH = "0"; jbxxmodel.SFKYGX = ""; jbxxmodel.GXYWBMJH = ""; jbxxmodel.MRSFGKPZ = ""; jbxxmodel.Accomplices = taryxx; jbxxmodel.Ajmb_bm = ajlb; jbxxmodel.Ajmb_mc = lbmc; jbxxmodel.Idnumber = sfzh; jbxxmodel.Isrecord = "0"; jbxxmodel.Suspectname = xyr; jbxxmodel.WSBH = wsbh; jbxxmodel.AJBH = ajbh; jbxxmodel.WSMC = wsmc; jbxxmodel.ZZZT = "-1"; if (jbxxbll.Add(jbxxmodel)) { return; } else { jzajxx.Delete(model.BMSAH); } } return; } return; }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.TYYW_GG_AJJBXX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TYYW_GG_AJJBXX("); strSql.Append("BMSAH,TYSAH,SFSC,SFYGXTSJ,CBDW_BM,CBDW_MC,FQDWBM,FQL,CJSJ,ZHXGSJ,SLRQ,AJMC,AJLB_BM,AJLB_MC,ZCJG_DWDM,ZCJG_DWMC,YSDW_DWDM,YSDW_DWMC,YSWSWH,YSAY_AYDM,YSAY_AYMC,YSQTAY_AYDMS,YSQTAY_AYMCS,CBRGH,CBR,CBBM_BM,CBBM_MC,AJZT,SFSWAJ,SFDBAJ,ZXHD_MC,WCRQ,GDRQ,GDRGH,GDR,AQZY,DQJD,BLKSRQ,BLTS,DQRQ,BJRQ,YJZT,JYYJZT,JYYJHCQXYRGS,LCSLBH,FXDJ,SFGZAJ,FZ,YSYJ_DM,YSYJ_MC,SFJBAJ,ZXHD_DM,DQYJJD,YASCSSJD_DM,YASCSSJD_MC,YSRJDH,XYR,SFZH,TARYXX,SHR,SHSJ,ZJS,DJJ,ZYS)"); strSql.Append(" values ("); strSql.Append(":BMSAH,:TYSAH,:SFSC,:SFYGXTSJ,:CBDW_BM,:CBDW_MC,:FQDWBM,:FQL,:CJSJ,:ZHXGSJ,:SLRQ,:AJMC,:AJLB_BM,:AJLB_MC,:ZCJG_DWDM,:ZCJG_DWMC,:YSDW_DWDM,:YSDW_DWMC,:YSWSWH,:YSAY_AYDM,:YSAY_AYMC,:YSQTAY_AYDMS,:YSQTAY_AYMCS,:CBRGH,:CBR,:CBBM_BM,:CBBM_MC,:AJZT,:SFSWAJ,:SFDBAJ,:ZXHD_MC,:WCRQ,:GDRQ,:GDRGH,:GDR,:AQZY,:DQJD,:BLKSRQ,:BLTS,:DQRQ,:BJRQ,:YJZT,:JYYJZT,:JYYJHCQXYRGS,:LCSLBH,:FXDJ,:SFGZAJ,:FZ,:YSYJ_DM,:YSYJ_MC,:SFJBAJ,:ZXHD_DM,:DQYJJD,:YASCSSJD_DM,:YASCSSJD_MC,:YSRJDH,:XYR,:SFZH,:TARYXX,:SHR,:SHSJ,:ZJS,:DJJ,:ZYS)"); OracleParameter[] parameters = { new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":TYSAH", OracleType.Char, 17), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":SFYGXTSJ", OracleType.Char, 1), new OracleParameter(":CBDW_BM", OracleType.VarChar, 50), new OracleParameter(":CBDW_MC", OracleType.VarChar, 300), new OracleParameter(":FQDWBM", OracleType.Number, 4), new OracleParameter(":FQL", OracleType.VarChar, 6), new OracleParameter(":CJSJ", OracleType.DateTime), new OracleParameter(":ZHXGSJ", OracleType.DateTime), new OracleParameter(":SLRQ", OracleType.DateTime), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLB_BM", OracleType.VarChar, 50), new OracleParameter(":AJLB_MC", OracleType.VarChar, 300), new OracleParameter(":ZCJG_DWDM", OracleType.Char, 13), new OracleParameter(":ZCJG_DWMC", OracleType.VarChar, 300), new OracleParameter(":YSDW_DWDM", OracleType.Char, 13), new OracleParameter(":YSDW_DWMC", OracleType.VarChar, 300), new OracleParameter(":YSWSWH", OracleType.VarChar, 300), new OracleParameter(":YSAY_AYDM", OracleType.Char, 13), new OracleParameter(":YSAY_AYMC", OracleType.VarChar, 300), new OracleParameter(":YSQTAY_AYDMS", OracleType.VarChar, 130), new OracleParameter(":YSQTAY_AYMCS", OracleType.VarChar, 3000), new OracleParameter(":CBRGH", OracleType.Char, 4), new OracleParameter(":CBR", OracleType.VarChar, 60), new OracleParameter(":CBBM_BM", OracleType.Char, 4), new OracleParameter(":CBBM_MC", OracleType.VarChar, 300), new OracleParameter(":AJZT", OracleType.Char, 1), new OracleParameter(":SFSWAJ", OracleType.Char, 1), new OracleParameter(":SFDBAJ", OracleType.Char, 1), new OracleParameter(":ZXHD_MC", OracleType.VarChar, 300), new OracleParameter(":WCRQ", OracleType.DateTime), new OracleParameter(":GDRQ", OracleType.DateTime), new OracleParameter(":GDRGH", OracleType.Char, 4), new OracleParameter(":GDR", OracleType.VarChar, 60), new OracleParameter(":AQZY", OracleType.VarChar, 4000), new OracleParameter(":DQJD", OracleType.VarChar, 3000), new OracleParameter(":BLKSRQ", OracleType.DateTime), new OracleParameter(":BLTS", OracleType.Number, 4), new OracleParameter(":DQRQ", OracleType.DateTime), new OracleParameter(":BJRQ", OracleType.DateTime), new OracleParameter(":YJZT", OracleType.Char, 1), new OracleParameter(":JYYJZT", OracleType.Char, 1), new OracleParameter(":JYYJHCQXYRGS", OracleType.Number, 4), new OracleParameter(":LCSLBH", OracleType.Char, 2), new OracleParameter(":FXDJ", OracleType.Char, 1), new OracleParameter(":SFGZAJ", OracleType.Char, 1), new OracleParameter(":FZ", OracleType.VarChar, 4000), new OracleParameter(":YSYJ_DM", OracleType.Char, 13), new OracleParameter(":YSYJ_MC", OracleType.VarChar, 300), new OracleParameter(":SFJBAJ", OracleType.Char, 1), new OracleParameter(":ZXHD_DM", OracleType.Char, 13), new OracleParameter(":DQYJJD", OracleType.VarChar, 300), new OracleParameter(":YASCSSJD_DM", OracleType.Char, 13), new OracleParameter(":YASCSSJD_MC", OracleType.VarChar, 300), new OracleParameter(":YSRJDH", OracleType.VarChar, 300), new OracleParameter(":XYR", OracleType.VarChar, 500), new OracleParameter(":SFZH", OracleType.VarChar, 100), new OracleParameter(":TARYXX", OracleType.VarChar, 2000), new OracleParameter(":SHR", OracleType.VarChar, 100), new OracleParameter(":SHSJ", OracleType.DateTime), new OracleParameter(":ZJS", OracleType.Number, 18), new OracleParameter(":DJJ", OracleType.VarChar, 100), new OracleParameter(":ZYS", OracleType.Number, 18) }; parameters[0].Value = model.BMSAH ?? ""; parameters[1].Value = model.TYSAH ?? ""; parameters[2].Value = model.SFSC ?? ""; parameters[3].Value = model.SFYGXTSJ ?? ""; parameters[4].Value = model.CBDW_BM ?? ""; parameters[5].Value = model.CBDW_MC ?? ""; parameters[6].Value = model.FQDWBM; parameters[7].Value = model.FQL ?? ""; parameters[8].Value = model.CJSJ; parameters[9].Value = model.ZHXGSJ; parameters[10].Value = model.SLRQ; parameters[11].Value = model.AJMC ?? ""; parameters[12].Value = model.AJLB_BM ?? ""; parameters[13].Value = model.AJLB_MC ?? ""; parameters[14].Value = model.ZCJG_DWDM ?? ""; parameters[15].Value = model.ZCJG_DWMC ?? ""; parameters[16].Value = model.YSDW_DWDM ?? ""; parameters[17].Value = model.YSDW_DWMC ?? ""; parameters[18].Value = model.YSWSWH ?? ""; parameters[19].Value = model.YSAY_AYDM ?? ""; parameters[20].Value = model.YSAY_AYMC ?? ""; parameters[21].Value = model.YSQTAY_AYDMS ?? ""; parameters[22].Value = model.YSQTAY_AYMCS ?? ""; parameters[23].Value = model.CBRGH ?? ""; parameters[24].Value = model.CBR ?? ""; parameters[25].Value = model.CBBM_BM ?? ""; parameters[26].Value = model.CBBM_MC ?? ""; parameters[27].Value = model.AJZT ?? ""; parameters[28].Value = model.SFSWAJ ?? ""; parameters[29].Value = model.SFDBAJ ?? ""; parameters[30].Value = model.ZXHD_MC ?? ""; parameters[31].Value = model.WCRQ ?? Convert.ToDateTime("1900-01-01"); parameters[32].Value = model.GDRQ ?? Convert.ToDateTime("1900-01-01"); parameters[33].Value = model.GDRGH ?? ""; parameters[34].Value = model.GDR ?? ""; parameters[35].Value = model.AQZY ?? ""; parameters[36].Value = model.DQJD ?? ""; parameters[37].Value = model.BLKSRQ ?? Convert.ToDateTime("1900-01-01"); parameters[38].Value = model.BLTS ?? 0; parameters[39].Value = model.DQRQ ?? Convert.ToDateTime("1900-01-01"); parameters[40].Value = model.BJRQ ?? Convert.ToDateTime("1900-01-01"); parameters[41].Value = model.YJZT ?? ""; parameters[42].Value = model.JYYJZT ?? ""; parameters[43].Value = model.JYYJHCQXYRGS ?? 0; parameters[44].Value = model.LCSLBH ?? ""; parameters[45].Value = model.FXDJ ?? ""; parameters[46].Value = model.SFGZAJ ?? ""; parameters[47].Value = model.FZ ?? ""; parameters[48].Value = model.YSYJ_DM ?? ""; parameters[49].Value = model.YSYJ_MC ?? ""; parameters[50].Value = model.SFJBAJ ?? ""; parameters[51].Value = model.ZXHD_DM ?? ""; parameters[52].Value = model.DQYJJD ?? ""; parameters[53].Value = model.YASCSSJD_DM ?? ""; parameters[54].Value = model.YASCSSJD_MC ?? ""; parameters[55].Value = model.YSRJDH ?? ""; parameters[56].Value = model.XYR ?? ""; parameters[57].Value = model.SFZH ?? ""; parameters[58].Value = model.TARYXX ?? ""; parameters[59].Value = model.SHR ?? ""; parameters[60].Value = model.SHSJ ?? DateTime.Now; parameters[61].Value = model.ZJS; parameters[62].Value = model.DJJ ?? ""; parameters[63].Value = model.ZYS; try { int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.TYYW_GG_AJJBXX model)", "EDRS.OracleDAL.TYYW_GG_AJJBXX", strSql.ToString(), parameters); } return(false); }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.TYYW_GG_AJJBXX DataRowToModel(DataRow row) { EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX(); if (row != null) { if (row["BMSAH"] != null) { model.BMSAH = row["BMSAH"].ToString(); } if (row["TYSAH"] != null) { model.TYSAH = row["TYSAH"].ToString(); } if (row["SFSC"] != null) { model.SFSC = row["SFSC"].ToString(); } if (row["SFYGXTSJ"] != null) { model.SFYGXTSJ = row["SFYGXTSJ"].ToString(); } if (row["CBDW_BM"] != null) { model.CBDW_BM = row["CBDW_BM"].ToString(); } if (row["CBDW_MC"] != null) { model.CBDW_MC = row["CBDW_MC"].ToString(); } if (row["FQDWBM"] != null && row["FQDWBM"].ToString() != "") { model.FQDWBM = decimal.Parse(row["FQDWBM"].ToString()); } if (row["FQL"] != null) { model.FQL = row["FQL"].ToString(); } if (row["CJSJ"] != null && row["CJSJ"].ToString() != "") { model.CJSJ = DateTime.Parse(row["CJSJ"].ToString()); } if (row["ZHXGSJ"] != null && row["ZHXGSJ"].ToString() != "") { model.ZHXGSJ = DateTime.Parse(row["ZHXGSJ"].ToString()); } if (row["SLRQ"] != null && row["SLRQ"].ToString() != "") { model.SLRQ = DateTime.Parse(row["SLRQ"].ToString()); } if (row["AJMC"] != null) { model.AJMC = row["AJMC"].ToString(); } if (row["AJLB_BM"] != null) { model.AJLB_BM = row["AJLB_BM"].ToString(); } if (row["AJLB_MC"] != null) { model.AJLB_MC = row["AJLB_MC"].ToString(); } if (row["ZCJG_DWDM"] != null) { model.ZCJG_DWDM = row["ZCJG_DWDM"].ToString(); } if (row["ZCJG_DWMC"] != null) { model.ZCJG_DWMC = row["ZCJG_DWMC"].ToString(); } if (row["YSDW_DWDM"] != null) { model.YSDW_DWDM = row["YSDW_DWDM"].ToString(); } if (row["YSDW_DWMC"] != null) { model.YSDW_DWMC = row["YSDW_DWMC"].ToString(); } if (row["YSWSWH"] != null) { model.YSWSWH = row["YSWSWH"].ToString(); } if (row["YSAY_AYDM"] != null) { model.YSAY_AYDM = row["YSAY_AYDM"].ToString(); } if (row["YSAY_AYMC"] != null) { model.YSAY_AYMC = row["YSAY_AYMC"].ToString(); } if (row["YSQTAY_AYDMS"] != null) { model.YSQTAY_AYDMS = row["YSQTAY_AYDMS"].ToString(); } if (row["YSQTAY_AYMCS"] != null) { model.YSQTAY_AYMCS = row["YSQTAY_AYMCS"].ToString(); } if (row["CBRGH"] != null) { model.CBRGH = row["CBRGH"].ToString(); } if (row["CBR"] != null) { model.CBR = row["CBR"].ToString(); } if (row["CBBM_BM"] != null) { model.CBBM_BM = row["CBBM_BM"].ToString(); } if (row["CBBM_MC"] != null) { model.CBBM_MC = row["CBBM_MC"].ToString(); } if (row["AJZT"] != null) { model.AJZT = row["AJZT"].ToString(); } if (row["SFSWAJ"] != null) { model.SFSWAJ = row["SFSWAJ"].ToString(); } if (row["SFDBAJ"] != null) { model.SFDBAJ = row["SFDBAJ"].ToString(); } if (row["ZXHD_MC"] != null) { model.ZXHD_MC = row["ZXHD_MC"].ToString(); } if (row["WCRQ"] != null && row["WCRQ"].ToString() != "") { model.WCRQ = DateTime.Parse(row["WCRQ"].ToString()); } if (row["GDRQ"] != null && row["GDRQ"].ToString() != "") { model.GDRQ = DateTime.Parse(row["GDRQ"].ToString()); } if (row["GDRGH"] != null) { model.GDRGH = row["GDRGH"].ToString(); } if (row["GDR"] != null) { model.GDR = row["GDR"].ToString(); } if (row["AQZY"] != null) { model.AQZY = row["AQZY"].ToString(); } if (row["DQJD"] != null) { model.DQJD = row["DQJD"].ToString(); } if (row["BLKSRQ"] != null && row["BLKSRQ"].ToString() != "") { model.BLKSRQ = DateTime.Parse(row["BLKSRQ"].ToString()); } if (row["BLTS"] != null && row["BLTS"].ToString() != "") { model.BLTS = decimal.Parse(row["BLTS"].ToString()); } if (row["DQRQ"] != null && row["DQRQ"].ToString() != "") { model.DQRQ = DateTime.Parse(row["DQRQ"].ToString()); } if (row["BJRQ"] != null && row["BJRQ"].ToString() != "") { model.BJRQ = DateTime.Parse(row["BJRQ"].ToString()); } if (row["YJZT"] != null) { model.YJZT = row["YJZT"].ToString(); } if (row["JYYJZT"] != null) { model.JYYJZT = row["JYYJZT"].ToString(); } if (row["JYYJHCQXYRGS"] != null && row["JYYJHCQXYRGS"].ToString() != "") { model.JYYJHCQXYRGS = decimal.Parse(row["JYYJHCQXYRGS"].ToString()); } if (row["LCSLBH"] != null) { model.LCSLBH = row["LCSLBH"].ToString(); } if (row["FXDJ"] != null) { model.FXDJ = row["FXDJ"].ToString(); } if (row["SFGZAJ"] != null) { model.SFGZAJ = row["SFGZAJ"].ToString(); } if (row["FZ"] != null) { model.FZ = row["FZ"].ToString(); } if (row["YSYJ_DM"] != null) { model.YSYJ_DM = row["YSYJ_DM"].ToString(); } if (row["YSYJ_MC"] != null) { model.YSYJ_MC = row["YSYJ_MC"].ToString(); } if (row["SFJBAJ"] != null) { model.SFJBAJ = row["SFJBAJ"].ToString(); } if (row["ZXHD_DM"] != null) { model.ZXHD_DM = row["ZXHD_DM"].ToString(); } if (row["DQYJJD"] != null) { model.DQYJJD = row["DQYJJD"].ToString(); } if (row["YASCSSJD_DM"] != null) { model.YASCSSJD_DM = row["YASCSSJD_DM"].ToString(); } if (row["YASCSSJD_MC"] != null) { model.YASCSSJD_MC = row["YASCSSJD_MC"].ToString(); } if (row["YSRJDH"] != null) { model.YSRJDH = row["YSRJDH"].ToString(); } if (row["XYR"] != null) { model.XYR = row["XYR"].ToString(); } if (row["SFZH"] != null) { model.SFZH = row["SFZH"].ToString(); } if (row["TARYXX"] != null) { model.TARYXX = row["TARYXX"].ToString(); } if (row["SHR"] != null) { model.SHR = row["SHR"].ToString(); } if (row["ZJS"] != null && row["ZJS"].ToString() != "") { model.ZJS = decimal.Parse(row["ZJS"].ToString()); } if (row["DJJ"] != null) { model.DJJ = row["DJJ"].ToString(); } if (row["ZYS"] != null && row["ZYS"].ToString() != "") { model.ZYS = decimal.Parse(row["ZYS"].ToString()); } if (row["AJBH"] != null) { model.AJBH = row["AJBH"].ToString(); } if (row["WSBH"] != null) { model.WSBH = row["WSBH"].ToString(); } if (row["WSMC"] != null) { model.WSMC = row["WSMC"].ToString(); } if (row["ZZZT"] != null) { model.ZZZT = row["ZZZT"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.TYYW_GG_AJJBXX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TYYW_GG_AJJBXX set "); strSql.Append("TYSAH=:TYSAH,"); strSql.Append("SFSC=:SFSC,"); strSql.Append("SFYGXTSJ=:SFYGXTSJ,"); strSql.Append("CBDW_BM=:CBDW_BM,"); strSql.Append("CBDW_MC=:CBDW_MC,"); strSql.Append("FQDWBM=:FQDWBM,"); strSql.Append("FQL=:FQL,"); strSql.Append("CJSJ=:CJSJ,"); strSql.Append("ZHXGSJ=:ZHXGSJ,"); strSql.Append("SLRQ=:SLRQ,"); strSql.Append("AJMC=:AJMC,"); strSql.Append("AJLB_BM=:AJLB_BM,"); strSql.Append("AJLB_MC=:AJLB_MC,"); strSql.Append("ZCJG_DWDM=:ZCJG_DWDM,"); strSql.Append("ZCJG_DWMC=:ZCJG_DWMC,"); strSql.Append("YSDW_DWDM=:YSDW_DWDM,"); strSql.Append("YSDW_DWMC=:YSDW_DWMC,"); strSql.Append("YSWSWH=:YSWSWH,"); strSql.Append("YSAY_AYDM=:YSAY_AYDM,"); strSql.Append("YSAY_AYMC=:YSAY_AYMC,"); strSql.Append("YSQTAY_AYDMS=:YSQTAY_AYDMS,"); strSql.Append("YSQTAY_AYMCS=:YSQTAY_AYMCS,"); strSql.Append("CBRGH=:CBRGH,"); strSql.Append("CBR=:CBR,"); strSql.Append("CBBM_BM=:CBBM_BM,"); strSql.Append("CBBM_MC=:CBBM_MC,"); strSql.Append("AJZT=:AJZT,"); strSql.Append("SFSWAJ=:SFSWAJ,"); strSql.Append("SFDBAJ=:SFDBAJ,"); strSql.Append("ZXHD_MC=:ZXHD_MC,"); strSql.Append("WCRQ=:WCRQ,"); strSql.Append("GDRQ=:GDRQ,"); strSql.Append("GDRGH=:GDRGH,"); strSql.Append("GDR=:GDR,"); strSql.Append("AQZY=:AQZY,"); strSql.Append("DQJD=:DQJD,"); strSql.Append("BLKSRQ=:BLKSRQ,"); strSql.Append("BLTS=:BLTS,"); strSql.Append("DQRQ=:DQRQ,"); strSql.Append("BJRQ=:BJRQ,"); strSql.Append("YJZT=:YJZT,"); strSql.Append("JYYJZT=:JYYJZT,"); strSql.Append("JYYJHCQXYRGS=:JYYJHCQXYRGS,"); strSql.Append("LCSLBH=:LCSLBH,"); strSql.Append("FXDJ=:FXDJ,"); strSql.Append("SFGZAJ=:SFGZAJ,"); strSql.Append("FZ=:FZ,"); strSql.Append("YSYJ_DM=:YSYJ_DM,"); strSql.Append("YSYJ_MC=:YSYJ_MC,"); strSql.Append("SFJBAJ=:SFJBAJ,"); strSql.Append("ZXHD_DM=:ZXHD_DM,"); strSql.Append("DQYJJD=:DQYJJD,"); strSql.Append("YASCSSJD_DM=:YASCSSJD_DM,"); strSql.Append("YASCSSJD_MC=:YASCSSJD_MC,"); strSql.Append("YSRJDH=:YSRJDH,"); strSql.Append("XYR=:XYR,"); strSql.Append("SFZH=:SFZH,"); strSql.Append("TARYXX=:TARYXX,"); strSql.Append("SHR=:SHR,"); strSql.Append("SHSJ=:SHSJ,"); strSql.Append("ZJS=:ZJS,"); strSql.Append("DJJ=:DJJ,"); strSql.Append("ZYS=:ZYS"); strSql.Append(" where BMSAH=:BMSAH "); OracleParameter[] parameters = { new OracleParameter(":TYSAH", OracleType.Char, 17), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":SFYGXTSJ", OracleType.Char, 1), new OracleParameter(":CBDW_BM", OracleType.VarChar, 50), new OracleParameter(":CBDW_MC", OracleType.VarChar, 300), new OracleParameter(":FQDWBM", OracleType.Number, 4), new OracleParameter(":FQL", OracleType.VarChar, 6), new OracleParameter(":CJSJ", OracleType.DateTime), new OracleParameter(":ZHXGSJ", OracleType.DateTime), new OracleParameter(":SLRQ", OracleType.DateTime), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLB_BM", OracleType.VarChar, 50), new OracleParameter(":AJLB_MC", OracleType.VarChar, 300), new OracleParameter(":ZCJG_DWDM", OracleType.Char, 13), new OracleParameter(":ZCJG_DWMC", OracleType.VarChar, 300), new OracleParameter(":YSDW_DWDM", OracleType.Char, 13), new OracleParameter(":YSDW_DWMC", OracleType.VarChar, 300), new OracleParameter(":YSWSWH", OracleType.VarChar, 300), new OracleParameter(":YSAY_AYDM", OracleType.Char, 13), new OracleParameter(":YSAY_AYMC", OracleType.VarChar, 300), new OracleParameter(":YSQTAY_AYDMS", OracleType.VarChar, 130), new OracleParameter(":YSQTAY_AYMCS", OracleType.VarChar, 3000), new OracleParameter(":CBRGH", OracleType.Char, 4), new OracleParameter(":CBR", OracleType.VarChar, 60), new OracleParameter(":CBBM_BM", OracleType.Char, 4), new OracleParameter(":CBBM_MC", OracleType.VarChar, 300), new OracleParameter(":AJZT", OracleType.Char, 1), new OracleParameter(":SFSWAJ", OracleType.Char, 1), new OracleParameter(":SFDBAJ", OracleType.Char, 1), new OracleParameter(":ZXHD_MC", OracleType.VarChar, 300), new OracleParameter(":WCRQ", OracleType.DateTime), new OracleParameter(":GDRQ", OracleType.DateTime), new OracleParameter(":GDRGH", OracleType.Char, 4), new OracleParameter(":GDR", OracleType.VarChar, 60), new OracleParameter(":AQZY", OracleType.VarChar, 4000), new OracleParameter(":DQJD", OracleType.VarChar, 3000), new OracleParameter(":BLKSRQ", OracleType.DateTime), new OracleParameter(":BLTS", OracleType.Number, 4), new OracleParameter(":DQRQ", OracleType.DateTime), new OracleParameter(":BJRQ", OracleType.DateTime), new OracleParameter(":YJZT", OracleType.Char, 1), new OracleParameter(":JYYJZT", OracleType.Char, 1), new OracleParameter(":JYYJHCQXYRGS", OracleType.Number, 4), new OracleParameter(":LCSLBH", OracleType.Char, 2), new OracleParameter(":FXDJ", OracleType.Char, 1), new OracleParameter(":SFGZAJ", OracleType.Char, 1), new OracleParameter(":FZ", OracleType.VarChar, 4000), new OracleParameter(":YSYJ_DM", OracleType.Char, 13), new OracleParameter(":YSYJ_MC", OracleType.VarChar, 300), new OracleParameter(":SFJBAJ", OracleType.Char, 1), new OracleParameter(":ZXHD_DM", OracleType.Char, 13), new OracleParameter(":DQYJJD", OracleType.VarChar, 300), new OracleParameter(":YASCSSJD_DM", OracleType.Char, 13), new OracleParameter(":YASCSSJD_MC", OracleType.VarChar, 300), new OracleParameter(":YSRJDH", OracleType.VarChar, 300), new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":XYR", OracleType.VarChar, 500), new OracleParameter(":SFZH", OracleType.VarChar, 100), new OracleParameter(":TARYXX", OracleType.VarChar, 2000), new OracleParameter(":SHR", OracleType.VarChar, 100), new OracleParameter(":SHSJ", OracleType.DateTime), new OracleParameter(":ZJS", OracleType.Number, 18), new OracleParameter(":DJJ", OracleType.VarChar, 100), new OracleParameter(":ZYS", OracleType.Number, 18) }; parameters[0].Value = model.TYSAH ?? ""; parameters[1].Value = model.SFSC ?? ""; parameters[2].Value = model.SFYGXTSJ ?? ""; parameters[3].Value = model.CBDW_BM ?? ""; parameters[4].Value = model.CBDW_MC ?? ""; parameters[5].Value = model.FQDWBM; parameters[6].Value = model.FQL ?? ""; parameters[7].Value = model.CJSJ; parameters[8].Value = model.ZHXGSJ; parameters[9].Value = model.SLRQ; parameters[10].Value = model.AJMC ?? ""; parameters[11].Value = model.AJLB_BM ?? ""; parameters[12].Value = model.AJLB_MC ?? ""; parameters[13].Value = model.ZCJG_DWDM ?? ""; parameters[14].Value = model.ZCJG_DWMC ?? ""; parameters[15].Value = model.YSDW_DWDM ?? ""; parameters[16].Value = model.YSDW_DWMC ?? ""; parameters[17].Value = model.YSWSWH ?? ""; parameters[18].Value = model.YSAY_AYDM ?? ""; parameters[19].Value = model.YSAY_AYMC ?? ""; parameters[20].Value = model.YSQTAY_AYDMS ?? ""; parameters[21].Value = model.YSQTAY_AYMCS ?? ""; parameters[22].Value = model.CBRGH ?? ""; parameters[23].Value = model.CBR ?? ""; parameters[24].Value = model.CBBM_BM ?? ""; parameters[25].Value = model.CBBM_MC ?? ""; parameters[26].Value = model.AJZT ?? ""; parameters[27].Value = model.SFSWAJ ?? ""; parameters[28].Value = model.SFDBAJ ?? ""; parameters[29].Value = model.ZXHD_MC ?? ""; parameters[30].Value = model.WCRQ ?? Convert.ToDateTime("1900-01-01"); parameters[31].Value = model.GDRQ ?? Convert.ToDateTime("1900-01-01"); parameters[32].Value = model.GDRGH ?? ""; parameters[33].Value = model.GDR ?? ""; parameters[34].Value = model.AQZY ?? ""; parameters[35].Value = model.DQJD ?? ""; parameters[36].Value = model.BLKSRQ ?? Convert.ToDateTime("1900-01-01"); parameters[37].Value = model.BLTS ?? 0; parameters[38].Value = model.DQRQ ?? Convert.ToDateTime("1900-01-01"); parameters[39].Value = model.BJRQ ?? Convert.ToDateTime("1900-01-01"); parameters[40].Value = model.YJZT ?? ""; parameters[41].Value = model.JYYJZT ?? ""; parameters[42].Value = model.JYYJHCQXYRGS ?? 0; parameters[43].Value = model.LCSLBH ?? ""; parameters[44].Value = model.FXDJ ?? ""; parameters[45].Value = model.SFGZAJ ?? ""; parameters[46].Value = model.FZ ?? ""; parameters[47].Value = model.YSYJ_DM ?? ""; parameters[48].Value = model.YSYJ_MC ?? ""; parameters[49].Value = model.SFJBAJ ?? ""; parameters[50].Value = model.ZXHD_DM ?? ""; parameters[51].Value = model.DQYJJD ?? ""; parameters[52].Value = model.YASCSSJD_DM ?? ""; parameters[53].Value = model.YASCSSJD_MC ?? ""; parameters[54].Value = model.YSRJDH ?? ""; parameters[55].Value = model.BMSAH; parameters[56].Value = model.XYR ?? ""; parameters[57].Value = model.SFZH ?? ""; parameters[58].Value = model.TARYXX ?? ""; parameters[59].Value = model.SHR ?? ""; parameters[60].Value = model.SHSJ ?? DateTime.Now; parameters[61].Value = model.ZJS; parameters[62].Value = model.DJJ ?? ""; parameters[63].Value = model.ZYS; try { int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.TYYW_GG_AJJBXX model)", "EDRS.OracleDAL.TYYW_GG_AJJBXX", strSql.ToString(), parameters); } return(false); }
/// <summary> /// 添加配置数据 /// </summary> /// <returns></returns> private string AddData() { string type = Request.Form.Get("txt_type"); //打印类型 string ywlx = Request.Form.Get("txt_ywlx"); //业务名称 string ywbm = Request.Form.Get("txt_ywlx_val"); //业务名称 string nf = Request.Form.Get("txt_nf"); //年份 string z = Request.Form.Get("txt_z"); //字 string h = Request.Form.Get("txt_h"); //号 string bmsah = "(" + nf + ")" + UserDwbm.DWJC + z + "字第" + h + "号"; //(2016)深南法少刑初字第2号 string ajmc = Request.Form.Get("txt_fbt"); //案由 string lbmc = z; //类别名称 string ajlb = (string.IsNullOrEmpty(Request.Form.Get("txt_z_val")) ? "" : Request.Form.Get("txt_z_val")); //案件类别编码 string lasj = Request.Form.Get("txt_sasj"); //收案日期 string jasj = Request.Form.Get("txt_jasj"); //结案时间 string ladw = UserDwbm.DWBM; //Request.Form.Get("txt_ladw_val"); //立卷单位 string ladw_mc = UserDwbm.DWMC; // Request.Form.Get("txt_ladw"); //立卷单位名称 string ljr = ""; //Request.Form.Get("txt_lar_val"); //立卷人 string ljr_mc = string.IsNullOrEmpty(Request.Form.Get("txt_cbr")) ? "" : Request.Form.Get("txt_cbr"); //承办人 string shr = string.IsNullOrEmpty(Request.Form.Get("txt_shr")) ? "" : Request.Form.Get("txt_shr"); //审核人 string zjs = (string.IsNullOrEmpty(Request.Form.Get("txt_bjgjc")) ? "0" : Request.Form.Get("txt_bjgjc")); //本案共卷 string djj = string.IsNullOrEmpty(Request.Form.Get("txt_sdjc")) ? "0" : Request.Form.Get("txt_sdjc"); //第几卷 string djy = (string.IsNullOrEmpty(Request.Form.Get("txt_ngjy")) ? "0" : Request.Form.Get("txt_ngjy")); //第几页 string xyr = ""; //嫌疑人 string sfzh = ""; //身份证号 string taryxx = ""; //同人信息 string ajbh = ""; // Request.Form.Get("txt_ajbh"); //案件编号 string wsbh = ""; //Request.Form.Get("wsbh_hidd"); string wsmc = ""; //Request.Form.Get("txt_wsbh"); //判断案件名称 //if (string.IsNullOrEmpty(ajmc)) //{ // return ReturnString.JsonToString(Prompt.error, "必须填写案由", null); //} //判断年份 if (string.IsNullOrEmpty(nf)) { return(ReturnString.JsonToString(Prompt.error, "请选择年份", null)); } //判断字 if (string.IsNullOrEmpty(z)) { return(ReturnString.JsonToString(Prompt.error, "请选择字", null)); } //判断号 if (string.IsNullOrEmpty(h)) { return(ReturnString.JsonToString(Prompt.error, "必须填写号", null)); } //案号名称 if (string.IsNullOrEmpty(bmsah)) { return(ReturnString.JsonToString(Prompt.error, "必须填写案号名称", null)); } //案由 if (string.IsNullOrEmpty(ajmc)) { return(ReturnString.JsonToString(Prompt.error, "必须填写案由", null)); } //判断案件类别 if (string.IsNullOrEmpty(ajlb)) { return(ReturnString.JsonToString(Prompt.error, "必须填写案件类别", null)); } // EDRS.BLL.YX_DZJZ_JZJBXX jbxxbll = new YX_DZJZ_JZJBXX(Request); if (!string.IsNullOrEmpty(ajmc) && !string.IsNullOrEmpty(ajlb))//&& !string.IsNullOrEmpty(ajbh) { EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX(); EDRS.Model.YX_DZJZ_JZJBXX jbxxmodel = new EDRS.Model.YX_DZJZ_JZJBXX(); EDRS.Model.TYYW_GG_AJJBXXKZ modelkz = new EDRS.Model.TYYW_GG_AJJBXXKZ(); //EDRS.BLL.XT_DM_AJLBBM ajlbbmBll = new XT_DM_AJLBBM(Request); //EDRS.Model.XT_DM_AJLBBM ajlbModel = ajlbbmBll.GetModel(ajlb); //if (ajlbModel != null) // lbjc = ajlbModel.AJSLJC; //if (string.IsNullOrEmpty(lbjc)) // lbjc = lbmc; #region 公共案件基本信息 //string bmsahName = ajlb + "[" + DateTime.Now.Year + "]" + UserInfo.DWBM; //string num = "00001号"; //TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request); //DataSet ds = jzajxx.GetListByPage(" and bmsah like '" + bmsahName + "%'", "bmsah desc", 1, 1, null); //if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 1) //{ // num = ds.Tables[0].Rows[0]["bmsah"].ToString().Replace(bmsahName, "").Replace("号", ""); // num = (Convert.ToInt32(num) + 1).ToString().PadLeft(5, '0') + "号"; //} //山东省院起诉受[2015]37000000072号 //model.BMSAH = bmsahName + num; model.BMSAH = bmsah; model.TYSAH = Guid.NewGuid().ToString().ToUpper().Replace("-", ""); model.SFSC = "N"; model.SFYGXTSJ = "N"; model.CBDW_BM = UserInfo.DWBM; model.CBDW_MC = UserInfo.DWMC; model.FQDWBM = Convert.ToDecimal(UserInfo.DWBM.Substring(0, 4)); model.FQL = DateTime.Now.Year.ToString(); model.CJSJ = DateTime.Now; model.ZHXGSJ = DateTime.Now; model.SLRQ = (string.IsNullOrEmpty(lasj) ? DateTime.Now : Convert.ToDateTime(lasj));// DateTime.Now; model.AJMC = ajmc; model.AJLB_BM = ajlb; model.AJLB_MC = lbmc; model.XYR = xyr; model.SFZH = sfzh; model.TARYXX = taryxx; if (!string.IsNullOrEmpty(jasj)) { model.BJRQ = Convert.ToDateTime(jasj); } model.CBDW_BM = ladw; model.CBDW_MC = ladw_mc; model.CBR = ljr_mc; model.CBRGH = ljr; //2016-6-6 增字段 model.SHR = shr; //审核人 model.SHSJ = DateTime.Now; //审核时间 model.ZJS = Convert.ToDecimal(zjs); //总卷数 model.DJJ = djj; //第几卷 model.ZYS = Convert.ToDecimal(djy); //总页数 #endregion //if (jzajxx.Add(model)) //{ #region 卷宗基本信息 //string count = "0"; //count = jbxxbll.GetRecordCount("", null).ToString(); //count = count.PadLeft(5, '0'); jbxxmodel.JZBH = DateTime.Now.ToString("yyyyMMddHHmmssfff"); jbxxmodel.SFSC = "N"; jbxxmodel.CJSJ = DateTime.Now; jbxxmodel.ZHXGSJ = DateTime.Now; jbxxmodel.FQDWBM = 0; jbxxmodel.FQL = ""; jbxxmodel.DWBM = UserInfo.DWBM; jbxxmodel.BMSAH = model.BMSAH; jbxxmodel.TYSAH = model.TYSAH; //UserInfo.DWBM + DateTime.Now.ToString("yyyyMM") + jbxxbll.GetRecordCount("", null) + count; jbxxmodel.JZMC = ajmc; jbxxmodel.JZLJ = ""; jbxxmodel.JZSCSJ = DateTime.Now; jbxxmodel.JZSCRGH = UserInfo.GH; jbxxmodel.JZSCRXM = UserInfo.MC; jbxxmodel.JZMS = ""; jbxxmodel.JZXGH = "0"; jbxxmodel.SFKYGX = ""; jbxxmodel.GXYWBMJH = ""; jbxxmodel.MRSFGKPZ = ""; jbxxmodel.Accomplices = taryxx; jbxxmodel.Ajmb_bm = ajlb; jbxxmodel.Ajmb_mc = lbmc; jbxxmodel.Idnumber = sfzh; jbxxmodel.Isrecord = "0"; jbxxmodel.Suspectname = xyr; jbxxmodel.WSBH = wsbh; jbxxmodel.AJBH = ajbh; jbxxmodel.WSMC = wsmc; //jbxxmodel.ZZZT = "-1"; jbxxmodel.LAZZZT = "-1"; jbxxmodel.SMAJLA = "1"; jbxxmodel.SMAJCD = ""; #endregion #region 案件基本信息扩展 //modelkz.AJKZXH = ; modelkz.AHMC = bmsah; modelkz.AY = Request.Form.Get("txt_fbt"); modelkz.SAJG = Request.Form.Get("txt_ajmc"); modelkz.YG = Request.Form.Get("txt_ajbh"); modelkz.BG = Request.Form.Get("txt_fzxyr"); modelkz.YYR = string.IsNullOrEmpty(Request.Form.Get("txt_yyr")) ? "" : Request.Form.Get("txt_yyr"); modelkz.SQZXR = string.IsNullOrEmpty(Request.Form.Get("txt_sqzxr")) ? "" : Request.Form.Get("txt_sqzxr"); modelkz.BZXR = string.IsNullOrEmpty(Request.Form.Get("txt_bzxr")) ? "" : Request.Form.Get("txt_bzxr"); modelkz.SARQ = Convert.ToDateTime(Request.Form.Get("txt_sasj")); modelkz.JARQ = Convert.ToDateTime(Request.Form.Get("txt_jasj")); modelkz.CJJG = string.IsNullOrEmpty(Request.Form.Get("txt_cjjg")) ? "" : Request.Form.Get("txt_cjjg"); modelkz.ZXBD = string.IsNullOrEmpty(Request.Form.Get("txt_zxby")) ? "" : Request.Form.Get("txt_zxby"); modelkz.SLJG = string.IsNullOrEmpty(Request.Form.Get("txt_shjg")) ? "" : Request.Form.Get("txt_shjg"); modelkz.ZXJG = string.IsNullOrEmpty(Request.Form.Get("txt_zxjg")) ? "" : Request.Form.Get("txt_zxjg"); modelkz.JAFS = string.IsNullOrEmpty(Request.Form.Get("txt_jafs")) ? "" : Request.Form.Get("txt_jafs"); modelkz.GLDAXLH = string.IsNullOrEmpty(Request.Form.Get("txt_gldaxlh")) ? "" : Request.Form.Get("txt_gldaxlh"); modelkz.HYTCY = string.IsNullOrEmpty(Request.Form.Get("txt_hytcy")) ? "" : Request.Form.Get("txt_hytcy"); modelkz.CBR = string.IsNullOrEmpty(Request.Form.Get("txt_cbr")) ? "" : Request.Form.Get("txt_cbr"); modelkz.SJY = string.IsNullOrEmpty(Request.Form.Get("txt_sjy")) ? "" : Request.Form.Get("txt_sjy"); modelkz.ZCS = string.IsNullOrEmpty(Request.Form.Get("txt_bjgjc")) ? 0 : Convert.ToDecimal(Request.Form.Get("txt_bjgjc")); modelkz.DJC = string.IsNullOrEmpty(Request.Form.Get("txt_sdjc")) ? 0 : Convert.ToDecimal(Request.Form.Get("txt_sdjc")); modelkz.YS = string.IsNullOrEmpty(Request.Form.Get("txt_ngjy")) ? 0 : Convert.ToDecimal(Request.Form.Get("txt_ngjy")); modelkz.GDRQ = Convert.ToDateTime(Request.Form.Get("txt_gdrq")); modelkz.YWT = string.IsNullOrEmpty(Request.Form.Get("txt_ywt")) ? "" : Request.Form.Get("txt_ywt"); modelkz.BGQX = string.IsNullOrEmpty(Request.Form.Get("txt_bgqx")) ? "" : Request.Form.Get("txt_bgqx"); modelkz.AJLBBM = string.IsNullOrEmpty(Request.Form.Get("txt_z_val")) ? "" : Request.Form.Get("txt_z_val"); modelkz.AJLBMC = string.IsNullOrEmpty(Request.Form.Get("txt_z")) ? "" : Request.Form.Get("txt_z"); modelkz.H = Convert.ToDecimal(Request.Form.Get("txt_h")); modelkz.NF = string.IsNullOrEmpty(Request.Form.Get("txt_nf")) ? "" : Request.Form.Get("txt_nf"); modelkz.YWLBBM = string.IsNullOrEmpty(ywbm) ? "" : ywbm; modelkz.YWLBMC = string.IsNullOrEmpty(ywlx) ? "" : ywlx; modelkz.DWBM = UserInfo.DWBM; modelkz.DWMC = UserInfo.DWMC; modelkz.DWJC = UserDwbm.DWJC; modelkz.QAH = ""; modelkz.MLH = "G" + ywbm + "." + modelkz.AJLBBM; modelkz.JH = ""; modelkz.CZRGH = UserInfo.GH; modelkz.CZRMC = UserInfo.MC; modelkz.CZSJ = DateTime.Now; #endregion #region 操作制作参数 EDRS.BLL.XY_DZJZ_XTPZ xtpzbll = new EDRS.BLL.XY_DZJZ_XTPZ(Request); EDRS.Model.XY_DZJZ_XTPZ xtpz = xtpzbll.GetConfigById(EnumConfig.卷宗文件上传地址); if (xtpz == null) { return(ReturnString.JsonToString(Prompt.error, "请先配置卷宗文件上传地址", null)); } string linkType = string.Empty; //链接类型 string callBack = string.Empty; //路由链接模式地址 XT_DZJZ_ZZCS zzcsbll = new XT_DZJZ_ZZCS(Request); string bmbm = ""; string bmmc = ""; if (UserRole != null && UserRole.Count > 0) { bmbm = UserRole[0].BMBM; bmmc = UserRole[0].BMMC; } string strstring = string.Empty; string[] zks = new string[] { "BMSAH", "SFDC", "DWBM", "MC", "GH", "DWMC", "BMBM", "BMMC", "LJLX", "DZ1", "DZ2", "AJBH", "WSBH", "WSMC" }; List <EDRS.Model.XT_DZJZ_ZZCS> zzcsList = new List <EDRS.Model.XT_DZJZ_ZZCS>(); EDRS.Model.XT_DZJZ_ZZCS zzcsModel = null; string guid = Guid.NewGuid().ToString(); foreach (string dr in zks) { //制作参数(部门受案号,是否导出,单位编码,用户名称,单位名称,部门编码,部门名称,连接类型,文件上传地址,回调地址)<add key="ZzCsKey" value="BMSAH,SFDC,DWBM,MC,GH,DWMC,BMBM,BMMC,LJLX,DZ1,DZ2"/> zzcsModel = new EDRS.Model.XT_DZJZ_ZZCS(); zzcsModel.CSKEY = dr; zzcsModel.FZBS = guid; zzcsModel.DYSJ = DateTime.Now; switch (zzcsModel.CSKEY) { case "BMSAH": zzcsModel.CSVALUE = model.BMSAH; break; case "SFDC": zzcsModel.CSVALUE = type; break; case "DWBM": zzcsModel.CSVALUE = base.UserInfo.DWBM; break; case "MC": zzcsModel.CSVALUE = base.UserInfo.MC; break; case "GH": zzcsModel.CSVALUE = UserInfo.GH; break; case "DWMC": zzcsModel.CSVALUE = UserInfo.DWMC; break; case "BMBM": zzcsModel.CSVALUE = bmbm; break; case "BMMC": zzcsModel.CSVALUE = bmmc; break; case "LJLX": object obj3 = xtpzbll.GetConfigById(EnumConfig.连接类型); if (obj3 != null) { linkType = zzcsModel.CSVALUE = ((EDRS.Model.XY_DZJZ_XTPZ)obj3).CONFIGVALUE; } else { zzcsModel.CSVALUE = ""; } break; case "DZ1": zzcsModel.CSVALUE = xtpz.CONFIGVALUE; break; case "DZ2": object obj4 = xtpzbll.GetConfigById(EnumConfig.路由映射地址); if (obj4 != null && obj4 != DBNull.Value) { callBack = zzcsModel.CSVALUE = ((EDRS.Model.XY_DZJZ_XTPZ)obj4).CONFIGVALUE; } else { zzcsModel.CSVALUE = ""; } break; case "AJBH": zzcsModel.CSVALUE = ajbh; break; case "WSBH": zzcsModel.CSVALUE = wsbh; break; case "WSMC": zzcsModel.CSVALUE = wsmc; break; default: zzcsModel.CSVALUE = ""; break; } zzcsList.Add(zzcsModel); } if (zzcsbll.AddList(zzcsList)) { strstring = xtpz.CONFIGVALUE + "@" + linkType + "@" + callBack + "@" + guid + "@" + type; } #endregion EDRS.BLL.TYYW_GG_AJJBXX bll = new TYYW_GG_AJJBXX(Request); //判断存在调用修改 if (bll.GetRecordCount(" and BMSAH=:BMSAH", new object[] { bmsah }) > 0) { if (bll.UpdateList(model, modelkz, jbxxmodel)) { OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "成功", model.BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, DESEncrypt.Encrypt(strstring), null)); } OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "保存数据失败", model.BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存数据失败", null)); } if (bll.AddList(model, modelkz, jbxxmodel)) { if (xtpz != null) { OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "成功", model.BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, DESEncrypt.Encrypt(strstring), null)); } return(ReturnString.JsonToString(Prompt.win, "未设置服务链接地址", null)); } OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "失败", model.BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "添加" + ((VersionName)0).ToString() + "失败", null)); } return(ReturnString.JsonToString(Prompt.error, "请将" + ((VersionName)0).ToString() + "信息填写完整", null)); }
/// <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> /// 保存分配案件文件 /// </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)); }