/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.TYYW_GG_AJJBXX GetModel(string BMSAH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AJBH,jz.WSBH,jz.WSMC,ZZZT,t.BMSAH,TYSAH,SFSC,SFYGXTSJ,CBDW_BM,CBDW_MC,FQDWBM,FQL,CJSJ,ZHXGSJ,SLRQ,AJMC,AJLB_BM,AJLB_MC,ZCJG_DWDM,ZCJG_DWMC,YSDW_DWDM,YSDW_DWMC,YSWSWH,YSAY_AYDM,YSAY_AYMC,YSQTAY_AYDMS,YSQTAY_AYMCS,CBRGH,CBR,CBBM_BM,CBBM_MC,AJZT,SFSWAJ,SFDBAJ,ZXHD_MC,WCRQ,GDRQ,GDRGH,GDR,AQZY,DQJD,BLKSRQ,BLTS,DQRQ,BJRQ,YJZT,JYYJZT,JYYJHCQXYRGS,LCSLBH,FXDJ,SFGZAJ,FZ,YSYJ_DM,YSYJ_MC,SFJBAJ,ZXHD_DM,DQYJJD,YASCSSJD_DM,YASCSSJD_MC,YSRJDH,XYR,SFZH,TARYXX,SHR,ZJS,DJJ,ZYS from TYYW_GG_AJJBXX t left join (select BMSAH,AJBH,WSBH,WSMC,ZZZT,JZPZ from yx_dzjz_jzjbxx) jz on(t.Bmsah = jz.BMSAH)");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where t.BMSAH=:BMSAH ");
OracleParameter[] parameters =
{
new OracleParameter(":BMSAH", OracleType.VarChar, 100)
};
parameters[0].Value = BMSAH;
EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX();
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.TYYW_GG_AJJBXX GetModel(string BMSAH)", "EDRS.OracleDAL.TYYW_GG_AJJBXX", strSql.ToString(), parameters);
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 根据编号获取数据
/// </summary>
/// <returns></returns>
public string GetModel(string BMSAH)
{
if (string.IsNullOrEmpty(BMSAH))
{
BMSAH = Request["id"];
if (string.IsNullOrEmpty(BMSAH))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request);
EDRS.Model.TYYW_GG_AJJBXX model = jzajxx.GetModel(BMSAH);
if (model != null)
{
return(JsonHelper.JsonString(model));
}
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
/// <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 != 4)
{
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);
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 律师阅卷申请
EDRS.Model.YX_DZJZ_LSYJSQ modelLsyjsq = new EDRS.Model.YX_DZJZ_LSYJSQ();
modelLsyjsq.LSZH = lssqs[0];
modelLsyjsq.YJSQDH = Guid.NewGuid().ToString();
modelLsyjsq.SQSJ = DateTime.Now;
modelLsyjsq.SQSM = lssqs[2];
modelLsyjsq.SFSC = "N";
modelLsyjsq.SHRGH = UserInfo.GH;
modelLsyjsq.SHR = UserInfo.MC;
modelLsyjsq.SHSM = "";
modelLsyjsq.SHSJ = DateTime.Now;
modelLsyjsq.YJSQDM = lssqs[1];
modelLsyjsq.SQDZT = "Y";
#endregion
#region 律师阅卷绑定
Random random = new Random();
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
model.GH = lssqs[0];
model.BMSAH = ajmodel.BMSAH;
model.YJXH = yjxh;
model.MC = lssqs[3];
model.AJMC = ajmodel.AJMC;
model.AJLBBM = ajmodel.AJLB_BM;
model.AJLBMC = ajmodel.AJLB_MC;
model.YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]);
model.YJJSSJ = 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))
{
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));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool AddList(EDRS.Model.TYYW_GG_AJJBXX model, EDRS.Model.TYYW_GG_AJJBXXKZ modelkz, EDRS.Model.YX_DZJZ_JZJBXX modeljbxx)
{
System.Collections.Hashtable hash = new System.Collections.Hashtable();
StringBuilder strSql = new StringBuilder();
if (model != null)
{
#region 案件基本信息
strSql.Append("insert into TYYW_GG_AJJBXX(");
strSql.Append("BMSAH,TYSAH,SFSC,SFYGXTSJ,CBDW_BM,CBDW_MC,FQDWBM,FQL,CJSJ,ZHXGSJ,SLRQ,AJMC,AJLB_BM,AJLB_MC,ZCJG_DWDM,ZCJG_DWMC,YSDW_DWDM,YSDW_DWMC,YSWSWH,YSAY_AYDM,YSAY_AYMC,YSQTAY_AYDMS,YSQTAY_AYMCS,CBRGH,CBR,CBBM_BM,CBBM_MC,AJZT,SFSWAJ,SFDBAJ,ZXHD_MC,WCRQ,GDRQ,GDRGH,GDR,AQZY,DQJD,BLKSRQ,BLTS,DQRQ,BJRQ,YJZT,JYYJZT,JYYJHCQXYRGS,LCSLBH,FXDJ,SFGZAJ,FZ,YSYJ_DM,YSYJ_MC,SFJBAJ,ZXHD_DM,DQYJJD,YASCSSJD_DM,YASCSSJD_MC,YSRJDH,XYR,SFZH,TARYXX,SHR,SHSJ,ZJS,DJJ,ZYS)");
strSql.Append(" values (");
strSql.Append(":BMSAH,:TYSAH,:SFSC,:SFYGXTSJ,:CBDW_BM,:CBDW_MC,:FQDWBM,:FQL,:CJSJ,:ZHXGSJ,:SLRQ,:AJMC,:AJLB_BM,:AJLB_MC,:ZCJG_DWDM,:ZCJG_DWMC,:YSDW_DWDM,:YSDW_DWMC,:YSWSWH,:YSAY_AYDM,:YSAY_AYMC,:YSQTAY_AYDMS,:YSQTAY_AYMCS,:CBRGH,:CBR,:CBBM_BM,:CBBM_MC,:AJZT,:SFSWAJ,:SFDBAJ,:ZXHD_MC,:WCRQ,:GDRQ,:GDRGH,:GDR,:AQZY,:DQJD,:BLKSRQ,:BLTS,:DQRQ,:BJRQ,:YJZT,:JYYJZT,:JYYJHCQXYRGS,:LCSLBH,:FXDJ,:SFGZAJ,:FZ,:YSYJ_DM,:YSYJ_MC,:SFJBAJ,:ZXHD_DM,:DQYJJD,:YASCSSJD_DM,:YASCSSJD_MC,:YSRJDH,:XYR,:SFZH,:TARYXX,:SHR,:SHSJ,:ZJS,:DJJ,:ZYS)");
OracleParameter[] parameters =
{
new OracleParameter(":BMSAH", OracleType.VarChar, 100),
new OracleParameter(":TYSAH", OracleType.Char, 17),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":SFYGXTSJ", OracleType.Char, 1),
new OracleParameter(":CBDW_BM", OracleType.VarChar, 50),
new OracleParameter(":CBDW_MC", OracleType.VarChar, 300),
new OracleParameter(":FQDWBM", OracleType.Number, 4),
new OracleParameter(":FQL", OracleType.VarChar, 6),
new OracleParameter(":CJSJ", OracleType.DateTime),
new OracleParameter(":ZHXGSJ", OracleType.DateTime),
new OracleParameter(":SLRQ", OracleType.DateTime),
new OracleParameter(":AJMC", OracleType.VarChar, 300),
new OracleParameter(":AJLB_BM", OracleType.VarChar, 50),
new OracleParameter(":AJLB_MC", OracleType.VarChar, 300),
new OracleParameter(":ZCJG_DWDM", OracleType.Char, 13),
new OracleParameter(":ZCJG_DWMC", OracleType.VarChar, 300),
new OracleParameter(":YSDW_DWDM", OracleType.Char, 13),
new OracleParameter(":YSDW_DWMC", OracleType.VarChar, 300),
new OracleParameter(":YSWSWH", OracleType.VarChar, 300),
new OracleParameter(":YSAY_AYDM", OracleType.Char, 13),
new OracleParameter(":YSAY_AYMC", OracleType.VarChar, 300),
new OracleParameter(":YSQTAY_AYDMS", OracleType.VarChar, 130),
new OracleParameter(":YSQTAY_AYMCS", OracleType.VarChar, 3000),
new OracleParameter(":CBRGH", OracleType.Char, 4),
new OracleParameter(":CBR", OracleType.VarChar, 60),
new OracleParameter(":CBBM_BM", OracleType.Char, 4),
new OracleParameter(":CBBM_MC", OracleType.VarChar, 300),
new OracleParameter(":AJZT", OracleType.Char, 1),
new OracleParameter(":SFSWAJ", OracleType.Char, 1),
new OracleParameter(":SFDBAJ", OracleType.Char, 1),
new OracleParameter(":ZXHD_MC", OracleType.VarChar, 300),
new OracleParameter(":WCRQ", OracleType.DateTime),
new OracleParameter(":GDRQ", OracleType.DateTime),
new OracleParameter(":GDRGH", OracleType.Char, 4),
new OracleParameter(":GDR", OracleType.VarChar, 60),
new OracleParameter(":AQZY", OracleType.VarChar, 4000),
new OracleParameter(":DQJD", OracleType.VarChar, 3000),
new OracleParameter(":BLKSRQ", OracleType.DateTime),
new OracleParameter(":BLTS", OracleType.Number, 4),
new OracleParameter(":DQRQ", OracleType.DateTime),
new OracleParameter(":BJRQ", OracleType.DateTime),
new OracleParameter(":YJZT", OracleType.Char, 1),
new OracleParameter(":JYYJZT", OracleType.Char, 1),
new OracleParameter(":JYYJHCQXYRGS", OracleType.Number, 4),
new OracleParameter(":LCSLBH", OracleType.Char, 2),
new OracleParameter(":FXDJ", OracleType.Char, 1),
new OracleParameter(":SFGZAJ", OracleType.Char, 1),
new OracleParameter(":FZ", OracleType.VarChar, 4000),
new OracleParameter(":YSYJ_DM", OracleType.Char, 13),
new OracleParameter(":YSYJ_MC", OracleType.VarChar, 300),
new OracleParameter(":SFJBAJ", OracleType.Char, 1),
new OracleParameter(":ZXHD_DM", OracleType.Char, 13),
new OracleParameter(":DQYJJD", OracleType.VarChar, 300),
new OracleParameter(":YASCSSJD_DM", OracleType.Char, 13),
new OracleParameter(":YASCSSJD_MC", OracleType.VarChar, 300),
new OracleParameter(":YSRJDH", OracleType.VarChar, 300),
new OracleParameter(":XYR", OracleType.VarChar, 500),
new OracleParameter(":SFZH", OracleType.VarChar, 100),
new OracleParameter(":TARYXX", OracleType.VarChar, 2000),
new OracleParameter(":SHR", OracleType.VarChar, 100),
new OracleParameter(":SHSJ", OracleType.DateTime),
new OracleParameter(":ZJS", OracleType.Number, 18),
new OracleParameter(":DJJ", OracleType.VarChar, 100),
new OracleParameter(":ZYS", OracleType.Number, 18)
};
parameters[0].Value = model.BMSAH ?? "";
parameters[1].Value = model.TYSAH ?? "";
parameters[2].Value = model.SFSC ?? "";
parameters[3].Value = model.SFYGXTSJ ?? "";
parameters[4].Value = model.CBDW_BM ?? "";
parameters[5].Value = model.CBDW_MC ?? "";
parameters[6].Value = model.FQDWBM;
parameters[7].Value = model.FQL ?? "";
parameters[8].Value = model.CJSJ;
parameters[9].Value = model.ZHXGSJ;
parameters[10].Value = model.SLRQ;
parameters[11].Value = model.AJMC ?? "";
parameters[12].Value = model.AJLB_BM ?? "";
parameters[13].Value = model.AJLB_MC ?? "";
parameters[14].Value = model.ZCJG_DWDM ?? "";
parameters[15].Value = model.ZCJG_DWMC ?? "";
parameters[16].Value = model.YSDW_DWDM ?? "";
parameters[17].Value = model.YSDW_DWMC ?? "";
parameters[18].Value = model.YSWSWH ?? "";
parameters[19].Value = model.YSAY_AYDM ?? "";
parameters[20].Value = model.YSAY_AYMC ?? "";
parameters[21].Value = model.YSQTAY_AYDMS ?? "";
parameters[22].Value = model.YSQTAY_AYMCS ?? "";
parameters[23].Value = model.CBRGH ?? "";
parameters[24].Value = model.CBR ?? "";
parameters[25].Value = model.CBBM_BM ?? "";
parameters[26].Value = model.CBBM_MC ?? "";
parameters[27].Value = model.AJZT ?? "";
parameters[28].Value = model.SFSWAJ ?? "";
parameters[29].Value = model.SFDBAJ ?? "";
parameters[30].Value = model.ZXHD_MC ?? "";
parameters[31].Value = model.WCRQ ?? Convert.ToDateTime("1900-01-01");
parameters[32].Value = model.GDRQ ?? Convert.ToDateTime("1900-01-01");
parameters[33].Value = model.GDRGH ?? "";
parameters[34].Value = model.GDR ?? "";
parameters[35].Value = model.AQZY ?? "";
parameters[36].Value = model.DQJD ?? "";
parameters[37].Value = model.BLKSRQ ?? Convert.ToDateTime("1900-01-01");
parameters[38].Value = model.BLTS ?? 0;
parameters[39].Value = model.DQRQ ?? Convert.ToDateTime("1900-01-01");
parameters[40].Value = model.BJRQ ?? Convert.ToDateTime("1900-01-01");
parameters[41].Value = model.YJZT ?? "";
parameters[42].Value = model.JYYJZT ?? "";
parameters[43].Value = model.JYYJHCQXYRGS ?? 0;
parameters[44].Value = model.LCSLBH ?? "";
parameters[45].Value = model.FXDJ ?? "";
parameters[46].Value = model.SFGZAJ ?? "";
parameters[47].Value = model.FZ ?? "";
parameters[48].Value = model.YSYJ_DM ?? "";
parameters[49].Value = model.YSYJ_MC ?? "";
parameters[50].Value = model.SFJBAJ ?? "";
parameters[51].Value = model.ZXHD_DM ?? "";
parameters[52].Value = model.DQYJJD ?? "";
parameters[53].Value = model.YASCSSJD_DM ?? "";
parameters[54].Value = model.YASCSSJD_MC ?? "";
parameters[55].Value = model.YSRJDH ?? "";
parameters[56].Value = model.XYR ?? "";
parameters[57].Value = model.SFZH ?? "";
parameters[58].Value = model.TARYXX ?? "";
parameters[59].Value = model.SHR ?? "";
parameters[60].Value = model.SHSJ ?? DateTime.Now;
parameters[61].Value = model.ZJS;
parameters[62].Value = model.DJJ ?? "";
parameters[63].Value = model.ZYS;
hash.Add(strSql.ToString(), parameters);
#endregion
}
if (modelkz != null)
{
#region 案件基本信息扩展
strSql.Clear();
strSql.Append("insert into TYYW_GG_AJJBXXKZ(");
strSql.Append("AHMC,AY,SAJG,YG,BG,YYR,SQZXR,BZXR,SARQ,JARQ,CJJG,ZXBD,SLJG,ZXJG,JAFS,GLDAXLH,HYTCY,CBR,SJY,ZCS,DJC,YS,GDRQ,YWT,BGQX,AJLBBM,H,NF,YWLBBM,YWLBMC,DWBM,DWMC,DWJC,AJLBMC,QAH,MLH,JH,CZRGH,CZRMC,CZSJ)");
strSql.Append(" values (");
strSql.Append(":AHMC,:AY,:SAJG,:YG,:BG,:YYR,:SQZXR,:BZXR,:SARQ,:JARQ,:CJJG,:ZXBD,:SLJG,:ZXJG,:JAFS,:GLDAXLH,:HYTCY,:CBR,:SJY,:ZCS,:DJC,:YS,:GDRQ,:YWT,:BGQX,:AJLBBM,:H,:NF,:YWLBBM,:YWLBMC,:DWBM,:DWMC,:DWJC,:AJLBMC,:QAH,:MLH,:JH,:CZRGH,:CZRMC,:CZSJ)");
OracleParameter[] parameterskz =
{
new OracleParameter(":AHMC", OracleType.VarChar, 200),
new OracleParameter(":AY", OracleType.VarChar, 500),
new OracleParameter(":SAJG", OracleType.VarChar, 200),
new OracleParameter(":YG", OracleType.VarChar, 200),
new OracleParameter(":BG", OracleType.VarChar, 200),
new OracleParameter(":YYR", OracleType.VarChar, 200),
new OracleParameter(":SQZXR", OracleType.VarChar, 50),
new OracleParameter(":BZXR", OracleType.VarChar, 50),
new OracleParameter(":SARQ", OracleType.DateTime),
new OracleParameter(":JARQ", OracleType.DateTime),
new OracleParameter(":CJJG", OracleType.VarChar, 200),
new OracleParameter(":ZXBD", OracleType.VarChar, 200),
new OracleParameter(":SLJG", OracleType.VarChar, 4000),
new OracleParameter(":ZXJG", OracleType.VarChar, 4000),
new OracleParameter(":JAFS", OracleType.VarChar, 200),
new OracleParameter(":GLDAXLH", OracleType.VarChar, 200),
new OracleParameter(":HYTCY", OracleType.VarChar, 200),
new OracleParameter(":CBR", OracleType.VarChar, 50),
new OracleParameter(":SJY", OracleType.VarChar, 50),
new OracleParameter(":ZCS", OracleType.Number),
new OracleParameter(":DJC", OracleType.Number),
new OracleParameter(":YS", OracleType.Number),
new OracleParameter(":GDRQ", OracleType.DateTime),
new OracleParameter(":YWT", OracleType.VarChar, 200),
new OracleParameter(":BGQX", OracleType.VarChar, 20),
new OracleParameter(":AJLBBM", OracleType.VarChar, 20),
new OracleParameter(":H", OracleType.Number),
new OracleParameter(":NF", OracleType.VarChar, 4),
new OracleParameter(":YWLBBM", OracleType.VarChar, 20),
new OracleParameter(":YWLBMC", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":DWMC", OracleType.VarChar, 500),
new OracleParameter(":DWJC", OracleType.VarChar, 200),
new OracleParameter(":AJLBMC", OracleType.VarChar, 200),
new OracleParameter(":QAH", OracleType.VarChar, 20),
new OracleParameter(":MLH", OracleType.VarChar, 20),
new OracleParameter(":JH", OracleType.VarChar, 20),
new OracleParameter(":CZRGH", OracleType.VarChar, 20),
new OracleParameter(":CZRMC", OracleType.VarChar, 100),
new OracleParameter(":CZSJ", OracleType.DateTime)
};
parameterskz[0].Value = modelkz.AHMC ?? "";
parameterskz[1].Value = modelkz.AY ?? "";
parameterskz[2].Value = modelkz.SAJG ?? "";
parameterskz[3].Value = modelkz.YG ?? "";
parameterskz[4].Value = modelkz.BG ?? "";
parameterskz[5].Value = modelkz.YYR ?? "";
parameterskz[6].Value = modelkz.SQZXR ?? "";
parameterskz[7].Value = modelkz.BZXR ?? "";
parameterskz[8].Value = modelkz.SARQ;
parameterskz[9].Value = modelkz.JARQ;
parameterskz[10].Value = modelkz.CJJG ?? "";
parameterskz[11].Value = modelkz.ZXBD ?? "";
parameterskz[12].Value = modelkz.SLJG ?? "";
parameterskz[13].Value = modelkz.ZXJG ?? "";
parameterskz[14].Value = modelkz.JAFS ?? "";
parameterskz[15].Value = modelkz.GLDAXLH ?? "";
parameterskz[16].Value = modelkz.HYTCY ?? "";
parameterskz[17].Value = modelkz.CBR ?? "";
parameterskz[18].Value = modelkz.SJY ?? "";
parameterskz[19].Value = modelkz.ZCS;
parameterskz[20].Value = modelkz.DJC;
parameterskz[21].Value = modelkz.YS;
parameterskz[22].Value = modelkz.GDRQ;
parameterskz[23].Value = modelkz.YWT ?? "";
parameterskz[24].Value = modelkz.BGQX ?? "";
parameterskz[25].Value = modelkz.AJLBBM ?? "";
parameterskz[26].Value = modelkz.H;
parameterskz[27].Value = modelkz.NF;
parameterskz[28].Value = modelkz.YWLBBM ?? "";
parameterskz[29].Value = modelkz.YWLBMC ?? "";
parameterskz[30].Value = modelkz.DWBM ?? "";
parameterskz[31].Value = modelkz.DWMC ?? "";
parameterskz[32].Value = modelkz.DWJC ?? "";
parameterskz[33].Value = modelkz.AJLBMC ?? "";
parameterskz[34].Value = modelkz.QAH ?? "";
parameterskz[35].Value = modelkz.MLH ?? "";
parameterskz[36].Value = modelkz.JH ?? "";
parameterskz[37].Value = modelkz.CZRGH ?? "";
parameterskz[38].Value = modelkz.CZRMC ?? "";
parameterskz[39].Value = modelkz.CZSJ;
hash.Add(strSql.ToString(), parameterskz);
#endregion
}
if (modeljbxx != null)
{
#region 卷宗基本信息
strSql.Clear();
strSql.Append("insert into YX_DZJZ_JZJBXX(");
strSql.Append("JZBH,SFSC,CJSJ,ZHXGSJ,FQDWBM,FQL,DWBM,BMSAH,TYSAH,JZMC,JZLJ,JZSCSJ,JZSCRGH,JZSCRXM,JZMS,JZXGH,SFKYGX,GXYWBMJH,MRSFGKPZ, ACCOMPLICES, AJMB_BM, AJMB_MC, IDNUMBER, ISRECORD, SUSPECTNAME,WSBH,AJBH,ZZZT,JZPZ,JZSHRBH,JZSHR,JZSHSJ,WSMC,SMAJLA,SMAJCD,LAZZZT)");
strSql.Append(" values (");
strSql.Append(":JZBH,:SFSC,:CJSJ,:ZHXGSJ,:FQDWBM,:FQL,:DWBM,:BMSAH,:TYSAH,:JZMC,:JZLJ,:JZSCSJ,:JZSCRGH,:JZSCRXM,:JZMS,:JZXGH,:SFKYGX,:GXYWBMJH,:MRSFGKPZ, :ACCOMPLICES, :AJMB_BM, :AJMB_MC, :IDNUMBER, :ISRECORD, :SUSPECTNAME, :WSBH, :AJBH, :ZZZT,:JZPZ,:JZSHRBH,:JZSHR,:JZSHSJ,:WSMC,:SMAJLA,:SMAJCD,:LAZZZT)");
OracleParameter[] parametersjbxx =
{
new OracleParameter(":JZBH", OracleType.Char, 14),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":CJSJ", OracleType.DateTime),
new OracleParameter(":ZHXGSJ", OracleType.DateTime),
new OracleParameter(":FQDWBM", OracleType.VarChar, 50),
new OracleParameter(":FQL", OracleType.VarChar, 6),
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":BMSAH", OracleType.VarChar, 100),
new OracleParameter(":TYSAH", OracleType.Char, 17),
new OracleParameter(":JZMC", OracleType.VarChar, 300),
new OracleParameter(":JZLJ", OracleType.VarChar, 500),
new OracleParameter(":JZSCSJ", OracleType.DateTime),
new OracleParameter(":JZSCRGH", OracleType.Char, 4),
new OracleParameter(":JZSCRXM", OracleType.VarChar, 60),
new OracleParameter(":JZMS", OracleType.VarChar, 500),
new OracleParameter(":JZXGH", OracleType.Clob, 4000),
new OracleParameter(":SFKYGX", OracleType.Char, 1),
new OracleParameter(":GXYWBMJH", OracleType.VarChar, 300),
new OracleParameter(":MRSFGKPZ", OracleType.Char, 1),
new OracleParameter(":ACCOMPLICES", OracleType.VarChar, 2000),
new OracleParameter(":AJMB_BM", OracleType.VarChar, 500),
new OracleParameter(":AJMB_MC", OracleType.VarChar, 500),
new OracleParameter(":IDNUMBER", OracleType.VarChar, 500),
new OracleParameter(":ISRECORD", OracleType.VarChar, 10),
new OracleParameter(":SUSPECTNAME", OracleType.VarChar, 500),
new OracleParameter(":WSBH", OracleType.VarChar, 100),
new OracleParameter(":AJBH", OracleType.VarChar, 100),
new OracleParameter(":ZZZT", OracleType.VarChar, 10),
new OracleParameter(":JZPZ", OracleType.VarChar, 4000),
new OracleParameter(":JZSHRBH", OracleType.VarChar),
new OracleParameter(":JZSHR", OracleType.VarChar),
new OracleParameter(":JZSHSJ", OracleType.DateTime),
new OracleParameter(":WSMC", OracleType.VarChar),
new OracleParameter(":SMAJLA", OracleType.VarChar),
new OracleParameter(":SMAJCD", OracleType.VarChar),
new OracleParameter(":LAZZZT", OracleType.VarChar, 10)
};
parametersjbxx[0].Value = modeljbxx.JZBH ?? "";
parametersjbxx[1].Value = modeljbxx.SFSC;
parametersjbxx[2].Value = modeljbxx.CJSJ;
parametersjbxx[3].Value = modeljbxx.ZHXGSJ;
parametersjbxx[4].Value = modeljbxx.FQDWBM;
parametersjbxx[5].Value = modeljbxx.FQL ?? "";
parametersjbxx[6].Value = modeljbxx.DWBM ?? "";
parametersjbxx[7].Value = modeljbxx.BMSAH ?? "";
parametersjbxx[8].Value = modeljbxx.TYSAH ?? "";
parametersjbxx[9].Value = modeljbxx.JZMC ?? "";
parametersjbxx[10].Value = modeljbxx.JZLJ ?? "";
parametersjbxx[11].Value = (object)modeljbxx.JZSCSJ ?? DBNull.Value;
parametersjbxx[12].Value = modeljbxx.JZSCRGH ?? "";
parametersjbxx[13].Value = modeljbxx.JZSCRXM ?? "";
parametersjbxx[14].Value = modeljbxx.JZMS ?? "";
parametersjbxx[15].Value = modeljbxx.JZXGH;
parametersjbxx[16].Value = modeljbxx.SFKYGX;
parametersjbxx[17].Value = modeljbxx.GXYWBMJH ?? "";
parametersjbxx[18].Value = modeljbxx.MRSFGKPZ;
parametersjbxx[19].Value = modeljbxx.Accomplices ?? "";
parametersjbxx[20].Value = modeljbxx.Ajmb_bm ?? "";
parametersjbxx[21].Value = modeljbxx.Ajmb_mc ?? "";
parametersjbxx[22].Value = modeljbxx.Idnumber ?? "";
parametersjbxx[23].Value = modeljbxx.Isrecord ?? "";
parametersjbxx[24].Value = modeljbxx.Suspectname ?? "";
parametersjbxx[25].Value = modeljbxx.WSBH ?? "";
parametersjbxx[26].Value = modeljbxx.AJBH ?? "";
parametersjbxx[27].Value = modeljbxx.ZZZT ?? "";
parametersjbxx[28].Value = modeljbxx.JZPZ ?? "";
parametersjbxx[29].Value = modeljbxx.JZSHRBH ?? "";
parametersjbxx[30].Value = modeljbxx.JZSHR ?? "";
parametersjbxx[31].Value = (object)modeljbxx.JZSHSJ ?? DBNull.Value;
parametersjbxx[32].Value = modeljbxx.WSMC ?? "";
parametersjbxx[33].Value = modeljbxx.SMAJLA ?? "";
parametersjbxx[34].Value = modeljbxx.SMAJCD ?? "";
parametersjbxx[35].Value = modeljbxx.LAZZZT ?? "";
hash.Add(strSql.ToString(), parametersjbxx);
#endregion
}
try
{
return(DbHelperOra.ExecuteSqlTran(hash));
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddList(EDRS.Model.TYYW_GG_AJJBXX model,EDRS.Model.TYYW_GG_AJJBXXKZ modelkz,EDRS.Model.YX_DZJZ_JZJBXX modeljbxx)", "EDRS.OracleDAL.TYYW_GG_AJJBXX");
}
return(false);
}
/// <summary>
/// 修改一条数据
/// </summary>
public bool UpdateList(EDRS.Model.TYYW_GG_AJJBXX model, EDRS.Model.TYYW_GG_AJJBXXKZ modelkz, EDRS.Model.YX_DZJZ_JZJBXX modeljbxx)
{
System.Collections.Hashtable hash = new System.Collections.Hashtable();
StringBuilder strSql = new StringBuilder();
if (model != null)
{
#region 案件基本信息
strSql.Append("update TYYW_GG_AJJBXX set ");
strSql.Append("ZHXGSJ=:ZHXGSJ,SLRQ=:SLRQ,AJMC=:AJMC,AJLB_BM=:AJLB_BM,AJLB_MC=:AJLB_MC,CBRGH=:CBRGH,CBR=:CBR,BJRQ=:BJRQ where BMSAH=:BMSAH ");
OracleParameter[] parameters =
{
new OracleParameter(":BMSAH", OracleType.VarChar, 100),
new OracleParameter(":ZHXGSJ", OracleType.DateTime),
new OracleParameter(":SLRQ", OracleType.DateTime),
new OracleParameter(":AJMC", OracleType.VarChar, 300),
new OracleParameter(":AJLB_BM", OracleType.VarChar, 50),
new OracleParameter(":AJLB_MC", OracleType.VarChar, 300),
new OracleParameter(":CBRGH", OracleType.Char, 4),
new OracleParameter(":CBR", OracleType.VarChar, 60),
new OracleParameter(":BJRQ", OracleType.DateTime)
};
parameters[0].Value = model.BMSAH ?? "";
parameters[1].Value = model.ZHXGSJ;
parameters[2].Value = model.SLRQ;
parameters[3].Value = model.AJMC ?? "";
parameters[4].Value = model.AJLB_BM ?? "";
parameters[5].Value = model.AJLB_MC ?? "";
parameters[6].Value = model.CBRGH ?? "";
parameters[7].Value = model.CBR ?? "";
parameters[8].Value = (object)model.BJRQ ?? DBNull.Value;
hash.Add(strSql.ToString(), parameters);
#endregion
}
if (modelkz != null)
{
#region 案件基本信息扩展
strSql.Clear();
strSql.Append("update TYYW_GG_AJJBXXKZ set ");
strSql.Append("AY=:AY,SAJG=:SAJG,YG=:YG,BG=:BG,YYR=:YYR,SQZXR=:SQZXR,BZXR=:BZXR,SARQ=:SARQ,JARQ=:JARQ,CJJG=:CJJG,ZXBD=:ZXBD,SLJG=:SLJG,ZXJG=:ZXJG,JAFS=:JAFS,GLDAXLH=:GLDAXLH,HYTCY=:HYTCY,CBR=:CBR,SJY=:SJY,ZCS=:ZCS,DJC=:DJC,YS=:YS,GDRQ=:GDRQ,YWT=:YWT,BGQX=:BGQX,AJLBBM=:AJLBBM,H=:H,NF=:NF,YWLBBM=:YWLBBM,YWLBMC=:YWLBMC,DWBM=:DWBM,DWMC=:DWMC,DWJC=:DWJC,AJLBMC=:AJLBMC,QAH=:QAH,MLH=:MLH,JH=:JH where AHMC=:AHMC");
OracleParameter[] parameterskz =
{
new OracleParameter(":AHMC", OracleType.VarChar, 200),
new OracleParameter(":AY", OracleType.VarChar, 500),
new OracleParameter(":SAJG", OracleType.VarChar, 200),
new OracleParameter(":YG", OracleType.VarChar, 200),
new OracleParameter(":BG", OracleType.VarChar, 200),
new OracleParameter(":YYR", OracleType.VarChar, 200),
new OracleParameter(":SQZXR", OracleType.VarChar, 50),
new OracleParameter(":BZXR", OracleType.VarChar, 50),
new OracleParameter(":SARQ", OracleType.DateTime),
new OracleParameter(":JARQ", OracleType.DateTime),
new OracleParameter(":CJJG", OracleType.VarChar, 200),
new OracleParameter(":ZXBD", OracleType.VarChar, 200),
new OracleParameter(":SLJG", OracleType.VarChar, 4000),
new OracleParameter(":ZXJG", OracleType.VarChar, 4000),
new OracleParameter(":JAFS", OracleType.VarChar, 200),
new OracleParameter(":GLDAXLH", OracleType.VarChar, 200),
new OracleParameter(":HYTCY", OracleType.VarChar, 200),
new OracleParameter(":CBR", OracleType.VarChar, 50),
new OracleParameter(":SJY", OracleType.VarChar, 50),
new OracleParameter(":ZCS", OracleType.Number),
new OracleParameter(":DJC", OracleType.Number),
new OracleParameter(":YS", OracleType.Number),
new OracleParameter(":GDRQ", OracleType.DateTime),
new OracleParameter(":YWT", OracleType.VarChar, 200),
new OracleParameter(":BGQX", OracleType.VarChar, 20),
new OracleParameter(":AJLBBM", OracleType.VarChar, 20),
new OracleParameter(":H", OracleType.Number),
new OracleParameter(":NF", OracleType.VarChar, 4),
new OracleParameter(":YWLBBM", OracleType.VarChar, 20),
new OracleParameter(":YWLBMC", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":DWMC", OracleType.VarChar, 500),
new OracleParameter(":DWJC", OracleType.VarChar, 200),
new OracleParameter(":AJLBMC", OracleType.VarChar, 200),
new OracleParameter(":QAH", OracleType.VarChar, 20),
new OracleParameter(":MLH", OracleType.VarChar, 20),
new OracleParameter(":JH", OracleType.VarChar, 20)
};
parameterskz[0].Value = modelkz.AHMC ?? "";
parameterskz[1].Value = modelkz.AY ?? "";
parameterskz[2].Value = modelkz.SAJG ?? "";
parameterskz[3].Value = modelkz.YG ?? "";
parameterskz[4].Value = modelkz.BG ?? "";
parameterskz[5].Value = modelkz.YYR ?? "";
parameterskz[6].Value = modelkz.SQZXR ?? "";
parameterskz[7].Value = modelkz.BZXR ?? "";
parameterskz[8].Value = modelkz.SARQ;
parameterskz[9].Value = modelkz.JARQ;
parameterskz[10].Value = modelkz.CJJG ?? "";
parameterskz[11].Value = modelkz.ZXBD ?? "";
parameterskz[12].Value = modelkz.SLJG ?? "";
parameterskz[13].Value = modelkz.ZXJG ?? "";
parameterskz[14].Value = modelkz.JAFS ?? "";
parameterskz[15].Value = modelkz.GLDAXLH ?? "";
parameterskz[16].Value = modelkz.HYTCY ?? "";
parameterskz[17].Value = modelkz.CBR ?? "";
parameterskz[18].Value = modelkz.SJY ?? "";
parameterskz[19].Value = modelkz.ZCS;
parameterskz[20].Value = modelkz.DJC;
parameterskz[21].Value = modelkz.YS;
parameterskz[22].Value = modelkz.GDRQ;
parameterskz[23].Value = modelkz.YWT ?? "";
parameterskz[24].Value = modelkz.BGQX ?? "";
parameterskz[25].Value = modelkz.AJLBBM ?? "";
parameterskz[26].Value = modelkz.H;
parameterskz[27].Value = modelkz.NF;
parameterskz[28].Value = modelkz.YWLBBM ?? "";
parameterskz[29].Value = modelkz.YWLBMC ?? "";
parameterskz[30].Value = modelkz.DWBM ?? "";
parameterskz[31].Value = modelkz.DWMC ?? "";
parameterskz[32].Value = modelkz.DWJC ?? "";
parameterskz[33].Value = modelkz.AJLBMC ?? "";
parameterskz[34].Value = modelkz.QAH ?? "";
parameterskz[35].Value = modelkz.MLH ?? "";
parameterskz[36].Value = modelkz.JH ?? "";
hash.Add(strSql.ToString(), parameterskz);
#endregion
}
if (modeljbxx != null)
{
#region 卷宗基本信息
strSql.Clear();
strSql.Append("update YX_DZJZ_JZJBXX set ");
strSql.AppendFormat("ZHXGSJ=:ZHXGSJ,JZMC=:JZMC,AJMB_BM= :AJMB_BM, AJMB_MC=:AJMB_MC {0}{1} where BMSAH=:BMSAH", (string.IsNullOrEmpty(modeljbxx.SMAJLA) ? "" : ",SMAJLA=:SMAJLA"), (string.IsNullOrEmpty(modeljbxx.SMAJCD) ? "" : ",SMAJCD=:SMAJCD"));
System.Collections.Generic.List <OracleParameter> parametersjbxx = new System.Collections.Generic.List <OracleParameter>();
parametersjbxx.Add(new OracleParameter(":ZHXGSJ", modeljbxx.ZHXGSJ));
parametersjbxx.Add(new OracleParameter(":AJMB_BM", modeljbxx.Ajmb_bm ?? ""));
parametersjbxx.Add(new OracleParameter(":AJMB_MC", modeljbxx.Ajmb_mc ?? ""));
parametersjbxx.Add(new OracleParameter(":BMSAH", modeljbxx.BMSAH ?? ""));
parametersjbxx.Add(new OracleParameter(":JZMC", modeljbxx.JZMC ?? ""));
if (!string.IsNullOrEmpty(modeljbxx.SMAJLA))
{
parametersjbxx.Add(new OracleParameter(":SMAJLA", modeljbxx.SMAJLA ?? ""));
}
if (!string.IsNullOrEmpty(modeljbxx.SMAJCD))
{
parametersjbxx.Add(new OracleParameter(":SMAJCD", modeljbxx.SMAJCD ?? ""));
}
//OracleParameter[] parametersjbxx = {
// new OracleParameter(":ZHXGSJ", OracleType.DateTime),
// new OracleParameter(":AJMB_BM", OracleType.VarChar,500),
// new OracleParameter(":AJMB_MC", OracleType.VarChar,500),
// new OracleParameter(":BMSAH", OracleType.VarChar,100),
// new OracleParameter(":JZMC", OracleType.VarChar,300),
// new OracleParameter(":SMAJLA", OracleType.VarChar),
// new OracleParameter(":SMAJCD", OracleType.VarChar),
// };
//parametersjbxx[0].Value = modeljbxx.ZHXGSJ;
//parametersjbxx[1].Value = modeljbxx.Ajmb_bm ?? "";
//parametersjbxx[2].Value = modeljbxx.Ajmb_mc ?? "";
//parametersjbxx[3].Value = modeljbxx.BMSAH ?? "";
//parametersjbxx[4].Value = modeljbxx.JZMC ?? "";
//parametersjbxx[5].Value = modeljbxx.SMAJLA ?? "";
//parametersjbxx[6].Value = modeljbxx.SMAJCD ?? "";
hash.Add(strSql.ToString(), parametersjbxx.ToArray());
#endregion
}
try
{
return(DbHelperOra.ExecuteSqlTran(hash));
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddList(EDRS.Model.TYYW_GG_AJJBXX model,EDRS.Model.TYYW_GG_AJJBXXKZ modelkz,EDRS.Model.YX_DZJZ_JZJBXX modeljbxx)", "EDRS.OracleDAL.TYYW_GG_AJJBXX");
}
return(false);
}
/// <summary>
/// 添加案件信息
/// </summary>
/// <returns></returns>
private string AddData()
{
string ajmc = Request.Form.Get("txt_ajmc");
string lbmc = Request.Form.Get("txt_lbmc");
string xyr = Request.Form.Get("txt_xyr");
string sfzh = (string.IsNullOrEmpty(Request.Form.Get("txt_sfzh")) ? "" : Request.Form.Get("txt_sfzh"));
string taryxx = (string.IsNullOrEmpty(Request.Form.Get("txt_taryxx")) ? "" : Request.Form.Get("txt_taryxx"));
string ajlb = (string.IsNullOrEmpty(Request.Form.Get("txt_ajlb")) ? "" : Request.Form.Get("txt_ajlb"));
string ajbh = Request.Form.Get("txt_ajbh"); //案件编号
string lasj = Request.Form.Get("txt_lasj"); //立案时间
string jasj = Request.Form.Get("txt_jasj"); //结案时间
string ladw = Request.Form.Get("txt_ladw_val"); //立卷单位
string ladw_mc = Request.Form.Get("txt_ladw"); //立卷单位名称
string ljr = Request.Form.Get("txt_lar_val"); //立卷人
string ljr_mc = Request.Form.Get("txt_lar"); //立卷人名称
string shr = Request.Form.Get("txt_shr"); //审核人
string zjs = (string.IsNullOrEmpty(Request.Form.Get("txt_zjs")) ? "0" : Request.Form.Get("txt_zjs")); //本案共卷
string djj = Request.Form.Get("txt_djj"); //第几卷
string djy = (string.IsNullOrEmpty(Request.Form.Get("txt_djy")) ? "0" : Request.Form.Get("txt_djy")); //第几页
string wsbh = Request.Form.Get("wsbh_hidd");
string wsmc = Request.Form.Get("txt_wsbh");
//案件编号
if (string.IsNullOrEmpty(ajbh))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写案件编号", null));
}
//判断案件名称
if (string.IsNullOrEmpty(ajmc))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写案件名称", null));
}
//判断案件类别
if (string.IsNullOrEmpty(ajlb))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写案件类别", null));
}
//立案时间
if (string.IsNullOrEmpty(lasj))
{
return(ReturnString.JsonToString(Prompt.error, "必须选择立案时间", null));
}
//立卷单位
if (string.IsNullOrEmpty(ladw))
{
return(ReturnString.JsonToString(Prompt.error, "必须选择立卷单位", null));
}
EDRS.BLL.YX_DZJZ_JZJBXX jbxxbll = new YX_DZJZ_JZJBXX(Request);
if (!string.IsNullOrEmpty(ajbh))
{
string where = string.Empty;
object[] param = null;
if (string.IsNullOrEmpty(wsbh))
{
where = " and ajbh = :ajbh and (wsbh is null or wsbh='') and SFSC='N'";
param = new object[] { ajbh };
}
else
{
where = " and ajbh = :ajbh and wsbh=:wsbh and SFSC='N'";
param = new object[] { ajbh, wsbh };
}
//if (!string.IsNullOrEmpty(wsbh))
//{
//where = " and ajbh like :ajbh and wsbh=:wsbh and SFSC='N'";
//param = new object[] { ajbh + "%", wsbh };
//}
//else
//{
// where = " and ajbh like :ajbh and SFSC='N'";
// param = new object[] { ajbh + "%" };
//}
// List<EDRS.Model.YX_DZJZ_JZJBXX> list = jbxxbll.GetModelList(where, param);
// int dataCount = jbxxbll.GetRecordCount(where, param);
//if (dataCount > 0)
//{
// return ReturnString.JsonToString(Prompt.error, "案件【" + ajbh + "】已存在，请不要重复添加！", null);
//}
DataSet ds = jbxxbll.GetList(where, param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//{
// if (ds.Tables[0].Rows[i]["DWBM"].ToString() == UserInfo.DWBM)
// {
return(ReturnString.JsonToString(Prompt.error, "案件【" + ajbh + "】已存在，请不要重复添加，或者选择其它文书号！", null));
// }
//}
//ajbh += "_"+UserInfo.DWBM;
}
}
//if (!string.IsNullOrEmpty(wsbh))
//{
// List<EDRS.Model.YX_DZJZ_JZJBXX> list = jbxxbll.GetModelList(" and wsbh=:wsbh and SFSC='N'", new object[] { wsbh });
// if (list != null && list.Count > 0)
// {
// return ReturnString.JsonToString(Prompt.error, "文书编号【" + wsbh + "】已存在，请不要重复添加！", null);
// }
//}
if (!string.IsNullOrEmpty(ajmc) && !string.IsNullOrEmpty(ajlb))//&& !string.IsNullOrEmpty(ajbh)
{
//EDRS.BLL.XT_DM_AJLBBM ajlbbmBll = new XT_DM_AJLBBM(Request);
//EDRS.Model.XT_DM_AJLBBM ajlbModel = ajlbbmBll.GetModel(ajlb);
//if (ajlbModel != null)
// lbjc = ajlbModel.AJSLJC;
//if (string.IsNullOrEmpty(lbjc))
// lbjc = lbmc;
string bmsahName = ajlb + "[" + DateTime.Now.Year + "]" + UserInfo.DWBM;
string num = "00001号";
TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request);
DataSet ds = jzajxx.GetListByPage(" and bmsah like '" + bmsahName + "%'", "bmsah desc", 1, 1, null);
if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 1)
{
num = ds.Tables[0].Rows[0]["bmsah"].ToString().Replace(bmsahName, "").Replace("号", "");
num = (Convert.ToInt32(num) + 1).ToString().PadLeft(5, '0') + "号";
}
EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX();
//山东省院起诉受[2015]37000000072号
model.BMSAH = bmsahName + num;
model.TYSAH = Guid.NewGuid().ToString().ToUpper().Replace("-", "");
model.SFSC = "N";
model.SFYGXTSJ = "N";
model.FQDWBM = Convert.ToDecimal(UserInfo.DWBM.Substring(0, 4));
model.FQL = DateTime.Now.Year.ToString();
model.CJSJ = DateTime.Now;
model.ZHXGSJ = DateTime.Now;
model.SLRQ = (string.IsNullOrEmpty(lasj)? DateTime.Now : Convert.ToDateTime(lasj));// DateTime.Now;
model.AJMC = ajmc;
model.AJLB_BM = ajlb;
model.AJLB_MC = lbmc;
model.XYR = xyr;
model.SFZH = sfzh;
model.TARYXX = taryxx;
if (!string.IsNullOrEmpty(jasj))
{
model.BJRQ = Convert.ToDateTime(jasj);
}
if (!string.IsNullOrEmpty(ladw) && ladw != "null")
{
model.CBDW_BM = ladw;
model.CBDW_MC = ladw_mc;
}
else
{
model.CBDW_BM = UserInfo.DWBM;
model.CBDW_MC = UserInfo.DWMC;
}
model.CBR = ljr_mc;
model.CBRGH = ljr;
//2016-6-6 增字段
model.SHR = shr; //审核人
model.SHSJ = DateTime.Now; //审核时间
model.ZJS = Convert.ToDecimal(zjs); //总卷数
model.DJJ = djj; //第几卷
model.ZYS = Convert.ToDecimal(djy); //总页数
if (jzajxx.Add(model))
{
string count = "0";
count = jbxxbll.GetRecordCount("", null).ToString();
count = count.PadLeft(5, '0');
EDRS.Model.YX_DZJZ_JZJBXX jbxxmodel = new EDRS.Model.YX_DZJZ_JZJBXX();
jbxxmodel.JZBH = DateTime.Now.ToString("yyyyMMddHHmmssfff");
jbxxmodel.SFSC = "N";
jbxxmodel.CJSJ = DateTime.Now;
jbxxmodel.ZHXGSJ = DateTime.Now;
jbxxmodel.FQDWBM = 0;
jbxxmodel.FQL = "";
jbxxmodel.DWBM = model.CBDW_BM;
jbxxmodel.BMSAH = model.BMSAH;
jbxxmodel.TYSAH = UserInfo.DWBM + DateTime.Now.ToString("yyyyMM") + jbxxbll.GetRecordCount("", null) + count;
jbxxmodel.JZMC = ajmc;
jbxxmodel.JZLJ = "";
jbxxmodel.JZSCSJ = DateTime.Now;
jbxxmodel.JZSCRGH = UserInfo.GH;
jbxxmodel.JZSCRXM = UserInfo.MC;
jbxxmodel.JZMS = "";
jbxxmodel.JZXGH = "0";
jbxxmodel.SFKYGX = "";
jbxxmodel.GXYWBMJH = "";
jbxxmodel.MRSFGKPZ = "";
jbxxmodel.Accomplices = taryxx;
jbxxmodel.Ajmb_bm = ajlb;
jbxxmodel.Ajmb_mc = lbmc;
jbxxmodel.Idnumber = sfzh;
jbxxmodel.Isrecord = "0";
jbxxmodel.Suspectname = xyr;
jbxxmodel.WSBH = wsbh;
jbxxmodel.AJBH = ajbh;
jbxxmodel.WSMC = wsmc;
jbxxmodel.ZZZT = "-1";
if (jbxxbll.Add(jbxxmodel))
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "成功", model.BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "添加" + ((VersionName)0).ToString() + "成功", null));
}
else
{
jzajxx.Delete(model.BMSAH);
}
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "失败", model.BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "添加" + ((VersionName)0).ToString() + "失败", null));
}
return(ReturnString.JsonToString(Prompt.error, "请将" + ((VersionName)0).ToString() + "信息填写完整", null));
}
/// <summary>
/// 编辑数据
/// </summary>
/// <returns></returns>
public string UpData()
{
string ajmc = Request.Form.Get("txt_ajmc");
string lbmc = Request.Form.Get("txt_lbmc");
string xyr = Request.Form.Get("txt_xyr");
string sfzh = Request.Form.Get("txt_sfzh");
string taryxx = Request.Form.Get("txt_taryxx");
string ajlb = Request.Form.Get("txt_ajlb");
string bmsah = Request.Form.Get("hidd_bmsah");
string ajbh = Request.Form.Get("txt_ajbh"); //案件编号
string lasj = Request.Form.Get("txt_lasj"); //立案时间
string jasj = Request.Form.Get("txt_jasj"); //结案时间
string ladw = Request.Form.Get("txt_ladw_val"); //立卷单位
string ladw_mc = Request.Form.Get("txt_ladw"); //立卷单位名称
string ljr = Request.Form.Get("txt_lar_val"); //立卷人
string ljr_mc = Request.Form.Get("txt_lar"); //立卷人名称
string shr = Request.Form.Get("txt_shr"); //审核人
string zjs = (string.IsNullOrEmpty(Request.Form.Get("txt_zjs")) ? "0" : Request.Form.Get("txt_zjs")); //本案共卷
string djj = Request.Form.Get("txt_djj"); //第几卷
string djy = (string.IsNullOrEmpty(Request.Form.Get("txt_djy")) ? "0" : Request.Form.Get("txt_djy")); //第几页
string wsbh = Request.Form.Get("wsbh_hidd");
string wsmc = Request.Form.Get("txt_wsbh"); //txt_wsbh
//案件编号
if (string.IsNullOrEmpty(ajbh))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写案件编号", null));
}
//判断案件名称
if (string.IsNullOrEmpty(ajmc))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写案件名称", null));
}
//判断案件类别
if (string.IsNullOrEmpty(ajlb))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写案件类别", null));
}
//立案时间
if (string.IsNullOrEmpty(lasj))
{
return(ReturnString.JsonToString(Prompt.error, "必须选择立案时间", null));
}
//立卷单位
if (string.IsNullOrEmpty(ladw))
{
return(ReturnString.JsonToString(Prompt.error, "必须选择立卷单位", null));
}
if (string.IsNullOrEmpty(bmsah))
{
return(ReturnString.JsonToString(Prompt.error, "未指定修改" + ((VersionName)0).ToString() + "，请重新选择修改" + ((VersionName)0).ToString(), null));
}
YX_DZJZ_JZJBXX bll = new YX_DZJZ_JZJBXX(Request);
if (!string.IsNullOrEmpty(ajbh))
{
// List<EDRS.Model.YX_DZJZ_JZJBXX> list = bll.GetModelList(" and ajbh=:ajbh and wsbh=:wsbh and SFSC='N' and bmsah<>:bmsah ", new object[] { ajbh, wsbh ,bmsah});
int dataCount = bll.GetRecordCount(" and ajbh=:ajbh and wsbh=:wsbh and SFSC='N' and bmsah<>:bmsah ", new object[] { ajbh, wsbh, bmsah });
if (dataCount > 0)
{
return(ReturnString.JsonToString(Prompt.error, "案件信息【" + ajbh + "】已存在，请不要重复添加！", null));
}
}
if (!string.IsNullOrEmpty(ajmc) && !string.IsNullOrEmpty(ajlb))
{
TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request);
EDRS.Model.TYYW_GG_AJJBXX model = jzajxx.GetModel(bmsah);
if (model != null)
{
model.AJMC = ajmc;
model.AJLB_BM = ajlb;
model.AJLB_MC = lbmc;
model.XYR = xyr;
model.SFZH = sfzh;
model.TARYXX = taryxx;
model.SLRQ = (string.IsNullOrEmpty(lasj) ? DateTime.Now : Convert.ToDateTime(lasj));// DateTime.Now;
if (!string.IsNullOrEmpty(jasj))
{
model.BJRQ = Convert.ToDateTime(jasj);
}
if (!string.IsNullOrEmpty(ladw) && ladw != "null")
{
model.CBDW_BM = ladw;
model.CBDW_MC = ladw_mc;
}
model.CBR = ljr_mc;
model.CBRGH = ljr;
//2016-6-6 增字段
model.SHR = shr; //审核人
model.SHSJ = DateTime.Now; //审核时间
model.ZJS = Convert.ToDecimal(zjs); //总卷数
model.DJJ = djj; //第几卷
model.ZYS = Convert.ToDecimal(djy); //总页数
if (jzajxx.Update(model))
{
List <EDRS.Model.YX_DZJZ_JZJBXX> list = bll.GetModelList(" and BMSAH ='" + bmsah + "'", null);
if (list != null && list.Count > 0)
{
EDRS.Model.YX_DZJZ_JZJBXX jbxxModel = list[0];
jbxxModel.JZMC = ajmc;
jbxxModel.Ajmb_bm = ajlb;
jbxxModel.Ajmb_mc = lbmc;
jbxxModel.WSBH = wsbh;
jbxxModel.WSMC = wsmc;
jbxxModel.ZHXGSJ = DateTime.Now;
jbxxModel.DWBM = model.CBDW_BM;
if (!bll.Update(jbxxModel))
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "卷宗基本信息修改失败", model.BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "卷宗基本信息修改失败", null));
}
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "修改" + ((VersionName)0).ToString() + "成功", model.BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "修改" + ((VersionName)0).ToString() + "成功", null));
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "修改" + ((VersionName)0).ToString() + "失败", model.BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "修改" + ((VersionName)0).ToString() + "失败", null));
}
return(ReturnString.JsonToString(Prompt.error, "修改" + ((VersionName)0).ToString() + "不存在", null));
}
return(ReturnString.JsonToString(Prompt.error, "请将" + ((VersionName)0).ToString() + "信息填写完整", null));
}
/// <summary>
/// 卷宗制作
/// </summary>
/// <param name="BMSAH"></param>
/// <returns></returns>
private string GetMake(string BMSAH)
{
try
{
string dwbm = "";
string ajbh = "";
string wsbh = "";
string wsmc = "";
if (string.IsNullOrEmpty(BMSAH))
{
BMSAH = Request["id"];
dwbm = Request["dwbm"];
ajbh = Request["ajbh"];
wsbh = Request["wsbh"];
wsmc = Request.Form["wsmc"];
if (string.IsNullOrEmpty(BMSAH))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
string type = Request["type"];
string interfaceType = Request["interfaceType"];
#region 原件导出和pdf导出控制按钮权限
if (interfaceType == "5")
{
if (!base.IsAnRole("caseinfomanage_yjdc"))
{
return(ReturnString.JsonToString(Prompt.error, "没有权限，请先设置权限", null));
}
}
if (interfaceType == "8")
{
if (!base.IsAnRole("caseinfomanage_pdfdc"))
{
return(ReturnString.JsonToString(Prompt.error, "没有权限，请先设置权限", null));
}
}
#endregion
//判断是否为导出
if (type == "btn_derive")
{
type = "1";
}
else
{
type = "0";
}
TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request);
EDRS.Model.TYYW_GG_AJJBXX model = jzajxx.GetModel(BMSAH);
//读取配置文件中的配置
int?isLocalAjxx = ConfigHelper.GetConfigInt("IsLocalAjxx");
if (isLocalAjxx == 1)
{
if (model == null)
{
//本地数据不存在执行添加到本地
model = jzajxx.GetIceByModel(BMSAH, jzajxx.GetAjTypeBm(Request, UserInfo.DWBM, "", UserInfo.GH), GetUserRoleList(UserInfo.DWBM, UserInfo.GH), dwbm, UserInfo.GH);
if (model == null || !jzajxx.Add(model))
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "制作添加本地数据失败", BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取" + ((VersionName)0).ToString() + "失败", null));
}
}
else
{
//本地数据存在执行更新本地数据
model = jzajxx.GetIceByModel(BMSAH, jzajxx.GetAjTypeBm(Request, UserInfo.DWBM, "", UserInfo.GH), GetUserRoleList(UserInfo.DWBM, UserInfo.GH), model.CBDW_BM, UserInfo.GH);
if (model == null || !jzajxx.Update(model))
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "制作修改本地数据失败", BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取" + ((VersionName)0).ToString() + "失败", null));
}
}
}
if (model != null)
{
//0制作，1导出
EDRS.Model.XY_DZJZ_XTPZ xtpz = GetConfigById(EnumConfig.卷宗文件上传地址);
if (xtpz != null)
{
string bmbm = "";
string bmmc = "";
if (UserRole != null && UserRole.Count > 0)
{
bmbm = UserRole[0].BMBM;
bmmc = UserRole[0].BMMC;
}
//string strstring = model.BMSAH + "_" + type + "@" + base.UserInfo.DWBM + "@" + base.UserInfo.MC + "@" + GetConfigById(EnumConfig.卷宗文件上传地址).CONFIGVALUE + "@" + UserInfo.GH + "@" + UserInfo.DWMC + "@" + bmbm + "@" + bmmc;
//strstring = DESEncrypt.Encrypt(strstring);
//string d = DESEncrypt.Decrypt(strstring);
//OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "案件制作成功", model.BMSAH, UserInfo, UserRole, this.Request);
XT_DZJZ_ZZCS zzcsbll = new XT_DZJZ_ZZCS(Request);
string[] zks = new string[] { "BMSAH", "SFDC", "DWBM", "MC", "GH", "DWMC", "BMBM", "BMMC", "LJLX", "DZ1", "DZ2", "AJBH", "WSBH", "WSMC" };
string callBack = string.Empty;
string linkType = string.Empty;
List <EDRS.Model.XT_DZJZ_ZZCS> zzcsList = new List <EDRS.Model.XT_DZJZ_ZZCS>();
EDRS.Model.XT_DZJZ_ZZCS zzcsModel = null;
string guid = Guid.NewGuid().ToString();
foreach (string dr in zks)
{
//制作参数(部门受案号，是否导出，单位编码，用户名称，单位名称，部门编码，部门名称，连接类型，文件上传地址，回调地址)<add key="ZzCsKey" value="BMSAH,SFDC,DWBM,MC,GH,DWMC,BMBM,BMMC,LJLX,DZ1,DZ2"/>
zzcsModel = new EDRS.Model.XT_DZJZ_ZZCS();
zzcsModel.CSKEY = dr;
zzcsModel.FZBS = guid;
zzcsModel.DYSJ = DateTime.Now;
switch (zzcsModel.CSKEY)
{
case "BMSAH":
zzcsModel.CSVALUE = model.BMSAH;
break;
case "SFDC":
zzcsModel.CSVALUE = type;
break;
case "DWBM":
zzcsModel.CSVALUE = base.UserInfo.DWBM;
break;
case "MC":
zzcsModel.CSVALUE = base.UserInfo.MC;
break;
case "GH":
zzcsModel.CSVALUE = UserInfo.GH;
break;
case "DWMC":
zzcsModel.CSVALUE = UserInfo.DWMC;
break;
case "BMBM":
zzcsModel.CSVALUE = bmbm;
break;
case "BMMC":
zzcsModel.CSVALUE = bmmc;
break;
case "LJLX":
object obj = GetConfigById(EnumConfig.连接类型);
if (obj != null)
{
linkType = zzcsModel.CSVALUE = ((EDRS.Model.XY_DZJZ_XTPZ)obj).CONFIGVALUE;
}
else
{
zzcsModel.CSVALUE = "";
}
break;
case "DZ1":
zzcsModel.CSVALUE = xtpz.CONFIGVALUE;
break;
case "DZ2":
object obj2 = GetConfigById(EnumConfig.路由映射地址);
if (obj2 != null && obj2 != DBNull.Value)
{
callBack = zzcsModel.CSVALUE = ((EDRS.Model.XY_DZJZ_XTPZ)obj2).CONFIGVALUE;
}
else
{
zzcsModel.CSVALUE = "";
}
break;
case "AJBH":
zzcsModel.CSVALUE = ajbh;
break;
case "WSBH":
zzcsModel.CSVALUE = wsbh;
break;
case "WSMC":
zzcsModel.CSVALUE = wsmc;
break;
}
zzcsList.Add(zzcsModel);
}
if (zzcsbll.AddList(zzcsList))
{
//string strstring = Request.Url.Authority + "@" + guid;
//TH:2016-05-23
//string strstring = Request.Url.Authority + "@" + guid;
string strstring = xtpz.CONFIGVALUE + "@" + linkType + "@" + callBack + "@" + guid + "@" + interfaceType;
return("{\"parm\":\"" + DESEncrypt.Encrypt(strstring) + "\"}");
}
}
else
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "未配置卷宗服务地址，请先到参数配置中配置", BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未配置卷宗服务地址，请先到参数配置中配置", null));
}
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "制作失败", BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取" + ((VersionName)0).ToString() + "失败", null));
}
catch (Exception ex)
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "制作失败异常" + ex.Message, BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取" + ((VersionName)0).ToString() + "失败,错误：" + ex.Message.Replace("\"", ""), null));
}
}
/// <summary>
/// (测试)添加案件信息
/// </summary>
/// <returns></returns>
private void AddDataTest(int c, System.Web.HttpRequest req)
{
string ajmc = "测试案件名称" + c;
string ajlb = "020911";
string lbmc = "盗窃枪支、弹药案";//020911 //3A1802 冒用他人边境管理区通行证
if (c % 4 == 0)
{
ajlb = "3A1802";
lbmc = "冒用他人边境管理区通行证";
}
string xyr = "张某" + c;
string sfzh = "";
string taryxx = "";
string ajbh = "ABCDE1" + c; //案件编号
string lasj = DateTime.Now.ToString(); //立案时间
string jasj = DateTime.Now.ToString(); //结案时间
string ladw = UserInfo.DWBM; //立卷单位
string ladw_mc = UserInfo.DWMC; //立卷单位名称
string ljr = UserInfo.GH; //立卷人
string ljr_mc = UserInfo.MC; //立卷人名称
string shr = ""; //审核人
string zjs = "10"; //本案共卷
string djj = ""; //第几卷
string djy = "0"; //第几页
string wsbh = "XXXX" + c;
string wsmc = "XXXXX文书名称" + c;
EDRS.BLL.YX_DZJZ_JZJBXX jbxxbll = new YX_DZJZ_JZJBXX(req);
if (!string.IsNullOrEmpty(ajmc) && !string.IsNullOrEmpty(ajlb))//&& !string.IsNullOrEmpty(ajbh)
{
string bmsahName = ajlb + "[" + DateTime.Now.Year + "]" + UserInfo.DWBM;
string num = "00001号";
TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(req);
DataSet ds = jzajxx.GetListByPage(" and bmsah like '" + bmsahName + "%'", "bmsah desc", 1, 1, null);
if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 1)
{
num = ds.Tables[0].Rows[0]["bmsah"].ToString().Replace(bmsahName, "").Replace("号", "");
num = (Convert.ToInt32(num) + 1).ToString().PadLeft(5, '0') + "号";
}
EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX();
//山东省院起诉受[2015]37000000072号
model.BMSAH = bmsahName + num;
model.TYSAH = Guid.NewGuid().ToString().ToUpper().Replace("-", "");
model.SFSC = "N";
model.SFYGXTSJ = "N";
model.CBDW_BM = UserInfo.DWBM;
model.CBDW_MC = UserInfo.DWMC;
model.FQDWBM = Convert.ToDecimal(UserInfo.DWBM.Substring(0, 4));
model.FQL = DateTime.Now.Year.ToString();
model.CJSJ = DateTime.Now;
model.ZHXGSJ = DateTime.Now;
model.SLRQ = (string.IsNullOrEmpty(lasj) ? DateTime.Now : Convert.ToDateTime(lasj));// DateTime.Now;
model.AJMC = ajmc;
model.AJLB_BM = ajlb;
model.AJLB_MC = lbmc;
model.XYR = xyr;
model.SFZH = sfzh;
model.TARYXX = taryxx;
if (!string.IsNullOrEmpty(jasj))
{
model.BJRQ = Convert.ToDateTime(jasj);
}
model.CBDW_BM = ladw;
model.CBDW_MC = ladw_mc;
model.CBR = ljr_mc;
model.CBRGH = ljr;
//2016-6-6 增字段
model.SHR = shr; //审核人
model.SHSJ = DateTime.Now; //审核时间
model.ZJS = Convert.ToDecimal(zjs); //总卷数
model.DJJ = djj; //第几卷
model.ZYS = Convert.ToDecimal(djy); //总页数
if (jzajxx.Add(model))
{
string count = "0";
count = jbxxbll.GetRecordCount("", null).ToString();
count = count.PadLeft(5, '0');
EDRS.Model.YX_DZJZ_JZJBXX jbxxmodel = new EDRS.Model.YX_DZJZ_JZJBXX();
jbxxmodel.JZBH = DateTime.Now.ToString("yyyyMMddHHmmssfff");
jbxxmodel.SFSC = "N";
jbxxmodel.CJSJ = DateTime.Now;
jbxxmodel.ZHXGSJ = DateTime.Now;
jbxxmodel.FQDWBM = 0;
jbxxmodel.FQL = "";
jbxxmodel.DWBM = UserInfo.DWBM;
jbxxmodel.BMSAH = model.BMSAH;
jbxxmodel.TYSAH = UserInfo.DWBM + DateTime.Now.ToString("yyyyMM") + jbxxbll.GetRecordCount("", null) + count;
jbxxmodel.JZMC = ajmc;
jbxxmodel.JZLJ = "";
jbxxmodel.JZSCSJ = DateTime.Now;
jbxxmodel.JZSCRGH = UserInfo.GH;
jbxxmodel.JZSCRXM = UserInfo.MC;
jbxxmodel.JZMS = "";
jbxxmodel.JZXGH = "0";
jbxxmodel.SFKYGX = "";
jbxxmodel.GXYWBMJH = "";
jbxxmodel.MRSFGKPZ = "";
jbxxmodel.Accomplices = taryxx;
jbxxmodel.Ajmb_bm = ajlb;
jbxxmodel.Ajmb_mc = lbmc;
jbxxmodel.Idnumber = sfzh;
jbxxmodel.Isrecord = "0";
jbxxmodel.Suspectname = xyr;
jbxxmodel.WSBH = wsbh;
jbxxmodel.AJBH = ajbh;
jbxxmodel.WSMC = wsmc;
jbxxmodel.ZZZT = "-1";
if (jbxxbll.Add(jbxxmodel))
{
return;
}
else
{
jzajxx.Delete(model.BMSAH);
}
}
return;
}
return;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.TYYW_GG_AJJBXX model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TYYW_GG_AJJBXX(");
strSql.Append("BMSAH,TYSAH,SFSC,SFYGXTSJ,CBDW_BM,CBDW_MC,FQDWBM,FQL,CJSJ,ZHXGSJ,SLRQ,AJMC,AJLB_BM,AJLB_MC,ZCJG_DWDM,ZCJG_DWMC,YSDW_DWDM,YSDW_DWMC,YSWSWH,YSAY_AYDM,YSAY_AYMC,YSQTAY_AYDMS,YSQTAY_AYMCS,CBRGH,CBR,CBBM_BM,CBBM_MC,AJZT,SFSWAJ,SFDBAJ,ZXHD_MC,WCRQ,GDRQ,GDRGH,GDR,AQZY,DQJD,BLKSRQ,BLTS,DQRQ,BJRQ,YJZT,JYYJZT,JYYJHCQXYRGS,LCSLBH,FXDJ,SFGZAJ,FZ,YSYJ_DM,YSYJ_MC,SFJBAJ,ZXHD_DM,DQYJJD,YASCSSJD_DM,YASCSSJD_MC,YSRJDH,XYR,SFZH,TARYXX,SHR,SHSJ,ZJS,DJJ,ZYS)");
strSql.Append(" values (");
strSql.Append(":BMSAH,:TYSAH,:SFSC,:SFYGXTSJ,:CBDW_BM,:CBDW_MC,:FQDWBM,:FQL,:CJSJ,:ZHXGSJ,:SLRQ,:AJMC,:AJLB_BM,:AJLB_MC,:ZCJG_DWDM,:ZCJG_DWMC,:YSDW_DWDM,:YSDW_DWMC,:YSWSWH,:YSAY_AYDM,:YSAY_AYMC,:YSQTAY_AYDMS,:YSQTAY_AYMCS,:CBRGH,:CBR,:CBBM_BM,:CBBM_MC,:AJZT,:SFSWAJ,:SFDBAJ,:ZXHD_MC,:WCRQ,:GDRQ,:GDRGH,:GDR,:AQZY,:DQJD,:BLKSRQ,:BLTS,:DQRQ,:BJRQ,:YJZT,:JYYJZT,:JYYJHCQXYRGS,:LCSLBH,:FXDJ,:SFGZAJ,:FZ,:YSYJ_DM,:YSYJ_MC,:SFJBAJ,:ZXHD_DM,:DQYJJD,:YASCSSJD_DM,:YASCSSJD_MC,:YSRJDH,:XYR,:SFZH,:TARYXX,:SHR,:SHSJ,:ZJS,:DJJ,:ZYS)");
OracleParameter[] parameters =
{
new OracleParameter(":BMSAH", OracleType.VarChar, 100),
new OracleParameter(":TYSAH", OracleType.Char, 17),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":SFYGXTSJ", OracleType.Char, 1),
new OracleParameter(":CBDW_BM", OracleType.VarChar, 50),
new OracleParameter(":CBDW_MC", OracleType.VarChar, 300),
new OracleParameter(":FQDWBM", OracleType.Number, 4),
new OracleParameter(":FQL", OracleType.VarChar, 6),
new OracleParameter(":CJSJ", OracleType.DateTime),
new OracleParameter(":ZHXGSJ", OracleType.DateTime),
new OracleParameter(":SLRQ", OracleType.DateTime),
new OracleParameter(":AJMC", OracleType.VarChar, 300),
new OracleParameter(":AJLB_BM", OracleType.VarChar, 50),
new OracleParameter(":AJLB_MC", OracleType.VarChar, 300),
new OracleParameter(":ZCJG_DWDM", OracleType.Char, 13),
new OracleParameter(":ZCJG_DWMC", OracleType.VarChar, 300),
new OracleParameter(":YSDW_DWDM", OracleType.Char, 13),
new OracleParameter(":YSDW_DWMC", OracleType.VarChar, 300),
new OracleParameter(":YSWSWH", OracleType.VarChar, 300),
new OracleParameter(":YSAY_AYDM", OracleType.Char, 13),
new OracleParameter(":YSAY_AYMC", OracleType.VarChar, 300),
new OracleParameter(":YSQTAY_AYDMS", OracleType.VarChar, 130),
new OracleParameter(":YSQTAY_AYMCS", OracleType.VarChar, 3000),
new OracleParameter(":CBRGH", OracleType.Char, 4),
new OracleParameter(":CBR", OracleType.VarChar, 60),
new OracleParameter(":CBBM_BM", OracleType.Char, 4),
new OracleParameter(":CBBM_MC", OracleType.VarChar, 300),
new OracleParameter(":AJZT", OracleType.Char, 1),
new OracleParameter(":SFSWAJ", OracleType.Char, 1),
new OracleParameter(":SFDBAJ", OracleType.Char, 1),
new OracleParameter(":ZXHD_MC", OracleType.VarChar, 300),
new OracleParameter(":WCRQ", OracleType.DateTime),
new OracleParameter(":GDRQ", OracleType.DateTime),
new OracleParameter(":GDRGH", OracleType.Char, 4),
new OracleParameter(":GDR", OracleType.VarChar, 60),
new OracleParameter(":AQZY", OracleType.VarChar, 4000),
new OracleParameter(":DQJD", OracleType.VarChar, 3000),
new OracleParameter(":BLKSRQ", OracleType.DateTime),
new OracleParameter(":BLTS", OracleType.Number, 4),
new OracleParameter(":DQRQ", OracleType.DateTime),
new OracleParameter(":BJRQ", OracleType.DateTime),
new OracleParameter(":YJZT", OracleType.Char, 1),
new OracleParameter(":JYYJZT", OracleType.Char, 1),
new OracleParameter(":JYYJHCQXYRGS", OracleType.Number, 4),
new OracleParameter(":LCSLBH", OracleType.Char, 2),
new OracleParameter(":FXDJ", OracleType.Char, 1),
new OracleParameter(":SFGZAJ", OracleType.Char, 1),
new OracleParameter(":FZ", OracleType.VarChar, 4000),
new OracleParameter(":YSYJ_DM", OracleType.Char, 13),
new OracleParameter(":YSYJ_MC", OracleType.VarChar, 300),
new OracleParameter(":SFJBAJ", OracleType.Char, 1),
new OracleParameter(":ZXHD_DM", OracleType.Char, 13),
new OracleParameter(":DQYJJD", OracleType.VarChar, 300),
new OracleParameter(":YASCSSJD_DM", OracleType.Char, 13),
new OracleParameter(":YASCSSJD_MC", OracleType.VarChar, 300),
new OracleParameter(":YSRJDH", OracleType.VarChar, 300),
new OracleParameter(":XYR", OracleType.VarChar, 500),
new OracleParameter(":SFZH", OracleType.VarChar, 100),
new OracleParameter(":TARYXX", OracleType.VarChar, 2000),
new OracleParameter(":SHR", OracleType.VarChar, 100),
new OracleParameter(":SHSJ", OracleType.DateTime),
new OracleParameter(":ZJS", OracleType.Number, 18),
new OracleParameter(":DJJ", OracleType.VarChar, 100),
new OracleParameter(":ZYS", OracleType.Number, 18)
};
parameters[0].Value = model.BMSAH ?? "";
parameters[1].Value = model.TYSAH ?? "";
parameters[2].Value = model.SFSC ?? "";
parameters[3].Value = model.SFYGXTSJ ?? "";
parameters[4].Value = model.CBDW_BM ?? "";
parameters[5].Value = model.CBDW_MC ?? "";
parameters[6].Value = model.FQDWBM;
parameters[7].Value = model.FQL ?? "";
parameters[8].Value = model.CJSJ;
parameters[9].Value = model.ZHXGSJ;
parameters[10].Value = model.SLRQ;
parameters[11].Value = model.AJMC ?? "";
parameters[12].Value = model.AJLB_BM ?? "";
parameters[13].Value = model.AJLB_MC ?? "";
parameters[14].Value = model.ZCJG_DWDM ?? "";
parameters[15].Value = model.ZCJG_DWMC ?? "";
parameters[16].Value = model.YSDW_DWDM ?? "";
parameters[17].Value = model.YSDW_DWMC ?? "";
parameters[18].Value = model.YSWSWH ?? "";
parameters[19].Value = model.YSAY_AYDM ?? "";
parameters[20].Value = model.YSAY_AYMC ?? "";
parameters[21].Value = model.YSQTAY_AYDMS ?? "";
parameters[22].Value = model.YSQTAY_AYMCS ?? "";
parameters[23].Value = model.CBRGH ?? "";
parameters[24].Value = model.CBR ?? "";
parameters[25].Value = model.CBBM_BM ?? "";
parameters[26].Value = model.CBBM_MC ?? "";
parameters[27].Value = model.AJZT ?? "";
parameters[28].Value = model.SFSWAJ ?? "";
parameters[29].Value = model.SFDBAJ ?? "";
parameters[30].Value = model.ZXHD_MC ?? "";
parameters[31].Value = model.WCRQ ?? Convert.ToDateTime("1900-01-01");
parameters[32].Value = model.GDRQ ?? Convert.ToDateTime("1900-01-01");
parameters[33].Value = model.GDRGH ?? "";
parameters[34].Value = model.GDR ?? "";
parameters[35].Value = model.AQZY ?? "";
parameters[36].Value = model.DQJD ?? "";
parameters[37].Value = model.BLKSRQ ?? Convert.ToDateTime("1900-01-01");
parameters[38].Value = model.BLTS ?? 0;
parameters[39].Value = model.DQRQ ?? Convert.ToDateTime("1900-01-01");
parameters[40].Value = model.BJRQ ?? Convert.ToDateTime("1900-01-01");
parameters[41].Value = model.YJZT ?? "";
parameters[42].Value = model.JYYJZT ?? "";
parameters[43].Value = model.JYYJHCQXYRGS ?? 0;
parameters[44].Value = model.LCSLBH ?? "";
parameters[45].Value = model.FXDJ ?? "";
parameters[46].Value = model.SFGZAJ ?? "";
parameters[47].Value = model.FZ ?? "";
parameters[48].Value = model.YSYJ_DM ?? "";
parameters[49].Value = model.YSYJ_MC ?? "";
parameters[50].Value = model.SFJBAJ ?? "";
parameters[51].Value = model.ZXHD_DM ?? "";
parameters[52].Value = model.DQYJJD ?? "";
parameters[53].Value = model.YASCSSJD_DM ?? "";
parameters[54].Value = model.YASCSSJD_MC ?? "";
parameters[55].Value = model.YSRJDH ?? "";
parameters[56].Value = model.XYR ?? "";
parameters[57].Value = model.SFZH ?? "";
parameters[58].Value = model.TARYXX ?? "";
parameters[59].Value = model.SHR ?? "";
parameters[60].Value = model.SHSJ ?? DateTime.Now;
parameters[61].Value = model.ZJS;
parameters[62].Value = model.DJJ ?? "";
parameters[63].Value = model.ZYS;
try
{
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.TYYW_GG_AJJBXX model)", "EDRS.OracleDAL.TYYW_GG_AJJBXX", strSql.ToString(), parameters);
}
return(false);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.TYYW_GG_AJJBXX DataRowToModel(DataRow row)
{
EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX();
if (row != null)
{
if (row["BMSAH"] != null)
{
model.BMSAH = row["BMSAH"].ToString();
}
if (row["TYSAH"] != null)
{
model.TYSAH = row["TYSAH"].ToString();
}
if (row["SFSC"] != null)
{
model.SFSC = row["SFSC"].ToString();
}
if (row["SFYGXTSJ"] != null)
{
model.SFYGXTSJ = row["SFYGXTSJ"].ToString();
}
if (row["CBDW_BM"] != null)
{
model.CBDW_BM = row["CBDW_BM"].ToString();
}
if (row["CBDW_MC"] != null)
{
model.CBDW_MC = row["CBDW_MC"].ToString();
}
if (row["FQDWBM"] != null && row["FQDWBM"].ToString() != "")
{
model.FQDWBM = decimal.Parse(row["FQDWBM"].ToString());
}
if (row["FQL"] != null)
{
model.FQL = row["FQL"].ToString();
}
if (row["CJSJ"] != null && row["CJSJ"].ToString() != "")
{
model.CJSJ = DateTime.Parse(row["CJSJ"].ToString());
}
if (row["ZHXGSJ"] != null && row["ZHXGSJ"].ToString() != "")
{
model.ZHXGSJ = DateTime.Parse(row["ZHXGSJ"].ToString());
}
if (row["SLRQ"] != null && row["SLRQ"].ToString() != "")
{
model.SLRQ = DateTime.Parse(row["SLRQ"].ToString());
}
if (row["AJMC"] != null)
{
model.AJMC = row["AJMC"].ToString();
}
if (row["AJLB_BM"] != null)
{
model.AJLB_BM = row["AJLB_BM"].ToString();
}
if (row["AJLB_MC"] != null)
{
model.AJLB_MC = row["AJLB_MC"].ToString();
}
if (row["ZCJG_DWDM"] != null)
{
model.ZCJG_DWDM = row["ZCJG_DWDM"].ToString();
}
if (row["ZCJG_DWMC"] != null)
{
model.ZCJG_DWMC = row["ZCJG_DWMC"].ToString();
}
if (row["YSDW_DWDM"] != null)
{
model.YSDW_DWDM = row["YSDW_DWDM"].ToString();
}
if (row["YSDW_DWMC"] != null)
{
model.YSDW_DWMC = row["YSDW_DWMC"].ToString();
}
if (row["YSWSWH"] != null)
{
model.YSWSWH = row["YSWSWH"].ToString();
}
if (row["YSAY_AYDM"] != null)
{
model.YSAY_AYDM = row["YSAY_AYDM"].ToString();
}
if (row["YSAY_AYMC"] != null)
{
model.YSAY_AYMC = row["YSAY_AYMC"].ToString();
}
if (row["YSQTAY_AYDMS"] != null)
{
model.YSQTAY_AYDMS = row["YSQTAY_AYDMS"].ToString();
}
if (row["YSQTAY_AYMCS"] != null)
{
model.YSQTAY_AYMCS = row["YSQTAY_AYMCS"].ToString();
}
if (row["CBRGH"] != null)
{
model.CBRGH = row["CBRGH"].ToString();
}
if (row["CBR"] != null)
{
model.CBR = row["CBR"].ToString();
}
if (row["CBBM_BM"] != null)
{
model.CBBM_BM = row["CBBM_BM"].ToString();
}
if (row["CBBM_MC"] != null)
{
model.CBBM_MC = row["CBBM_MC"].ToString();
}
if (row["AJZT"] != null)
{
model.AJZT = row["AJZT"].ToString();
}
if (row["SFSWAJ"] != null)
{
model.SFSWAJ = row["SFSWAJ"].ToString();
}
if (row["SFDBAJ"] != null)
{
model.SFDBAJ = row["SFDBAJ"].ToString();
}
if (row["ZXHD_MC"] != null)
{
model.ZXHD_MC = row["ZXHD_MC"].ToString();
}
if (row["WCRQ"] != null && row["WCRQ"].ToString() != "")
{
model.WCRQ = DateTime.Parse(row["WCRQ"].ToString());
}
if (row["GDRQ"] != null && row["GDRQ"].ToString() != "")
{
model.GDRQ = DateTime.Parse(row["GDRQ"].ToString());
}
if (row["GDRGH"] != null)
{
model.GDRGH = row["GDRGH"].ToString();
}
if (row["GDR"] != null)
{
model.GDR = row["GDR"].ToString();
}
if (row["AQZY"] != null)
{
model.AQZY = row["AQZY"].ToString();
}
if (row["DQJD"] != null)
{
model.DQJD = row["DQJD"].ToString();
}
if (row["BLKSRQ"] != null && row["BLKSRQ"].ToString() != "")
{
model.BLKSRQ = DateTime.Parse(row["BLKSRQ"].ToString());
}
if (row["BLTS"] != null && row["BLTS"].ToString() != "")
{
model.BLTS = decimal.Parse(row["BLTS"].ToString());
}
if (row["DQRQ"] != null && row["DQRQ"].ToString() != "")
{
model.DQRQ = DateTime.Parse(row["DQRQ"].ToString());
}
if (row["BJRQ"] != null && row["BJRQ"].ToString() != "")
{
model.BJRQ = DateTime.Parse(row["BJRQ"].ToString());
}
if (row["YJZT"] != null)
{
model.YJZT = row["YJZT"].ToString();
}
if (row["JYYJZT"] != null)
{
model.JYYJZT = row["JYYJZT"].ToString();
}
if (row["JYYJHCQXYRGS"] != null && row["JYYJHCQXYRGS"].ToString() != "")
{
model.JYYJHCQXYRGS = decimal.Parse(row["JYYJHCQXYRGS"].ToString());
}
if (row["LCSLBH"] != null)
{
model.LCSLBH = row["LCSLBH"].ToString();
}
if (row["FXDJ"] != null)
{
model.FXDJ = row["FXDJ"].ToString();
}
if (row["SFGZAJ"] != null)
{
model.SFGZAJ = row["SFGZAJ"].ToString();
}
if (row["FZ"] != null)
{
model.FZ = row["FZ"].ToString();
}
if (row["YSYJ_DM"] != null)
{
model.YSYJ_DM = row["YSYJ_DM"].ToString();
}
if (row["YSYJ_MC"] != null)
{
model.YSYJ_MC = row["YSYJ_MC"].ToString();
}
if (row["SFJBAJ"] != null)
{
model.SFJBAJ = row["SFJBAJ"].ToString();
}
if (row["ZXHD_DM"] != null)
{
model.ZXHD_DM = row["ZXHD_DM"].ToString();
}
if (row["DQYJJD"] != null)
{
model.DQYJJD = row["DQYJJD"].ToString();
}
if (row["YASCSSJD_DM"] != null)
{
model.YASCSSJD_DM = row["YASCSSJD_DM"].ToString();
}
if (row["YASCSSJD_MC"] != null)
{
model.YASCSSJD_MC = row["YASCSSJD_MC"].ToString();
}
if (row["YSRJDH"] != null)
{
model.YSRJDH = row["YSRJDH"].ToString();
}
if (row["XYR"] != null)
{
model.XYR = row["XYR"].ToString();
}
if (row["SFZH"] != null)
{
model.SFZH = row["SFZH"].ToString();
}
if (row["TARYXX"] != null)
{
model.TARYXX = row["TARYXX"].ToString();
}
if (row["SHR"] != null)
{
model.SHR = row["SHR"].ToString();
}
if (row["ZJS"] != null && row["ZJS"].ToString() != "")
{
model.ZJS = decimal.Parse(row["ZJS"].ToString());
}
if (row["DJJ"] != null)
{
model.DJJ = row["DJJ"].ToString();
}
if (row["ZYS"] != null && row["ZYS"].ToString() != "")
{
model.ZYS = decimal.Parse(row["ZYS"].ToString());
}
if (row["AJBH"] != null)
{
model.AJBH = row["AJBH"].ToString();
}
if (row["WSBH"] != null)
{
model.WSBH = row["WSBH"].ToString();
}
if (row["WSMC"] != null)
{
model.WSMC = row["WSMC"].ToString();
}
if (row["ZZZT"] != null)
{
model.ZZZT = row["ZZZT"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.TYYW_GG_AJJBXX model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TYYW_GG_AJJBXX set ");
strSql.Append("TYSAH=:TYSAH,");
strSql.Append("SFSC=:SFSC,");
strSql.Append("SFYGXTSJ=:SFYGXTSJ,");
strSql.Append("CBDW_BM=:CBDW_BM,");
strSql.Append("CBDW_MC=:CBDW_MC,");
strSql.Append("FQDWBM=:FQDWBM,");
strSql.Append("FQL=:FQL,");
strSql.Append("CJSJ=:CJSJ,");
strSql.Append("ZHXGSJ=:ZHXGSJ,");
strSql.Append("SLRQ=:SLRQ,");
strSql.Append("AJMC=:AJMC,");
strSql.Append("AJLB_BM=:AJLB_BM,");
strSql.Append("AJLB_MC=:AJLB_MC,");
strSql.Append("ZCJG_DWDM=:ZCJG_DWDM,");
strSql.Append("ZCJG_DWMC=:ZCJG_DWMC,");
strSql.Append("YSDW_DWDM=:YSDW_DWDM,");
strSql.Append("YSDW_DWMC=:YSDW_DWMC,");
strSql.Append("YSWSWH=:YSWSWH,");
strSql.Append("YSAY_AYDM=:YSAY_AYDM,");
strSql.Append("YSAY_AYMC=:YSAY_AYMC,");
strSql.Append("YSQTAY_AYDMS=:YSQTAY_AYDMS,");
strSql.Append("YSQTAY_AYMCS=:YSQTAY_AYMCS,");
strSql.Append("CBRGH=:CBRGH,");
strSql.Append("CBR=:CBR,");
strSql.Append("CBBM_BM=:CBBM_BM,");
strSql.Append("CBBM_MC=:CBBM_MC,");
strSql.Append("AJZT=:AJZT,");
strSql.Append("SFSWAJ=:SFSWAJ,");
strSql.Append("SFDBAJ=:SFDBAJ,");
strSql.Append("ZXHD_MC=:ZXHD_MC,");
strSql.Append("WCRQ=:WCRQ,");
strSql.Append("GDRQ=:GDRQ,");
strSql.Append("GDRGH=:GDRGH,");
strSql.Append("GDR=:GDR,");
strSql.Append("AQZY=:AQZY,");
strSql.Append("DQJD=:DQJD,");
strSql.Append("BLKSRQ=:BLKSRQ,");
strSql.Append("BLTS=:BLTS,");
strSql.Append("DQRQ=:DQRQ,");
strSql.Append("BJRQ=:BJRQ,");
strSql.Append("YJZT=:YJZT,");
strSql.Append("JYYJZT=:JYYJZT,");
strSql.Append("JYYJHCQXYRGS=:JYYJHCQXYRGS,");
strSql.Append("LCSLBH=:LCSLBH,");
strSql.Append("FXDJ=:FXDJ,");
strSql.Append("SFGZAJ=:SFGZAJ,");
strSql.Append("FZ=:FZ,");
strSql.Append("YSYJ_DM=:YSYJ_DM,");
strSql.Append("YSYJ_MC=:YSYJ_MC,");
strSql.Append("SFJBAJ=:SFJBAJ,");
strSql.Append("ZXHD_DM=:ZXHD_DM,");
strSql.Append("DQYJJD=:DQYJJD,");
strSql.Append("YASCSSJD_DM=:YASCSSJD_DM,");
strSql.Append("YASCSSJD_MC=:YASCSSJD_MC,");
strSql.Append("YSRJDH=:YSRJDH,");
strSql.Append("XYR=:XYR,");
strSql.Append("SFZH=:SFZH,");
strSql.Append("TARYXX=:TARYXX,");
strSql.Append("SHR=:SHR,");
strSql.Append("SHSJ=:SHSJ,");
strSql.Append("ZJS=:ZJS,");
strSql.Append("DJJ=:DJJ,");
strSql.Append("ZYS=:ZYS");
strSql.Append(" where BMSAH=:BMSAH ");
OracleParameter[] parameters =
{
new OracleParameter(":TYSAH", OracleType.Char, 17),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":SFYGXTSJ", OracleType.Char, 1),
new OracleParameter(":CBDW_BM", OracleType.VarChar, 50),
new OracleParameter(":CBDW_MC", OracleType.VarChar, 300),
new OracleParameter(":FQDWBM", OracleType.Number, 4),
new OracleParameter(":FQL", OracleType.VarChar, 6),
new OracleParameter(":CJSJ", OracleType.DateTime),
new OracleParameter(":ZHXGSJ", OracleType.DateTime),
new OracleParameter(":SLRQ", OracleType.DateTime),
new OracleParameter(":AJMC", OracleType.VarChar, 300),
new OracleParameter(":AJLB_BM", OracleType.VarChar, 50),
new OracleParameter(":AJLB_MC", OracleType.VarChar, 300),
new OracleParameter(":ZCJG_DWDM", OracleType.Char, 13),
new OracleParameter(":ZCJG_DWMC", OracleType.VarChar, 300),
new OracleParameter(":YSDW_DWDM", OracleType.Char, 13),
new OracleParameter(":YSDW_DWMC", OracleType.VarChar, 300),
new OracleParameter(":YSWSWH", OracleType.VarChar, 300),
new OracleParameter(":YSAY_AYDM", OracleType.Char, 13),
new OracleParameter(":YSAY_AYMC", OracleType.VarChar, 300),
new OracleParameter(":YSQTAY_AYDMS", OracleType.VarChar, 130),
new OracleParameter(":YSQTAY_AYMCS", OracleType.VarChar, 3000),
new OracleParameter(":CBRGH", OracleType.Char, 4),
new OracleParameter(":CBR", OracleType.VarChar, 60),
new OracleParameter(":CBBM_BM", OracleType.Char, 4),
new OracleParameter(":CBBM_MC", OracleType.VarChar, 300),
new OracleParameter(":AJZT", OracleType.Char, 1),
new OracleParameter(":SFSWAJ", OracleType.Char, 1),
new OracleParameter(":SFDBAJ", OracleType.Char, 1),
new OracleParameter(":ZXHD_MC", OracleType.VarChar, 300),
new OracleParameter(":WCRQ", OracleType.DateTime),
new OracleParameter(":GDRQ", OracleType.DateTime),
new OracleParameter(":GDRGH", OracleType.Char, 4),
new OracleParameter(":GDR", OracleType.VarChar, 60),
new OracleParameter(":AQZY", OracleType.VarChar, 4000),
new OracleParameter(":DQJD", OracleType.VarChar, 3000),
new OracleParameter(":BLKSRQ", OracleType.DateTime),
new OracleParameter(":BLTS", OracleType.Number, 4),
new OracleParameter(":DQRQ", OracleType.DateTime),
new OracleParameter(":BJRQ", OracleType.DateTime),
new OracleParameter(":YJZT", OracleType.Char, 1),
new OracleParameter(":JYYJZT", OracleType.Char, 1),
new OracleParameter(":JYYJHCQXYRGS", OracleType.Number, 4),
new OracleParameter(":LCSLBH", OracleType.Char, 2),
new OracleParameter(":FXDJ", OracleType.Char, 1),
new OracleParameter(":SFGZAJ", OracleType.Char, 1),
new OracleParameter(":FZ", OracleType.VarChar, 4000),
new OracleParameter(":YSYJ_DM", OracleType.Char, 13),
new OracleParameter(":YSYJ_MC", OracleType.VarChar, 300),
new OracleParameter(":SFJBAJ", OracleType.Char, 1),
new OracleParameter(":ZXHD_DM", OracleType.Char, 13),
new OracleParameter(":DQYJJD", OracleType.VarChar, 300),
new OracleParameter(":YASCSSJD_DM", OracleType.Char, 13),
new OracleParameter(":YASCSSJD_MC", OracleType.VarChar, 300),
new OracleParameter(":YSRJDH", OracleType.VarChar, 300),
new OracleParameter(":BMSAH", OracleType.VarChar, 100),
new OracleParameter(":XYR", OracleType.VarChar, 500),
new OracleParameter(":SFZH", OracleType.VarChar, 100),
new OracleParameter(":TARYXX", OracleType.VarChar, 2000),
new OracleParameter(":SHR", OracleType.VarChar, 100),
new OracleParameter(":SHSJ", OracleType.DateTime),
new OracleParameter(":ZJS", OracleType.Number, 18),
new OracleParameter(":DJJ", OracleType.VarChar, 100),
new OracleParameter(":ZYS", OracleType.Number, 18)
};
parameters[0].Value = model.TYSAH ?? "";
parameters[1].Value = model.SFSC ?? "";
parameters[2].Value = model.SFYGXTSJ ?? "";
parameters[3].Value = model.CBDW_BM ?? "";
parameters[4].Value = model.CBDW_MC ?? "";
parameters[5].Value = model.FQDWBM;
parameters[6].Value = model.FQL ?? "";
parameters[7].Value = model.CJSJ;
parameters[8].Value = model.ZHXGSJ;
parameters[9].Value = model.SLRQ;
parameters[10].Value = model.AJMC ?? "";
parameters[11].Value = model.AJLB_BM ?? "";
parameters[12].Value = model.AJLB_MC ?? "";
parameters[13].Value = model.ZCJG_DWDM ?? "";
parameters[14].Value = model.ZCJG_DWMC ?? "";
parameters[15].Value = model.YSDW_DWDM ?? "";
parameters[16].Value = model.YSDW_DWMC ?? "";
parameters[17].Value = model.YSWSWH ?? "";
parameters[18].Value = model.YSAY_AYDM ?? "";
parameters[19].Value = model.YSAY_AYMC ?? "";
parameters[20].Value = model.YSQTAY_AYDMS ?? "";
parameters[21].Value = model.YSQTAY_AYMCS ?? "";
parameters[22].Value = model.CBRGH ?? "";
parameters[23].Value = model.CBR ?? "";
parameters[24].Value = model.CBBM_BM ?? "";
parameters[25].Value = model.CBBM_MC ?? "";
parameters[26].Value = model.AJZT ?? "";
parameters[27].Value = model.SFSWAJ ?? "";
parameters[28].Value = model.SFDBAJ ?? "";
parameters[29].Value = model.ZXHD_MC ?? "";
parameters[30].Value = model.WCRQ ?? Convert.ToDateTime("1900-01-01");
parameters[31].Value = model.GDRQ ?? Convert.ToDateTime("1900-01-01");
parameters[32].Value = model.GDRGH ?? "";
parameters[33].Value = model.GDR ?? "";
parameters[34].Value = model.AQZY ?? "";
parameters[35].Value = model.DQJD ?? "";
parameters[36].Value = model.BLKSRQ ?? Convert.ToDateTime("1900-01-01");
parameters[37].Value = model.BLTS ?? 0;
parameters[38].Value = model.DQRQ ?? Convert.ToDateTime("1900-01-01");
parameters[39].Value = model.BJRQ ?? Convert.ToDateTime("1900-01-01");
parameters[40].Value = model.YJZT ?? "";
parameters[41].Value = model.JYYJZT ?? "";
parameters[42].Value = model.JYYJHCQXYRGS ?? 0;
parameters[43].Value = model.LCSLBH ?? "";
parameters[44].Value = model.FXDJ ?? "";
parameters[45].Value = model.SFGZAJ ?? "";
parameters[46].Value = model.FZ ?? "";
parameters[47].Value = model.YSYJ_DM ?? "";
parameters[48].Value = model.YSYJ_MC ?? "";
parameters[49].Value = model.SFJBAJ ?? "";
parameters[50].Value = model.ZXHD_DM ?? "";
parameters[51].Value = model.DQYJJD ?? "";
parameters[52].Value = model.YASCSSJD_DM ?? "";
parameters[53].Value = model.YASCSSJD_MC ?? "";
parameters[54].Value = model.YSRJDH ?? "";
parameters[55].Value = model.BMSAH;
parameters[56].Value = model.XYR ?? "";
parameters[57].Value = model.SFZH ?? "";
parameters[58].Value = model.TARYXX ?? "";
parameters[59].Value = model.SHR ?? "";
parameters[60].Value = model.SHSJ ?? DateTime.Now;
parameters[61].Value = model.ZJS;
parameters[62].Value = model.DJJ ?? "";
parameters[63].Value = model.ZYS;
try
{
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.TYYW_GG_AJJBXX model)", "EDRS.OracleDAL.TYYW_GG_AJJBXX", strSql.ToString(), parameters);
}
return(false);
}
/// <summary>
/// 添加配置数据
/// </summary>
/// <returns></returns>
private string AddData()
{
string type = Request.Form.Get("txt_type"); //打印类型
string ywlx = Request.Form.Get("txt_ywlx"); //业务名称
string ywbm = Request.Form.Get("txt_ywlx_val"); //业务名称
string nf = Request.Form.Get("txt_nf"); //年份
string z = Request.Form.Get("txt_z"); //字
string h = Request.Form.Get("txt_h"); //号
string bmsah = "(" + nf + ")" + UserDwbm.DWJC + z + "字第" + h + "号"; //(2016)深南法少刑初字第2号
string ajmc = Request.Form.Get("txt_fbt"); //案由
string lbmc = z; //类别名称
string ajlb = (string.IsNullOrEmpty(Request.Form.Get("txt_z_val")) ? "" : Request.Form.Get("txt_z_val")); //案件类别编码
string lasj = Request.Form.Get("txt_sasj"); //收案日期
string jasj = Request.Form.Get("txt_jasj"); //结案时间
string ladw = UserDwbm.DWBM; //Request.Form.Get("txt_ladw_val"); //立卷单位
string ladw_mc = UserDwbm.DWMC; // Request.Form.Get("txt_ladw"); //立卷单位名称
string ljr = ""; //Request.Form.Get("txt_lar_val"); //立卷人
string ljr_mc = string.IsNullOrEmpty(Request.Form.Get("txt_cbr")) ? "" : Request.Form.Get("txt_cbr"); //承办人
string shr = string.IsNullOrEmpty(Request.Form.Get("txt_shr")) ? "" : Request.Form.Get("txt_shr"); //审核人
string zjs = (string.IsNullOrEmpty(Request.Form.Get("txt_bjgjc")) ? "0" : Request.Form.Get("txt_bjgjc")); //本案共卷
string djj = string.IsNullOrEmpty(Request.Form.Get("txt_sdjc")) ? "0" : Request.Form.Get("txt_sdjc"); //第几卷
string djy = (string.IsNullOrEmpty(Request.Form.Get("txt_ngjy")) ? "0" : Request.Form.Get("txt_ngjy")); //第几页
string xyr = ""; //嫌疑人
string sfzh = ""; //身份证号
string taryxx = ""; //同人信息
string ajbh = ""; // Request.Form.Get("txt_ajbh"); //案件编号
string wsbh = ""; //Request.Form.Get("wsbh_hidd");
string wsmc = ""; //Request.Form.Get("txt_wsbh");
//判断案件名称
//if (string.IsNullOrEmpty(ajmc))
//{
// return ReturnString.JsonToString(Prompt.error, "必须填写案由", null);
//}
//判断年份
if (string.IsNullOrEmpty(nf))
{
return(ReturnString.JsonToString(Prompt.error, "请选择年份", null));
}
//判断字
if (string.IsNullOrEmpty(z))
{
return(ReturnString.JsonToString(Prompt.error, "请选择字", null));
}
//判断号
if (string.IsNullOrEmpty(h))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写号", null));
}
//案号名称
if (string.IsNullOrEmpty(bmsah))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写案号名称", null));
}
//案由
if (string.IsNullOrEmpty(ajmc))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写案由", null));
}
//判断案件类别
if (string.IsNullOrEmpty(ajlb))
{
return(ReturnString.JsonToString(Prompt.error, "必须填写案件类别", null));
}
// EDRS.BLL.YX_DZJZ_JZJBXX jbxxbll = new YX_DZJZ_JZJBXX(Request);
if (!string.IsNullOrEmpty(ajmc) && !string.IsNullOrEmpty(ajlb))//&& !string.IsNullOrEmpty(ajbh)
{
EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX();
EDRS.Model.YX_DZJZ_JZJBXX jbxxmodel = new EDRS.Model.YX_DZJZ_JZJBXX();
EDRS.Model.TYYW_GG_AJJBXXKZ modelkz = new EDRS.Model.TYYW_GG_AJJBXXKZ();
//EDRS.BLL.XT_DM_AJLBBM ajlbbmBll = new XT_DM_AJLBBM(Request);
//EDRS.Model.XT_DM_AJLBBM ajlbModel = ajlbbmBll.GetModel(ajlb);
//if (ajlbModel != null)
// lbjc = ajlbModel.AJSLJC;
//if (string.IsNullOrEmpty(lbjc))
// lbjc = lbmc;
#region 公共案件基本信息
//string bmsahName = ajlb + "[" + DateTime.Now.Year + "]" + UserInfo.DWBM;
//string num = "00001号";
//TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request);
//DataSet ds = jzajxx.GetListByPage(" and bmsah like '" + bmsahName + "%'", "bmsah desc", 1, 1, null);
//if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 1)
//{
// num = ds.Tables[0].Rows[0]["bmsah"].ToString().Replace(bmsahName, "").Replace("号", "");
// num = (Convert.ToInt32(num) + 1).ToString().PadLeft(5, '0') + "号";
//}
//山东省院起诉受[2015]37000000072号
//model.BMSAH = bmsahName + num;
model.BMSAH = bmsah;
model.TYSAH = Guid.NewGuid().ToString().ToUpper().Replace("-", "");
model.SFSC = "N";
model.SFYGXTSJ = "N";
model.CBDW_BM = UserInfo.DWBM;
model.CBDW_MC = UserInfo.DWMC;
model.FQDWBM = Convert.ToDecimal(UserInfo.DWBM.Substring(0, 4));
model.FQL = DateTime.Now.Year.ToString();
model.CJSJ = DateTime.Now;
model.ZHXGSJ = DateTime.Now;
model.SLRQ = (string.IsNullOrEmpty(lasj) ? DateTime.Now : Convert.ToDateTime(lasj));// DateTime.Now;
model.AJMC = ajmc;
model.AJLB_BM = ajlb;
model.AJLB_MC = lbmc;
model.XYR = xyr;
model.SFZH = sfzh;
model.TARYXX = taryxx;
if (!string.IsNullOrEmpty(jasj))
{
model.BJRQ = Convert.ToDateTime(jasj);
}
model.CBDW_BM = ladw;
model.CBDW_MC = ladw_mc;
model.CBR = ljr_mc;
model.CBRGH = ljr;
//2016-6-6 增字段
model.SHR = shr; //审核人
model.SHSJ = DateTime.Now; //审核时间
model.ZJS = Convert.ToDecimal(zjs); //总卷数
model.DJJ = djj; //第几卷
model.ZYS = Convert.ToDecimal(djy); //总页数
#endregion
//if (jzajxx.Add(model))
//{
#region 卷宗基本信息
//string count = "0";
//count = jbxxbll.GetRecordCount("", null).ToString();
//count = count.PadLeft(5, '0');
jbxxmodel.JZBH = DateTime.Now.ToString("yyyyMMddHHmmssfff");
jbxxmodel.SFSC = "N";
jbxxmodel.CJSJ = DateTime.Now;
jbxxmodel.ZHXGSJ = DateTime.Now;
jbxxmodel.FQDWBM = 0;
jbxxmodel.FQL = "";
jbxxmodel.DWBM = UserInfo.DWBM;
jbxxmodel.BMSAH = model.BMSAH;
jbxxmodel.TYSAH = model.TYSAH; //UserInfo.DWBM + DateTime.Now.ToString("yyyyMM") + jbxxbll.GetRecordCount("", null) + count;
jbxxmodel.JZMC = ajmc;
jbxxmodel.JZLJ = "";
jbxxmodel.JZSCSJ = DateTime.Now;
jbxxmodel.JZSCRGH = UserInfo.GH;
jbxxmodel.JZSCRXM = UserInfo.MC;
jbxxmodel.JZMS = "";
jbxxmodel.JZXGH = "0";
jbxxmodel.SFKYGX = "";
jbxxmodel.GXYWBMJH = "";
jbxxmodel.MRSFGKPZ = "";
jbxxmodel.Accomplices = taryxx;
jbxxmodel.Ajmb_bm = ajlb;
jbxxmodel.Ajmb_mc = lbmc;
jbxxmodel.Idnumber = sfzh;
jbxxmodel.Isrecord = "0";
jbxxmodel.Suspectname = xyr;
jbxxmodel.WSBH = wsbh;
jbxxmodel.AJBH = ajbh;
jbxxmodel.WSMC = wsmc;
//jbxxmodel.ZZZT = "-1";
jbxxmodel.LAZZZT = "-1";
jbxxmodel.SMAJLA = "1";
jbxxmodel.SMAJCD = "";
#endregion
#region 案件基本信息扩展
//modelkz.AJKZXH = ;
modelkz.AHMC = bmsah;
modelkz.AY = Request.Form.Get("txt_fbt");
modelkz.SAJG = Request.Form.Get("txt_ajmc");
modelkz.YG = Request.Form.Get("txt_ajbh");
modelkz.BG = Request.Form.Get("txt_fzxyr");
modelkz.YYR = string.IsNullOrEmpty(Request.Form.Get("txt_yyr")) ? "" : Request.Form.Get("txt_yyr");
modelkz.SQZXR = string.IsNullOrEmpty(Request.Form.Get("txt_sqzxr")) ? "" : Request.Form.Get("txt_sqzxr");
modelkz.BZXR = string.IsNullOrEmpty(Request.Form.Get("txt_bzxr")) ? "" : Request.Form.Get("txt_bzxr");
modelkz.SARQ = Convert.ToDateTime(Request.Form.Get("txt_sasj"));
modelkz.JARQ = Convert.ToDateTime(Request.Form.Get("txt_jasj"));
modelkz.CJJG = string.IsNullOrEmpty(Request.Form.Get("txt_cjjg")) ? "" : Request.Form.Get("txt_cjjg");
modelkz.ZXBD = string.IsNullOrEmpty(Request.Form.Get("txt_zxby")) ? "" : Request.Form.Get("txt_zxby");
modelkz.SLJG = string.IsNullOrEmpty(Request.Form.Get("txt_shjg")) ? "" : Request.Form.Get("txt_shjg");
modelkz.ZXJG = string.IsNullOrEmpty(Request.Form.Get("txt_zxjg")) ? "" : Request.Form.Get("txt_zxjg");
modelkz.JAFS = string.IsNullOrEmpty(Request.Form.Get("txt_jafs")) ? "" : Request.Form.Get("txt_jafs");
modelkz.GLDAXLH = string.IsNullOrEmpty(Request.Form.Get("txt_gldaxlh")) ? "" : Request.Form.Get("txt_gldaxlh");
modelkz.HYTCY = string.IsNullOrEmpty(Request.Form.Get("txt_hytcy")) ? "" : Request.Form.Get("txt_hytcy");
modelkz.CBR = string.IsNullOrEmpty(Request.Form.Get("txt_cbr")) ? "" : Request.Form.Get("txt_cbr");
modelkz.SJY = string.IsNullOrEmpty(Request.Form.Get("txt_sjy")) ? "" : Request.Form.Get("txt_sjy");
modelkz.ZCS = string.IsNullOrEmpty(Request.Form.Get("txt_bjgjc")) ? 0 : Convert.ToDecimal(Request.Form.Get("txt_bjgjc"));
modelkz.DJC = string.IsNullOrEmpty(Request.Form.Get("txt_sdjc")) ? 0 : Convert.ToDecimal(Request.Form.Get("txt_sdjc"));
modelkz.YS = string.IsNullOrEmpty(Request.Form.Get("txt_ngjy")) ? 0 : Convert.ToDecimal(Request.Form.Get("txt_ngjy"));
modelkz.GDRQ = Convert.ToDateTime(Request.Form.Get("txt_gdrq"));
modelkz.YWT = string.IsNullOrEmpty(Request.Form.Get("txt_ywt")) ? "" : Request.Form.Get("txt_ywt");
modelkz.BGQX = string.IsNullOrEmpty(Request.Form.Get("txt_bgqx")) ? "" : Request.Form.Get("txt_bgqx");
modelkz.AJLBBM = string.IsNullOrEmpty(Request.Form.Get("txt_z_val")) ? "" : Request.Form.Get("txt_z_val");
modelkz.AJLBMC = string.IsNullOrEmpty(Request.Form.Get("txt_z")) ? "" : Request.Form.Get("txt_z");
modelkz.H = Convert.ToDecimal(Request.Form.Get("txt_h"));
modelkz.NF = string.IsNullOrEmpty(Request.Form.Get("txt_nf")) ? "" : Request.Form.Get("txt_nf");
modelkz.YWLBBM = string.IsNullOrEmpty(ywbm) ? "" : ywbm;
modelkz.YWLBMC = string.IsNullOrEmpty(ywlx) ? "" : ywlx;
modelkz.DWBM = UserInfo.DWBM;
modelkz.DWMC = UserInfo.DWMC;
modelkz.DWJC = UserDwbm.DWJC;
modelkz.QAH = "";
modelkz.MLH = "G" + ywbm + "." + modelkz.AJLBBM;
modelkz.JH = "";
modelkz.CZRGH = UserInfo.GH;
modelkz.CZRMC = UserInfo.MC;
modelkz.CZSJ = DateTime.Now;
#endregion
#region 操作制作参数
EDRS.BLL.XY_DZJZ_XTPZ xtpzbll = new EDRS.BLL.XY_DZJZ_XTPZ(Request);
EDRS.Model.XY_DZJZ_XTPZ xtpz = xtpzbll.GetConfigById(EnumConfig.卷宗文件上传地址);
if (xtpz == null)
{
return(ReturnString.JsonToString(Prompt.error, "请先配置卷宗文件上传地址", null));
}
string linkType = string.Empty; //链接类型
string callBack = string.Empty; //路由链接模式地址
XT_DZJZ_ZZCS zzcsbll = new XT_DZJZ_ZZCS(Request);
string bmbm = "";
string bmmc = "";
if (UserRole != null && UserRole.Count > 0)
{
bmbm = UserRole[0].BMBM;
bmmc = UserRole[0].BMMC;
}
string strstring = string.Empty;
string[] zks = new string[] { "BMSAH", "SFDC", "DWBM", "MC", "GH", "DWMC", "BMBM", "BMMC", "LJLX", "DZ1", "DZ2", "AJBH", "WSBH", "WSMC" };
List <EDRS.Model.XT_DZJZ_ZZCS> zzcsList = new List <EDRS.Model.XT_DZJZ_ZZCS>();
EDRS.Model.XT_DZJZ_ZZCS zzcsModel = null;
string guid = Guid.NewGuid().ToString();
foreach (string dr in zks)
{
//制作参数(部门受案号，是否导出，单位编码，用户名称，单位名称，部门编码，部门名称，连接类型，文件上传地址，回调地址)<add key="ZzCsKey" value="BMSAH,SFDC,DWBM,MC,GH,DWMC,BMBM,BMMC,LJLX,DZ1,DZ2"/>
zzcsModel = new EDRS.Model.XT_DZJZ_ZZCS();
zzcsModel.CSKEY = dr;
zzcsModel.FZBS = guid;
zzcsModel.DYSJ = DateTime.Now;
switch (zzcsModel.CSKEY)
{
case "BMSAH":
zzcsModel.CSVALUE = model.BMSAH;
break;
case "SFDC":
zzcsModel.CSVALUE = type;
break;
case "DWBM":
zzcsModel.CSVALUE = base.UserInfo.DWBM;
break;
case "MC":
zzcsModel.CSVALUE = base.UserInfo.MC;
break;
case "GH":
zzcsModel.CSVALUE = UserInfo.GH;
break;
case "DWMC":
zzcsModel.CSVALUE = UserInfo.DWMC;
break;
case "BMBM":
zzcsModel.CSVALUE = bmbm;
break;
case "BMMC":
zzcsModel.CSVALUE = bmmc;
break;
case "LJLX":
object obj3 = xtpzbll.GetConfigById(EnumConfig.连接类型);
if (obj3 != null)
{
linkType = zzcsModel.CSVALUE = ((EDRS.Model.XY_DZJZ_XTPZ)obj3).CONFIGVALUE;
}
else
{
zzcsModel.CSVALUE = "";
}
break;
case "DZ1":
zzcsModel.CSVALUE = xtpz.CONFIGVALUE;
break;
case "DZ2":
object obj4 = xtpzbll.GetConfigById(EnumConfig.路由映射地址);
if (obj4 != null && obj4 != DBNull.Value)
{
callBack = zzcsModel.CSVALUE = ((EDRS.Model.XY_DZJZ_XTPZ)obj4).CONFIGVALUE;
}
else
{
zzcsModel.CSVALUE = "";
}
break;
case "AJBH":
zzcsModel.CSVALUE = ajbh;
break;
case "WSBH":
zzcsModel.CSVALUE = wsbh;
break;
case "WSMC":
zzcsModel.CSVALUE = wsmc;
break;
default:
zzcsModel.CSVALUE = "";
break;
}
zzcsList.Add(zzcsModel);
}
if (zzcsbll.AddList(zzcsList))
{
strstring = xtpz.CONFIGVALUE + "@" + linkType + "@" + callBack + "@" + guid + "@" + type;
}
#endregion
EDRS.BLL.TYYW_GG_AJJBXX bll = new TYYW_GG_AJJBXX(Request);
//判断存在调用修改
if (bll.GetRecordCount(" and BMSAH=:BMSAH", new object[] { bmsah }) > 0)
{
if (bll.UpdateList(model, modelkz, jbxxmodel))
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "成功", model.BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, DESEncrypt.Encrypt(strstring), null));
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "保存数据失败", model.BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存数据失败", null));
}
if (bll.AddList(model, modelkz, jbxxmodel))
{
if (xtpz != null)
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "成功", model.BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, DESEncrypt.Encrypt(strstring), null));
}
return(ReturnString.JsonToString(Prompt.win, "未设置服务链接地址", null));
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "添加" + ((VersionName)0).ToString() + "失败", model.BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "添加" + ((VersionName)0).ToString() + "失败", null));
}
return(ReturnString.JsonToString(Prompt.error, "请将" + ((VersionName)0).ToString() + "信息填写完整", null));
}
/// <summary>
/// 保存分配案件文件
/// </summary>
/// <returns></returns>
private string AddData()
{
string json = Request.Form["json"];
string yjxh = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); //"山东省院捕受[2015]37000000054号";
string rybm = Request.Form["lszh_hidd"];
string[] rybms = rybm.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (rybms.Length != 2)
{
return(ReturnString.JsonToString(Prompt.error, "请选择阅卷人！", null));
}
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");
Random random = new Random();
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
model.GH = rybms[0];
model.BMSAH = ajmodel.BMSAH;
model.YJXH = yjxh;
model.MC = Request.Form["txt_lsxm"];
model.AJMC = ajmodel.AJMC;
model.AJLBBM = ajmodel.AJLB_BM;
model.AJLBMC = ajmodel.AJLB_MC;
model.YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]);
model.YJJSSJ = Convert.ToDateTime(Request.Form["txt_yjjssj"]);
model.YJZH = random.Next(100000, 999999).ToString();
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 = "";//Request.Form["yjsqdh"];
model.JZZTXS = "";
model.DWBM = rybms[1];
EDRS.BLL.YX_DZJZ_LSAJBD bllBD = new EDRS.BLL.YX_DZJZ_LSAJBD(Request);
List <EDRS.Model.YX_DZJZ_LSAJBD> listModel = bllBD.GetModelList(" and YJXH=:YJXH", new object[] { Request.Form["yjxh"] });
if (listModel == null || listModel.Count == 0)
{
if (!bllBD.Add(model))
{
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
}
else
{
yjxh = listModel[0].YJXH;
listModel[0].BMSAH = ajmodel.BMSAH;
listModel[0].GH = rybms[0];
listModel[0].DWBM = rybms[1];
listModel[0].MC = Request.Form["txt_lsxm"];
listModel[0].AJMC = ajmodel.AJMC;
listModel[0].AJLBBM = ajmodel.AJLB_BM;
listModel[0].AJLBMC = ajmodel.AJLB_MC;
listModel[0].YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]);
listModel[0].YJJSSJ = Convert.ToDateTime(Request.Form["txt_yjjssj"]);
if (!bllBD.Update(listModel[0]))
{
return(ReturnString.JsonToString(Prompt.error, "修改分配失败！", null));
}
}
List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList = JsonHelper.JsonToList <EDRS.Model.YX_DZJZ_LSAJWJFP>(json);
if (modelList != null && modelList.Count > 0)
{
EDRS.BLL.YX_DZJZ_LSAJWJFP bll = new EDRS.BLL.YX_DZJZ_LSAJWJFP(Request);
if (bll.AddList(modelList, model, yjxh))
{
return(ReturnString.JsonToString(Prompt.win, "分配成功！", null));
}
}
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
/// <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));
}
