Пример #1
0
        private string submitapply()
        {
            EDRS.BLL.YX_DZJZ_JZMLWJ bll   = new EDRS.BLL.YX_DZJZ_JZMLWJ(Request);
            EDRS.BLL.YX_DZJZ_WJSQDY BLLSQ = new EDRS.BLL.YX_DZJZ_WJSQDY(Request);
            string id   = Request["id"];
            string wjxh = Request.Form["yjxh"];
            string sq   = string.Empty;

            if (!string.IsNullOrEmpty(id))
            {
                sq = " and JZWJBH=:JZWJBH";
            }

            DataSet   d  = BLLSQ.GetList(sq, new[] { id });
            DataTable dt = d.Tables[0];

            //判断该案件是否已在申请中.
            if (dt != null && dt.Rows.Count == 0)
            {
                string str = string.Empty;
                str = " and wjxh=:wjxh";
                DataSet ds = bll.GetList(str, new[] { id });
                if (ds.Tables[0].Rows.Count > 0)
                {
                    //string bmsah = ds.Tables[0].Rows[0]["BMSAH"].ToString();
                    EDRS.Model.YX_DZJZ_WJSQDY model = new EDRS.Model.YX_DZJZ_WJSQDY();
                    model.BMSAH  = ds.Tables[0].Rows[0]["BMSAH"].ToString();
                    model.DYBMBM = "";  //打印部门编码
                    model.DYBMMC = "";
                    model.DYDWBM = "";
                    model.DYDWMC = "";
                    model.DYFS   = null;         //打印份数
                    model.DYFY   = null;         //打印费用
                    model.DYR    = "";           //打印人
                    model.DYRGH  = "";           //打印人工号
                    model.DYSJ   = null;         //打印时间
                    model.LSZH   = UserInfo.GH;  //律师证号
                    model.DYSQDH = DateTime.Now.ToString("yyyyMMddHHmmssfff") + model.LSZH;
                    model.JZWJBH = id;           //文件编号
                    model.SFSC   = "N";
                    model.SQFS   = 1;            //申请份数
                    model.SQSJ   = DateTime.Now; //申请时间
                    model.YJXH   = wjxh;         //阅卷序号

                    if (BLLSQ.Add(model))
                    {
                        return(ReturnString.JsonToString(Prompt.win, "申请成功", null));
                    }
                    else
                    {
                        return(ReturnString.JsonToString(Prompt.error, "申请失败", null));
                    }
                }
            }
            else
            {
                return(ReturnString.JsonToString(Prompt.error, "该文件已申请", null));
            }
            return(ReturnString.JsonToString(Prompt.error, "未获取文件信息", null));
        }
Пример #2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public EDRS.Model.YX_DZJZ_WJSQDY GetModel(string XH)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select LSZH,BMSAH,YJXH,JZWJBH,SQSJ,SQFS,DYSJ,DYFS,DYFY,DYR,DYRGH,DYBMBM,DYBMMC,DYDWBM,DYDWMC,SFSC,DYSQDH,XH from YX_DZJZ_WJSQDY ");
            strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
            strSql.Append(" where XH=:XH ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":XH", OracleType.VarChar, 50)
            };
            parameters[0].Value = XH;

            EDRS.Model.YX_DZJZ_WJSQDY model = new EDRS.Model.YX_DZJZ_WJSQDY();
            DataSet ds = null;

            try
            {
                ds = DbHelperOra.Query(strSql.ToString(), parameters);
            }
            catch (Exception ex)
            {
                EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "ppublic EDRS.Model.YX_DZJZ_WJSQDY GetModel(string XH)", "EDRS.OracleDAL.YX_DZJZ_WJSQDY", strSql.ToString(), parameters);
            }
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Пример #3
0
        public string submitapplyall()
        {
            EDRS.BLL.YX_DZJZ_JZMLWJ bll   = new EDRS.BLL.YX_DZJZ_JZMLWJ(Request);
            EDRS.BLL.YX_DZJZ_WJSQDY BLLSQ = new EDRS.BLL.YX_DZJZ_WJSQDY(Request);
            string idstr = Request.Form["idstr[]"];
            string yjxh  = Request.Form["yjxh"];

            if (!string.IsNullOrEmpty(idstr))
            {
                List <EDRS.Model.YX_DZJZ_WJSQDY> wlist = new List <EDRS.Model.YX_DZJZ_WJSQDY>();
                string[] idarr = idstr.Split(',');

                for (int i = 0; i < idarr.Length; i++)
                {
                    string sq = string.Empty;
                    sq = " and JZWJBH=:JZWJBH";
                    DataSet   d  = BLLSQ.GetList(sq, new[] { idarr[i] });
                    DataTable dt = d.Tables[0];
                    //判断是否存在该申请记录
                    if (dt != null && dt.Rows.Count == 0)
                    {
                        string lszh = UserInfo.GH;
                        string str  = string.Empty;
                        str = " and wjxh=:wjxh";
                        DataSet ds = bll.GetList(str, new[] { idarr[i] });
                        if (ds.Tables[0].Rows.Count > 0)
                        {
                            EDRS.Model.YX_DZJZ_WJSQDY model = new EDRS.Model.YX_DZJZ_WJSQDY();
                            model.BMSAH  = ds.Tables[0].Rows[0]["BMSAH"].ToString();
                            model.DYBMBM = "";  //打印部门编码
                            model.DYBMMC = "";
                            model.DYDWBM = "";
                            model.DYDWMC = "";
                            model.DYFS   = null;         //打印份数
                            model.DYFY   = null;         //打印费用
                            model.DYR    = "";           //打印人
                            model.DYRGH  = "";           //打印人工号
                            model.DYSJ   = null;         //打印时间
                            model.LSZH   = UserInfo.GH;  //律师证号
                            model.DYSQDH = DateTime.Now.ToString("yyyyMMddHHmmssfff") + model.LSZH;
                            model.JZWJBH = idarr[i];     //文件编号
                            model.SFSC   = "N";
                            model.SQFS   = 1;            //申请份数
                            model.SQSJ   = DateTime.Now; //申请时间
                            model.YJXH   = yjxh;         //阅卷序号
                            //添加到集合
                            wlist.Add(model);
                        }
                    }
                }
                if (BLLSQ.AddList(wlist))
                {
                    return(ReturnString.JsonToString(Prompt.win, "提交申请成功", null));
                }
                else
                {
                    return(ReturnString.JsonToString(Prompt.error, "提交申请失败", null));
                }
            }
            return(ReturnString.JsonToString(Prompt.error, "未获取文件信息", null));
        }
Пример #4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(EDRS.Model.YX_DZJZ_WJSQDY model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into YX_DZJZ_WJSQDY(");
            strSql.Append("LSZH,BMSAH,YJXH,JZWJBH,SQSJ,SQFS,DYSJ,DYFS,DYFY,DYR,DYRGH,DYBMBM,DYBMMC,DYDWBM,DYDWMC,SFSC,DYSQDH)");
            strSql.Append(" values (");
            strSql.Append(":LSZH,:BMSAH,:YJXH,:JZWJBH,:SQSJ,:SQFS,:DYSJ,:DYFS,:DYFY,:DYR,:DYRGH,:DYBMBM,:DYBMMC,:DYDWBM,:DYDWMC,:SFSC,:DYSQDH)");
            OracleParameter[] parameters =
            {
                new OracleParameter(":LSZH",   OracleType.VarChar,   100),
                new OracleParameter(":BMSAH",  OracleType.VarChar,   100),
                new OracleParameter(":YJXH",   OracleType.VarChar,    50),
                new OracleParameter(":JZWJBH", OracleType.VarChar,    50),
                new OracleParameter(":SQSJ",   OracleType.DateTime),
                new OracleParameter(":SQFS",   OracleType.Number,      4),
                new OracleParameter(":DYSJ",   OracleType.DateTime),
                new OracleParameter(":DYFS",   OracleType.Number,      4),
                new OracleParameter(":DYFY",   OracleType.Number,      8),
                new OracleParameter(":DYR",    OracleType.VarChar,    60),
                new OracleParameter(":DYRGH",  OracleType.Char,        4),
                new OracleParameter(":DYBMBM", OracleType.Char,        4),
                new OracleParameter(":DYBMMC", OracleType.VarChar,   300),
                new OracleParameter(":DYDWBM", OracleType.VarChar,    50),
                new OracleParameter(":DYDWMC", OracleType.VarChar,   300),
                new OracleParameter(":SFSC",   OracleType.Char,        1),
                new OracleParameter(":DYSQDH", OracleType.VarChar, 50)
            };
            parameters[0].Value  = model.LSZH;
            parameters[1].Value  = model.BMSAH;
            parameters[2].Value  = model.YJXH;
            parameters[3].Value  = model.JZWJBH;
            parameters[4].Value  = model.SQSJ;
            parameters[5].Value  = model.SQFS;
            parameters[6].Value  = model.DYSJ ?? (object)DBNull.Value;
            parameters[7].Value  = model.DYFS ?? (object)DBNull.Value;
            parameters[8].Value  = model.DYFY ?? (object)DBNull.Value;
            parameters[9].Value  = model.DYR;
            parameters[10].Value = model.DYRGH;
            parameters[11].Value = model.DYBMBM;
            parameters[12].Value = model.DYBMMC;
            parameters[13].Value = model.DYDWBM;
            parameters[14].Value = model.DYDWMC;
            parameters[15].Value = model.SFSC;
            parameters[16].Value = model.DYSQDH;

            int rows = 0;

            try
            {
                rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
            }
            catch (Exception ex)
            {
                EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.YX_DZJZ_WJSQDY model)", "EDRS.OracleDAL.YX_DZJZ_WJSQDY", strSql.ToString(), parameters);
            }
            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #5
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public EDRS.Model.YX_DZJZ_WJSQDY DataRowToModel(DataRow row)
 {
     EDRS.Model.YX_DZJZ_WJSQDY model = new EDRS.Model.YX_DZJZ_WJSQDY();
     if (row != null)
     {
         if (row["LSZH"] != null)
         {
             model.LSZH = row["LSZH"].ToString();
         }
         if (row["BMSAH"] != null)
         {
             model.BMSAH = row["BMSAH"].ToString();
         }
         if (row["YJXH"] != null && row["YJXH"].ToString() != "")
         {
             model.YJXH = row["YJXH"].ToString();
         }
         if (row["JZWJBH"] != null)
         {
             model.JZWJBH = row["JZWJBH"].ToString();
         }
         if (row["SQSJ"] != null && row["SQSJ"].ToString() != "")
         {
             model.SQSJ = DateTime.Parse(row["SQSJ"].ToString());
         }
         if (row["SQFS"] != null && row["SQFS"].ToString() != "")
         {
             model.SQFS = decimal.Parse(row["SQFS"].ToString());
         }
         if (row["DYSJ"] != null && row["DYSJ"].ToString() != "")
         {
             model.DYSJ = DateTime.Parse(row["DYSJ"].ToString());
         }
         if (row["DYFS"] != null && row["DYFS"].ToString() != "")
         {
             model.DYFS = decimal.Parse(row["DYFS"].ToString());
         }
         if (row["DYFY"] != null && row["DYFY"].ToString() != "")
         {
             model.DYFY = decimal.Parse(row["DYFY"].ToString());
         }
         if (row["DYR"] != null)
         {
             model.DYR = row["DYR"].ToString();
         }
         if (row["DYRGH"] != null)
         {
             model.DYRGH = row["DYRGH"].ToString();
         }
         if (row["DYBMBM"] != null)
         {
             model.DYBMBM = row["DYBMBM"].ToString();
         }
         if (row["DYBMMC"] != null)
         {
             model.DYBMMC = row["DYBMMC"].ToString();
         }
         if (row["DYDWBM"] != null)
         {
             model.DYDWBM = row["DYDWBM"].ToString();
         }
         if (row["DYDWMC"] != null)
         {
             model.DYDWMC = row["DYDWMC"].ToString();
         }
         if (row["SFSC"] != null)
         {
             model.SFSC = row["SFSC"].ToString();
         }
         if (row["DYSQDH"] != null)
         {
             model.DYSQDH = row["DYSQDH"].ToString();
         }
         if (row["XH"] != null)
         {
             model.XH = row["XH"].ToString();
         }
     }
     return(model);
 }
Пример #6
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(EDRS.Model.YX_DZJZ_WJSQDY model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update YX_DZJZ_WJSQDY set ");
            strSql.Append("LSZH=:LSZH,");
            strSql.Append("BMSAH=:BMSAH,");
            strSql.Append("YJXH=:YJXH,");
            strSql.Append("JZWJBH=:JZWJBH,");
            strSql.Append("SQSJ=:SQSJ,");
            strSql.Append("SQFS=:SQFS,");
            strSql.Append("DYSJ=:DYSJ,");
            strSql.Append("DYFS=:DYFS,");
            strSql.Append("DYFY=:DYFY,");
            strSql.Append("DYR=:DYR,");
            strSql.Append("DYRGH=:DYRGH,");
            strSql.Append("DYBMBM=:DYBMBM,");
            strSql.Append("DYBMMC=:DYBMMC,");
            strSql.Append("DYDWBM=:DYDWBM,");
            strSql.Append("DYDWMC=:DYDWMC,");
            strSql.Append("SFSC=:SFSC,");
            strSql.Append("DYSQDH=:DYSQDH");
            strSql.Append(" where XH=:XH ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":LSZH",   OracleType.VarChar,   100),
                new OracleParameter(":BMSAH",  OracleType.VarChar,   100),
                new OracleParameter(":YJXH",   OracleType.VarChar,    50),
                new OracleParameter(":JZWJBH", OracleType.VarChar,    50),
                new OracleParameter(":SQSJ",   OracleType.DateTime),
                new OracleParameter(":SQFS",   OracleType.Number,      4),
                new OracleParameter(":DYSJ",   OracleType.DateTime),
                new OracleParameter(":DYFS",   OracleType.Number,      4),
                new OracleParameter(":DYFY",   OracleType.Number,      8),
                new OracleParameter(":DYR",    OracleType.VarChar,    60),
                new OracleParameter(":DYRGH",  OracleType.Char,        4),
                new OracleParameter(":DYBMBM", OracleType.Char,        4),
                new OracleParameter(":DYBMMC", OracleType.VarChar,   300),
                new OracleParameter(":DYDWBM", OracleType.VarChar,    50),
                new OracleParameter(":DYDWMC", OracleType.VarChar,   300),
                new OracleParameter(":SFSC",   OracleType.Char,        1),
                new OracleParameter(":DYSQDH", OracleType.VarChar,    50),
                new OracleParameter(":XH",     OracleType.VarChar, 50)
            };
            parameters[0].Value  = model.LSZH;
            parameters[1].Value  = model.BMSAH;
            parameters[2].Value  = model.YJXH;
            parameters[3].Value  = model.JZWJBH;
            parameters[4].Value  = model.SQSJ;
            parameters[5].Value  = model.SQFS;
            parameters[6].Value  = model.DYSJ;
            parameters[7].Value  = model.DYFS;
            parameters[8].Value  = model.DYFY;
            parameters[9].Value  = model.DYR;
            parameters[10].Value = model.DYRGH;
            parameters[11].Value = model.DYBMBM;
            parameters[12].Value = model.DYBMMC;
            parameters[13].Value = model.DYDWBM;
            parameters[14].Value = model.DYDWMC;
            parameters[15].Value = model.SFSC;
            parameters[16].Value = model.DYSQDH;
            parameters[17].Value = model.XH;

            int rows = 0;

            try
            {
                rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
            }
            catch (Exception ex)
            {
                EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.YX_DZJZ_WJSQDY model)", "EDRS.OracleDAL.YX_DZJZ_WJSQDY", strSql.ToString(), parameters);
            }
            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #7
0
        public string submitapplyall()
        {
            EDRS.BLL.YX_DZJZ_JZMLWJ bll   = new EDRS.BLL.YX_DZJZ_JZMLWJ(Request);
            EDRS.BLL.YX_DZJZ_WJSQDY BLLSQ = new EDRS.BLL.YX_DZJZ_WJSQDY(Request);
            string idstr = Request.Form["idstr[]"];
            string yjxh  = Request.Form["yjxh"];

            if (!string.IsNullOrEmpty(idstr))
            {
                #region 申请打印

                EDRS.BLL.YX_DZJZ_LSAJBD dbbll = new EDRS.BLL.YX_DZJZ_LSAJBD(Request);
                //获取部门部门受案号
                EDRS.Model.YX_DZJZ_LSAJBD dbmodel = dbbll.GetModel(yjxh);
                //判断该申请打印是否存在
                EDRS.Model.YX_DZJZ_WJSQDY model = BLLSQ.GetModelByYJXH(yjxh);
                if (model != null)
                {
                    model.SQSJ  = DateTime.Now;
                    model.DYR   = "";
                    model.DYRGH = "";
                    model.DYSJ  = null;
                }
                else
                {
                    model        = new EDRS.Model.YX_DZJZ_WJSQDY();
                    model.BMSAH  = dbmodel.BMSAH;
                    model.DYBMBM = "";  //打印部门编码
                    model.DYBMMC = "";
                    model.DYDWBM = "";
                    model.DYDWMC = "";
                    model.DYFS   = null;                 //打印份数
                    model.DYFY   = null;                 //打印费用
                    model.DYR    = "";                   //打印人
                    model.DYRGH  = "";                   //打印人工号
                    model.DYSJ   = null;                 //打印时间
                    model.LSZH   = Request.Form["lszh"]; //律师证号
                    model.DYSQDH = DateTime.Now.ToString("yyyyMMddHHmmssfff") + model.LSZH;
                    model.JZWJBH = "";                   //文件编号
                    model.SFSC   = "N";
                    model.SQFS   = 1;                    //申请份数
                    model.SQSJ   = DateTime.Now;         //申请时间
                    model.YJXH   = yjxh;                 //阅卷序号
                    model.XH     = Guid.NewGuid().ToString();
                }
                #endregion

                #region 申请打印记录
                List <EDRS.Model.YX_DZJZ_WJSQDYJL> sqjlList = new List <EDRS.Model.YX_DZJZ_WJSQDYJL>();

                string[] idarr = idstr.Split(',');

                //根据序号获取打印记录
                DataSet ds = BLLSQ.GetListDYJL(" and XH ='" + model.XH + "'");

                EDRS.Model.YX_DZJZ_WJSQDYJL sqjlModel = null;
                for (int i = 0; i < idarr.Length; i++)
                {
                    DataRow[] dr = null;
                    if (ds != null)
                    {
                        dr = ds.Tables[0].Select("WJXH='" + idarr[i] + "'");
                    }
                    if (dr == null || dr.Length == 0)
                    {
                        sqjlModel         = new EDRS.Model.YX_DZJZ_WJSQDYJL();
                        sqjlModel.WJXH    = idarr[i];
                        sqjlModel.XH      = model.XH;
                        sqjlModel.YJXH    = model.YJXH;
                        sqjlModel.ADDTIME = DateTime.Now;
                        sqjlModel.SFSC    = "N";
                        sqjlList.Add(sqjlModel);
                    }
                }
                #endregion

                if (BLLSQ.AddListJL(sqjlList, model, model.XH))
                {
                    return(ReturnString.JsonToString(Prompt.win, "提交申请成功", null));
                }
                else
                {
                    return(ReturnString.JsonToString(Prompt.error, "提交申请失败", null));
                }
            }
            return(ReturnString.JsonToString(Prompt.error, "未获取文件信息", null));
        }
Пример #8
0
        /// <summary>
        /// 增加多条文件申请打印记录
        /// </summary>
        public bool AddListJL(List <EDRS.Model.YX_DZJZ_WJSQDYJL> sqdyjlList, EDRS.Model.YX_DZJZ_WJSQDY sqdyModel, string xh)
        {
            int count = 0;

            Dictionary <object, object> hash = new Dictionary <object, object>();

            StringBuilder strSql = new StringBuilder();

            // strSql.Append(" update YX_DZJZ_WJSQDYJL set SFSC='Y' where XH=:YJXH ");
            strSql.Append(" Delete YX_DZJZ_WJSQDY where XH=:YJXH ");
            OracleParameter[] parameters1 =
            {
                new OracleParameter(":YJXH", OracleType.VarChar, 50)
            };
            parameters1[0].Value = xh;
            hash.Add(strSql.ToString(), parameters1);


            #region 添加阅卷申请打印
            strSql.Clear();
            strSql.Append("insert into YX_DZJZ_WJSQDY(");
            strSql.Append("LSZH,BMSAH,YJXH,JZWJBH,SQSJ,SQFS,DYSJ,DYFS,DYFY,DYR,DYRGH,DYBMBM,DYBMMC,DYDWBM,DYDWMC,SFSC,DYSQDH,XH)");
            strSql.Append(" values (");
            strSql.Append(":LSZH,:BMSAH,:YJXH,:JZWJBH,:SQSJ,:SQFS,:DYSJ,:DYFS,:DYFY,:DYR,:DYRGH,:DYBMBM,:DYBMMC,:DYDWBM,:DYDWMC,:SFSC,:DYSQDH,:XH)");
            OracleParameter[] parameters =
            {
                new OracleParameter(":LSZH",   OracleType.VarChar,   100),
                new OracleParameter(":BMSAH",  OracleType.VarChar,   100),
                new OracleParameter(":YJXH",   OracleType.VarChar,    50),
                new OracleParameter(":JZWJBH", OracleType.VarChar,    50),
                new OracleParameter(":SQSJ",   OracleType.DateTime),
                new OracleParameter(":SQFS",   OracleType.Number,      4),
                new OracleParameter(":DYSJ",   OracleType.DateTime),
                new OracleParameter(":DYFS",   OracleType.Number,      4),
                new OracleParameter(":DYFY",   OracleType.Number,      8),
                new OracleParameter(":DYR",    OracleType.VarChar,    60),
                new OracleParameter(":DYRGH",  OracleType.Char,        4),
                new OracleParameter(":DYBMBM", OracleType.Char,        4),
                new OracleParameter(":DYBMMC", OracleType.VarChar,   300),
                new OracleParameter(":DYDWBM", OracleType.VarChar,    50),
                new OracleParameter(":DYDWMC", OracleType.VarChar,   300),
                new OracleParameter(":SFSC",   OracleType.Char,        1),
                new OracleParameter(":DYSQDH", OracleType.VarChar,    50),
                new OracleParameter(":XH",     OracleType.VarChar, 50)
            };
            parameters[0].Value  = sqdyModel.LSZH ?? "";
            parameters[1].Value  = sqdyModel.BMSAH ?? "";
            parameters[2].Value  = sqdyModel.YJXH ?? "";
            parameters[3].Value  = sqdyModel.JZWJBH ?? "";
            parameters[4].Value  = sqdyModel.SQSJ ?? (object)DBNull.Value;
            parameters[5].Value  = sqdyModel.SQFS ?? (object)DBNull.Value;
            parameters[6].Value  = sqdyModel.DYSJ ?? (object)DBNull.Value;
            parameters[7].Value  = sqdyModel.DYFS ?? (object)DBNull.Value;
            parameters[8].Value  = sqdyModel.DYFY ?? (object)DBNull.Value;
            parameters[9].Value  = sqdyModel.DYR ?? "";
            parameters[10].Value = sqdyModel.DYRGH ?? "";
            parameters[11].Value = sqdyModel.DYBMBM ?? "";
            parameters[12].Value = sqdyModel.DYBMMC ?? "";
            parameters[13].Value = sqdyModel.DYDWBM ?? "";
            parameters[14].Value = sqdyModel.DYDWMC ?? "";
            parameters[15].Value = sqdyModel.SFSC ?? "";
            parameters[16].Value = sqdyModel.DYSQDH ?? "";
            parameters[17].Value = sqdyModel.XH ?? "";

            hash.Add(strSql.ToString(), parameters);
            #endregion

            #region 阅卷申请记录
            foreach (EDRS.Model.YX_DZJZ_WJSQDYJL model in sqdyjlList)
            {
                strSql.Clear();
                strSql.Append(" insert into YX_DZJZ_WJSQDYJL(");
                strSql.Append("XH,YJXH,WJXH,SFSC,ADDTIME,WJLJ)");
                strSql.Append(" values (");
                strSql.Append(":XH" + count + ",:YJXH" + count + ",:WJXH" + count + ",:SFSC" + count + ",:ADDTIME" + count + ",:WJLJ" + count + ")");
                OracleParameter[] parameters2 =
                {
                    new OracleParameter(":XH" + count,      OracleType.VarChar,    50),
                    new OracleParameter(":YJXH" + count,    OracleType.VarChar,    50),
                    new OracleParameter(":WJXH" + count,    OracleType.VarChar,   100),
                    new OracleParameter(":SFSC" + count,    OracleType.Char,        1),
                    new OracleParameter(":ADDTIME" + count, OracleType.DateTime),
                    new OracleParameter(":WJLJ" + count,    OracleType.VarChar, 1000)
                };
                parameters2[0].Value = xh;
                parameters2[1].Value = model.YJXH;
                parameters2[2].Value = model.WJXH;
                parameters2[3].Value = "N";
                parameters2[4].Value = model.ADDTIME;
                parameters2[5].Value = model.WJLJ;

                hash.Add(strSql.ToString(), parameters2);
                count++;
            }
            #endregion
            try
            {
                return(DbHelperOra.ExecuteSqlTran(hash));
            }
            catch (Exception ex)
            {
                EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddListJL(List<EDRS.Model.YX_DZJZ_WJSQDYJL> sqdyjlList, EDRS.Model.YX_DZJZ_WJSQDY sqdyModel, string xh)", "EDRS.OracleDAL.YX_DZJZ_WJSQDYJL");
            }
            return(false);
        }