/// <summary>
/// 根据部门受案号获取封面打印信息
/// </summary>
/// <returns></returns>
private string GetModelByBmsah(string bmsah)
{
EDRS.BLL.TYYW_GG_AJJBXXKZ bll = new TYYW_GG_AJJBXXKZ(Request);
EDRS.Model.TYYW_GG_AJJBXXKZ model = bll.GetModel(bmsah);
if (model != null)
{
return(JsonHelper.JsonString(model));
}
return(ReturnString.JsonToString(Prompt.win, bmsah, null));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.TYYW_GG_AJJBXXKZ GetModel(string AJKZXH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AJKZXH,DWBM,DWMC,DWJC,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,AJLBMC,H,NF,YWLBBM,YWLBMC,QAH,MLH,JH from TYYW_GG_AJJBXXKZ ");
strSql.Append(" where AHMC=:AHMC ");
OracleParameter[] parameters =
{
new OracleParameter(":AHMC", OracleType.VarChar, 200)
};
parameters[0].Value = AJKZXH;
EDRS.Model.TYYW_GG_AJJBXXKZ model = new EDRS.Model.TYYW_GG_AJJBXXKZ();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.TYYW_GG_AJJBXXKZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TYYW_GG_AJJBXXKZ(");
strSql.Append("AJKZXH,DWBM,DWMC,DWJC,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,AJLBMC,H,NF,YWLBBM,YWLBMC,QAH,MLH,JH)");
strSql.Append(" values (");
strSql.Append(":AJKZXH,:DWBM,:DWMC,:DWJC,: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,:AJLBMC,:H,:NF,:YWLBBM,:YWLBMC,:QAH,:MLH,:JH)");
OracleParameter[] parameters =
{
new OracleParameter(":AJKZXH", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":DWMC", OracleType.VarChar, 500),
new OracleParameter(":DWJC", OracleType.VarChar, 200),
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, 18),
new OracleParameter(":DJC", OracleType.Number, 18),
new OracleParameter(":YS", OracleType.Number, 18),
new OracleParameter(":GDRQ", OracleType.DateTime),
new OracleParameter(":YWT", OracleType.VarChar, 200),
new OracleParameter(":BGQX", OracleType.VarChar, 20),
new OracleParameter(":AJLBBM", OracleType.VarChar, 50),
new OracleParameter(":AJLBMC", OracleType.VarChar, 200),
new OracleParameter(":H", OracleType.Number, 18),
new OracleParameter(":NF", OracleType.VarChar, 10),
new OracleParameter(":YWLBBM", OracleType.VarChar, 50),
new OracleParameter(":YWLBMC", OracleType.VarChar, 50),
new OracleParameter(":QAH", OracleType.VarChar, 20),
new OracleParameter(":MLH", OracleType.VarChar, 20),
new OracleParameter(":JH", OracleType.VarChar, 20)
};
parameters[0].Value = model.AJKZXH;
parameters[1].Value = model.DWBM;
parameters[2].Value = model.DWMC;
parameters[3].Value = model.DWJC;
parameters[4].Value = model.AHMC;
parameters[5].Value = model.AY;
parameters[6].Value = model.SAJG;
parameters[7].Value = model.YG;
parameters[8].Value = model.BG;
parameters[9].Value = model.YYR;
parameters[10].Value = model.SQZXR;
parameters[11].Value = model.BZXR;
parameters[12].Value = model.SARQ;
parameters[13].Value = model.JARQ;
parameters[14].Value = model.CJJG;
parameters[15].Value = model.ZXBD;
parameters[16].Value = model.SLJG;
parameters[17].Value = model.ZXJG;
parameters[18].Value = model.JAFS;
parameters[19].Value = model.GLDAXLH;
parameters[20].Value = model.HYTCY;
parameters[21].Value = model.CBR;
parameters[22].Value = model.SJY;
parameters[23].Value = model.ZCS;
parameters[24].Value = model.DJC;
parameters[25].Value = model.YS;
parameters[26].Value = model.GDRQ;
parameters[27].Value = model.YWT;
parameters[28].Value = model.BGQX;
parameters[29].Value = model.AJLBBM;
parameters[30].Value = model.AJLBMC;
parameters[31].Value = model.H;
parameters[32].Value = model.NF;
parameters[33].Value = model.YWLBBM;
parameters[34].Value = model.YWLBMC;
parameters[35].Value = model.QAH;
parameters[36].Value = model.MLH;
parameters[37].Value = model.JH;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.TYYW_GG_AJJBXXKZ DataRowToModel(DataRow row)
{
EDRS.Model.TYYW_GG_AJJBXXKZ model = new EDRS.Model.TYYW_GG_AJJBXXKZ();
if (row != null)
{
if (row["AJKZXH"] != null)
{
model.AJKZXH = row["AJKZXH"].ToString();
}
if (row["DWBM"] != null)
{
model.DWBM = row["DWBM"].ToString();
}
if (row["DWMC"] != null)
{
model.DWMC = row["DWMC"].ToString();
}
if (row["DWJC"] != null)
{
model.DWJC = row["DWJC"].ToString();
}
if (row["AHMC"] != null)
{
model.AHMC = row["AHMC"].ToString();
}
if (row["AY"] != null)
{
model.AY = row["AY"].ToString();
}
if (row["SAJG"] != null)
{
model.SAJG = row["SAJG"].ToString();
}
if (row["YG"] != null)
{
model.YG = row["YG"].ToString();
}
if (row["BG"] != null)
{
model.BG = row["BG"].ToString();
}
if (row["YYR"] != null)
{
model.YYR = row["YYR"].ToString();
}
if (row["SQZXR"] != null)
{
model.SQZXR = row["SQZXR"].ToString();
}
if (row["BZXR"] != null)
{
model.BZXR = row["BZXR"].ToString();
}
if (row["SARQ"] != null && row["SARQ"].ToString() != "")
{
model.SARQ = DateTime.Parse(row["SARQ"].ToString());
}
if (row["JARQ"] != null && row["JARQ"].ToString() != "")
{
model.JARQ = DateTime.Parse(row["JARQ"].ToString());
}
if (row["CJJG"] != null)
{
model.CJJG = row["CJJG"].ToString();
}
if (row["ZXBD"] != null)
{
model.ZXBD = row["ZXBD"].ToString();
}
if (row["SLJG"] != null)
{
model.SLJG = row["SLJG"].ToString();
}
if (row["ZXJG"] != null)
{
model.ZXJG = row["ZXJG"].ToString();
}
if (row["JAFS"] != null)
{
model.JAFS = row["JAFS"].ToString();
}
if (row["GLDAXLH"] != null)
{
model.GLDAXLH = row["GLDAXLH"].ToString();
}
if (row["HYTCY"] != null)
{
model.HYTCY = row["HYTCY"].ToString();
}
if (row["CBR"] != null)
{
model.CBR = row["CBR"].ToString();
}
if (row["SJY"] != null)
{
model.SJY = row["SJY"].ToString();
}
if (row["ZCS"] != null && row["ZCS"].ToString() != "")
{
model.ZCS = decimal.Parse(row["ZCS"].ToString());
}
if (row["DJC"] != null && row["DJC"].ToString() != "")
{
model.DJC = decimal.Parse(row["DJC"].ToString());
}
if (row["YS"] != null && row["YS"].ToString() != "")
{
model.YS = decimal.Parse(row["YS"].ToString());
}
if (row["GDRQ"] != null && row["GDRQ"].ToString() != "")
{
model.GDRQ = DateTime.Parse(row["GDRQ"].ToString());
}
if (row["YWT"] != null)
{
model.YWT = row["YWT"].ToString();
}
if (row["BGQX"] != null)
{
model.BGQX = row["BGQX"].ToString();
}
if (row["AJLBBM"] != null)
{
model.AJLBBM = row["AJLBBM"].ToString();
}
if (row["AJLBMC"] != null)
{
model.AJLBMC = row["AJLBMC"].ToString();
}
if (row["H"] != null && row["H"].ToString() != "")
{
model.H = decimal.Parse(row["H"].ToString());
}
if (row["NF"] != null)
{
model.NF = row["NF"].ToString();
}
if (row["YWLBBM"] != null)
{
model.YWLBBM = row["YWLBBM"].ToString();
}
if (row["YWLBMC"] != null)
{
model.YWLBMC = row["YWLBMC"].ToString();
}
if (row["QAH"] != null)
{
model.QAH = row["QAH"].ToString();
}
if (row["MLH"] != null)
{
model.MLH = row["MLH"].ToString();
}
if (row["JH"] != null)
{
model.JH = row["JH"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.TYYW_GG_AJJBXXKZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TYYW_GG_AJJBXXKZ set ");
strSql.Append("DWBM=:DWBM,");
strSql.Append("DWMC=:DWMC,");
strSql.Append("DWJC=:DWJC,");
strSql.Append("AHMC=:AHMC,");
strSql.Append("AY=:AY,");
strSql.Append("SAJG=:SAJG,");
strSql.Append("YG=:YG,");
strSql.Append("BG=:BG,");
strSql.Append("YYR=:YYR,");
strSql.Append("SQZXR=:SQZXR,");
strSql.Append("BZXR=:BZXR,");
strSql.Append("SARQ=:SARQ,");
strSql.Append("JARQ=:JARQ,");
strSql.Append("CJJG=:CJJG,");
strSql.Append("ZXBD=:ZXBD,");
strSql.Append("SLJG=:SLJG,");
strSql.Append("ZXJG=:ZXJG,");
strSql.Append("JAFS=:JAFS,");
strSql.Append("GLDAXLH=:GLDAXLH,");
strSql.Append("HYTCY=:HYTCY,");
strSql.Append("CBR=:CBR,");
strSql.Append("SJY=:SJY,");
strSql.Append("ZCS=:ZCS,");
strSql.Append("DJC=:DJC,");
strSql.Append("YS=:YS,");
strSql.Append("GDRQ=:GDRQ,");
strSql.Append("YWT=:YWT,");
strSql.Append("BGQX=:BGQX,");
strSql.Append("AJLBBM=:AJLBBM,");
strSql.Append("AJLBMC=:AJLBMC,");
strSql.Append("H=:H,");
strSql.Append("NF=:NF,");
strSql.Append("YWLBBM=:YWLBBM,");
strSql.Append("YWLBMC=:YWLBMC,");
strSql.Append("QAH=:QAH,");
strSql.Append("MLH=:MLH,");
strSql.Append("JH=:JH");
strSql.Append(" where AJKZXH=:AJKZXH ");
OracleParameter[] parameters =
{
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":DWMC", OracleType.VarChar, 500),
new OracleParameter(":DWJC", OracleType.VarChar, 200),
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, 18),
new OracleParameter(":DJC", OracleType.Number, 18),
new OracleParameter(":YS", OracleType.Number, 18),
new OracleParameter(":GDRQ", OracleType.DateTime),
new OracleParameter(":YWT", OracleType.VarChar, 200),
new OracleParameter(":BGQX", OracleType.VarChar, 20),
new OracleParameter(":AJLBBM", OracleType.VarChar, 50),
new OracleParameter(":AJLBMC", OracleType.VarChar, 200),
new OracleParameter(":H", OracleType.Number, 18),
new OracleParameter(":NF", OracleType.VarChar, 10),
new OracleParameter(":YWLBBM", OracleType.VarChar, 50),
new OracleParameter(":YWLBMC", OracleType.VarChar, 50),
new OracleParameter(":QAH", OracleType.VarChar, 20),
new OracleParameter(":MLH", OracleType.VarChar, 20),
new OracleParameter(":JH", OracleType.VarChar, 20),
new OracleParameter(":AJKZXH", OracleType.VarChar, 50)
};
parameters[0].Value = model.DWBM;
parameters[1].Value = model.DWMC;
parameters[2].Value = model.DWJC;
parameters[3].Value = model.AHMC;
parameters[4].Value = model.AY;
parameters[5].Value = model.SAJG;
parameters[6].Value = model.YG;
parameters[7].Value = model.BG;
parameters[8].Value = model.YYR;
parameters[9].Value = model.SQZXR;
parameters[10].Value = model.BZXR;
parameters[11].Value = model.SARQ;
parameters[12].Value = model.JARQ;
parameters[13].Value = model.CJJG;
parameters[14].Value = model.ZXBD;
parameters[15].Value = model.SLJG;
parameters[16].Value = model.ZXJG;
parameters[17].Value = model.JAFS;
parameters[18].Value = model.GLDAXLH;
parameters[19].Value = model.HYTCY;
parameters[20].Value = model.CBR;
parameters[21].Value = model.SJY;
parameters[22].Value = model.ZCS;
parameters[23].Value = model.DJC;
parameters[24].Value = model.YS;
parameters[25].Value = model.GDRQ;
parameters[26].Value = model.YWT;
parameters[27].Value = model.BGQX;
parameters[28].Value = model.AJLBBM;
parameters[29].Value = model.AJLBMC;
parameters[30].Value = model.H;
parameters[31].Value = model.NF;
parameters[32].Value = model.YWLBBM;
parameters[33].Value = model.YWLBMC;
parameters[34].Value = model.QAH;
parameters[35].Value = model.MLH;
parameters[36].Value = model.JH;
parameters[37].Value = model.AJKZXH;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <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 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));
}
