/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.YX_DZJZ_LSGL GetModel(string LSZH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select LSZH,LSXM,LSDW,T2.DwMC LSDWMC,LSDWDZ,LSDWYZHM,LSLXDH,LSSJ,DELXR,DELXRDH,LSZGYXSJ,SFDXZG,LSXXBZ,LSZZWJ1,LSZZWJ2,LSZZWJ3,LSZZWJ4,CJSJ,ZHYCYJSJ,T1.SFSC "); strSql.Append(" FROM YX_DZJZ_LSGL T1 LEFT JOIN xt_zzjg_dwbm T2 ON(T1.Lsdw = T2.Dwbm) "); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where LSZH=:LSZH "); OracleParameter[] parameters = { new OracleParameter(":LSZH", OracleType.VarChar, 100) }; parameters[0].Value = LSZH; EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL(); 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_LSGL GetModel(string LSZH)", "EDRS.OracleDAL.YX_DZJZ_LSGL", strSql.ToString(), parameters); } if (ds != null && ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.YX_DZJZ_LSGL model) { StringBuilder strSql = new StringBuilder(); 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[] parameters = { 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) }; parameters[0].Value = model.LSZH; parameters[1].Value = model.LSXM; parameters[2].Value = model.LSDW; parameters[3].Value = model.LSDWDZ; parameters[4].Value = model.LSDWYZHM; parameters[5].Value = model.LSLXDH; parameters[6].Value = model.LSSJ; parameters[7].Value = model.DELXR; parameters[8].Value = model.DELXRDH; parameters[9].Value = model.LSZGYXSJ; parameters[10].Value = model.SFDXZG; parameters[11].Value = model.LSXXBZ; parameters[12].Value = model.CJSJ; parameters[13].Value = model.ZHYCYJSJ ?? (object)DBNull.Value; parameters[14].Value = model.SFSC; 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_LSGL model)", "EDRS.OracleDAL.YX_DZJZ_LSGL", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
public void AddData(HttpContext context) { EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL(); model.LSZH = context.Request["LSZH"]; model.LSXM = context.Request["LSXM"]; model.LSDW = context.Request["LSDW"]; model.LSDWDZ = context.Request["LSDWDZ"]; model.LSDWYZHM = context.Request["LSDWYZHM"]; model.LSLXDH = context.Request["LSLXDH"]; model.LSSJ = context.Request["LSSJ"]; model.DELXR = context.Request["DELXR"]; model.DELXRDH = context.Request["DELXRDH"]; model.LSZGYXSJ = Convert.ToDateTime(context.Request["LSZGYXSJ"]); model.SFDXZG = "N";//this.SFDXZG.Checked ? "Y" : "N"; model.LSXXBZ = context.Request["LSXXBZ"]; model.LSZZWJ1 = ""; model.LSZZWJ2 = ""; model.LSZZWJ3 = ""; model.LSZZWJ4 = ""; string[] LSZZWJ = context.Request["LSZZWJ"].Split(','); model.CJSJ = DateTime.Now; EDRS.BLL.YX_DZJZ_LSGL bll = new YX_DZJZ_LSGL(context.Request); if (bll.Add(model)) { //成功后再保存资质文件关联 List <string> fileList = new List <string>(); foreach (string file in LSZZWJ) { if (file != "") { fileList.Add(file); } } EDRS.BLL.YX_DZJZ_LSZZWJ WJBLL = new YX_DZJZ_LSZZWJ(context.Request); if (fileList.Count == 0 || WJBLL.AddList(model.LSZH, fileList)) { context.Response.Write(ReturnString.JsonToString(Prompt.win, "保存成功", null)); //true } else { context.Response.Write(ReturnString.JsonToString(Prompt.error, "保存失败", null)); //false } } else { context.Response.Write(ReturnString.JsonToString(Prompt.error, "保存失败", null)); //false } }
private void GetModelPList(HttpContext context) { EDRS.BLL.YX_DZJZ_LSGL bll = new YX_DZJZ_LSGL(context.Request); EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL(); string LSZH = context.Request["LSZH"]; if (string.IsNullOrEmpty(LSZH)) { context.Response.Write(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } model = bll.GetModel(LSZH); if (model != null) { context.Response.Write(EDRS.Common.JsonHelper.JsonString(model)); } else { context.Response.Write(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); } }
/// <summary> /// 添加律师 /// </summary> /// <returns></returns> private string AddLS() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL(); model.LSZH = Request.Form["lszh"]; model.LSXM = Request.Form["lsxm"]; model.LSDW = Request.Form["lsdw"]; model.LSDWDZ = Request.Form["lsdwdz"]; model.LSDWYZHM = Request.Form["lsdwyzh"]; model.LSLXDH = Request.Form["lslxdh"]; model.LSSJ = Request.Form["lssj"]; model.DELXR = Request.Form["delxr"]; model.DELXRDH = Request.Form["delxrdh"]; model.LSZGYXSJ = Convert.ToDateTime(Request.Form["lszgyxsj"]); model.SFDXZG = Request.Form["sfdxzg"] == "0" ? "N" : "Y"; model.LSXXBZ = Request.Form["lsxxbz"]; model.CJSJ = DateTime.Now; model.ZHYCYJSJ = null; model.SFSC = "N"; EDRS.BLL.YX_DZJZ_LSGL bll = new EDRS.BLL.YX_DZJZ_LSGL(this.Request); //添加资质文件 EDRS.BLL.YX_DZJZ_LSZZWJ zzbll = new EDRS.BLL.YX_DZJZ_LSZZWJ(this.Request); string idstr = Request.Form["filestr[]"]; //判断律师证号是否重复 if (bll.Exists(model.LSZH)) { return(ReturnString.JsonToString(Prompt.error, "该律师证号已被使用,请重置", null)); } //添加律师 if (bll.Add(model)) { //判断是否添加附件 if (!string.IsNullOrEmpty(idstr)) { string[] idarr = idstr.Split(','); List <string> filestr = new List <string>(); for (int i = 0; i < idarr.Length; i++) { filestr.Add(idarr[i]); } //添加律师资质文件 if (zzbll.AddList(model.LSZH, filestr)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "添加律师成功", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "添加律师成功", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "添加律师失败", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); }
/// <summary> /// 修改律师信息 /// </summary> /// <returns></returns> private string UpData() { string lszh = Request.Form.Get("key_hidd").Trim(); if (string.IsNullOrEmpty(lszh)) { return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } EDRS.BLL.YX_DZJZ_LSGL bll = new EDRS.BLL.YX_DZJZ_LSGL(this.Request); EDRS.Model.YX_DZJZ_LSGL model = bll.GetModel(lszh); //添加资质文件 EDRS.BLL.YX_DZJZ_LSZZWJ zzbll = new EDRS.BLL.YX_DZJZ_LSZZWJ(this.Request); string idstr = Request.Form.Get("key_arrlife"); if (model != null) { model.LSXM = Request.Form.Get("txt_lsxm"); model.LSDW = Request.Form.Get("txt_lsdw"); model.LSDWDZ = Request.Form.Get("txt_lsdwdz"); model.LSDWYZHM = Request.Form.Get("txt_lsdwyzh"); model.LSLXDH = Request.Form.Get("txt_lslxdh"); model.LSSJ = Request.Form.Get("txt_lssj"); model.DELXR = Request.Form.Get("txt_delxr"); model.DELXRDH = Request.Form.Get("txt_delxrdh"); model.LSZGYXSJ = Convert.ToDateTime(Request.Form.Get("txt_lszgyxsj")); model.SFDXZG = Request.Form.Get("txt_sfdxzg") == "0" ? "N" : "Y"; model.LSXXBZ = Request.Form.Get("txt_lsxxbz"); model.CJSJ = DateTime.Now; model.ZHYCYJSJ = null; model.SFSC = "N"; if (bll.Update(model)) { if (!string.IsNullOrEmpty(idstr)) { string[] idarr = idstr.Split(','); List <string> filestr = new List <string>(); for (int i = 0; i < idarr.Length; i++) { filestr.Add(idarr[i]); } //添加律师资质文件 if (zzbll.AddList(model.LSZH, filestr)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改律师信息成功", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改律师信息成功", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改律师信息失败", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", 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 EDRS.Model.YX_DZJZ_LSGL DataRowToModel(DataRow row) { EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL(); if (row != null) { if (row["LSZH"] != null) { model.LSZH = row["LSZH"].ToString(); } if (row["LSXM"] != null) { model.LSXM = row["LSXM"].ToString(); } if (row["LSDW"] != null) { model.LSDW = row["LSDW"].ToString(); } if (row["LSDWMC"] != null) { model.LSDWMC = row["LSDWMC"].ToString(); } if (row["LSDWDZ"] != null) { model.LSDWDZ = row["LSDWDZ"].ToString(); } if (row["LSDWYZHM"] != null) { model.LSDWYZHM = row["LSDWYZHM"].ToString(); } if (row["LSLXDH"] != null) { model.LSLXDH = row["LSLXDH"].ToString(); } if (row["LSSJ"] != null) { model.LSSJ = row["LSSJ"].ToString(); } if (row["DELXR"] != null) { model.DELXR = row["DELXR"].ToString(); } if (row["DELXRDH"] != null) { model.DELXRDH = row["DELXRDH"].ToString(); } if (row["LSZGYXSJ"] != null && row["LSZGYXSJ"].ToString() != "") { model.LSZGYXSJ = DateTime.Parse(row["LSZGYXSJ"].ToString()); } if (row["SFDXZG"] != null) { model.SFDXZG = row["SFDXZG"].ToString(); } if (row["LSXXBZ"] != null) { model.LSXXBZ = row["LSXXBZ"].ToString(); } if (row["LSZZWJ1"] != null) { model.LSZZWJ1 = row["LSZZWJ1"].ToString(); } if (row["LSZZWJ2"] != null) { model.LSZZWJ2 = row["LSZZWJ2"].ToString(); } if (row["LSZZWJ3"] != null) { model.LSZZWJ3 = row["LSZZWJ3"].ToString(); } if (row["LSZZWJ4"] != null) { model.LSZZWJ4 = row["LSZZWJ4"].ToString(); } if (row["CJSJ"] != null && row["CJSJ"].ToString() != "") { model.CJSJ = DateTime.Parse(row["CJSJ"].ToString()); } if (row["ZHYCYJSJ"] != null && row["ZHYCYJSJ"].ToString() != "") { model.ZHYCYJSJ = DateTime.Parse(row["ZHYCYJSJ"].ToString()); } if (row["SFSC"] != null) { model.SFSC = row["SFSC"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.YX_DZJZ_LSGL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update YX_DZJZ_LSGL set "); strSql.Append("LSXM=:LSXM,"); strSql.Append("LSDW=:LSDW,"); strSql.Append("LSDWDZ=:LSDWDZ,"); strSql.Append("LSDWYZHM=:LSDWYZHM,"); strSql.Append("LSLXDH=:LSLXDH,"); strSql.Append("LSSJ=:LSSJ,"); strSql.Append("DELXR=:DELXR,"); strSql.Append("DELXRDH=:DELXRDH,"); strSql.Append("LSZGYXSJ=:LSZGYXSJ,"); strSql.Append("SFDXZG=:SFDXZG,"); strSql.Append("LSXXBZ=:LSXXBZ,"); strSql.Append("ZHYCYJSJ=:ZHYCYJSJ,"); strSql.Append("SFSC=:SFSC"); strSql.Append(" where LSZH=:LSZH "); OracleParameter[] parameters = { 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(":LSZH", OracleType.VarChar, 100), new OracleParameter(":ZHYCYJSJ", OracleType.DateTime), new OracleParameter(":SFSC", OracleType.Char, 1) }; parameters[0].Value = model.LSXM; parameters[1].Value = model.LSDW; parameters[2].Value = model.LSDWDZ; parameters[3].Value = model.LSDWYZHM; parameters[4].Value = model.LSLXDH; parameters[5].Value = model.LSSJ; parameters[6].Value = model.DELXR; parameters[7].Value = model.DELXRDH; parameters[8].Value = model.LSZGYXSJ; parameters[9].Value = model.SFDXZG; parameters[10].Value = model.LSXXBZ; parameters[11].Value = model.LSZH; parameters[12].Value = model.ZHYCYJSJ ?? (object)DBNull.Value; parameters[13].Value = model.SFSC; 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_LSGL model)", "EDRS.OracleDAL.YX_DZJZ_LSGL", 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)); }