/// <summary>
/// 增加当前处理用户的附件
/// </summary>
/// <param name="WFSUID">当前环节处理用户对应的编号</param>
public void function_Case_WorkFlowAttrach_smsj(string wfsaid, List <Doc_WfsasModel> WfsasList)
{
if (WfsasList != null && WfsasList.Count > 0)
{
foreach (Doc_WfsasModel item in WfsasList)
{
doc_wfsas wfsufModel = new doc_wfsas();
wfsufModel.wfsaid = wfsaid;
wfsufModel.filepath = item.filepath;
wfsufModel.filename = item.filename;
wfsufModel.dwfsasid = item.dwfsasid;
wfsufModel.ddid = item.ddid;
wfsufModel.filetyoe = item.filetyoe;
wfsufModel.createuserid = item.createuserid;
wfsufModel.createtime = item.createtime;
wfsufModel.caseid = item.caseid;
wfsufModel.lastwordpath = item.lastwordpath;
wfsufModel.lastpdfpath = item.lastpdfpath;
wfsufModel.lastdwfname = item.lastdwfname;
wfsufModel.lastdwfcode = item.lastdwfcode;
wfsufModel.ddtablename = item.ddtablename;
wfsufModel.ddtableid = item.ddtableid;
new Doc_WfsasDAL().Add(wfsufModel);
System.Threading.Thread.Sleep(500);
}
}
}
public void Add(doc_wfsas model)
{
Entities db = new Entities();
db.doc_wfsas.Add(model);
db.SaveChanges();
}
/// <summary>
/// 改变文书状态
/// </summary>
/// <param name="dwfsasid">文书表标识</param>
/// <param name="status">文书状态 -1,已删除,0正常,1已编辑</param>
/// <returns></returns>
public int EditDocumentStatus(int dwfsasid, int status)
{
using (Entities db = new Entities())
{
doc_wfsas model = db.doc_wfsas.FirstOrDefault(a => a.dwfsasid == dwfsasid);
model.status = status;
return(db.SaveChanges());
}
}
/// <summary>
/// 增加当前处理用户的附件
/// </summary>
public void function_AddWfsas(List <Doc_WfsasModel> WfsasList)
{
if (WfsasList != null && WfsasList.Count > 0)
{
foreach (Doc_WfsasModel item in WfsasList)
{
doc_wfsas wfsufModel = new doc_wfsas();
wfsufModel.wfsaid = item.wfsaid;
wfsufModel.filepath = item.filepath;
wfsufModel.filename = item.filename;
wfsufModel.dwfsasid = item.dwfsasid;
wfsufModel.ddid = item.ddid;
wfsufModel.filetyoe = item.filetyoe;
wfsufModel.createuserid = item.createuserid;
wfsufModel.createtime = DateTime.Now;
wfsufModel.caseid = item.caseid;
wfsufModel.lastwordpath = item.lastwordpath;
wfsufModel.lastpdfpath = item.lastpdfpath;
wfsufModel.lastdwfname = item.lastdwfname;
wfsufModel.lastdwfcode = item.lastdwfcode;
wfsufModel.ddtablename = item.ddtablename;
wfsufModel.ddtableid = item.ddtableid;
wfsufModel.status = item.status;
wfsufModel.documentid = item.documentid;
wfsufModel.dcjg = item.dcjg;
wfsufModel.wfss = item.wfss;
wfsufModel.ajdx = item.ajdx;
wfsufModel.ajdxremark = item.ajdxremark;
wfsufModel.jyaq = item.jyaq;
wfsufModel.xzcftype = item.xzcftype;
wfsufModel.xzcfje = item.xzcfje;
wfsufModel.xzcfnr = item.xzcfnr;
wfsufModel.xzcffs = item.xzcffs;
wfsufModel.dsrreplay = item.dsrreplay;
wfsufModel.dsryj = item.dsryj;
wfsufModel.cssbtime = item.cssbtime;
wfsufModel.sdremark = item.sdremark;
wfsufModel.dsrzxfs = item.dsrzxfs;
wfsufModel.sfyj = item.sfyj;
wfsufModel.yjdw = item.yjdw;
wfsufModel.yjtime = item.yjtime;
wfsufModel.xzcfbgbz = item.xzcfbgbz;
wfsufModel.xzcfbgclr = item.xzcfbgclr;
wfsufModel.xzcfbgcltime = item.xzcfbgcltime;
wfsufModel.tzjgsm = item.tzjgsm;
wfsufModel.tzclr = item.tzclr;
wfsufModel.tzcltime = item.tzcltime;
new Doc_WfsasDAL().Add(wfsufModel);
System.Threading.Thread.Sleep(500);
}
}
}
/// <summary>
/// 修改环节文书关系表
/// </summary>
/// <param name="DocModel"></param>
/// <returns></returns>
public int EditWFSASModel(int dwfsasid, string WordPath, string PDFPath, int userid)
{
using (Entities db = new Entities())
{
doc_wfsas model = db.doc_wfsas.FirstOrDefault(t => t.dwfsasid == dwfsasid);
model.lastwordpath = WordPath;
model.lastpdfpath = PDFPath;
model.createuserid = userid;
return(db.SaveChanges());
}
}
/// <summary>
/// 获取责令停止违法行为通知书文书编号
/// </summary>
/// <param name="wfsaid"></param>
/// <param name="ddid"></param>
/// <returns></returns>
public string GetZLTZWFXWTZSNumber(string wfsaid, int ddid)
{
Entities db = new Entities();
int year = DateTime.Now.Year;
doc_wfsas model = db.doc_wfsas.FirstOrDefault(t => t.wfsaid == wfsaid && t.ddid == ddid);
if (model == null)
{
string sql = string.Format(@"SELECT dw.dwfsasid,dw.wfsaid,dw.ddid,dw.filename,dw.documentid,dw.createtime,dw.status,wfs.wfsid,tz.id
FROM doc_wfsas dw
LEFT JOIN case_workflowspecificactivitys wfsa on dw.wfsaid = wfsa.wfsaid
LEFT JOIN case_workflowspecifics wfs on wfsa.wfsid = wfs.wfsid
LEFT JOIN temp_zltzwfxwtzs tz on dw.documentid = tz.id
WHERE dw.ddid = {0} AND DATE_FORMAT(dw.createtime,'%Y')={1} AND tz.id is not null
GROUP BY wfs.wfsid", ddid, year);
string countstr = (db.Database.SqlQuery <CaseList>(sql).Count() + 1).ToString("000");
return("秀综责停通字[" + year + "]第" + countstr + "号");
}
else
{
return(db.temp_zltzwfxwtzs.FirstOrDefault(t => t.id == model.documentid).wsbh);
}
}
/// <summary>
/// 根据案件流程id获取文书
/// </summary>
/// <param name="wfdid"></param>
/// <returns></returns>
public List <Doc_WfsasModel> GetWFSASList(string wfsaid, int ddid, int?phaseid = null, string wfdid = null)
{
List <Doc_WfsasModel> list = new List <Doc_WfsasModel>();
using (Entities db = new Entities())
{
IQueryable <Doc_WfsasModel> queryable = null;
doc_wfsas model = db.doc_wfsas.FirstOrDefault(t => t.wfsaid == wfsaid);
int? caseid = model.caseid;
int[] arr = new int[] { 9, 11, 12, 13, 14, 15, 16, 17 };
if (wfdid != null)
{
if (ddid == 47)
{
doc_wfsas smjmodel = db.doc_wfsas.FirstOrDefault(t => t.wfsaid == wfsaid && t.lastwordpath.Contains("文书扫描件"));
if (smjmodel != null)
{
queryable = from a in db.doc_wfsas
join dd in db.doc_definitions
on a.ddid equals dd.ddid
join wfsa in db.case_workflowspecificactivitys
on a.wfsaid equals wfsa.wfsaid
where wfsa.wfdid == wfdid && a.ddid == smjmodel.ddid && a.status == 0 && a.filetyoe != 4 && a.caseid == caseid
select new Doc_WfsasModel
{
dwfsasid = a.dwfsasid,
wfsaid = a.wfsaid,
ddid = a.ddid,
filetyoe = a.filetyoe,
filename = a.filename,
filepath = a.filepath,
createtime = a.createtime,
caseid = a.caseid,
lastpdfpath = a.lastpdfpath,
lastwordpath = a.lastwordpath,
ddtablename = a.ddtablename,
documentid = a.documentid,
status = a.status,
doccode = dd.doccode,
};
}
}
else
{
queryable = from a in db.doc_wfsas
join dd in db.doc_definitions
on a.ddid equals dd.ddid
join wfsa in db.case_workflowspecificactivitys
on a.wfsaid equals wfsa.wfsaid
where wfsa.wfdid == wfdid && a.ddid == ddid && a.status == 0 && a.filetyoe != 4 && a.caseid == caseid
select new Doc_WfsasModel
{
dwfsasid = a.dwfsasid,
wfsaid = a.wfsaid,
ddid = a.ddid,
filetyoe = a.filetyoe,
filename = a.filename,
filepath = a.filepath,
createtime = a.createtime,
caseid = a.caseid,
lastpdfpath = a.lastpdfpath,
lastwordpath = a.lastwordpath,
ddtablename = a.ddtablename,
documentid = a.documentid,
status = a.status,
doccode = dd.doccode,
};
}
}
if (phaseid != null)
{
if (arr.Contains(ddid))
{
queryable = from a in db.doc_wfsas
join dd in db.doc_definitions
on a.ddid equals dd.ddid
where a.ddid == ddid && a.status == 0 && a.filetyoe != 4 && a.caseid == caseid
select new Doc_WfsasModel
{
dwfsasid = a.dwfsasid,
wfsaid = a.wfsaid,
ddid = a.ddid,
filetyoe = a.filetyoe,
filename = a.filename,
filepath = a.filepath,
createtime = a.createtime,
caseid = a.caseid,
lastpdfpath = a.lastpdfpath,
lastwordpath = a.lastwordpath,
ddtablename = a.ddtablename,
documentid = a.documentid,
status = a.status,
doccode = dd.doccode,
};
}
else
{
queryable = from a in db.doc_wfsas
join dd in db.doc_definitions
on a.ddid equals dd.ddid
join wfsa in db.case_workflowspecificactivitys
on a.wfsaid equals wfsa.wfsaid
join wfd in db.case_workflowdetails
on wfsa.wfdid equals wfd.wfdid
where a.ddid == ddid && a.status == 0 && a.filetyoe != 4 && a.caseid == caseid && wfd.phaseid == phaseid
select new Doc_WfsasModel
{
dwfsasid = a.dwfsasid,
wfsaid = a.wfsaid,
ddid = a.ddid,
filetyoe = a.filetyoe,
filename = a.filename,
filepath = a.filepath,
createtime = a.createtime,
caseid = a.caseid,
lastpdfpath = a.lastpdfpath,
lastwordpath = a.lastwordpath,
ddtablename = a.ddtablename,
documentid = a.documentid,
status = a.status,
doccode = dd.doccode,
};
}
}
list = queryable.OrderBy(a => a.createtime).ToList();
}
return(list);
}
