/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_LSGL GetModel(string LSZH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select LSZH,LSXM,LSDW,T2.DwMC LSDWMC,LSDWDZ,LSDWYZHM,LSLXDH,LSSJ,DELXR,DELXRDH,LSZGYXSJ,SFDXZG,LSXXBZ,LSZZWJ1,LSZZWJ2,LSZZWJ3,LSZZWJ4,CJSJ,ZHYCYJSJ,T1.SFSC ");
strSql.Append(" FROM YX_DZJZ_LSGL T1 LEFT JOIN xt_zzjg_dwbm T2 ON(T1.Lsdw = T2.Dwbm) ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where LSZH=:LSZH ");
OracleParameter[] parameters =
{
new OracleParameter(":LSZH", OracleType.VarChar, 100)
};
parameters[0].Value = LSZH;
EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL();
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_LSGL GetModel(string LSZH)", "EDRS.OracleDAL.YX_DZJZ_LSGL", strSql.ToString(), parameters);
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.YX_DZJZ_LSGL model)
{
StringBuilder strSql = new StringBuilder();
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[] parameters =
{
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)
};
parameters[0].Value = model.LSZH;
parameters[1].Value = model.LSXM;
parameters[2].Value = model.LSDW;
parameters[3].Value = model.LSDWDZ;
parameters[4].Value = model.LSDWYZHM;
parameters[5].Value = model.LSLXDH;
parameters[6].Value = model.LSSJ;
parameters[7].Value = model.DELXR;
parameters[8].Value = model.DELXRDH;
parameters[9].Value = model.LSZGYXSJ;
parameters[10].Value = model.SFDXZG;
parameters[11].Value = model.LSXXBZ;
parameters[12].Value = model.CJSJ;
parameters[13].Value = model.ZHYCYJSJ ?? (object)DBNull.Value;
parameters[14].Value = model.SFSC;
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_LSGL model)", "EDRS.OracleDAL.YX_DZJZ_LSGL", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void AddData(HttpContext context)
{
EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL();
model.LSZH = context.Request["LSZH"];
model.LSXM = context.Request["LSXM"];
model.LSDW = context.Request["LSDW"];
model.LSDWDZ = context.Request["LSDWDZ"];
model.LSDWYZHM = context.Request["LSDWYZHM"];
model.LSLXDH = context.Request["LSLXDH"];
model.LSSJ = context.Request["LSSJ"];
model.DELXR = context.Request["DELXR"];
model.DELXRDH = context.Request["DELXRDH"];
model.LSZGYXSJ = Convert.ToDateTime(context.Request["LSZGYXSJ"]);
model.SFDXZG = "N";//this.SFDXZG.Checked ? "Y" : "N";
model.LSXXBZ = context.Request["LSXXBZ"];
model.LSZZWJ1 = "";
model.LSZZWJ2 = "";
model.LSZZWJ3 = "";
model.LSZZWJ4 = "";
string[] LSZZWJ = context.Request["LSZZWJ"].Split(',');
model.CJSJ = DateTime.Now;
EDRS.BLL.YX_DZJZ_LSGL bll = new YX_DZJZ_LSGL(context.Request);
if (bll.Add(model))
{
//成功后再保存资质文件关联
List <string> fileList = new List <string>();
foreach (string file in LSZZWJ)
{
if (file != "")
{
fileList.Add(file);
}
}
EDRS.BLL.YX_DZJZ_LSZZWJ WJBLL = new YX_DZJZ_LSZZWJ(context.Request);
if (fileList.Count == 0 || WJBLL.AddList(model.LSZH, fileList))
{
context.Response.Write(ReturnString.JsonToString(Prompt.win, "保存成功", null));
//true
}
else
{
context.Response.Write(ReturnString.JsonToString(Prompt.error, "保存失败", null));
//false
}
}
else
{
context.Response.Write(ReturnString.JsonToString(Prompt.error, "保存失败", null));
//false
}
}
private void GetModelPList(HttpContext context)
{
EDRS.BLL.YX_DZJZ_LSGL bll = new YX_DZJZ_LSGL(context.Request);
EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL();
string LSZH = context.Request["LSZH"];
if (string.IsNullOrEmpty(LSZH))
{
context.Response.Write(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
model = bll.GetModel(LSZH);
if (model != null)
{
context.Response.Write(EDRS.Common.JsonHelper.JsonString(model));
}
else
{
context.Response.Write(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
}
/// <summary>
/// 添加律师
/// </summary>
/// <returns></returns>
private string AddLS()
{
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL();
model.LSZH = Request.Form["lszh"];
model.LSXM = Request.Form["lsxm"];
model.LSDW = Request.Form["lsdw"];
model.LSDWDZ = Request.Form["lsdwdz"];
model.LSDWYZHM = Request.Form["lsdwyzh"];
model.LSLXDH = Request.Form["lslxdh"];
model.LSSJ = Request.Form["lssj"];
model.DELXR = Request.Form["delxr"];
model.DELXRDH = Request.Form["delxrdh"];
model.LSZGYXSJ = Convert.ToDateTime(Request.Form["lszgyxsj"]);
model.SFDXZG = Request.Form["sfdxzg"] == "0" ? "N" : "Y";
model.LSXXBZ = Request.Form["lsxxbz"];
model.CJSJ = DateTime.Now;
model.ZHYCYJSJ = null;
model.SFSC = "N";
EDRS.BLL.YX_DZJZ_LSGL bll = new EDRS.BLL.YX_DZJZ_LSGL(this.Request);
//添加资质文件
EDRS.BLL.YX_DZJZ_LSZZWJ zzbll = new EDRS.BLL.YX_DZJZ_LSZZWJ(this.Request);
string idstr = Request.Form["filestr[]"];
//判断律师证号是否重复
if (bll.Exists(model.LSZH))
{
return(ReturnString.JsonToString(Prompt.error, "该律师证号已被使用,请重置", null));
}
//添加律师
if (bll.Add(model))
{
//判断是否添加附件
if (!string.IsNullOrEmpty(idstr))
{
string[] idarr = idstr.Split(',');
List <string> filestr = new List <string>();
for (int i = 0; i < idarr.Length; i++)
{
filestr.Add(idarr[i]);
}
//添加律师资质文件
if (zzbll.AddList(model.LSZH, filestr))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "添加律师成功", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "添加律师成功", "", 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));
}
/// <summary>
/// 修改律师信息
/// </summary>
/// <returns></returns>
private string UpData()
{
string lszh = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(lszh))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
EDRS.BLL.YX_DZJZ_LSGL bll = new EDRS.BLL.YX_DZJZ_LSGL(this.Request);
EDRS.Model.YX_DZJZ_LSGL model = bll.GetModel(lszh);
//添加资质文件
EDRS.BLL.YX_DZJZ_LSZZWJ zzbll = new EDRS.BLL.YX_DZJZ_LSZZWJ(this.Request);
string idstr = Request.Form.Get("key_arrlife");
if (model != null)
{
model.LSXM = Request.Form.Get("txt_lsxm");
model.LSDW = Request.Form.Get("txt_lsdw");
model.LSDWDZ = Request.Form.Get("txt_lsdwdz");
model.LSDWYZHM = Request.Form.Get("txt_lsdwyzh");
model.LSLXDH = Request.Form.Get("txt_lslxdh");
model.LSSJ = Request.Form.Get("txt_lssj");
model.DELXR = Request.Form.Get("txt_delxr");
model.DELXRDH = Request.Form.Get("txt_delxrdh");
model.LSZGYXSJ = Convert.ToDateTime(Request.Form.Get("txt_lszgyxsj"));
model.SFDXZG = Request.Form.Get("txt_sfdxzg") == "0" ? "N" : "Y";
model.LSXXBZ = Request.Form.Get("txt_lsxxbz");
model.CJSJ = DateTime.Now;
model.ZHYCYJSJ = null;
model.SFSC = "N";
if (bll.Update(model))
{
if (!string.IsNullOrEmpty(idstr))
{
string[] idarr = idstr.Split(',');
List <string> filestr = new List <string>();
for (int i = 0; i < idarr.Length; i++)
{
filestr.Add(idarr[i]);
}
//添加律师资质文件
if (zzbll.AddList(model.LSZH, filestr))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改律师信息成功", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改律师信息成功", "", 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));
}
//数据日志
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 EDRS.Model.YX_DZJZ_LSGL DataRowToModel(DataRow row)
{
EDRS.Model.YX_DZJZ_LSGL model = new EDRS.Model.YX_DZJZ_LSGL();
if (row != null)
{
if (row["LSZH"] != null)
{
model.LSZH = row["LSZH"].ToString();
}
if (row["LSXM"] != null)
{
model.LSXM = row["LSXM"].ToString();
}
if (row["LSDW"] != null)
{
model.LSDW = row["LSDW"].ToString();
}
if (row["LSDWMC"] != null)
{
model.LSDWMC = row["LSDWMC"].ToString();
}
if (row["LSDWDZ"] != null)
{
model.LSDWDZ = row["LSDWDZ"].ToString();
}
if (row["LSDWYZHM"] != null)
{
model.LSDWYZHM = row["LSDWYZHM"].ToString();
}
if (row["LSLXDH"] != null)
{
model.LSLXDH = row["LSLXDH"].ToString();
}
if (row["LSSJ"] != null)
{
model.LSSJ = row["LSSJ"].ToString();
}
if (row["DELXR"] != null)
{
model.DELXR = row["DELXR"].ToString();
}
if (row["DELXRDH"] != null)
{
model.DELXRDH = row["DELXRDH"].ToString();
}
if (row["LSZGYXSJ"] != null && row["LSZGYXSJ"].ToString() != "")
{
model.LSZGYXSJ = DateTime.Parse(row["LSZGYXSJ"].ToString());
}
if (row["SFDXZG"] != null)
{
model.SFDXZG = row["SFDXZG"].ToString();
}
if (row["LSXXBZ"] != null)
{
model.LSXXBZ = row["LSXXBZ"].ToString();
}
if (row["LSZZWJ1"] != null)
{
model.LSZZWJ1 = row["LSZZWJ1"].ToString();
}
if (row["LSZZWJ2"] != null)
{
model.LSZZWJ2 = row["LSZZWJ2"].ToString();
}
if (row["LSZZWJ3"] != null)
{
model.LSZZWJ3 = row["LSZZWJ3"].ToString();
}
if (row["LSZZWJ4"] != null)
{
model.LSZZWJ4 = row["LSZZWJ4"].ToString();
}
if (row["CJSJ"] != null && row["CJSJ"].ToString() != "")
{
model.CJSJ = DateTime.Parse(row["CJSJ"].ToString());
}
if (row["ZHYCYJSJ"] != null && row["ZHYCYJSJ"].ToString() != "")
{
model.ZHYCYJSJ = DateTime.Parse(row["ZHYCYJSJ"].ToString());
}
if (row["SFSC"] != null)
{
model.SFSC = row["SFSC"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.YX_DZJZ_LSGL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_DZJZ_LSGL set ");
strSql.Append("LSXM=:LSXM,");
strSql.Append("LSDW=:LSDW,");
strSql.Append("LSDWDZ=:LSDWDZ,");
strSql.Append("LSDWYZHM=:LSDWYZHM,");
strSql.Append("LSLXDH=:LSLXDH,");
strSql.Append("LSSJ=:LSSJ,");
strSql.Append("DELXR=:DELXR,");
strSql.Append("DELXRDH=:DELXRDH,");
strSql.Append("LSZGYXSJ=:LSZGYXSJ,");
strSql.Append("SFDXZG=:SFDXZG,");
strSql.Append("LSXXBZ=:LSXXBZ,");
strSql.Append("ZHYCYJSJ=:ZHYCYJSJ,");
strSql.Append("SFSC=:SFSC");
strSql.Append(" where LSZH=:LSZH ");
OracleParameter[] parameters =
{
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(":LSZH", OracleType.VarChar, 100),
new OracleParameter(":ZHYCYJSJ", OracleType.DateTime),
new OracleParameter(":SFSC", OracleType.Char, 1)
};
parameters[0].Value = model.LSXM;
parameters[1].Value = model.LSDW;
parameters[2].Value = model.LSDWDZ;
parameters[3].Value = model.LSDWYZHM;
parameters[4].Value = model.LSLXDH;
parameters[5].Value = model.LSSJ;
parameters[6].Value = model.DELXR;
parameters[7].Value = model.DELXRDH;
parameters[8].Value = model.LSZGYXSJ;
parameters[9].Value = model.SFDXZG;
parameters[10].Value = model.LSXXBZ;
parameters[11].Value = model.LSZH;
parameters[12].Value = model.ZHYCYJSJ ?? (object)DBNull.Value;
parameters[13].Value = model.SFSC;
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_LSGL model)", "EDRS.OracleDAL.YX_DZJZ_LSGL", 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));
}
