/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_LSAJBD GetModel(string YJXH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select GH,BMSAH,YJXH,MC,AJMC,AJLBBM,AJLBMC,YJKSSJ,YJJSSJ,YJZH,YJMM,JDSJ,JDR,JDRGH,JDBMBM,JDBMMC,JDDWBM,JDDWMC,SFSC,YJSQDH,DWBM from YX_DZJZ_LSAJBD ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where YJXH=:YJXH ");
OracleParameter[] parameters =
{
new OracleParameter(":YJXH", OracleType.VarChar, 50)
};
parameters[0].Value = YJXH;
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
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_LSAJBD GetModel(string YJXH)", "EDRS.OracleDAL.YX_DZJZ_LSAJBD", strSql.ToString(), parameters);
}
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private Dictionary <object, object> LSAJBD(EDRS.Model.YX_DZJZ_LSAJBD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_DZJZ_LSAJBD(");
strSql.Append("GH,BMSAH,MC,AJMC,AJLBBM,AJLBMC,YJKSSJ,YJJSSJ,YJZH,YJMM,JDSJ,JDR,JDRGH,JDBMBM,JDBMMC,JDDWBM,JDDWMC,SFSC,YJSQDH,DWBM)");
strSql.Append(" values (");
strSql.Append(":GH,:BMSAH,:MC,:AJMC,:AJLBBM,:AJLBMC,:YJKSSJ,:YJJSSJ,:YJZH,:YJMM,:JDSJ,:JDR,:JDRGH,:JDBMBM,:JDBMMC,:JDDWBM,:JDDWMC,:SFSC,:YJSQDH,:DWBM)");
OracleParameter[] parameters =
{
new OracleParameter(":GH", OracleType.VarChar, 100),
new OracleParameter(":BMSAH", OracleType.VarChar, 100),
new OracleParameter(":MC", OracleType.VarChar, 60),
new OracleParameter(":AJMC", OracleType.VarChar, 300),
new OracleParameter(":AJLBBM", OracleType.VarChar, 50),
new OracleParameter(":AJLBMC", OracleType.VarChar, 50),
new OracleParameter(":YJKSSJ", OracleType.DateTime),
new OracleParameter(":YJJSSJ", OracleType.DateTime),
new OracleParameter(":YJZH", OracleType.VarChar, 100),
new OracleParameter(":YJMM", OracleType.Char, 8),
new OracleParameter(":JDSJ", OracleType.DateTime),
new OracleParameter(":JDR", OracleType.VarChar, 60),
new OracleParameter(":JDRGH", OracleType.Char, 4),
new OracleParameter(":JDBMBM", OracleType.Char, 4),
new OracleParameter(":JDBMMC", OracleType.VarChar, 300),
new OracleParameter(":JDDWBM", OracleType.VarChar, 50),
new OracleParameter(":JDDWMC", OracleType.VarChar, 300),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":YJSQDH", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50)
};
parameters[0].Value = model.GH;
parameters[1].Value = model.BMSAH;
parameters[2].Value = model.MC;
parameters[3].Value = model.AJMC;
parameters[4].Value = model.AJLBBM;
parameters[5].Value = model.AJLBMC;
parameters[6].Value = model.YJKSSJ;
parameters[7].Value = model.YJJSSJ;
parameters[8].Value = model.YJZH;
parameters[9].Value = model.YJMM;
parameters[10].Value = model.JDSJ;
parameters[11].Value = model.JDR;
parameters[12].Value = model.JDRGH;
parameters[13].Value = model.JDBMBM;
parameters[14].Value = model.JDBMMC;
parameters[15].Value = model.JDDWBM;
parameters[16].Value = model.JDDWMC;
parameters[17].Value = model.SFSC;
parameters[18].Value = model.YJSQDH;
parameters[19].Value = model.DWBM;
Dictionary <object, object> hash = new Dictionary <object, object>();
hash.Add(strSql.ToString(), parameters);
return(hash);
}
/// <summary>
/// 增加多条数据
/// </summary>
public bool AddList(List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList, EDRS.Model.YX_DZJZ_LSAJBD lsajbdModel, string yjxh)
{
int count = 0;
//Hashtable hash = new Hashtable();
Dictionary <object, object> hash = new Dictionary <object, object>();
// hash = LSAJBD(lsajbdModel);
StringBuilder strSql = new StringBuilder();
strSql.Append(" update YX_DZJZ_LSAJWJFP set SFSC='Y' where YJXH=:YJXHUP ");
OracleParameter[] parameters1 =
{
new OracleParameter(":YJXHUP", OracleType.VarChar, 50)
};
parameters1[0].Value = yjxh;
hash.Add(strSql.ToString(), parameters1);
foreach (EDRS.Model.YX_DZJZ_LSAJWJFP model in modelList)
{
strSql.Clear();
strSql.Append(" insert into YX_DZJZ_LSAJWJFP(");
strSql.Append("YJXH,WJXH,SFSC)");
strSql.Append(" values (");
strSql.Append(":YJXH" + count + ",:WJXH" + count + ",:SFSC" + count + ")");
OracleParameter[] parameters =
{
new OracleParameter(":YJXH" + count, OracleType.VarChar, 50),
new OracleParameter(":WJXH" + count, OracleType.VarChar, 100),
new OracleParameter(":SFSC" + count, OracleType.Char, 1)
};
parameters[0].Value = yjxh;
parameters[1].Value = model.WJXH;
parameters[2].Value = "N";
hash.Add(strSql.ToString(), parameters);
count++;
}
try
{
return(DbHelperOra.ExecuteSqlTran(hash));
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddList(List<EDRS.Model.YX_DZJZ_LSAJWJFP> modelList)", "EDRS.OracleDAL.YX_DZJZ_LSAJWJFP");
}
return(false);
}
public void ProcessRequest(HttpContext context)
{
string action = context.Request.Params["action"];
switch (action)
{
case "Time":
EDRS.Model.YX_DZJZ_LSAJBD model = context.Session["YjData"] as EDRS.Model.YX_DZJZ_LSAJBD;
if (model != null && model.YJJSSJ != null && model.YJJSSJ.Value.CompareTo(DateTime.Now) > 0)
{
TimeSpan ts = model.YJJSSJ.Value.Subtract(DateTime.Now);
context.Response.Write((ts.Days > 0 ? ts.Days + "天 " : "") + ts.Hours.ToString().PadLeft(2, '0') + ":" + ts.Minutes.ToString().PadLeft(2, '0') + ":" + ts.Seconds.ToString().PadLeft(2, '0'));
}
else
{
context.Session["YjData"] = null;
context.Response.Write("N");
}
break;
}
}
public string submitapplyall()
{
EDRS.BLL.YX_DZJZ_JZMLWJ bll = new EDRS.BLL.YX_DZJZ_JZMLWJ(Request);
EDRS.BLL.YX_DZJZ_WJSQDY BLLSQ = new EDRS.BLL.YX_DZJZ_WJSQDY(Request);
string idstr = Request.Form["idstr[]"];
string yjxh = Request.Form["yjxh"];
if (!string.IsNullOrEmpty(idstr))
{
#region 申请打印
EDRS.BLL.YX_DZJZ_LSAJBD dbbll = new EDRS.BLL.YX_DZJZ_LSAJBD(Request);
//获取部门部门受案号
EDRS.Model.YX_DZJZ_LSAJBD dbmodel = dbbll.GetModel(yjxh);
//判断该申请打印是否存在
EDRS.Model.YX_DZJZ_WJSQDY model = BLLSQ.GetModelByYJXH(yjxh);
if (model != null)
{
model.SQSJ = DateTime.Now;
model.DYR = "";
model.DYRGH = "";
model.DYSJ = null;
}
else
{
model = new EDRS.Model.YX_DZJZ_WJSQDY();
model.BMSAH = dbmodel.BMSAH;
model.DYBMBM = ""; //打印部门编码
model.DYBMMC = "";
model.DYDWBM = "";
model.DYDWMC = "";
model.DYFS = null; //打印份数
model.DYFY = null; //打印费用
model.DYR = ""; //打印人
model.DYRGH = ""; //打印人工号
model.DYSJ = null; //打印时间
model.LSZH = Request.Form["lszh"]; //律师证号
model.DYSQDH = DateTime.Now.ToString("yyyyMMddHHmmssfff") + model.LSZH;
model.JZWJBH = ""; //文件编号
model.SFSC = "N";
model.SQFS = 1; //申请份数
model.SQSJ = DateTime.Now; //申请时间
model.YJXH = yjxh; //阅卷序号
model.XH = Guid.NewGuid().ToString();
}
#endregion
#region 申请打印记录
List <EDRS.Model.YX_DZJZ_WJSQDYJL> sqjlList = new List <EDRS.Model.YX_DZJZ_WJSQDYJL>();
string[] idarr = idstr.Split(',');
//根据序号获取打印记录
DataSet ds = BLLSQ.GetListDYJL(" and XH ='" + model.XH + "'");
EDRS.Model.YX_DZJZ_WJSQDYJL sqjlModel = null;
for (int i = 0; i < idarr.Length; i++)
{
DataRow[] dr = null;
if (ds != null)
{
dr = ds.Tables[0].Select("WJXH='" + idarr[i] + "'");
}
if (dr == null || dr.Length == 0)
{
sqjlModel = new EDRS.Model.YX_DZJZ_WJSQDYJL();
sqjlModel.WJXH = idarr[i];
sqjlModel.XH = model.XH;
sqjlModel.YJXH = model.YJXH;
sqjlModel.ADDTIME = DateTime.Now;
sqjlModel.SFSC = "N";
sqjlList.Add(sqjlModel);
}
}
#endregion
if (BLLSQ.AddListJL(sqjlList, model, model.XH))
{
return(ReturnString.JsonToString(Prompt.win, "提交申请成功", null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, "提交申请失败", null));
}
}
return(ReturnString.JsonToString(Prompt.error, "未获取文件信息", null));
}
/// <summary>
/// 保存分配案件文件
/// </summary>
/// <returns></returns>
private string AddData()
{
string json = Request.Form["json"];
string yjxh = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); //"山东省院捕受[2015]37000000054号";
string lssq = Request.Form["lssq"];
string[] lssqs = null;
if (string.IsNullOrEmpty(lssq))
{
return(ReturnString.JsonToString(Prompt.error, "请先填写律师阅卷申请信息！", null));
}
lssqs = lssq.Split(new string[] { "|&|" }, StringSplitOptions.None);
if (lssqs == null || lssqs.Length != 4)
{
return(ReturnString.JsonToString(Prompt.error, "您填写的律师阅卷申请信息不正确！", null));
}
string rybm = "";// Request.Form["lszh_hidd"];
// string[] rybms = rybm.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries);
//if(rybms.Length != 2)
// return ReturnString.JsonToString(Prompt.error, "请选择阅卷人！", null);
if (Request.Form["txt_yjkssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjkssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "请设置阅卷开始时间！", null));
}
if (Request.Form["txt_yjjssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjjssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "请设置阅卷结束时间！", null));
}
if (Convert.ToDateTime(Request.Form["txt_yjkssj"]) > Convert.ToDateTime(Request.Form["txt_yjjssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "结束时间不能小于开始时间！", null));
}
EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
EDRS.Model.TYYW_GG_AJJBXX ajmodel = ajbll.GetModel(Request.Form["key_hidd"]);
if (ajmodel == null)
{
return(ReturnString.JsonToString(Prompt.error, "分配失败，" + ((VersionName)0).ToString() + "不存在！", null));
}
//json = json.Replace("id", "_wjxh").Replace("MLLX", "_fpbm").Replace("text", "_sfsc").Replace("PARENTID", "_yjxh");
#region 律师阅卷申请
EDRS.Model.YX_DZJZ_LSYJSQ modelLsyjsq = new EDRS.Model.YX_DZJZ_LSYJSQ();
modelLsyjsq.LSZH = lssqs[0];
modelLsyjsq.YJSQDH = Guid.NewGuid().ToString();
modelLsyjsq.SQSJ = DateTime.Now;
modelLsyjsq.SQSM = lssqs[2];
modelLsyjsq.SFSC = "N";
modelLsyjsq.SHRGH = UserInfo.GH;
modelLsyjsq.SHR = UserInfo.MC;
modelLsyjsq.SHSM = "";
modelLsyjsq.SHSJ = DateTime.Now;
modelLsyjsq.YJSQDM = lssqs[1];
modelLsyjsq.SQDZT = "Y";
#endregion
#region 律师阅卷绑定
Random random = new Random();
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
model.GH = lssqs[0];
model.BMSAH = ajmodel.BMSAH;
model.YJXH = yjxh;
model.MC = lssqs[3];
model.AJMC = ajmodel.AJMC;
model.AJLBBM = ajmodel.AJLB_BM;
model.AJLBMC = ajmodel.AJLB_MC;
model.YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]);
model.YJJSSJ = Convert.ToDateTime(Request.Form["txt_yjjssj"]);
model.YJZH = lssqs[0];
model.YJMM = random.Next(100000, 999999).ToString();
model.JDSJ = DateTime.Now;
model.JDR = UserInfo.MC;
model.JDRGH = UserInfo.GH;
model.JDBMBM = "";
model.JDBMMC = "";
model.JDDWBM = UserInfo.DWBM;
model.JDDWMC = UserInfo.DWMC;
model.SFSC = "N";
model.YJSQDH = modelLsyjsq.YJSQDH;
model.JZZTXS = "";
model.DWBM = UserInfo.DWBM;
#endregion
#region 律师阅卷绑定文件
List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList = JsonHelper.JsonToList <EDRS.Model.YX_DZJZ_LSAJWJFP>(json);
#endregion
EDRS.BLL.YX_DZJZ_LSAJBD bllBD = new EDRS.BLL.YX_DZJZ_LSAJBD(Request);
try
{
if (bllBD.AddList(modelLsyjsq, model, modelList))
{
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配成功", "", UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//return ReturnString.JsonToString(Prompt.win, "分配成功！", null);
}
catch (Exception ex)
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(ex.Message), null));
}
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
/// <summary>
/// 增加多条数据
/// </summary>
public bool AddList(EDRS.Model.YX_DZJZ_LSYJSQ lsyjsqModel, EDRS.Model.YX_DZJZ_LSAJBD lsajbdModel, List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList, EDRS.Model.YX_DZJZ_LSGL lsglModel)
{
int count = 0;
Dictionary <object, object> hash = new Dictionary <object, object>();
StringBuilder strSql = new StringBuilder();
strSql.Append(" update YX_DZJZ_LSAJWJFP set SFSC='Y' where YJXH=:YJXHUP ");
OracleParameter[] parameters1 =
{
new OracleParameter(":YJXHUP", OracleType.VarChar, 50)
};
parameters1[0].Value = lsajbdModel.YJXH;
hash.Add(strSql.ToString(), parameters1);
#region 阅卷人信息
strSql.Clear();
strSql.Append("insert into YX_DZJZ_LSGL(");
strSql.Append("LSZH,LSXM,LSDW,LSDWDZ,LSDWYZHM,LSLXDH,LSSJ,DELXR,DELXRDH,LSZGYXSJ,SFDXZG,LSXXBZ,CJSJ,ZHYCYJSJ,SFSC)");
strSql.Append(" values (");
strSql.Append(":LSZH,:LSXM,:LSDW,:LSDWDZ,:LSDWYZHM,:LSLXDH,:LSSJ,:DELXR,:DELXRDH,:LSZGYXSJ,:SFDXZG,:LSXXBZ,:CJSJ,:ZHYCYJSJ,:SFSC)");
OracleParameter[] parameters4 =
{
new OracleParameter(":LSZH", OracleType.VarChar, 100),
new OracleParameter(":LSXM", OracleType.VarChar, 60),
new OracleParameter(":LSDW", OracleType.VarChar, 300),
new OracleParameter(":LSDWDZ", OracleType.VarChar, 300),
new OracleParameter(":LSDWYZHM", OracleType.Char, 6),
new OracleParameter(":LSLXDH", OracleType.VarChar, 50),
new OracleParameter(":LSSJ", OracleType.VarChar, 50),
new OracleParameter(":DELXR", OracleType.VarChar, 60),
new OracleParameter(":DELXRDH", OracleType.VarChar, 50),
new OracleParameter(":LSZGYXSJ", OracleType.DateTime),
new OracleParameter(":SFDXZG", OracleType.Char, 1),
new OracleParameter(":LSXXBZ", OracleType.VarChar, 300),
new OracleParameter(":CJSJ", OracleType.DateTime),
new OracleParameter(":ZHYCYJSJ", OracleType.DateTime),
new OracleParameter(":SFSC", OracleType.Char, 1)
};
parameters4[0].Value = lsglModel.LSZH;
parameters4[1].Value = lsglModel.LSXM;
parameters4[2].Value = lsglModel.LSDW;
parameters4[3].Value = lsglModel.LSDWDZ;
parameters4[4].Value = lsglModel.LSDWYZHM;
parameters4[5].Value = lsglModel.LSLXDH;
parameters4[6].Value = lsglModel.LSSJ;
parameters4[7].Value = lsglModel.DELXR;
parameters4[8].Value = lsglModel.DELXRDH;
parameters4[9].Value = lsglModel.LSZGYXSJ ?? (object)DBNull.Value;
parameters4[10].Value = lsglModel.SFDXZG;
parameters4[11].Value = lsglModel.LSXXBZ;
parameters4[12].Value = lsglModel.CJSJ;
parameters4[13].Value = lsglModel.ZHYCYJSJ ?? (object)DBNull.Value;
parameters4[14].Value = lsglModel.SFSC;
hash.Add(strSql.ToString(), parameters4);
#endregion
#region 律师申请
strSql.Clear();
strSql.Append("insert into YX_DZJZ_LSYJSQ(");
strSql.Append("LSZH,SQSJ,SQSM,SFSC,SHRGH,SHR,SHSM,SHSJ,YJSQDM,SQDZT,YJSQDH)");
strSql.Append(" values (");
strSql.Append(":LSZH,:SQSJ,:SQSM,:SFSC,:SHRGH,:SHR,:SHSM,:SHSJ,:YJSQDM,:SQDZT,:YJSQDH)");
OracleParameter[] parameters2 =
{
new OracleParameter(":LSZH", OracleType.VarChar, 100),
new OracleParameter(":SQSJ", OracleType.DateTime),
new OracleParameter(":SQSM", OracleType.VarChar, 300),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":SHRGH", OracleType.Char, 4),
new OracleParameter(":SHR", OracleType.VarChar, 60),
new OracleParameter(":SHSM", OracleType.VarChar, 300),
new OracleParameter(":SHSJ", OracleType.DateTime),
new OracleParameter(":YJSQDM", OracleType.VarChar, 300),
new OracleParameter(":SQDZT", OracleType.Char, 5),
new OracleParameter(":YJSQDH", OracleType.VarChar, 50)
};
parameters2[0].Value = (object)lsyjsqModel.LSZH ?? DBNull.Value;
parameters2[1].Value = (object)lsyjsqModel.SQSJ ?? DBNull.Value;
parameters2[2].Value = (object)lsyjsqModel.SQSM ?? DBNull.Value;
parameters2[3].Value = (object)lsyjsqModel.SFSC ?? DBNull.Value;
parameters2[4].Value = (object)lsyjsqModel.SHRGH ?? DBNull.Value;
parameters2[5].Value = (object)lsyjsqModel.SHR ?? DBNull.Value;
parameters2[6].Value = (object)lsyjsqModel.SHSM ?? DBNull.Value;
parameters2[7].Value = (object)lsyjsqModel.SHSJ ?? DBNull.Value;
parameters2[8].Value = (object)lsyjsqModel.YJSQDM ?? DBNull.Value;
parameters2[9].Value = (object)lsyjsqModel.SQDZT ?? DBNull.Value;
parameters2[10].Value = lsyjsqModel.YJSQDH;
hash.Add(strSql.ToString(), parameters2);
#endregion
#region 律师阅卷绑定
strSql.Clear();
strSql.Append("insert into YX_DZJZ_LSAJBD(");
strSql.Append("GH,BMSAH,MC,AJMC,AJLBBM,AJLBMC,YJKSSJ,YJJSSJ,YJZH,YJMM,JDSJ,JDR,JDRGH,JDBMBM,JDBMMC,JDDWBM,JDDWMC,SFSC,YJSQDH,YJXH,DWBM)");
strSql.Append(" values (");
strSql.Append(":GH,:BMSAH,:MC,:AJMC,:AJLBBM,:AJLBMC,:YJKSSJ,:YJJSSJ,:YJZH,:YJMM,:JDSJ,:JDR,:JDRGH,:JDBMBM,:JDBMMC,:JDDWBM,:JDDWMC,:SFSC,:YJSQDH,:YJXH,:DWBM)");
OracleParameter[] parameters3 =
{
new OracleParameter(":GH", OracleType.VarChar, 100),
new OracleParameter(":BMSAH", OracleType.VarChar, 100),
new OracleParameter(":MC", OracleType.VarChar, 60),
new OracleParameter(":AJMC", OracleType.VarChar, 300),
new OracleParameter(":AJLBBM", OracleType.VarChar, 50),
new OracleParameter(":AJLBMC", OracleType.VarChar, 50),
new OracleParameter(":YJKSSJ", OracleType.DateTime),
new OracleParameter(":YJJSSJ", OracleType.DateTime),
new OracleParameter(":YJZH", OracleType.VarChar, 100),
new OracleParameter(":YJMM", OracleType.Char, 8),
new OracleParameter(":JDSJ", OracleType.DateTime),
new OracleParameter(":JDR", OracleType.VarChar, 60),
new OracleParameter(":JDRGH", OracleType.Char, 4),
new OracleParameter(":JDBMBM", OracleType.Char, 4),
new OracleParameter(":JDBMMC", OracleType.VarChar, 300),
new OracleParameter(":JDDWBM", OracleType.VarChar, 50),
new OracleParameter(":JDDWMC", OracleType.VarChar, 300),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":YJSQDH", OracleType.VarChar, 50),
new OracleParameter(":YJXH", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50)
};
parameters3[0].Value = lsajbdModel.GH ?? "";
parameters3[1].Value = lsajbdModel.BMSAH ?? "";
parameters3[2].Value = lsajbdModel.MC ?? "";
parameters3[3].Value = lsajbdModel.AJMC ?? "";
parameters3[4].Value = lsajbdModel.AJLBBM ?? "";
parameters3[5].Value = lsajbdModel.AJLBMC ?? "";
parameters3[6].Value = lsajbdModel.YJKSSJ ?? (object)DBNull.Value;
parameters3[7].Value = lsajbdModel.YJJSSJ ?? (object)DBNull.Value;
parameters3[8].Value = lsajbdModel.YJZH ?? "";
parameters3[9].Value = lsajbdModel.YJMM ?? "";
parameters3[10].Value = lsajbdModel.JDSJ;
parameters3[11].Value = lsajbdModel.JDR ?? "";
parameters3[12].Value = lsajbdModel.JDRGH ?? "";
parameters3[13].Value = lsajbdModel.JDBMBM ?? "";
parameters3[14].Value = lsajbdModel.JDBMMC ?? "";
parameters3[15].Value = lsajbdModel.JDDWBM ?? "";
parameters3[16].Value = lsajbdModel.JDDWMC ?? "";
parameters3[17].Value = lsajbdModel.SFSC ?? "";
parameters3[18].Value = lsajbdModel.YJSQDH ?? "";
parameters3[19].Value = lsajbdModel.YJXH ?? "";
parameters3[20].Value = lsajbdModel.DWBM ?? "";
hash.Add(strSql.ToString(), parameters3);
#endregion
#region 律师阅卷文件绑定
foreach (EDRS.Model.YX_DZJZ_LSAJWJFP model in modelList)
{
strSql.Clear();
strSql.Append(" insert into YX_DZJZ_LSAJWJFP(");
strSql.Append("YJXH,WJXH,SFSC)");
strSql.Append(" values (");
strSql.AppendFormat(":YJXH{0},:WJXH{0},:SFSC{0})", count);
OracleParameter[] parameters =
{
new OracleParameter(":YJXH" + count, OracleType.VarChar, 50),
new OracleParameter(":WJXH" + count, OracleType.VarChar, 100),
new OracleParameter(":SFSC" + count, OracleType.Char, 1)
};
parameters[0].Value = lsajbdModel.YJXH;
parameters[1].Value = model.WJXH;
parameters[2].Value = "N";
hash.Add(strSql.ToString(), parameters);
count++;
}
#endregion
try
{
return(DbHelperOra.ExecuteSqlTran(hash));
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool AddList(EDRS.Model.YX_DZJZ_LSYJSQ lsyjsqModel, EDRS.Model.YX_DZJZ_LSAJBD lsajbdModel, List<EDRS.Model.YX_DZJZ_LSAJWJFP> modelList)", "EDRS.OracleDAL.YX_DZJZ_LSAJBD");
}
return(false);
}
/// <summary>
/// 保存分配案件文件
/// </summary>
/// <returns></returns>
private string AddData()
{
string json = Request.Form["json"];
string yjxh = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); //"山东省院捕受[2015]37000000054号";
string rybm = Request.Form["lszh_hidd"];
string[] rybms = rybm.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (rybms.Length != 2)
{
return(ReturnString.JsonToString(Prompt.error, "请选择阅卷人！", null));
}
if (Request.Form["txt_yjkssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjkssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "请设置阅卷开始时间！", null));
}
if (Request.Form["txt_yjjssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjjssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "请设置阅卷结束时间！", null));
}
if (Convert.ToDateTime(Request.Form["txt_yjkssj"]) > Convert.ToDateTime(Request.Form["txt_yjjssj"]))
{
return(ReturnString.JsonToString(Prompt.error, "结束时间不能小于开始时间！", null));
}
EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
EDRS.Model.TYYW_GG_AJJBXX ajmodel = ajbll.GetModel(Request.Form["key_hidd"]);
if (ajmodel == null)
{
return(ReturnString.JsonToString(Prompt.error, "分配失败，" + ((VersionName)0).ToString() + "不存在！", null));
}
//json = json.Replace("id", "_wjxh").Replace("MLLX", "_fpbm").Replace("text", "_sfsc").Replace("PARENTID", "_yjxh");
Random random = new Random();
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
model.GH = rybms[0];
model.BMSAH = ajmodel.BMSAH;
model.YJXH = yjxh;
model.MC = Request.Form["txt_lsxm"];
model.AJMC = ajmodel.AJMC;
model.AJLBBM = ajmodel.AJLB_BM;
model.AJLBMC = ajmodel.AJLB_MC;
model.YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]);
model.YJJSSJ = Convert.ToDateTime(Request.Form["txt_yjjssj"]);
model.YJZH = random.Next(100000, 999999).ToString();
model.YJMM = random.Next(100000, 999999).ToString();
model.JDSJ = DateTime.Now;
model.JDR = UserInfo.MC;
model.JDRGH = UserInfo.GH;
model.JDBMBM = "";
model.JDBMMC = "";
model.JDDWBM = UserInfo.DWBM;
model.JDDWMC = UserInfo.DWMC;
model.SFSC = "N";
model.YJSQDH = "";//Request.Form["yjsqdh"];
model.JZZTXS = "";
model.DWBM = rybms[1];
EDRS.BLL.YX_DZJZ_LSAJBD bllBD = new EDRS.BLL.YX_DZJZ_LSAJBD(Request);
List <EDRS.Model.YX_DZJZ_LSAJBD> listModel = bllBD.GetModelList(" and YJXH=:YJXH", new object[] { Request.Form["yjxh"] });
if (listModel == null || listModel.Count == 0)
{
if (!bllBD.Add(model))
{
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
}
else
{
yjxh = listModel[0].YJXH;
listModel[0].BMSAH = ajmodel.BMSAH;
listModel[0].GH = rybms[0];
listModel[0].DWBM = rybms[1];
listModel[0].MC = Request.Form["txt_lsxm"];
listModel[0].AJMC = ajmodel.AJMC;
listModel[0].AJLBBM = ajmodel.AJLB_BM;
listModel[0].AJLBMC = ajmodel.AJLB_MC;
listModel[0].YJKSSJ = Convert.ToDateTime(Request.Form["txt_yjkssj"]);
listModel[0].YJJSSJ = Convert.ToDateTime(Request.Form["txt_yjjssj"]);
if (!bllBD.Update(listModel[0]))
{
return(ReturnString.JsonToString(Prompt.error, "修改分配失败！", null));
}
}
List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList = JsonHelper.JsonToList <EDRS.Model.YX_DZJZ_LSAJWJFP>(json);
if (modelList != null && modelList.Count > 0)
{
EDRS.BLL.YX_DZJZ_LSAJWJFP bll = new EDRS.BLL.YX_DZJZ_LSAJWJFP(Request);
if (bll.AddList(modelList, model, yjxh))
{
return(ReturnString.JsonToString(Prompt.win, "分配成功！", null));
}
}
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
public object[] SetYjKh(string kh, string yjxh)
{
if (string.IsNullOrEmpty(kh) || string.IsNullOrEmpty(yjxh))
{
return(new object[] { false, "卡号和阅卷序号不能为空" });
}
EDRS.BLL.YX_DZJZ_LSAJBD bll = new EDRS.BLL.YX_DZJZ_LSAJBD(HttpContext.Current.Request);
try
{
DataSet ds = bll.GetYZYJZH(" and JDBMMC=:JDBMMC", new object[] { kh });
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
DataRow[] dr = ds.Tables[0].Select("SQDZT='X'");
if (dr.Length > 0)
{
return new object[] { false, "该卡正在使用" }
}
;
}
EDRS.Model.YX_DZJZ_LSAJBD model = bll.GetModel(yjxh);
if (model != null)
{
model.JDBMMC = kh;
try
{
if (bll.Update(model))
{
EDRS.BLL.YX_DZJZ_LSYJSQ bllsq = new EDRS.BLL.YX_DZJZ_LSYJSQ(HttpContext.Current.Request);
List <EDRS.Model.YX_DZJZ_LSYJSQ> list = bllsq.GetModelList(" and LSZH=:LSZH", new object[] { model.GH });
if (list != null && list.Count > 0)
{
list[0].SQDZT = "X";
if (bllsq.Update(list[0]))
{
return new object[] { true, "写卡成功" }
}
;
else
{
model.JDBMMC = "";
bll.Update(model);
}
}
}
}
catch (Exception ex)
{
return(new object[] { false, ex.Message });
}
return(new object[] { false, "写卡失败" });
}
return(new object[] { false, "阅卷信息不存在" });
}
}
catch (Exception ex)
{
return(new object[] { false, ex.Message });
}
return(new object[] { false, "验证卡号失败" });
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.YX_DZJZ_LSAJBD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_DZJZ_LSAJBD(");
strSql.Append("GH,BMSAH,MC,AJMC,AJLBBM,AJLBMC,YJKSSJ,YJJSSJ,YJZH,YJMM,JDSJ,JDR,JDRGH,JDBMBM,JDBMMC,JDDWBM,JDDWMC,SFSC,YJSQDH,YJXH,DWBM)");
strSql.Append(" values (");
strSql.Append(":GH,:BMSAH,:MC,:AJMC,:AJLBBM,:AJLBMC,:YJKSSJ,:YJJSSJ,:YJZH,:YJMM,:JDSJ,:JDR,:JDRGH,:JDBMBM,:JDBMMC,:JDDWBM,:JDDWMC,:SFSC,:YJSQDH,:YJXH,:DWBM)");
OracleParameter[] parameters =
{
new OracleParameter(":GH", OracleType.VarChar, 100),
new OracleParameter(":BMSAH", OracleType.VarChar, 100),
new OracleParameter(":MC", OracleType.VarChar, 60),
new OracleParameter(":AJMC", OracleType.VarChar, 300),
new OracleParameter(":AJLBBM", OracleType.VarChar, 50),
new OracleParameter(":AJLBMC", OracleType.VarChar, 50),
new OracleParameter(":YJKSSJ", OracleType.DateTime),
new OracleParameter(":YJJSSJ", OracleType.DateTime),
new OracleParameter(":YJZH", OracleType.VarChar, 100),
new OracleParameter(":YJMM", OracleType.Char, 8),
new OracleParameter(":JDSJ", OracleType.DateTime),
new OracleParameter(":JDR", OracleType.VarChar, 60),
new OracleParameter(":JDRGH", OracleType.Char, 4),
new OracleParameter(":JDBMBM", OracleType.Char, 4),
new OracleParameter(":JDBMMC", OracleType.VarChar, 300),
new OracleParameter(":JDDWBM", OracleType.VarChar, 50),
new OracleParameter(":JDDWMC", OracleType.VarChar, 300),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":YJSQDH", OracleType.VarChar, 50),
new OracleParameter(":YJXH", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50)
};
parameters[0].Value = model.GH ?? "";
parameters[1].Value = model.BMSAH ?? "";
parameters[2].Value = model.MC ?? "";
parameters[3].Value = model.AJMC ?? "";
parameters[4].Value = model.AJLBBM ?? "";
parameters[5].Value = model.AJLBMC ?? "";
parameters[6].Value = model.YJKSSJ;
parameters[7].Value = model.YJJSSJ;
parameters[8].Value = model.YJZH ?? "";
parameters[9].Value = model.YJMM ?? "";
parameters[10].Value = model.JDSJ;
parameters[11].Value = model.JDR ?? "";
parameters[12].Value = model.JDRGH ?? "";
parameters[13].Value = model.JDBMBM ?? "";
parameters[14].Value = model.JDBMMC ?? "";
parameters[15].Value = model.JDDWBM ?? "";
parameters[16].Value = model.JDDWMC ?? "";
parameters[17].Value = model.SFSC ?? "";
parameters[18].Value = model.YJSQDH ?? "";
parameters[19].Value = model.YJXH ?? "";
parameters[20].Value = model.DWBM ?? "";
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_LSAJBD model)", "EDRS.OracleDAL.YX_DZJZ_LSAJBD", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_LSAJBD DataRowToModel(DataRow row)
{
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
if (row != null)
{
if (row["GH"] != null)
{
model.GH = row["GH"].ToString();
}
if (row["DWBM"] != null)
{
model.DWBM = row["DWBM"].ToString();
}
if (row["BMSAH"] != null)
{
model.BMSAH = row["BMSAH"].ToString();
}
if (row["YJXH"] != null && row["YJXH"].ToString() != "")
{
model.YJXH = row["YJXH"].ToString();
}
if (row["MC"] != null)
{
model.MC = row["MC"].ToString();
}
if (row["AJMC"] != null)
{
model.AJMC = row["AJMC"].ToString();
}
if (row["AJLBBM"] != null)
{
model.AJLBBM = row["AJLBBM"].ToString();
}
if (row["AJLBMC"] != null)
{
model.AJLBMC = row["AJLBMC"].ToString();
}
if (row["YJKSSJ"] != null && row["YJKSSJ"].ToString() != "")
{
model.YJKSSJ = DateTime.Parse(row["YJKSSJ"].ToString());
}
if (row["YJJSSJ"] != null && row["YJJSSJ"].ToString() != "")
{
model.YJJSSJ = DateTime.Parse(row["YJJSSJ"].ToString());
}
if (row["YJZH"] != null)
{
model.YJZH = row["YJZH"].ToString();
}
if (row["YJMM"] != null)
{
model.YJMM = row["YJMM"].ToString();
}
if (row["JDSJ"] != null && row["JDSJ"].ToString() != "")
{
model.JDSJ = DateTime.Parse(row["JDSJ"].ToString());
}
if (row["JDR"] != null)
{
model.JDR = row["JDR"].ToString();
}
if (row["JDRGH"] != null)
{
model.JDRGH = row["JDRGH"].ToString();
}
if (row["JDBMBM"] != null)
{
model.JDBMBM = row["JDBMBM"].ToString();
}
if (row["JDBMMC"] != null)
{
model.JDBMMC = row["JDBMMC"].ToString();
}
if (row["JDDWBM"] != null)
{
model.JDDWBM = row["JDDWBM"].ToString();
}
if (row["JDDWMC"] != null)
{
model.JDDWMC = row["JDDWMC"].ToString();
}
if (row["SFSC"] != null)
{
model.SFSC = row["SFSC"].ToString();
}
if (row["YJSQDH"] != null)
{
model.YJSQDH = row["YJSQDH"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.YX_DZJZ_LSAJBD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_DZJZ_LSAJBD set ");
strSql.Append("MC=:MC,");
strSql.Append("AJMC=:AJMC,");
strSql.Append("AJLBBM=:AJLBBM,");
strSql.Append("AJLBMC=:AJLBMC,");
strSql.Append("YJKSSJ=:YJKSSJ,");
strSql.Append("YJJSSJ=:YJJSSJ,");
strSql.Append("YJZH=:YJZH,");
strSql.Append("YJMM=:YJMM,");
strSql.Append("JDSJ=:JDSJ,");
strSql.Append("JDR=:JDR,");
strSql.Append("JDRGH=:JDRGH,");
strSql.Append("JDBMBM=:JDBMBM,");
strSql.Append("JDBMMC=:JDBMMC,");
strSql.Append("JDDWBM=:JDDWBM,");
strSql.Append("JDDWMC=:JDDWMC,");
strSql.Append("SFSC=:SFSC,");
strSql.Append("YJSQDH=:YJSQDH,");
strSql.Append("GH=:GH,");
strSql.Append("BMSAH=:BMSAH,");
strSql.Append("DWBM=:DWBM");
strSql.Append(" where YJXH=:YJXH ");
OracleParameter[] parameters =
{
new OracleParameter(":MC", OracleType.VarChar, 60),
new OracleParameter(":AJMC", OracleType.VarChar, 300),
new OracleParameter(":AJLBBM", OracleType.VarChar, 50),
new OracleParameter(":AJLBMC", OracleType.VarChar, 50),
new OracleParameter(":YJKSSJ", OracleType.DateTime),
new OracleParameter(":YJJSSJ", OracleType.DateTime),
new OracleParameter(":YJZH", OracleType.VarChar, 100),
new OracleParameter(":YJMM", OracleType.Char, 8),
new OracleParameter(":JDSJ", OracleType.DateTime),
new OracleParameter(":JDR", OracleType.VarChar, 60),
new OracleParameter(":JDRGH", OracleType.Char, 4),
new OracleParameter(":JDBMBM", OracleType.Char, 4),
new OracleParameter(":JDBMMC", OracleType.VarChar, 300),
new OracleParameter(":JDDWBM", OracleType.VarChar, 50),
new OracleParameter(":JDDWMC", OracleType.VarChar, 300),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":YJSQDH", OracleType.VarChar, 50),
new OracleParameter(":GH", OracleType.VarChar, 100),
new OracleParameter(":BMSAH", OracleType.VarChar, 100),
new OracleParameter(":YJXH", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50)
};
parameters[0].Value = model.MC ?? (object)DBNull.Value;
parameters[1].Value = model.AJMC ?? (object)DBNull.Value;
parameters[2].Value = model.AJLBBM ?? (object)DBNull.Value;
parameters[3].Value = model.AJLBMC ?? (object)DBNull.Value;
parameters[4].Value = model.YJKSSJ ?? (object)DBNull.Value;
parameters[5].Value = model.YJJSSJ ?? (object)DBNull.Value;
parameters[6].Value = model.YJZH ?? (object)DBNull.Value;
parameters[7].Value = model.YJMM ?? (object)DBNull.Value;
parameters[8].Value = model.JDSJ ?? (object)DBNull.Value;
parameters[9].Value = model.JDR ?? (object)DBNull.Value;
parameters[10].Value = model.JDRGH ?? (object)DBNull.Value;
parameters[11].Value = model.JDBMBM ?? (object)DBNull.Value;
parameters[12].Value = model.JDBMMC ?? (object)DBNull.Value;
parameters[13].Value = model.JDDWBM ?? (object)DBNull.Value;
parameters[14].Value = model.JDDWMC ?? (object)DBNull.Value;
parameters[15].Value = model.SFSC ?? (object)DBNull.Value;
parameters[16].Value = model.YJSQDH ?? (object)DBNull.Value;
parameters[17].Value = model.GH ?? (object)DBNull.Value;
parameters[18].Value = model.BMSAH ?? (object)DBNull.Value;
parameters[19].Value = model.YJXH ?? (object)DBNull.Value;
parameters[20].Value = model.DWBM ?? (object)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_LSAJBD model)", "EDRS.OracleDAL.YX_DZJZ_LSAJBD", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 保存分配案件文件
/// </summary>
/// <returns></returns>
private string AddData()
{
string json = Request.Form["json"];
string yjxh = Guid.NewGuid().ToString().Replace("-", "").ToUpper(); //"山东省院捕受[2015]37000000054号";
string lssq = Request.Form["lssq"];
string[] lssqs = null;
if (string.IsNullOrEmpty(lssq))
{
return(ReturnString.JsonToString(Prompt.error, "请先填写阅卷登记信息！", null));
}
lssqs = lssq.Split(new string[] { "|&|" }, StringSplitOptions.None);
if (lssqs == null || lssqs.Length != 8)
{
return(ReturnString.JsonToString(Prompt.error, "填写的阅卷登记信息不正确！", null));
}
string rybm = "";// Request.Form["lszh_hidd"];
// string[] rybms = rybm.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries);
//if(rybms.Length != 2)
// return ReturnString.JsonToString(Prompt.error, "请选择阅卷人！", null);
/* 2016-9-6 取消设置阅卷时间
* if (Request.Form["txt_yjkssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjkssj"]))
* return ReturnString.JsonToString(Prompt.error, "请设置阅卷开始时间！", null);
* if (Request.Form["txt_yjjssj"] == null || string.IsNullOrEmpty(Request.Form["txt_yjjssj"]))
* return ReturnString.JsonToString(Prompt.error, "请设置阅卷结束时间！", null);
* if (Convert.ToDateTime(Request.Form["txt_yjkssj"]) > Convert.ToDateTime(Request.Form["txt_yjjssj"]))
* return ReturnString.JsonToString(Prompt.error, "结束时间不能小于开始时间！", null);
*/
EDRS.BLL.TYYW_GG_AJJBXX ajbll = new EDRS.BLL.TYYW_GG_AJJBXX(Request);
EDRS.Model.TYYW_GG_AJJBXX ajmodel = ajbll.GetModel(Request.Form["key_hidd"]);
if (ajmodel == null)
{
return(ReturnString.JsonToString(Prompt.error, "分配失败，" + ((VersionName)0).ToString() + "不存在！", null));
}
//json = json.Replace("id", "_wjxh").Replace("MLLX", "_fpbm").Replace("text", "_sfsc").Replace("PARENTID", "_yjxh");
#region 阅卷人信息
// localStorage['lssq'] = $("#txt_yjr").val() + "|&|" + zjlx + "|&|" + $("#txt_zjh").val() + "|&|" + yjrsf + "|&|" + cxyy + "|&|" + shr + "|&|" + shbm + "|&|" + $("#txt_shr").val();
EDRS.Model.YX_DZJZ_LSGL lsglModel = new EDRS.Model.YX_DZJZ_LSGL();
lsglModel.LSZH = Guid.NewGuid().ToString();
lsglModel.LSXM = lssqs[0]; //阅卷人
lsglModel.LSDW = lssqs[1]; //证件类型
lsglModel.LSDWDZ = lssqs[3]; //阅卷人身份
lsglModel.LSDWYZHM = "";
lsglModel.LSLXDH = lssqs[2]; //证件号
lsglModel.LSSJ = "";
lsglModel.DELXR = lssqs[4]; //查询原因
lsglModel.DELXRDH = "";
// lsglModel.LSZGYXSJ = ;
lsglModel.SFDXZG = "N";
lsglModel.LSXXBZ = "";
lsglModel.CJSJ = DateTime.Now;
lsglModel.ZHYCYJSJ = null;
lsglModel.SFSC = "N";
#endregion
#region 律师阅卷申请
EDRS.Model.YX_DZJZ_LSYJSQ modelLsyjsq = new EDRS.Model.YX_DZJZ_LSYJSQ();
modelLsyjsq.LSZH = lsglModel.LSZH;
modelLsyjsq.YJSQDH = Guid.NewGuid().ToString();
modelLsyjsq.SQSJ = DateTime.Now;
modelLsyjsq.SQSM = lssqs[6]; //审核部门
modelLsyjsq.SFSC = "N";
modelLsyjsq.SHRGH = lssqs[5]; //审核人工号
modelLsyjsq.SHR = lssqs[7]; //审核人
modelLsyjsq.SHSM = "";
modelLsyjsq.SHSJ = null;
modelLsyjsq.YJSQDM = "";
modelLsyjsq.SQDZT = "T";
#endregion
#region 律师阅卷绑定
Random random = new Random();
EDRS.Model.YX_DZJZ_LSAJBD model = new EDRS.Model.YX_DZJZ_LSAJBD();
model.GH = lsglModel.LSZH;
model.BMSAH = ajmodel.BMSAH;
model.YJXH = yjxh;
model.MC = lssqs[0];
model.AJMC = ajmodel.AJMC;
model.AJLBBM = ajmodel.AJLB_BM;
model.AJLBMC = ajmodel.AJLB_MC;
model.YJKSSJ = DateTime.Now; // Convert.ToDateTime(Request.Form["txt_yjkssj"]);
model.YJJSSJ = null; // Convert.ToDateTime(Request.Form["txt_yjjssj"]);
model.YJZH = lssqs[0];
model.YJMM = random.Next(100000, 999999).ToString();
model.JDSJ = DateTime.Now;
model.JDR = UserInfo.MC;
model.JDRGH = UserInfo.GH;
model.JDBMBM = "";
model.JDBMMC = "";
model.JDDWBM = UserInfo.DWBM;
model.JDDWMC = UserInfo.DWMC;
model.SFSC = "N";
model.YJSQDH = modelLsyjsq.YJSQDH;
model.JZZTXS = "";
model.DWBM = UserInfo.DWBM;
#endregion
#region 律师阅卷绑定文件
List <EDRS.Model.YX_DZJZ_LSAJWJFP> modelList = JsonHelper.JsonToList <EDRS.Model.YX_DZJZ_LSAJWJFP>(json);
#endregion
EDRS.BLL.YX_DZJZ_LSAJBD bllBD = new EDRS.BLL.YX_DZJZ_LSAJBD(Request);
try
{
if (bllBD.AddList(modelLsyjsq, model, modelList, lsglModel))
{
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配成功", "", UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//return ReturnString.JsonToString(Prompt.win, "分配成功！", null);
}
catch (Exception ex)
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(ex.Message), null));
}
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "分配失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "分配失败！", null));
}
