/// <summary>
/// 绑定案件类别
/// </summary>
/// <returns></returns>
private string GetSSLB()
{
XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request);
string where = " ";
List <object> objValues = new List <object>();
if (Request["key"] != null && !string.IsNullOrEmpty(Request["key"]))
{
where += " AND SSLBMC like :SSLBMC ";
objValues.Add("%" + Request["key"].Trim() + "%");
}
if (Request["LBLX"] != null && !string.IsNullOrEmpty(Request["LBLX"]))
{
where += " AND FSSLBBM = :FSSLBBM";
objValues.Add(Request["LBLX"]);
}
else
{
where = " AND FSSLBBM IS NULL";
objValues.Clear();
}
where += "";
DataSet ds = bll.GetSSLBList(where, objValues.ToArray());
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
dt.Columns["SSLBBM"].ColumnName = "id";
dt.Columns["SSLBMC"].ColumnName = "text";
return(EDRS.Common.JsonHelper.JsonString(dt));
}
return(ReturnString.JsonToString(Prompt.error, "未找到" + ((VersionName)0).ToString() + "类别", null));
}
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);
}
}
}
}
}