/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_LSYJSQ GetModel(string YJSQDH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select LSZH,YJSQDH,SQSJ,SQSM,SFSC,SHRGH,SHR,SHSM,SHSJ,YJSQDM,SQDZT from YX_DZJZ_LSYJSQ ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where YJSQDH=:YJSQDH ");
OracleParameter[] parameters =
{
new OracleParameter(":YJSQDH", OracleType.VarChar, 50)
};
parameters[0].Value = YJSQDH;
EDRS.Model.YX_DZJZ_LSYJSQ model = new EDRS.Model.YX_DZJZ_LSYJSQ();
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_LSYJSQ GetModel(string YJSQDH)", "EDRS.OracleDAL.YX_DZJZ_LSYJSQ", strSql.ToString(), parameters);
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public string applypass()
{
string state = Request.Form["state"];
string yjsqd = Request.Form["yjsqd"];
string shsm = Request.Form["shsm"];
EDRS.BLL.YX_DZJZ_LSYJSQ bll = new EDRS.BLL.YX_DZJZ_LSYJSQ(Request);
//判断非空
if (!string.IsNullOrEmpty(yjsqd))
{
if (state == "Y")
{
EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(yjsqd);
model.SHRGH = UserInfo.GH;
model.SHR = UserInfo.MC;
model.SQDZT = "Y";
model.SHSJ = DateTime.Now;
model.SHSM = "";
if (bll.Update(model))
{
return(ReturnString.JsonToString(Prompt.win, "审核成功", null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, "审核失败", null));
}
}
else
{
if (!string.IsNullOrEmpty(shsm))
{
EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(yjsqd);
model.SHRGH = UserInfo.GH;
model.SHR = UserInfo.MC;
model.SQDZT = "N";
model.SHSJ = DateTime.Now;
model.SHSM = shsm;
if (bll.Update(model))
{
return(ReturnString.JsonToString(Prompt.win, "审核成功", null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, "审核失败", null));
}
}
else
{
return(ReturnString.JsonToString(Prompt.error, "审核说明不能为空", null));
}
}
}
return(ReturnString.JsonToString(Prompt.error, "未获取文件信息", null));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_LSYJSQ DataRowToModel(DataRow row)
{
EDRS.Model.YX_DZJZ_LSYJSQ model = new EDRS.Model.YX_DZJZ_LSYJSQ();
if (row != null)
{
if (row["LSZH"] != null)
{
model.LSZH = row["LSZH"].ToString();
}
if (row["YJSQDH"] != null)
{
model.YJSQDH = row["YJSQDH"].ToString();
}
if (row["SQSJ"] != null && row["SQSJ"].ToString() != "")
{
model.SQSJ = DateTime.Parse(row["SQSJ"].ToString());
}
if (row["SQSM"] != null)
{
model.SQSM = row["SQSM"].ToString();
}
if (row["SFSC"] != null)
{
model.SFSC = row["SFSC"].ToString();
}
if (row["SHRGH"] != null)
{
model.SHRGH = row["SHRGH"].ToString();
}
if (row["SHR"] != null)
{
model.SHR = row["SHR"].ToString();
}
if (row["SHSM"] != null)
{
model.SHSM = row["SHSM"].ToString();
}
if (row["SHSJ"] != null && row["SHSJ"].ToString() != "")
{
model.SHSJ = DateTime.Parse(row["SHSJ"].ToString());
}
if (row["YJSQDM"] != null)
{
model.YJSQDM = row["YJSQDM"].ToString();
}
if (row["SQDZT"] != null)
{
model.SQDZT = row["SQDZT"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.YX_DZJZ_LSYJSQ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_DZJZ_LSYJSQ(");
strSql.Append("LSZH,SQSJ,SQSM,SFSC,SHRGH,SHR,SHSM,SHSJ,YJSQDM,SQDZT)");
strSql.Append(" values (");
strSql.Append(":LSZH,:SQSJ,:SQSM,:SFSC,:SHRGH,:SHR,:SHSM,:SHSJ,:YJSQDM,:SQDZT)");
OracleParameter[] parameters =
{
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)
};
parameters[0].Value = (object)model.LSZH ?? DBNull.Value;
parameters[1].Value = (object)model.SQSJ ?? DBNull.Value;
parameters[2].Value = (object)model.SQSM ?? DBNull.Value;
parameters[3].Value = (object)model.SFSC ?? DBNull.Value;
parameters[4].Value = (object)model.SHRGH ?? DBNull.Value;
parameters[5].Value = (object)model.SHR ?? DBNull.Value;
parameters[6].Value = (object)model.SHSM ?? DBNull.Value;
parameters[7].Value = (object)model.SHSJ ?? DBNull.Value;
parameters[8].Value = (object)model.YJSQDM ?? DBNull.Value;
parameters[9].Value = (object)model.SQDZT ?? 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 Add(EDRS.Model.YX_DZJZ_LSYJSQ model)", "EDRS.OracleDAL.YX_DZJZ_LSYJSQ", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 提交申请
/// </summary>
/// <returns></returns>
private string AddData()
{
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(this.Request);
//DataSet ds = bll.GetList(" and SFSC='N' and SQDZT<>'N' and YJSQDH=:YJSQDH", new string[] { Request.Form["txt_yjsqdh"] });
//if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
// return ReturnString.JsonToString(Prompt.error, "该阅卷申请单号已被申请过", null);
string zh = Request.Form["LSZH"];
if (string.IsNullOrEmpty(zh))
{
return(ReturnString.JsonToString(Prompt.error, "请选择律师姓名", null));
}
string dm = Request.Form["txt_yjsqdm"];
if (string.IsNullOrEmpty(dm))
{
return(ReturnString.JsonToString(Prompt.error, "申请单名不能为空", null));
}
Random random = new Random();
EDRS.Model.YX_DZJZ_LSYJSQ model = new EDRS.Model.YX_DZJZ_LSYJSQ();
model.LSZH = Request.Form["LSZH"];
model.YJSQDH = random.Next(100000, 999999).ToString();
model.SQSJ = DateTime.Now;
model.SQSM = Request.Form["txt_sqsm"];
model.SFSC = "N";
model.SHRGH = UserInfo.GH;
model.SHR = UserInfo.MC;
model.SHSM = "";
model.SHSJ = DateTime.Now;
model.YJSQDM = dm;
model.SQDZT = "T";
if (bll.Add(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "提交阅卷申请成功", model.YJSQDH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "提交阅卷申请失败", model.YJSQDH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
/// <summary>
/// 审核
/// </summary>
/// <returns></returns>
private string ExUpData()
{
string id = Request.Form.Get("key_ex_hidd").Trim();
if (string.IsNullOrEmpty(id))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(this.Request);
EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(id);
if (model != null)
{
model.SHSJ = DateTime.Now;
model.SQDZT = Request.Form["rad_sqdzt"];
model.SHSM = Request.Form["txt_shsm"];
model.SHR = UserInfo.MC;
model.SHRGH = UserInfo.GH;
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改参数配置成功", model.YJSQDH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改参数配置失败", model.YJSQDH, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改参数配置未找到信息", id, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
private string UpData()
{
string id = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(id))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(this.Request);
EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(id);
if (model != null)
{
model.LSZH = "";// Request.Form["txt_lszh"];
// model.YJSQDH = Request.Form["txt_yjsqdh"];
model.YJSQDM = Request.Form["txt_yjsqdm"];
model.SQSJ = DateTime.Now;
model.SQSM = Request.Form["txt_sqsm"];
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改阅卷申请成功", id, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改阅卷申请失败", id, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "修改阅卷申请-未找到修改信息", id, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
public string applypass()
{
string lszh = Request["lszh"];
string dysqdh = Request["dysqdh"];
string sqsj = Request["sqsj"];
// string shsm = Request["shsm"];
//判断非空
if (!string.IsNullOrEmpty(lszh) && !string.IsNullOrEmpty(sqsj) && !string.IsNullOrEmpty(dysqdh))
{
EDRS.BLL.YX_DZJZ_LSYJSQ bll = new EDRS.BLL.YX_DZJZ_LSYJSQ(Request);
{
EDRS.Model.YX_DZJZ_LSYJSQ model = new EDRS.Model.YX_DZJZ_LSYJSQ();
model.LSZH = lszh;
// model.YJSQDH = dysqdh;
model.SQSJ = Convert.ToDateTime(sqsj);
model.SQSM = "";
model.SFSC = "N";
model.SHRGH = UserInfo.GH;
model.SHR = UserInfo.MC;
model.SHSM = "";
model.SHSJ = DateTime.Now;
model.YJSQDM = dysqdh;
model.SQDZT = "Y";
if (bll.Add(model))
{
return(ReturnString.JsonToString(Prompt.win, "审核成功", null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, "审核失败", null));
}
}
}
return(ReturnString.JsonToString(Prompt.error, "未获取文件信息", null));
}
/// <summary>
/// 根据单位获取配置数据
/// </summary>
/// <param name="DWBM"></param>
/// <returns></returns>
private string GetModel(string id)
{
if (string.IsNullOrEmpty(id))
{
id = Request["id"];
if (string.IsNullOrEmpty(id))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(this.Request);
EDRS.Model.YX_DZJZ_LSYJSQ model = bll.GetModel(id);
if (model != null)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "根据编号获取阅读申请成功", id, UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.阅卷Web, "根据编号获取阅读申请-未找到信息", id, UserInfo, UserRole, this.Request);
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>
public bool Update(EDRS.Model.YX_DZJZ_LSYJSQ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_DZJZ_LSYJSQ set ");
strSql.Append("LSZH=:LSZH,");
strSql.Append("SQSJ=:SQSJ,");
strSql.Append("SQSM=:SQSM,");
strSql.Append("SFSC=:SFSC,");
strSql.Append("SHRGH=:SHRGH,");
strSql.Append("SHR=:SHR,");
strSql.Append("SHSM=:SHSM,");
strSql.Append("SHSJ=:SHSJ,");
strSql.Append("YJSQDM=:YJSQDM,");
strSql.Append("SQDZT=:SQDZT");
strSql.Append(" where YJSQDH=:YJSQDH ");
OracleParameter[] parameters =
{
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, 1),
new OracleParameter(":YJSQDH", OracleType.VarChar, 50)
};
parameters[0].Value = model.LSZH;
parameters[1].Value = model.SQSJ;
parameters[2].Value = model.SQSM;
parameters[3].Value = model.SFSC;
parameters[4].Value = model.SHRGH;
parameters[5].Value = model.SHR;
parameters[6].Value = model.SHSM;
parameters[7].Value = model.SHSJ;
parameters[8].Value = model.YJSQDM;
parameters[9].Value = model.SQDZT;
parameters[10].Value = model.YJSQDH;
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_LSYJSQ model)", "EDRS.OracleDAL.YX_DZJZ_LSYJSQ", 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));
}
