//#region 添加数据
///// <summary>
///// 添加数据
///// </summary>
///// <returns></returns>
//public string AddData()
//{
// EDRS.Model.YX_DZJZ_JZAJXX model = new EDRS.Model.YX_DZJZ_JZAJXX();
// model.BMSAH = Request.Form.Get("txt_BMSAH");
// model.AJMC = Request.Form.Get("txt_AJMC");
// model.AJLB_BM = Request.Form.Get("sct_AJLB_BM");
// model.AJLB_BM = Request.Form.Get("sct_CBDWBM");
// model.FQL = "4";
// YX_DZJZ_JZAJXX jzajxx = new YX_DZJZ_JZAJXX(this.Request);
// if (jzajxx.Add(model))
// return ReturnString.JsonToString(Prompt.win, "保存成功", null);
// return ReturnString.JsonToString(Prompt.error, "保存失败", null);
//}
//#endregion
//#region 编辑数据
///// <summary>
///// 编辑数据
///// </summary>
///// <returns></returns>
//public string UpData()
//{
// YX_DZJZ_JZAJXX jzajxx = new YX_DZJZ_JZAJXX(this.Request);
// EDRS.Model.YX_DZJZ_JZAJXX model = jzajxx.GetModel(Request.Form.Get("key_hidd"));
// if (model != null)
// {
// model.BMSAH = Request.Form.Get("txt_BMSAH");
// model.AJMC = Request.Form.Get("txt_AJMC");
// model.AJLB_BM = Request.Form.Get("sct_AJLB_BM");
// model.AJLB_BM = Request.Form.Get("sct_CBDWBM");
// model.FQL = "4";
// if (jzajxx.Update(model))
// return ReturnString.JsonToString(Prompt.win, "修改成功", null);
// }
// return ReturnString.JsonToString(Prompt.error, "修改失败", null);
//}
//#endregion
//#region 删除
///// <summary>
///// 删除
///// </summary>
///// <returns></returns>
//private string DelData()
//{
// string ids = Request.Form["BMSAH"];
// string[] id = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
// ids="";
// for (int i = 0; i < id.Length; i++)
// {
// ids += "'" + id[i] + "'";
// if (i < id.Length - 1)
// ids += ",";
// }
// YX_DZJZ_JZAJXX jzajxx = new YX_DZJZ_JZAJXX(this.Request);
// if (jzajxx.DeleteList(ids))
// return ReturnString.JsonToString(Prompt.win, "删除数据成功", null);
// return ReturnString.JsonToString(Prompt.error, "删除数据失败", null);
//}
//#endregion
//#region 根据编号获取数据
///// <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);
// }
// YX_DZJZ_JZAJXX jzajxx = new YX_DZJZ_JZAJXX(this.Request);
// EDRS.Model.YX_DZJZ_JZAJXX model = jzajxx.GetModel(BMSAH);
// if (model != null)
// return JsonHelper.JsonString(model);
// return ReturnString.JsonToString(Prompt.error, "获取数据失败", null);
//}
//#endregion
#region 解除卷宗案件基本信息锁定状态
/// <summary>
/// 解除卷宗案件基本信息锁定状态
/// </summary>
/// <returns></returns>
private string RomIsLock()
{
string BMSAH = Request.Form["BMSAH"];
if (BMSAH == null || string.IsNullOrEmpty(BMSAH))
{
return(ReturnString.JsonToString(Prompt.error, "解锁参数不正确", null));
}
YX_DZJZ_JZJBXX jzjbxx = new YX_DZJZ_JZJBXX(this.Request);
List <EDRS.Model.YX_DZJZ_JZJBXX> jblist = jzjbxx.GetModelList(" and BMSAH=:BMSAH and SFSC='N'", new object[] { BMSAH });
if (jblist != null && jblist.Count > 0)
{
EDRS.Model.YX_DZJZ_JZJBXX model = jblist[0];
model.JZXGH = " ";
model.ZHXGSJ = DateTime.Now;
if (jzjbxx.Update(model))
{
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "解锁成功", BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "解锁成功", null));
}
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "解锁失败", BMSAH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "解锁失败", null));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_JZJBXX GetModel(string JZBH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select JZBH,SFSC,CJSJ,ZHXGSJ,FQDWBM,FQL,DWBM,BMSAH,TYSAH,JZMC,JZLJ,JZSCSJ,JZSCRGH,JZSCRXM,JZMS,JZXGH,SFKYGX,GXYWBMJH,MRSFGKPZ,ZZZT,JZPZ,JZSHRBH,JZSHR,JZSHSJ,AJBH,WSBH,WSMC from YX_DZJZ_JZJBXX ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where JZBH=:JZBH ");
OracleParameter[] parameters =
{
new OracleParameter(":JZBH", OracleType.Char, 14)
};
parameters[0].Value = JZBH;
EDRS.Model.YX_DZJZ_JZJBXX model = new EDRS.Model.YX_DZJZ_JZJBXX();
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.YX_DZJZ_JZJBXX GetModel(string JZBH)", "EDRS.OracleDAL.YX_DZJZ_JZJBXX", 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>
private string RomIsLock()
{
string bmsahs = Request.Form["bmsahs"];
if (bmsahs == null || string.IsNullOrEmpty(bmsahs))
{
return ReturnString.JsonToString(Prompt.error, "解锁参数不正确", null);
}
string[] str = bmsahs.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries);
List<EDRS.Model.YX_DZJZ_JZJBXX> modelList = new List<EDRS.Model.YX_DZJZ_JZJBXX>();
for (int i = 0; i < str.Length; i++)
{
EDRS.Model.YX_DZJZ_JZJBXX model = new EDRS.Model.YX_DZJZ_JZJBXX();
model.BMSAH = str[i];
model.JZXGH = "";
model.ZHXGSJ = DateTime.Now;
model.ZZZT = "-1";
modelList.Add(model);
}
YX_DZJZ_JZJBXX bll = new YX_DZJZ_JZJBXX(this.Request);
if (bll.LockByModelList(modelList))
{
OperateLog.AddLogList(OperateLog.LogType.案件卷宗制作Web, "卷宗解锁成功", str, UserInfo, UserRole, this.Request);
return ReturnString.JsonToString(Prompt.win, "解锁成功", null);
}
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "卷宗解锁失败", bmsahs, UserInfo, UserRole, this.Request);
return ReturnString.JsonToString(Prompt.error, "解锁失败", null);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.YX_DZJZ_JZJBXX model)
{
StringBuilder strSql = new StringBuilder();
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)");
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)");
OracleParameter[] parameters =
{
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)
};
parameters[0].Value = model.JZBH ?? "";
parameters[1].Value = model.SFSC;
parameters[2].Value = model.CJSJ;
parameters[3].Value = model.ZHXGSJ;
parameters[4].Value = model.FQDWBM;
parameters[5].Value = model.FQL ?? "";
parameters[6].Value = model.DWBM ?? "";
parameters[7].Value = model.BMSAH ?? "";
parameters[8].Value = model.TYSAH ?? "";
parameters[9].Value = model.JZMC ?? "";
parameters[10].Value = model.JZLJ ?? "";
parameters[11].Value = (object)model.JZSCSJ ?? DBNull.Value;
parameters[12].Value = model.JZSCRGH ?? "";
parameters[13].Value = model.JZSCRXM ?? "";
parameters[14].Value = model.JZMS ?? "";
parameters[15].Value = model.JZXGH;
parameters[16].Value = model.SFKYGX;
parameters[17].Value = model.GXYWBMJH ?? "";
parameters[18].Value = model.MRSFGKPZ;
parameters[19].Value = model.Accomplices ?? "";
parameters[20].Value = model.Ajmb_bm ?? "";
parameters[21].Value = model.Ajmb_mc ?? "";
parameters[22].Value = model.Idnumber ?? "";
parameters[23].Value = model.Isrecord ?? "";
parameters[24].Value = model.Suspectname ?? "";
parameters[25].Value = model.WSBH ?? "";
parameters[26].Value = model.AJBH ?? "";
parameters[27].Value = model.ZZZT ?? "";
parameters[28].Value = model.JZPZ ?? "";
parameters[29].Value = model.JZSHRBH ?? "";
parameters[30].Value = model.JZSHR ?? "";
parameters[31].Value = (object)model.JZSHSJ ?? DBNull.Value;
parameters[32].Value = model.WSMC ?? "";
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.YX_DZJZ_JZJBXX model)", "EDRS.OracleDAL.YX_DZJZ_JZJBXX", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_JZJBXX DataRowToModel(DataRow row)
{
EDRS.Model.YX_DZJZ_JZJBXX model = new EDRS.Model.YX_DZJZ_JZJBXX();
if (row != null)
{
if (row["JZBH"] != null)
{
model.JZBH = row["JZBH"].ToString();
}
if (row["SFSC"] != null)
{
model.SFSC = row["SFSC"].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["FQDWBM"] != null && row["FQDWBM"].ToString() != "")
{
model.FQDWBM = decimal.Parse(row["FQDWBM"].ToString());
}
if (row["FQL"] != null)
{
model.FQL = row["FQL"].ToString();
}
if (row["DWBM"] != null)
{
model.DWBM = row["DWBM"].ToString();
}
if (row["BMSAH"] != null)
{
model.BMSAH = row["BMSAH"].ToString();
}
if (row["TYSAH"] != null)
{
model.TYSAH = row["TYSAH"].ToString();
}
if (row["JZMC"] != null)
{
model.JZMC = row["JZMC"].ToString();
}
if (row["JZLJ"] != null)
{
model.JZLJ = row["JZLJ"].ToString();
}
if (row["JZSCSJ"] != null && row["JZSCSJ"].ToString() != "")
{
model.JZSCSJ = DateTime.Parse(row["JZSCSJ"].ToString());
}
if (row["JZSCRGH"] != null)
{
model.JZSCRGH = row["JZSCRGH"].ToString();
}
if (row["JZSCRXM"] != null)
{
model.JZSCRXM = row["JZSCRXM"].ToString();
}
if (row["JZMS"] != null)
{
model.JZMS = row["JZMS"].ToString();
}
if (row["JZXGH"] != null)
{
model.JZXGH = row["JZXGH"].ToString();
}
if (row["SFKYGX"] != null)
{
model.SFKYGX = row["SFKYGX"].ToString();
}
if (row["GXYWBMJH"] != null)
{
model.GXYWBMJH = row["GXYWBMJH"].ToString();
}
if (row["MRSFGKPZ"] != null)
{
model.MRSFGKPZ = row["MRSFGKPZ"].ToString();
}
if (row["ZZZT"] != null)
{
model.ZZZT = row["ZZZT"].ToString();
}
if (row["JZPZ"] != null)
{
model.JZPZ = row["JZPZ"].ToString();
}
if (row["JZSHRBH"] != null)
{
model.JZSHRBH = row["JZSHRBH"].ToString();
}
if (row["JZSHR"] != null)
{
model.JZSHR = row["JZSHR"].ToString();
}
if (row["JZSHSJ"] != null && row["JZSHSJ"].ToString() != "")
{
model.JZSHSJ = DateTime.Parse(row["JZSHSJ"].ToString());
}
if (row["AJBH"] != DBNull.Value)
{
model.AJBH = row["AJBH"].ToString();
}
if (row["WSBH"] != DBNull.Value)
{
model.WSBH = row["WSBH"].ToString();
}
if (row["WSMC"] != DBNull.Value)
{
model.WSMC = row["WSMC"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.YX_DZJZ_JZJBXX model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_DZJZ_JZJBXX set ");
strSql.Append("SFSC=:SFSC,");
strSql.Append("CJSJ=:CJSJ,");
strSql.Append("ZHXGSJ=:ZHXGSJ,");
strSql.Append("FQDWBM=:FQDWBM,");
strSql.Append("FQL=:FQL,");
strSql.Append("DWBM=:DWBM,");
strSql.Append("BMSAH=:BMSAH,");
strSql.Append("TYSAH=:TYSAH,");
strSql.Append("JZMC=:JZMC,");
strSql.Append("JZLJ=:JZLJ,");
strSql.Append("JZSCSJ=:JZSCSJ,");
strSql.Append("JZSCRGH=:JZSCRGH,");
strSql.Append("JZSCRXM=:JZSCRXM,");
strSql.Append("JZMS=:JZMS,");
strSql.Append("JZXGH=:JZXGH,");
strSql.Append("SFKYGX=:SFKYGX,");
strSql.Append("GXYWBMJH=:GXYWBMJH,");
strSql.Append("MRSFGKPZ=:MRSFGKPZ,");
strSql.Append("ZZZT=:ZZZT,");
strSql.Append("JZPZ =:JZPZ,");
strSql.Append("JZSHRBH =:JZSHRBH,");
strSql.Append("JZSHR =:JZSHR,");
strSql.Append("JZSHSJ =:JZSHSJ,");
strSql.Append("AJBH = :AJBH,");
strSql.Append("WSBH = :WSBH,");
strSql.Append("WSMC = :WSMC");
strSql.Append(" where JZBH=:JZBH ");
OracleParameter[] parameters =
{
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(":JZBH", OracleType.Char, 14),
new OracleParameter(":ZZZT", OracleType.VarChar, 10),
new OracleParameter(":JZPZ", OracleType.VarChar, 4000),
new OracleParameter(":JZSHRBH", OracleType.VarChar),
new OracleParameter(":JZSHR", OracleType.VarChar),
new OracleParameter(":AJBH", OracleType.VarChar),
new OracleParameter(":WSBH", OracleType.VarChar),
new OracleParameter(":WSMC", OracleType.VarChar),
new OracleParameter(":JZSHSJ", OracleType.DateTime)
};
parameters[0].Value = model.SFSC;
parameters[1].Value = model.CJSJ;
parameters[2].Value = model.ZHXGSJ;
parameters[3].Value = model.FQDWBM;
parameters[4].Value = model.FQL;
parameters[5].Value = model.DWBM;
parameters[6].Value = model.BMSAH;
parameters[7].Value = model.TYSAH;
parameters[8].Value = model.JZMC;
parameters[9].Value = model.JZLJ;
parameters[10].Value = model.JZSCSJ;
parameters[11].Value = model.JZSCRGH;
parameters[12].Value = model.JZSCRXM;
parameters[13].Value = model.JZMS;
parameters[14].Value = model.JZXGH;
parameters[15].Value = model.SFKYGX;
parameters[16].Value = model.GXYWBMJH;
parameters[17].Value = model.MRSFGKPZ;
parameters[18].Value = model.JZBH;
parameters[19].Value = model.ZZZT;
parameters[20].Value = model.JZPZ;
parameters[21].Value = model.JZSHRBH;
parameters[22].Value = model.JZSHR;
parameters[23].Value = model.AJBH ?? "";
parameters[24].Value = model.WSBH ?? "";
parameters[25].Value = model.WSMC ?? "";
parameters[26].Value = (object)model.JZSHSJ ?? DBNull.Value;
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.YX_DZJZ_JZJBXX model)", "EDRS.OracleDAL.YX_DZJZ_JZJBXX", 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>
public string SetSh()
{
string ids = Request.Form["bmsah"];
string[] id = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
ids = "";
for (int i = 0; i < id.Length; i++)
{
ids += "'" + id[i].Trim() + "'";
if (i < id.Length - 1)
{
ids += ",";
}
}
if (string.IsNullOrEmpty(ids))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
EDRS.BLL.YX_DZJZ_JZJBXX bll = new EDRS.BLL.YX_DZJZ_JZJBXX(this.Request);
DataSet ds = bll.GetList(string.Format(" and JZBH in ({0})", ids));
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["ZZZT"].ToString() != "2")
{
return(ReturnString.JsonToString(Prompt.error, "该案件目前不能再进行审核", null));
}
}
}
if (bll.UpdateByZZZTList(ids, "", DateTime.Now, "", Request.Form.Get("txt_type"), Request.Form.Get("txt_pz")))
{
//数据日志
// OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "操作成功", "",UserInfo, UserRole, this.Request);
foreach (string key in ids.Split(','))
{
string bmsah = key.Replace("'", "");
EDRS.Model.YX_DZJZ_JZJBXX model = bll.GetModel(bmsah);
if (model != null && (model.ZZZT == "4" || model.ZZZT == "3"))
{
try
{
WebReference.jzfk _interface = new WebReference.jzfk();
string status = model.ZZZT == "4" ? "1" : "0";
string result = _interface.updateStatus(model.AJBH, model.WSBH, status);
LogHelper.LogError(Request, "Exception", "通知审核状态记录：" + result + "|本地状态：" + model.ZZZT + "|AJBH:" + model.AJBH + "|WSBH:" + model.WSBH + "|" + status, "", "");
OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "通知状态改变成功：[案件编号=" + model.AJBH + "，文书编号=" + model.WSBH + "]", model.BMSAH + "|" + model.AJBH + "|" + model.WSBH, null, null, this.Request);
}
catch (Exception ex)
{
OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "状态回写失败：" + ex.Message, "", null, null, this.Request);
}
}
}
return(ReturnString.JsonToString(Prompt.win, "操作成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "操作失败", "", null, null, this.Request);
return(ReturnString.JsonToString(Prompt.error, "操作失败", null));
}
/// <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>
/// <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>
/// <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 SetBs()
{
string AJBH = Request.Form["AJBH"];
string WSBH = Request.Form["WSBH"];
string ZZZT = Request.Form["ZZZT"];
string Str = "";
if (string.IsNullOrEmpty(AJBH) || string.IsNullOrEmpty(WSBH) || ZZZT != "6")
{
return("{\"Stat\":1,\"Msg\":\"报送通知失败，手动报送只能针对报送失败的案件。\",\"Data\":\"\"}");
}
try
{
string bmsahs = GetText();
if (bmsahs.IndexOf(WSBH) > -1)
{
Str = "{\"Stat\":1,\"Msg\":\"报送通知失败，上一次报送通知尚未处理，请不要重复通知\",\"Data\":\"\"}";
OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "接收到报送通知失败：上一次报送通知尚未处理，不重复接收。[案件编号=" + AJBH + "，文书编号=" + WSBH + "]", "|" + AJBH + "|" + WSBH, null, null, this.Context.Request);
}
else
{
if (!string.IsNullOrEmpty(bmsahs))
{
bmsahs += ",";
}
bmsahs += WSBH;
//验证
EDRS.BLL.YX_DZJZ_JZJBXX bll = new YX_DZJZ_JZJBXX(this.Context.Request);
DataSet ds = bll.GetList(" AND WSBH=:WSBH", new object[] { WSBH });
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
Str = "{\"Stat\":1,\"Msg\":\"报送通知失败，无对应案件信息\",\"Data\":\"\"}";
OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "不接收的案件报送通知：不存在对应文书编号的案件。[案件编号=" + AJBH + "，文书编号=" + WSBH + "]", "|" + AJBH + "|" + WSBH, null, null, this.Context.Request);
}
else
{
string jzbh = ds.Tables[0].Rows[0]["JZBH"].ToString();
EDRS.Model.YX_DZJZ_JZJBXX jz = bll.GetModel(jzbh);
if (jz == null)
{
Str = "{\"Stat\":1,\"Msg\":\"报送通知失败，无对应案件信息\",\"Data\":\"\"}";
OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "不接收的案件报送通知：不存在对应文书编号的案件。[案件编号=" + AJBH + "，文书编号=" + WSBH + "]", "|" + AJBH + "|" + WSBH, null, null, this.Context.Request);
}
else
{
//审核通过或已上报允许报送
//if (jz.ZZZT == "4" || jz.ZZZT == "5")
//{
SaveText(bmsahs);
Str = "{\"Stat\":0,\"Msg\":\"报送通知成功\"}";
OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "接收到报送通知成功：[案件编号=" + AJBH + "，文书编号=" + WSBH + "]", "|" + AJBH + "|" + WSBH, null, null, this.Context.Request);
//}
//else
//{
// Str = "{\"Stat\":1,\"Msg\":\"报送通知失败，当前报送案件尚未审核通过\",\"Data\":\"\"}";
// OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "接收到报送通知成功：[案件编号=" + AJBH + "，文书编号=" + WSBH + "]", "|" + AJBH + "|" + WSBH, null, null, this.Context.Request);
//}
}
}
}
}
catch (Exception ex)
{
Str = "{\"Stat\":1,\"Msg\":\"接收报送通知失败：错误信息请查看系统日志！\",\"Data\":\"\"}";
OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "接收到报送通知失败：处理报送数据时发生系统错误，详情查看日志。[案件编号=" + AJBH + "，文书编号=" + WSBH + "]", "|" + AJBH + "|" + WSBH, null, null, this.Context.Request);
EDRS.Common.LogHelper.LogError(this.Context.Request, "Exception", ex.Message, "public void SetBs(string AJBH, string WSBH)", "WebUI.MakeCheck", "");
}
return(Str);
}
/// <summary>
/// 修改配置数据
/// </summary>
/// <returns></returns>
private string UpData()
{
string ids = Request.Form["bmsah"];
string[] id = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
ids = "";
for (int i = 0; i < id.Length; i++)
{
ids += "'" + id[i].Trim() + "'";
if (i < id.Length - 1)
{
ids += ",";
}
}
if (string.IsNullOrEmpty(ids))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
YX_DZJZ_JZJBXX bll = new YX_DZJZ_JZJBXX(this.Request);
if (bll.UpdateByZZZTList(ids, UserInfo.MC, DateTime.Now, UserInfo.GH, Request.Form.Get("type"), Request.Form.Get("txt_pz")))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "操作成功", "", UserInfo, UserRole, this.Request);
foreach (string key in ids.Split(','))
{
string bmsah = key.Replace("'", "");
EDRS.Model.YX_DZJZ_JZJBXX model = bll.GetModel(bmsah);
if (model != null && (model.ZZZT == "4" || model.ZZZT == "3"))
{
try
{
WebReference.jzfk _interface = new WebReference.jzfk();
string status = model.ZZZT == "4" ? "1" : "0";
string result = _interface.updateStatus(model.AJBH, model.WSBH, status);
string msg = "通知审核状态记录：" + result + "|本地状态：" + model.ZZZT + "|AJBH:" + model.AJBH + "|WSBH:" + model.WSBH + "|" + status;
try
{
string NoticeAuditStatusFilePath = Path.Combine(Path.Combine(GetRootPath(), "NoticeFile"), "NoticeWaitAuditStatus.txt");
FileStream fs = new FileStream(NoticeAuditStatusFilePath, FileMode.Append);
StreamWriter sr = new StreamWriter(fs, System.Text.Encoding.Default);
sr.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "|" + msg);
sr.Close();
fs.Close();
}
catch (Exception ex)
{ }
OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "通知状态改变成功：[案件编号=" + model.AJBH + "，文书编号=" + model.WSBH + "]", model.BMSAH + "|" + model.AJBH + "|" + model.WSBH, null, null, this.Request);
}
catch (Exception ex)
{
OperateLog.AddLog(OperateLog.LogType.卷宗OCR及打包状态, "状态回写失败：" + ex.Message, "", UserInfo, UserRole, this.Request);
}
}
}
return(ReturnString.JsonToString(Prompt.win, "操作成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "操作失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "操作失败", null));
}
