/// <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 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>
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;
}