/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XY_DZJZ_MBPZB GetModel(string DossierTypeValueMember) { StringBuilder strSql = new StringBuilder(); strSql.Append("select DossierTypeValueMember,CaseInfoTypeID,CaseInfoTypeName,UnitID,DossierTypeDisplayMember,DossierParentMember,DossierEvidenceValueMember,SortIndex,Category,Sslbbm,Sslbmc,Auto,(SELECT SSLBBM FROM XY_DZJZ_MBPZB T2 WHERE T1.Dossierparentmember = T2.Dossiertypevaluemember) FSSLBBM from XY_DZJZ_MBPZB T1"); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where DossierTypeValueMember=:DossierTypeValueMember "); OracleParameter[] parameters = { new OracleParameter(":DossierTypeValueMember", OracleType.VarChar, 20) }; parameters[0].Value = DossierTypeValueMember; EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB(); 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.XY_DZJZ_MBPZB GetModel(string DossierTypeValueMember)", "EDRS.OracleDAL.XY_DZJZ_MBPZB", 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 EDRS.Model.XY_DZJZ_MBPZB DataRowToModel(DataRow row) { EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB(); if (row != null) { if (row["DossierTypeValueMember"] != null) { model.DossierTypeValueMember = row["DossierTypeValueMember"].ToString(); } if (row["CaseInfoTypeID"] != null) { model.CaseInfoTypeID = row["CaseInfoTypeID"].ToString(); } if (row["CaseInfoTypeName"] != null) { model.CaseInfoTypeName = row["CaseInfoTypeName"].ToString(); } if (row["UnitID"] != null) { model.UnitID = row["UnitID"].ToString(); } if (row["DossierTypeDisplayMember"] != null && row["DossierTypeDisplayMember"].ToString() != "") { model.DossierTypeDisplayMember = row["DossierTypeDisplayMember"].ToString(); } if (row["DossierParentMember"] != null) { model.DossierParentMember = row["DossierParentMember"].ToString(); } if (row["DossierEvidenceValueMember"] != null) { model.DossierEvidenceValueMember = row["DossierEvidenceValueMember"].ToString(); } if (row["SortIndex"] != null) { model.SortIndex = int.Parse(row["SortIndex"].ToString()); } if (row["Category"] != null) { model.Category = row["Category"].ToString(); } if (row["Sslbbm"] != null) { model.SSLBBM = row["Sslbbm"].ToString(); } if (row["Sslbmc"] != null) { model.SSLBMC = row["Sslbmc"].ToString(); } if (row["FSSLBBM"] != null) { model.FSslbBM = row["FSSLBBM"].ToString(); } if (row["Auto"] != null) { model.Auto = row["Auto"].ToString(); } } return(model); }
/// <summary> /// 添加单位数据 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "添加模板配置验证失败" + msg, Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, msg, null)); } string number = "00000001"; XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request); DataSet ds = bll.GetListByPage("", "DOSSIERTYPEVALUEMEMBER desc", 0, 1); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { number = ds.Tables[0].Rows[0]["DOSSIERTYPEVALUEMEMBER"].ToString(); number = (int.Parse(number) + 1).ToString().PadLeft(8, '0'); } EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB(); model.DossierTypeValueMember = number; model.CaseInfoTypeID = Request.Form.Get("tree_ajtype_val") ?? ""; model.CaseInfoTypeName = Request.Form.Get("tree_ajtype"); model.DossierParentMember = Request.Form.Get("key_parent") ?? ""; model.UnitID = UserInfo.DWBM; model.SSLBBM = Request.Form.Get("tree_sslb_val") ?? ""; model.SSLBMC = Request.Form.Get("tree_sslb") ?? ""; if (string.IsNullOrEmpty(Request.Form.Get("txt_rank"))) { model.SortIndex = 1; } else { model.SortIndex = int.Parse(Request.Form.Get("txt_rank")); } model.DossierTypeDisplayMember = Request.Form.Get("txt_name"); model.DossierEvidenceValueMember = ""; model.Category = Request.Form.Get("hidd_Category"); if (bool.Parse(Request.Form.Get("chk_autoFound_ar"))) { model.Auto = "Y"; } else { model.Auto = "N"; } if (bll.Add(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "添加模板配置成功", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", number)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "添加模板配置失败", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); }
/// <summary> /// 修改 /// </summary> /// <param name="dwbm"></param> /// <returns></returns> private string UpData() { string dwbm = Request.Form.Get("key_hidd_up"); if (string.IsNullOrEmpty(dwbm) || !Regex.IsMatch(dwbm, @"^[A-Za-z0-9]{1,8}$")) { return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } string msg = string.Empty; if (!ProvingUpFrom(ref msg)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置验证失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, msg, null)); } XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request); EDRS.Model.XY_DZJZ_MBPZB model = bll.GetModel(dwbm); if (model != null) { model.CaseInfoTypeID = Request.Form.Get("tree_ajtype_up_val"); model.CaseInfoTypeName = Request.Form.Get("tree_ajtype_up") ?? ""; model.DossierTypeDisplayMember = Request.Form.Get("txt_name_up"); model.SSLBBM = Request.Form.Get("tree_sslb_up_val") ?? ""; model.SSLBMC = Request.Form.Get("tree_sslb_up") ?? ""; if (string.IsNullOrEmpty(Request.Form.Get("txt_rank_up"))) { model.SortIndex = 1; } else { model.SortIndex = int.Parse(Request.Form.Get("txt_rank_up")); } if (bool.Parse(Request.Form.Get("chk_autoFound_up_ar"))) { model.Auto = "Y"; } else { model.Auto = "N"; } if (bll.Update(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置成功", Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置未找到修改信息" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); }
private string UpDate2() { string dwbm = Request["dwbm"]; string sslbbm = Request["sslbbm"]; string ajlbbm = Request["ajlbbm"]; List <object> param = new List <object>(); string strWhere = " and unitID=:dwbm"; param.Add(dwbm); strWhere += " and CASEINFOTYPEID=:CASEINFOTYPEID"; param.Add(ajlbbm); strWhere += " and sslbbm=:sslbbm"; param.Add(sslbbm); EDRS.BLL.XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(Request); DataSet ds = bll.GetList(strWhere, param.ToArray()); EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB(); string msg = string.Empty; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; model = bll.GetModel(dr["DOSSIERTYPEVALUEMEMBER"].ToString()); if (model != null) { if (string.IsNullOrEmpty(Request.Form.Get("txt_rank"))) { model.SortIndex = 1; } else { model.SortIndex = int.Parse(Request.Form.Get("txt_rank")); } if (bool.Parse(Request.Form.Get("chk_autoFound_ar"))) { model.Auto = "Y"; } else { model.Auto = "N"; } if (bll.Update(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置成功", Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); } } //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置未找到修改信息" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.XY_DZJZ_MBPZB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update XY_DZJZ_MBPZB set "); strSql.Append("CaseInfoTypeID=:CaseInfoTypeID,CaseInfoTypeName=:CaseInfoTypeName,UnitID=:UnitID,DossierTypeDisplayMember=:DossierTypeDisplayMember,DossierParentMember=:DossierParentMember,DossierEvidenceValueMember=:DossierEvidenceValueMember,SortIndex=:SortIndex,Category=:Category,SSLBBM=:SSLBBM,SSLBMC=:SSLBMC,Auto=:Auto"); strSql.Append(" where DossierTypeValueMember=:DossierTypeValueMember"); OracleParameter[] parameters = { new OracleParameter(":DossierTypeValueMember", OracleType.VarChar, 20), new OracleParameter(":CaseInfoTypeID", OracleType.VarChar, 20), new OracleParameter(":CaseInfoTypeName", OracleType.VarChar, 100), new OracleParameter(":UnitID", OracleType.VarChar, 20), new OracleParameter(":DossierTypeDisplayMember", OracleType.VarChar, 100), new OracleParameter(":DossierParentMember", OracleType.VarChar, 20), new OracleParameter(":DossierEvidenceValueMember", OracleType.VarChar, 100), new OracleParameter(":SortIndex", OracleType.Number, 18), new OracleParameter(":Category", OracleType.Char, 1), new OracleParameter(":SSLBBM", OracleType.VarChar, 20), new OracleParameter(":SSLBMC", OracleType.VarChar, 100), new OracleParameter(":Auto", OracleType.Char, 1) }; parameters[0].Value = model.DossierTypeValueMember; parameters[1].Value = model.CaseInfoTypeID; parameters[2].Value = model.CaseInfoTypeName; parameters[3].Value = model.UnitID; parameters[4].Value = model.DossierTypeDisplayMember; parameters[5].Value = model.DossierParentMember; parameters[6].Value = model.DossierEvidenceValueMember; parameters[7].Value = model.SortIndex; parameters[8].Value = model.Category; parameters[9].Value = model.SSLBBM; parameters[10].Value = model.SSLBMC; parameters[11].Value = model.Auto; 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.XY_DZJZ_MBPZB model)", "EDRS.OracleDAL.XY_DZJZ_MBPZB", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改 /// </summary> /// <param name="dwbm"></param> /// <returns></returns> private string UpData1() { string msg = string.Empty; XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request); EDRS.Model.XY_DZJZ_MBPZB model = bll.GetModel(Request.Form.Get("tempID")); if (model != null) { model.DossierTypeValueMember = Request.Form.Get("tempID"); if (string.IsNullOrEmpty(Request.Form.Get("txt_rank"))) { model.SortIndex = 1; } else { model.SortIndex = int.Parse(Request.Form.Get("txt_rank")); } if (bool.Parse(Request.Form.Get("chk_autoFound_ar"))) { model.Auto = "Y"; } else { model.Auto = "N"; } if (bll.Update(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置成功", Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置未找到修改信息" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); }
/// <summary> /// 根据编号获取数据 /// </summary> /// <returns></returns> private string GetModelOrParentList() { string DossierTypeValueMember = Request["id"]; if (string.IsNullOrEmpty(DossierTypeValueMember)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "根据编号获取模板配置参数失败", Request.Form.Get("name"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request); EDRS.Model.XY_DZJZ_MBPZB model = bll.GetModel(DossierTypeValueMember); if (model != null) { //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "根据编号获取模板配置成功", Request.Form.Get("name"), UserInfo, UserRole, this.Request); return(EDRS.Common.JsonHelper.JsonString(model)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "根据编号获取模板配置失败", Request.Form.Get("name"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(EDRS.Model.XY_DZJZ_MBPZB model) { StringBuilder strSql = new StringBuilder(); //先删除数据 strSql.Append("DELETE XY_DZJZ_MBPZB WHERE UnitID = :UnitID AND SSLBBM = :SSLBBM"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":UnitID", OracleType.VarChar, 20), new OracleParameter(":SSLBBM", OracleType.VarChar, 20) }; parameters[0].Value = model.UnitID; parameters[1].Value = model.SSLBBM; int rows = 0; try { DbHelperOra.ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.XY_DZJZ_MBPZB model)", "EDRS.OracleDAL.XY_DZJZ_MBPZB", strSql.ToString(), parameters); } strSql.Clear(); strSql.Append("insert into XY_DZJZ_MBPZB("); strSql.Append("DossierTypeValueMember,CaseInfoTypeID,CaseInfoTypeName,UnitID,DossierTypeDisplayMember,DossierParentMember,DossierEvidenceValueMember,SortIndex,Category,SSLBBM,SSLBMC,Auto)"); strSql.Append(" values ("); strSql.Append(":DossierTypeValueMember,:CaseInfoTypeID,:CaseInfoTypeName,:UnitID,:DossierTypeDisplayMember,:DossierParentMember,:DossierEvidenceValueMember,:SortIndex,:Category,:SSLBBM,:SSLBMC,:Auto)"); parameters = new OracleParameter[] { new OracleParameter(":DossierTypeValueMember", OracleType.VarChar, 20), new OracleParameter(":CaseInfoTypeID", OracleType.VarChar, 20), new OracleParameter(":CaseInfoTypeName", OracleType.VarChar, 100), new OracleParameter(":UnitID", OracleType.VarChar, 20), new OracleParameter(":DossierTypeDisplayMember", OracleType.VarChar, 100), new OracleParameter(":DossierParentMember", OracleType.VarChar, 20), new OracleParameter(":DossierEvidenceValueMember", OracleType.VarChar, 100), new OracleParameter(":SortIndex", OracleType.Number, 18), new OracleParameter(":Category", OracleType.Char, 1), new OracleParameter(":SSLBBM", OracleType.VarChar, 20), new OracleParameter(":SSLBMC", OracleType.VarChar, 100), new OracleParameter(":Auto", OracleType.Char, 1) }; parameters[0].Value = model.DossierTypeValueMember; parameters[1].Value = model.CaseInfoTypeID; parameters[2].Value = model.CaseInfoTypeName; parameters[3].Value = model.UnitID; parameters[4].Value = model.DossierTypeDisplayMember; parameters[5].Value = model.DossierParentMember; parameters[6].Value = model.DossierEvidenceValueMember; parameters[7].Value = model.SortIndex; parameters[8].Value = model.Category; parameters[9].Value = model.SSLBBM; parameters[10].Value = model.SSLBMC; parameters[11].Value = model.Auto; 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.XY_DZJZ_MBPZB model)", "EDRS.OracleDAL.XY_DZJZ_MBPZB", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
protected void Button1_Click(object sender, EventArgs e) { Dictionary <string, string> SSLBList = new Dictionary <string, string>(); EDRS.BLL.XT_DM_AJLBBM bll2 = new XT_DM_AJLBBM(Request); DataSet dsSSLB = bll2.GetSSLBList("", null); foreach (DataRow dr in dsSSLB.Tables[0].Rows) { SSLBList.Add(dr["SSLBBM"].ToString(), dr["SSLBMC"].ToString()); } if (FileUpload1.HasFile) { string path = FileUpload1.PostedFile.FileName; DataSet ds = new DataSet(); ds.ReadXml(path); foreach (DataRow dr in ds.Tables[0].Rows) { string number = "00000001"; XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request); DataSet ds1 = bll.GetListByPage("", "DOSSIERTYPEVALUEMEMBER desc", 0, 1); if (ds1 != null && ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0) { number = ds1.Tables[0].Rows[0]["DOSSIERTYPEVALUEMEMBER"].ToString(); number = (int.Parse(number) + 1).ToString().PadLeft(8, '0'); } EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB(); model.DossierTypeValueMember = number; model.CaseInfoTypeID = "0301"; model.CaseInfoTypeName = "一审公诉案件"; model.UnitID = "370000"; model.DossierTypeDisplayMember = dr["value"].ToString(); model.DossierParentMember = ""; model.DossierEvidenceValueMember = ""; model.SortIndex = Convert.ToInt32(dr["index"]); model.Category = "J"; model.SSLBBM = dr["key"].ToString(); model.SSLBMC = SSLBList[model.SSLBBM]; model.Auto = "N"; string pid = number; EDRS.BLL.XY_DZJZ_MBPZB bll1 = new EDRS.BLL.XY_DZJZ_MBPZB(Request); if (bll1.Add(model)) { string key = dr["key"].ToString(); key = key.Split('-')[1]; DataRow[] drs = ds.Tables[1].Select("key like '" + key + "-%'"); foreach (DataRow dr1 in drs) { model.CaseInfoTypeID = "0301"; model.CaseInfoTypeName = "一审公诉案件"; model.UnitID = "370000"; model.DossierTypeDisplayMember = dr1["value"].ToString(); model.DossierParentMember = pid; model.DossierEvidenceValueMember = ""; ds1 = bll.GetListByPage("", "DOSSIERTYPEVALUEMEMBER desc", 0, 1); if (ds1 != null && ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0) { number = ds1.Tables[0].Rows[0]["DOSSIERTYPEVALUEMEMBER"].ToString(); number = (int.Parse(number) + 1).ToString().PadLeft(8, '0'); } model.DossierTypeValueMember = number; model.SortIndex = Convert.ToInt32(dr1["index"]);; model.Category = "W"; model.SSLBBM = dr1["key"].ToString(); model.SSLBMC = SSLBList[model.SSLBBM]; model.Auto = "N"; bll1.Add(model); } } } } }