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)); }
/// <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); } }
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)); }
/// <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); } }
/// <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); }
/// <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); } }
public string submitapplyall() { EDRS.BLL.YX_DZJZ_JZMLWJ bll = new EDRS.BLL.YX_DZJZ_JZMLWJ(Request); EDRS.BLL.YX_DZJZ_WJSQDY BLLSQ = new EDRS.BLL.YX_DZJZ_WJSQDY(Request); string idstr = Request.Form["idstr[]"]; string yjxh = Request.Form["yjxh"]; if (!string.IsNullOrEmpty(idstr)) { #region 申请打印 EDRS.BLL.YX_DZJZ_LSAJBD dbbll = new EDRS.BLL.YX_DZJZ_LSAJBD(Request); //获取部门部门受案号 EDRS.Model.YX_DZJZ_LSAJBD dbmodel = dbbll.GetModel(yjxh); //判断该申请打印是否存在 EDRS.Model.YX_DZJZ_WJSQDY model = BLLSQ.GetModelByYJXH(yjxh); if (model != null) { model.SQSJ = DateTime.Now; model.DYR = ""; model.DYRGH = ""; model.DYSJ = null; } else { model = new EDRS.Model.YX_DZJZ_WJSQDY(); model.BMSAH = dbmodel.BMSAH; model.DYBMBM = ""; //打印部门编码 model.DYBMMC = ""; model.DYDWBM = ""; model.DYDWMC = ""; model.DYFS = null; //打印份数 model.DYFY = null; //打印费用 model.DYR = ""; //打印人 model.DYRGH = ""; //打印人工号 model.DYSJ = null; //打印时间 model.LSZH = Request.Form["lszh"]; //律师证号 model.DYSQDH = DateTime.Now.ToString("yyyyMMddHHmmssfff") + model.LSZH; model.JZWJBH = ""; //文件编号 model.SFSC = "N"; model.SQFS = 1; //申请份数 model.SQSJ = DateTime.Now; //申请时间 model.YJXH = yjxh; //阅卷序号 model.XH = Guid.NewGuid().ToString(); } #endregion #region 申请打印记录 List <EDRS.Model.YX_DZJZ_WJSQDYJL> sqjlList = new List <EDRS.Model.YX_DZJZ_WJSQDYJL>(); string[] idarr = idstr.Split(','); //根据序号获取打印记录 DataSet ds = BLLSQ.GetListDYJL(" and XH ='" + model.XH + "'"); EDRS.Model.YX_DZJZ_WJSQDYJL sqjlModel = null; for (int i = 0; i < idarr.Length; i++) { DataRow[] dr = null; if (ds != null) { dr = ds.Tables[0].Select("WJXH='" + idarr[i] + "'"); } if (dr == null || dr.Length == 0) { sqjlModel = new EDRS.Model.YX_DZJZ_WJSQDYJL(); sqjlModel.WJXH = idarr[i]; sqjlModel.XH = model.XH; sqjlModel.YJXH = model.YJXH; sqjlModel.ADDTIME = DateTime.Now; sqjlModel.SFSC = "N"; sqjlList.Add(sqjlModel); } } #endregion if (BLLSQ.AddListJL(sqjlList, model, model.XH)) { return(ReturnString.JsonToString(Prompt.win, "提交申请成功", null)); } else { return(ReturnString.JsonToString(Prompt.error, "提交申请失败", null)); } } return(ReturnString.JsonToString(Prompt.error, "未获取文件信息", null)); }
/// <summary> /// 增加多条文件申请打印记录 /// </summary> 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); }