/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
private string DelData()
{
string ids = Request.Form["id"];
string[] id = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
ids = "";
for (int i = 0; i < id.Length; i++)
{
ids += "'" + id[i].Trim() + "'";
if (i < id.Length - 1)
{
ids += ",";
}
}
XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request);
if (bll.DeleteList(ids))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "删除类别成功", Request.Form["cs"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "删除类别成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "删除类别失败", Request.Form["cs"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "删除类别失败", null));
}
/// <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));
}
/// <summary>
/// 添加类别
/// </summary>
/// <returns></returns>
private string AddData()
{
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
string ywbm = Request.Form.Get("slct_type_val");
string ajlbbm = ywbm + "01";
XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request);
DataSet ds = bll.GetListByPage(" and ywbm=:ywbm ", "ajlbbm desc", 1, 1, new object[] { ywbm });
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
string lb = ds.Tables[0].Rows[0]["AJLBBM"].ToString();
lb = lb.Substring(ywbm.Length, lb.Length - ywbm.Length);
int num = int.Parse(lb);
num++;
ajlbbm = ywbm + num.ToString().PadLeft(lb.Length, '0');
}
EDRS.Model.XT_DM_AJLBBM model = new EDRS.Model.XT_DM_AJLBBM();
model.YWBM = ywbm;
model.AJLBBM = ajlbbm;
model.AJLBMC = Request.Form.Get("txt_lbname");
model.AJSLJC = Request.Form.Get("txt_sljc");
model.SFSC = "N";
if (bll.Add(model))
{
//数据日志
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>
/// <param name="DWBM"></param>
/// <returns></returns>
private string GetModel(string ajlbbm)
{
if (string.IsNullOrEmpty(ajlbbm))
{
ajlbbm = Request.Form.Get("id");
if (string.IsNullOrEmpty(ajlbbm))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request);
EDRS.Model.XT_DM_AJLBBM model = bll.GetModel(ajlbbm);
if (model != null)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息成功", "", UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
/// <summary>
/// 绑定案件类别
/// </summary>
/// <returns></returns>
private string GetAJType()
{
XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request);
string where = " and SFSC=:SCSC";
object[] objValues = new object[2];
objValues[0] = "N";
if (Request["key"] != null && !string.IsNullOrEmpty(Request["key"]))
{
where += " and AJLBMC like :AJLBMC ";
objValues[1] = "%" + Request["key"].Trim() + "%";
}
where += " order by xh desc ";
DataSet ds = bll.GetList(where, objValues);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
dt.Columns["AJLBBM"].ColumnName = "id";
dt.Columns["AJLBMC"].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);
}
}
}
}
}
/// <summary>
/// 修改类别
/// </summary>
/// <returns></returns>
private string UpData()
{
string ajlbbm = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(ajlbbm))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request);
EDRS.Model.XT_DM_AJLBBM model = bll.GetModel(ajlbbm);
if (model != null)
{
string ywbm = Request.Form.Get("slct_type_val");
string ajlbbmNew = ywbm + "01";
//业务类型不同重新设置编号
if (model.YWBM != ywbm)
{
DataSet ds = bll.GetListByPage(" and ywbm=:ywbm ", "ajlbbm desc", 1, 1, new object[] { ywbm });
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//int num = int.Parse(ds.Tables[0].Rows[0]["AJLBBM"].ToString().Substring(2, 2));
//num++;
//ajlbbmNew = Request.Form.Get("slct_type_val") + num.ToString().PadLeft(2, '0');
string lb = ds.Tables[0].Rows[0]["AJLBBM"].ToString();
lb = lb.Substring(ywbm.Length, lb.Length - ywbm.Length);
int num = int.Parse(lb);
num++;
ajlbbmNew = ywbm + num.ToString().PadLeft(lb.Length, '0');
}
model.AJLBBM = ajlbbmNew;
}
model.YWBM = Request.Form.Get("slct_type_val");
model.AJLBMC = Request.Form.Get("txt_lbname");
model.AJSLJC = Request.Form.Get("txt_sljc");
if (bll.Update(model, ajlbbm))
{
//数据日志
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));
}
