/// <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);
}
}
}
}
}
