/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_LSYJSQ GetModel(string YJSQDH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select LSZH,YJSQDH,SQSJ,SQSM,SFSC,SHRGH,SHR,SHSM,SHSJ,YJSQDM,SQDZT from YX_DZJZ_LSYJSQ "); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where YJSQDH=:YJSQDH "); OracleParameter[] parameters = { new OracleParameter(":YJSQDH", OracleType.VarChar, 50) }; parameters[0].Value = YJSQDH; EDRS.Model.YX_DZJZ_LSYJSQ model = new EDRS.Model.YX_DZJZ_LSYJSQ(); DataSet ds = null; try { ds = DbHelperOra.Query(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public EDRS.Model.YX_DZJZ_LSYJSQ GetModel(string YJSQDH)", "EDRS.OracleDAL.YX_DZJZ_LSYJSQ", strSql.ToString(), parameters); } if (ds != null && ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public string applypass() { string state = Request.Form["state"]; string yjsqd = Request.Form["yjsqd"]; string shsm = Request.Form["shsm"]; EDRS.BLL.YX_DZJZ_LSYJSQ bll = new EDRS.BLL.YX_DZJZ_LSYJSQ(Request); //判断非空 if (!string.IsNullOrEmpty(yjsqd)) { if (state == "Y") { EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(yjsqd); model.SHRGH = UserInfo.GH; model.SHR = UserInfo.MC; model.SQDZT = "Y"; model.SHSJ = DateTime.Now; model.SHSM = ""; if (bll.Update(model)) { return(ReturnString.JsonToString(Prompt.win, "审核成功", null)); } else { return(ReturnString.JsonToString(Prompt.error, "审核失败", null)); } } else { if (!string.IsNullOrEmpty(shsm)) { EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(yjsqd); model.SHRGH = UserInfo.GH; model.SHR = UserInfo.MC; model.SQDZT = "N"; model.SHSJ = DateTime.Now; model.SHSM = shsm; if (bll.Update(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_LSYJSQ DataRowToModel(DataRow row) { EDRS.Model.YX_DZJZ_LSYJSQ model = new EDRS.Model.YX_DZJZ_LSYJSQ(); if (row != null) { if (row["LSZH"] != null) { model.LSZH = row["LSZH"].ToString(); } if (row["YJSQDH"] != null) { model.YJSQDH = row["YJSQDH"].ToString(); } if (row["SQSJ"] != null && row["SQSJ"].ToString() != "") { model.SQSJ = DateTime.Parse(row["SQSJ"].ToString()); } if (row["SQSM"] != null) { model.SQSM = row["SQSM"].ToString(); } if (row["SFSC"] != null) { model.SFSC = row["SFSC"].ToString(); } if (row["SHRGH"] != null) { model.SHRGH = row["SHRGH"].ToString(); } if (row["SHR"] != null) { model.SHR = row["SHR"].ToString(); } if (row["SHSM"] != null) { model.SHSM = row["SHSM"].ToString(); } if (row["SHSJ"] != null && row["SHSJ"].ToString() != "") { model.SHSJ = DateTime.Parse(row["SHSJ"].ToString()); } if (row["YJSQDM"] != null) { model.YJSQDM = row["YJSQDM"].ToString(); } if (row["SQDZT"] != null) { model.SQDZT = row["SQDZT"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.YX_DZJZ_LSYJSQ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into YX_DZJZ_LSYJSQ("); strSql.Append("LSZH,SQSJ,SQSM,SFSC,SHRGH,SHR,SHSM,SHSJ,YJSQDM,SQDZT)"); strSql.Append(" values ("); strSql.Append(":LSZH,:SQSJ,:SQSM,:SFSC,:SHRGH,:SHR,:SHSM,:SHSJ,:YJSQDM,:SQDZT)"); OracleParameter[] parameters = { new OracleParameter(":LSZH", OracleType.VarChar, 100), new OracleParameter(":SQSJ", OracleType.DateTime), new OracleParameter(":SQSM", OracleType.VarChar, 300), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":SHRGH", OracleType.Char, 4), new OracleParameter(":SHR", OracleType.VarChar, 60), new OracleParameter(":SHSM", OracleType.VarChar, 300), new OracleParameter(":SHSJ", OracleType.DateTime), new OracleParameter(":YJSQDM", OracleType.VarChar, 300), new OracleParameter(":SQDZT", OracleType.Char, 5) }; parameters[0].Value = (object)model.LSZH ?? DBNull.Value; parameters[1].Value = (object)model.SQSJ ?? DBNull.Value; parameters[2].Value = (object)model.SQSM ?? DBNull.Value; parameters[3].Value = (object)model.SFSC ?? DBNull.Value; parameters[4].Value = (object)model.SHRGH ?? DBNull.Value; parameters[5].Value = (object)model.SHR ?? DBNull.Value; parameters[6].Value = (object)model.SHSM ?? DBNull.Value; parameters[7].Value = (object)model.SHSJ ?? DBNull.Value; parameters[8].Value = (object)model.YJSQDM ?? DBNull.Value; parameters[9].Value = (object)model.SQDZT ?? DBNull.Value; int rows = 0; try { rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.YX_DZJZ_LSYJSQ model)", "EDRS.OracleDAL.YX_DZJZ_LSYJSQ", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 提交申请 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(this.Request); //DataSet ds = bll.GetList(" and SFSC='N' and SQDZT<>'N' and YJSQDH=:YJSQDH", new string[] { Request.Form["txt_yjsqdh"] }); //if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) // return ReturnString.JsonToString(Prompt.error, "该阅卷申请单号已被申请过", null); string zh = Request.Form["LSZH"]; if (string.IsNullOrEmpty(zh)) { return(ReturnString.JsonToString(Prompt.error, "请选择律师姓名", null)); } string dm = Request.Form["txt_yjsqdm"]; if (string.IsNullOrEmpty(dm)) { return(ReturnString.JsonToString(Prompt.error, "申请单名不能为空", null)); } Random random = new Random(); EDRS.Model.YX_DZJZ_LSYJSQ model = new EDRS.Model.YX_DZJZ_LSYJSQ(); model.LSZH = Request.Form["LSZH"]; model.YJSQDH = random.Next(100000, 999999).ToString(); model.SQSJ = DateTime.Now; model.SQSM = Request.Form["txt_sqsm"]; model.SFSC = "N"; model.SHRGH = UserInfo.GH; model.SHR = UserInfo.MC; model.SHSM = ""; model.SHSJ = DateTime.Now; model.YJSQDM = dm; model.SQDZT = "T"; if (bll.Add(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "提交阅卷申请成功", model.YJSQDH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "提交阅卷申请失败", model.YJSQDH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); }
/// <summary> /// 审核 /// </summary> /// <returns></returns> private string ExUpData() { string id = Request.Form.Get("key_ex_hidd").Trim(); if (string.IsNullOrEmpty(id)) { return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(this.Request); EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(id); if (model != null) { model.SHSJ = DateTime.Now; model.SQDZT = Request.Form["rad_sqdzt"]; model.SHSM = Request.Form["txt_shsm"]; model.SHR = UserInfo.MC; model.SHRGH = UserInfo.GH; if (bll.Update(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改参数配置成功", model.YJSQDH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改参数配置失败", model.YJSQDH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改参数配置未找到信息", id, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); }
/// <summary> /// 修改 /// </summary> /// <returns></returns> private string UpData() { string id = Request.Form.Get("key_hidd").Trim(); if (string.IsNullOrEmpty(id)) { return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(this.Request); EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(id); if (model != null) { model.LSZH = "";// Request.Form["txt_lszh"]; // model.YJSQDH = Request.Form["txt_yjsqdh"]; model.YJSQDM = Request.Form["txt_yjsqdm"]; model.SQSJ = DateTime.Now; model.SQSM = Request.Form["txt_sqsm"]; if (bll.Update(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改阅卷申请成功", id, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改阅卷申请失败", id, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改阅卷申请-未找到修改信息", id, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); }
public string applypass() { string lszh = Request["lszh"]; string dysqdh = Request["dysqdh"]; string sqsj = Request["sqsj"]; // string shsm = Request["shsm"]; //判断非空 if (!string.IsNullOrEmpty(lszh) && !string.IsNullOrEmpty(sqsj) && !string.IsNullOrEmpty(dysqdh)) { EDRS.BLL.YX_DZJZ_LSYJSQ bll = new EDRS.BLL.YX_DZJZ_LSYJSQ(Request); { EDRS.Model.YX_DZJZ_LSYJSQ model = new EDRS.Model.YX_DZJZ_LSYJSQ(); model.LSZH = lszh; // model.YJSQDH = dysqdh; model.SQSJ = Convert.ToDateTime(sqsj); model.SQSM = ""; model.SFSC = "N"; model.SHRGH = UserInfo.GH; model.SHR = UserInfo.MC; model.SHSM = ""; model.SHSJ = DateTime.Now; model.YJSQDM = dysqdh; model.SQDZT = "Y"; if (bll.Add(model)) { return(ReturnString.JsonToString(Prompt.win, "审核成功", null)); } else { return(ReturnString.JsonToString(Prompt.error, "审核失败", null)); } } } return(ReturnString.JsonToString(Prompt.error, "未获取文件信息", null)); }
/// <summary> /// 根据单位获取配置数据 /// </summary> /// <param name="DWBM"></param> /// <returns></returns> private string GetModel(string id) { if (string.IsNullOrEmpty(id)) { id = Request["id"]; if (string.IsNullOrEmpty(id)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(this.Request); EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(id); if (model != null) { //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "根据编号获取阅读申请成功", id, UserInfo, UserRole, this.Request); return(JsonHelper.JsonString(model)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "根据编号获取阅读申请-未找到信息", id, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); }
/// <summary> /// 保存分配案件文件 /// </summary> /// <returns></returns> private string AddData() { string json = Request.Form["json"]; string yjxh = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); //"山东省院捕受[2015]37000000054号"; string lssq = Request.Form["lssq"]; string[] lssqs = null; if (string.IsNullOrEmpty(lssq)) { return(ReturnString.JsonToString(Prompt.error, "请先填写律师阅卷申请信息!", null)); } lssqs = lssq.Split(new string[] { "|&|" }, StringSplitOptions.None); if (lssqs == null || lssqs.Length != 4) { return(ReturnString.JsonToString(Prompt.error, "您填写的律师阅卷申请信息不正确!", null)); } string rybm = "";// Request.Form["lszh_hidd"]; // string[] rybms = rybm.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries); //if(rybms.Length != 2) // return ReturnString.JsonToString(Prompt.error, "请选择阅卷人!", null); if (Request.Form["txt_yjkssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjkssj"])) { return(ReturnString.JsonToString(Prompt.error, "请设置阅卷开始时间!", null)); } if (Request.Form["txt_yjjssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjjssj"])) { return(ReturnString.JsonToString(Prompt.error, "请设置阅卷结束时间!", null)); } if (Convert.ToDateTime(Request.Form["txt_yjkssj"]) > Convert.ToDateTime(Request.Form["txt_yjjssj"])) { return(ReturnString.JsonToString(Prompt.error, "结束时间不能小于开始时间!", null)); } EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request); EDRS.Model.TYYW_GG_AJJBXX ajmodel = ajbll.GetModel(Request.Form["key_hidd"]); if (ajmodel == null) { return(ReturnString.JsonToString(Prompt.error, "分配失败," + ((VersionName)0).ToString() + "不存在!", null)); } //json = json.Replace("id", "_wjxh").Replace("MLLX", "_fpbm").Replace("text", "_sfsc").Replace("PARENTID", "_yjxh"); #region 律师阅卷申请 EDRS.Model.YX_DZJZ_LSYJSQ modelLsyjsq = new EDRS.Model.YX_DZJZ_LSYJSQ(); modelLsyjsq.LSZH = lssqs[0]; modelLsyjsq.YJSQDH = Guid.NewGuid().ToString(); modelLsyjsq.SQSJ = DateTime.Now; modelLsyjsq.SQSM = lssqs[2]; modelLsyjsq.SFSC = "N"; modelLsyjsq.SHRGH = UserInfo.GH; modelLsyjsq.SHR = UserInfo.MC; modelLsyjsq.SHSM = ""; modelLsyjsq.SHSJ = DateTime.Now; modelLsyjsq.YJSQDM = lssqs[1]; modelLsyjsq.SQDZT = "Y"; #endregion #region 律师阅卷绑定 Random random = new Random(); EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD(); model.GH = lssqs[0]; model.BMSAH = ajmodel.BMSAH; model.YJXH = yjxh; model.MC = lssqs[3]; model.AJMC = ajmodel.AJMC; model.AJLBBM = ajmodel.AJLB_BM; model.AJLBMC = ajmodel.AJLB_MC; model.YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]); model.YJJSSJ = Convert.ToDateTime(Request.Form["txt_yjjssj"]); model.YJZH = lssqs[0]; model.YJMM = random.Next(100000, 999999).ToString(); model.JDSJ = DateTime.Now; model.JDR = UserInfo.MC; model.JDRGH = UserInfo.GH; model.JDBMBM = ""; model.JDBMMC = ""; model.JDDWBM = UserInfo.DWBM; model.JDDWMC = UserInfo.DWMC; model.SFSC = "N"; model.YJSQDH = modelLsyjsq.YJSQDH; model.JZZTXS = ""; model.DWBM = UserInfo.DWBM; #endregion #region 律师阅卷绑定文件 List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList = JsonHelper.JsonToList <EDRS.Model.YX_DZJZ_LSAJWJFP>(json); #endregion EDRS.BLL.YX_DZJZ_LSAJBD bllBD = new EDRS.BLL.YX_DZJZ_LSAJBD(Request); try { if (bllBD.AddList(modelLsyjsq, model, modelList)) { OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配成功", "", UserInfo, UserRole, this.Request); return(JsonHelper.JsonString(model)); } //return ReturnString.JsonToString(Prompt.win, "分配成功!", null); } catch (Exception ex) { return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(ex.Message), null)); } OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配失败", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "分配失败!", null)); }
/// <summary> /// 增加多条数据 /// </summary> public bool AddList(EDRS.Model.YX_DZJZ_LSYJSQ lsyjsqModel, EDRS.Model.YX_DZJZ_LSAJBD lsajbdModel, List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList, EDRS.Model.YX_DZJZ_LSGL lsglModel) { int count = 0; Dictionary <object, object> hash = new Dictionary <object, object>(); StringBuilder strSql = new StringBuilder(); strSql.Append(" update YX_DZJZ_LSAJWJFP set SFSC='Y' where YJXH=:YJXHUP "); OracleParameter[] parameters1 = { new OracleParameter(":YJXHUP", OracleType.VarChar, 50) }; parameters1[0].Value = lsajbdModel.YJXH; hash.Add(strSql.ToString(), parameters1); #region 阅卷人信息 strSql.Clear(); strSql.Append("insert into YX_DZJZ_LSGL("); strSql.Append("LSZH,LSXM,LSDW,LSDWDZ,LSDWYZHM,LSLXDH,LSSJ,DELXR,DELXRDH,LSZGYXSJ,SFDXZG,LSXXBZ,CJSJ,ZHYCYJSJ,SFSC)"); strSql.Append(" values ("); strSql.Append(":LSZH,:LSXM,:LSDW,:LSDWDZ,:LSDWYZHM,:LSLXDH,:LSSJ,:DELXR,:DELXRDH,:LSZGYXSJ,:SFDXZG,:LSXXBZ,:CJSJ,:ZHYCYJSJ,:SFSC)"); OracleParameter[] parameters4 = { new OracleParameter(":LSZH", OracleType.VarChar, 100), new OracleParameter(":LSXM", OracleType.VarChar, 60), new OracleParameter(":LSDW", OracleType.VarChar, 300), new OracleParameter(":LSDWDZ", OracleType.VarChar, 300), new OracleParameter(":LSDWYZHM", OracleType.Char, 6), new OracleParameter(":LSLXDH", OracleType.VarChar, 50), new OracleParameter(":LSSJ", OracleType.VarChar, 50), new OracleParameter(":DELXR", OracleType.VarChar, 60), new OracleParameter(":DELXRDH", OracleType.VarChar, 50), new OracleParameter(":LSZGYXSJ", OracleType.DateTime), new OracleParameter(":SFDXZG", OracleType.Char, 1), new OracleParameter(":LSXXBZ", OracleType.VarChar, 300), new OracleParameter(":CJSJ", OracleType.DateTime), new OracleParameter(":ZHYCYJSJ", OracleType.DateTime), new OracleParameter(":SFSC", OracleType.Char, 1) }; parameters4[0].Value = lsglModel.LSZH; parameters4[1].Value = lsglModel.LSXM; parameters4[2].Value = lsglModel.LSDW; parameters4[3].Value = lsglModel.LSDWDZ; parameters4[4].Value = lsglModel.LSDWYZHM; parameters4[5].Value = lsglModel.LSLXDH; parameters4[6].Value = lsglModel.LSSJ; parameters4[7].Value = lsglModel.DELXR; parameters4[8].Value = lsglModel.DELXRDH; parameters4[9].Value = lsglModel.LSZGYXSJ ?? (object)DBNull.Value; parameters4[10].Value = lsglModel.SFDXZG; parameters4[11].Value = lsglModel.LSXXBZ; parameters4[12].Value = lsglModel.CJSJ; parameters4[13].Value = lsglModel.ZHYCYJSJ ?? (object)DBNull.Value; parameters4[14].Value = lsglModel.SFSC; hash.Add(strSql.ToString(), parameters4); #endregion #region 律师申请 strSql.Clear(); strSql.Append("insert into YX_DZJZ_LSYJSQ("); strSql.Append("LSZH,SQSJ,SQSM,SFSC,SHRGH,SHR,SHSM,SHSJ,YJSQDM,SQDZT,YJSQDH)"); strSql.Append(" values ("); strSql.Append(":LSZH,:SQSJ,:SQSM,:SFSC,:SHRGH,:SHR,:SHSM,:SHSJ,:YJSQDM,:SQDZT,:YJSQDH)"); OracleParameter[] parameters2 = { new OracleParameter(":LSZH", OracleType.VarChar, 100), new OracleParameter(":SQSJ", OracleType.DateTime), new OracleParameter(":SQSM", OracleType.VarChar, 300), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":SHRGH", OracleType.Char, 4), new OracleParameter(":SHR", OracleType.VarChar, 60), new OracleParameter(":SHSM", OracleType.VarChar, 300), new OracleParameter(":SHSJ", OracleType.DateTime), new OracleParameter(":YJSQDM", OracleType.VarChar, 300), new OracleParameter(":SQDZT", OracleType.Char, 5), new OracleParameter(":YJSQDH", OracleType.VarChar, 50) }; parameters2[0].Value = (object)lsyjsqModel.LSZH ?? DBNull.Value; parameters2[1].Value = (object)lsyjsqModel.SQSJ ?? DBNull.Value; parameters2[2].Value = (object)lsyjsqModel.SQSM ?? DBNull.Value; parameters2[3].Value = (object)lsyjsqModel.SFSC ?? DBNull.Value; parameters2[4].Value = (object)lsyjsqModel.SHRGH ?? DBNull.Value; parameters2[5].Value = (object)lsyjsqModel.SHR ?? DBNull.Value; parameters2[6].Value = (object)lsyjsqModel.SHSM ?? DBNull.Value; parameters2[7].Value = (object)lsyjsqModel.SHSJ ?? DBNull.Value; parameters2[8].Value = (object)lsyjsqModel.YJSQDM ?? DBNull.Value; parameters2[9].Value = (object)lsyjsqModel.SQDZT ?? DBNull.Value; parameters2[10].Value = lsyjsqModel.YJSQDH; hash.Add(strSql.ToString(), parameters2); #endregion #region 律师阅卷绑定 strSql.Clear(); strSql.Append("insert into YX_DZJZ_LSAJBD("); strSql.Append("GH,BMSAH,MC,AJMC,AJLBBM,AJLBMC,YJKSSJ,YJJSSJ,YJZH,YJMM,JDSJ,JDR,JDRGH,JDBMBM,JDBMMC,JDDWBM,JDDWMC,SFSC,YJSQDH,YJXH,DWBM)"); strSql.Append(" values ("); strSql.Append(":GH,:BMSAH,:MC,:AJMC,:AJLBBM,:AJLBMC,:YJKSSJ,:YJJSSJ,:YJZH,:YJMM,:JDSJ,:JDR,:JDRGH,:JDBMBM,:JDBMMC,:JDDWBM,:JDDWMC,:SFSC,:YJSQDH,:YJXH,:DWBM)"); OracleParameter[] parameters3 = { new OracleParameter(":GH", OracleType.VarChar, 100), new OracleParameter(":BMSAH", OracleType.VarChar, 100), new OracleParameter(":MC", OracleType.VarChar, 60), new OracleParameter(":AJMC", OracleType.VarChar, 300), new OracleParameter(":AJLBBM", OracleType.VarChar, 50), new OracleParameter(":AJLBMC", OracleType.VarChar, 50), new OracleParameter(":YJKSSJ", OracleType.DateTime), new OracleParameter(":YJJSSJ", OracleType.DateTime), new OracleParameter(":YJZH", OracleType.VarChar, 100), new OracleParameter(":YJMM", OracleType.Char, 8), new OracleParameter(":JDSJ", OracleType.DateTime), new OracleParameter(":JDR", OracleType.VarChar, 60), new OracleParameter(":JDRGH", OracleType.Char, 4), new OracleParameter(":JDBMBM", OracleType.Char, 4), new OracleParameter(":JDBMMC", OracleType.VarChar, 300), new OracleParameter(":JDDWBM", OracleType.VarChar, 50), new OracleParameter(":JDDWMC", OracleType.VarChar, 300), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":YJSQDH", OracleType.VarChar, 50), new OracleParameter(":YJXH", OracleType.VarChar, 50), new OracleParameter(":DWBM", OracleType.VarChar, 50) }; parameters3[0].Value = lsajbdModel.GH ?? ""; parameters3[1].Value = lsajbdModel.BMSAH ?? ""; parameters3[2].Value = lsajbdModel.MC ?? ""; parameters3[3].Value = lsajbdModel.AJMC ?? ""; parameters3[4].Value = lsajbdModel.AJLBBM ?? ""; parameters3[5].Value = lsajbdModel.AJLBMC ?? ""; parameters3[6].Value = lsajbdModel.YJKSSJ ?? (object)DBNull.Value; parameters3[7].Value = lsajbdModel.YJJSSJ ?? (object)DBNull.Value; parameters3[8].Value = lsajbdModel.YJZH ?? ""; parameters3[9].Value = lsajbdModel.YJMM ?? ""; parameters3[10].Value = lsajbdModel.JDSJ; parameters3[11].Value = lsajbdModel.JDR ?? ""; parameters3[12].Value = lsajbdModel.JDRGH ?? ""; parameters3[13].Value = lsajbdModel.JDBMBM ?? ""; parameters3[14].Value = lsajbdModel.JDBMMC ?? ""; parameters3[15].Value = lsajbdModel.JDDWBM ?? ""; parameters3[16].Value = lsajbdModel.JDDWMC ?? ""; parameters3[17].Value = lsajbdModel.SFSC ?? ""; parameters3[18].Value = lsajbdModel.YJSQDH ?? ""; parameters3[19].Value = lsajbdModel.YJXH ?? ""; parameters3[20].Value = lsajbdModel.DWBM ?? ""; hash.Add(strSql.ToString(), parameters3); #endregion #region 律师阅卷文件绑定 foreach (EDRS.Model.YX_DZJZ_LSAJWJFP model in modelList) { strSql.Clear(); strSql.Append(" insert into YX_DZJZ_LSAJWJFP("); strSql.Append("YJXH,WJXH,SFSC)"); strSql.Append(" values ("); strSql.AppendFormat(":YJXH{0},:WJXH{0},:SFSC{0})", count); OracleParameter[] parameters = { new OracleParameter(":YJXH" + count, OracleType.VarChar, 50), new OracleParameter(":WJXH" + count, OracleType.VarChar, 100), new OracleParameter(":SFSC" + count, OracleType.Char, 1) }; parameters[0].Value = lsajbdModel.YJXH; parameters[1].Value = model.WJXH; parameters[2].Value = "N"; hash.Add(strSql.ToString(), parameters); count++; } #endregion try { return(DbHelperOra.ExecuteSqlTran(hash)); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddList(EDRS.Model.YX_DZJZ_LSYJSQ lsyjsqModel, EDRS.Model.YX_DZJZ_LSAJBD lsajbdModel, List<EDRS.Model.YX_DZJZ_LSAJWJFP> modelList)", "EDRS.OracleDAL.YX_DZJZ_LSAJBD"); } return(false); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.YX_DZJZ_LSYJSQ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update YX_DZJZ_LSYJSQ set "); strSql.Append("LSZH=:LSZH,"); strSql.Append("SQSJ=:SQSJ,"); strSql.Append("SQSM=:SQSM,"); strSql.Append("SFSC=:SFSC,"); strSql.Append("SHRGH=:SHRGH,"); strSql.Append("SHR=:SHR,"); strSql.Append("SHSM=:SHSM,"); strSql.Append("SHSJ=:SHSJ,"); strSql.Append("YJSQDM=:YJSQDM,"); strSql.Append("SQDZT=:SQDZT"); strSql.Append(" where YJSQDH=:YJSQDH "); OracleParameter[] parameters = { new OracleParameter(":LSZH", OracleType.VarChar, 100), new OracleParameter(":SQSJ", OracleType.DateTime), new OracleParameter(":SQSM", OracleType.VarChar, 300), new OracleParameter(":SFSC", OracleType.Char, 1), new OracleParameter(":SHRGH", OracleType.Char, 4), new OracleParameter(":SHR", OracleType.VarChar, 60), new OracleParameter(":SHSM", OracleType.VarChar, 300), new OracleParameter(":SHSJ", OracleType.DateTime), new OracleParameter(":YJSQDM", OracleType.VarChar, 300), new OracleParameter(":SQDZT", OracleType.Char, 1), new OracleParameter(":YJSQDH", OracleType.VarChar, 50) }; parameters[0].Value = model.LSZH; parameters[1].Value = model.SQSJ; parameters[2].Value = model.SQSM; parameters[3].Value = model.SFSC; parameters[4].Value = model.SHRGH; parameters[5].Value = model.SHR; parameters[6].Value = model.SHSM; parameters[7].Value = model.SHSJ; parameters[8].Value = model.YJSQDM; parameters[9].Value = model.SQDZT; parameters[10].Value = model.YJSQDH; 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_LSYJSQ model)", "EDRS.OracleDAL.YX_DZJZ_LSYJSQ", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 保存分配案件文件 /// </summary> /// <returns></returns> private string AddData() { string json = Request.Form["json"]; string yjxh = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); //"山东省院捕受[2015]37000000054号"; string lssq = Request.Form["lssq"]; string[] lssqs = null; if (string.IsNullOrEmpty(lssq)) { return(ReturnString.JsonToString(Prompt.error, "请先填写阅卷登记信息!", null)); } lssqs = lssq.Split(new string[] { "|&|" }, StringSplitOptions.None); if (lssqs == null || lssqs.Length != 8) { return(ReturnString.JsonToString(Prompt.error, "填写的阅卷登记信息不正确!", null)); } string rybm = "";// Request.Form["lszh_hidd"]; // string[] rybms = rybm.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries); //if(rybms.Length != 2) // return ReturnString.JsonToString(Prompt.error, "请选择阅卷人!", null); /* 2016-9-6 取消设置阅卷时间 * if (Request.Form["txt_yjkssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjkssj"])) * return ReturnString.JsonToString(Prompt.error, "请设置阅卷开始时间!", null); * if (Request.Form["txt_yjjssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjjssj"])) * return ReturnString.JsonToString(Prompt.error, "请设置阅卷结束时间!", null); * if (Convert.ToDateTime(Request.Form["txt_yjkssj"]) > Convert.ToDateTime(Request.Form["txt_yjjssj"])) * return ReturnString.JsonToString(Prompt.error, "结束时间不能小于开始时间!", null); */ EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request); EDRS.Model.TYYW_GG_AJJBXX ajmodel = ajbll.GetModel(Request.Form["key_hidd"]); if (ajmodel == null) { return(ReturnString.JsonToString(Prompt.error, "分配失败," + ((VersionName)0).ToString() + "不存在!", null)); } //json = json.Replace("id", "_wjxh").Replace("MLLX", "_fpbm").Replace("text", "_sfsc").Replace("PARENTID", "_yjxh"); #region 阅卷人信息 // localStorage['lssq'] = $("#txt_yjr").val() + "|&|" + zjlx + "|&|" + $("#txt_zjh").val() + "|&|" + yjrsf + "|&|" + cxyy + "|&|" + shr + "|&|" + shbm + "|&|" + $("#txt_shr").val(); EDRS.Model.YX_DZJZ_LSGL lsglModel = new EDRS.Model.YX_DZJZ_LSGL(); lsglModel.LSZH = Guid.NewGuid().ToString(); lsglModel.LSXM = lssqs[0]; //阅卷人 lsglModel.LSDW = lssqs[1]; //证件类型 lsglModel.LSDWDZ = lssqs[3]; //阅卷人身份 lsglModel.LSDWYZHM = ""; lsglModel.LSLXDH = lssqs[2]; //证件号 lsglModel.LSSJ = ""; lsglModel.DELXR = lssqs[4]; //查询原因 lsglModel.DELXRDH = ""; // lsglModel.LSZGYXSJ = ; lsglModel.SFDXZG = "N"; lsglModel.LSXXBZ = ""; lsglModel.CJSJ = DateTime.Now; lsglModel.ZHYCYJSJ = null; lsglModel.SFSC = "N"; #endregion #region 律师阅卷申请 EDRS.Model.YX_DZJZ_LSYJSQ modelLsyjsq = new EDRS.Model.YX_DZJZ_LSYJSQ(); modelLsyjsq.LSZH = lsglModel.LSZH; modelLsyjsq.YJSQDH = Guid.NewGuid().ToString(); modelLsyjsq.SQSJ = DateTime.Now; modelLsyjsq.SQSM = lssqs[6]; //审核部门 modelLsyjsq.SFSC = "N"; modelLsyjsq.SHRGH = lssqs[5]; //审核人工号 modelLsyjsq.SHR = lssqs[7]; //审核人 modelLsyjsq.SHSM = ""; modelLsyjsq.SHSJ = null; modelLsyjsq.YJSQDM = ""; modelLsyjsq.SQDZT = "T"; #endregion #region 律师阅卷绑定 Random random = new Random(); EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD(); model.GH = lsglModel.LSZH; model.BMSAH = ajmodel.BMSAH; model.YJXH = yjxh; model.MC = lssqs[0]; model.AJMC = ajmodel.AJMC; model.AJLBBM = ajmodel.AJLB_BM; model.AJLBMC = ajmodel.AJLB_MC; model.YJKSSJ = DateTime.Now; // Convert.ToDateTime(Request.Form["txt_yjkssj"]); model.YJJSSJ = null; // Convert.ToDateTime(Request.Form["txt_yjjssj"]); model.YJZH = lssqs[0]; model.YJMM = random.Next(100000, 999999).ToString(); model.JDSJ = DateTime.Now; model.JDR = UserInfo.MC; model.JDRGH = UserInfo.GH; model.JDBMBM = ""; model.JDBMMC = ""; model.JDDWBM = UserInfo.DWBM; model.JDDWMC = UserInfo.DWMC; model.SFSC = "N"; model.YJSQDH = modelLsyjsq.YJSQDH; model.JZZTXS = ""; model.DWBM = UserInfo.DWBM; #endregion #region 律师阅卷绑定文件 List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList = JsonHelper.JsonToList <EDRS.Model.YX_DZJZ_LSAJWJFP>(json); #endregion EDRS.BLL.YX_DZJZ_LSAJBD bllBD = new EDRS.BLL.YX_DZJZ_LSAJBD(Request); try { if (bllBD.AddList(modelLsyjsq, model, modelList, lsglModel)) { OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配成功", "", UserInfo, UserRole, this.Request); return(JsonHelper.JsonString(model)); } //return ReturnString.JsonToString(Prompt.win, "分配成功!", null); } catch (Exception ex) { return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(ex.Message), null)); } OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配失败", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "分配失败!", null)); }