/// <summary> /// 导出Excel /// </summary> /// <param name="ID">预备方案ID</param> /// <returns></returns> public ActionResult Export(string ID, string Type) { Common.ClientResult.Result result = new Common.ClientResult.Result(); ReportBLL reportBll = new ReportBLL(); string Message = string.Empty; bool IsSuccess = false; FILE_UPLOADER fEntity = null; if (Type == "OriginalRecord") { IsSuccess = reportBll.ExportOriginalRecord(ID, GetCurrentPerson(), out Message, out fEntity); } else { IsSuccess = reportBll.ExportReport(ID, GetCurrentPerson(), out Message, out fEntity); } if (IsSuccess) { result.Code = Common.ClientCode.Succeed; result.Message = Message; } else { result.Code = Common.ClientCode.Fail; result.Message = Message + "错误一"; } return(Json(result)); //返回 }
/// <summary> /// 创建一个附件 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据库上下文</param> /// <param name="entity">一个附件</param> /// <returns></returns> public bool Create(ref ValidationErrors validationErrors, FILE_UPLOADER entity) { try { string err = string.Empty; // DeleteByPREPARE_SCHEMEID(entity.PREPARE_SCHEMEID,entity.CREATEPERSON); repository.Create(entity); if (!string.IsNullOrWhiteSpace(entity.STATE2) && entity.STATE2 == "已上传")//原始记录 { Langben.Report.ReportBLL re = new Langben.Report.ReportBLL(); return(re.UpdateFuJianRemark(entity.PREPARE_SCHEMEID, out err)); } //if (chuanzhi == "Y") //{ // file.STATE2 = Common.PACKAGETYPE.已上传.ToString(); //} //else //{ // file.STATE = Common.PACKAGETYPE.已上传.ToString(); //} return(true); } catch (Exception ex) { validationErrors.Add(ex.Message + "创建错误"); validationErrors.Add(ex.Source); ExceptionsHander.WriteExceptions(ex); } return(false); }
/// <summary> /// 解析上传返回字符串 /// </summary> /// <param name="rod"></param> /// <returns></returns> public FILE_UPLOADER JieXi(string rod) { FILE_UPLOADER uplo = new FILE_UPLOADER(); rod = rod.TrimStart('{').TrimEnd('}'); //rod = rod.Substring(0, rod.Length - 1).TrimEnd('}');//去掉头尾{} string[] mg = rod.Split(','); for (int i = 0; i < mg.Length; i++)//解析上传文件方法返回的字符串 { string[] m = mg[i].Split('*'); switch (m[0].ToString()) { case "NAME": uplo.NAME = m[1]; break; case "NAME2": uplo.NAME2 = m[1]; break; case "PATH": uplo.PATH = m[1]; break; case "PATH2": uplo.PATH2 = m[1]; break; case "FULLPATH": uplo.FULLPATH = m[1]; break; case "FULLPATH2": uplo.FULLPATH2 = m[1]; break; case "SUFFIX": uplo.SUFFIX = m[1]; break; case "SUFFIX2": uplo.SUFFIX2 = m[1]; break; case "SIZE": uplo.SIZE = Convert.ToInt32(m[1]); break; case "SIZE2": uplo.SIZE2 = Convert.ToInt32(m[1]); break; default: break; } } return(uplo); }
/// <summary> /// 通过预备方案id,判断器具是否为上传报告 /// </summary> /// <param name="id"></param> /// <returns></returns> public string GetPREPARE_SCHEMEID(string id) { FILE_UPLOADER item = m_BLL.GetPREPARE_SCHEMEID(id); if (!string.IsNullOrEmpty(item.PREPARE_SCHEMEID)) { return("Yes"); } else { return("No"); } }
/// <summary> /// 编辑一个附件 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="entity">一个附件</param> /// <returns></returns> public bool EditField(ref ValidationErrors validationErrors, FILE_UPLOADER entity) { try { repository.EditField(db, entity); repository.Save(db); return(true); } catch (Exception ex) { validationErrors.Add(ex.Message); ExceptionsHander.WriteExceptions(ex); } return(false); }
public ActionResult ZaiXianShenHe(string id) { Common.Account account = GetCurrentAccount(); string APPLIANCE_DETAIL_INFORMATIONID = string.Empty; string[] IDD = id.Split('^'); PREPARE_SCHEME pr = m_BLL4.GetById(IDD[0]); FILE_UPLOADER file = m_BLL2.GetPREPARE_SCHEMEID(IDD[0]); //IList<APPLIANCE_LABORATORY> appliance = m_BLL3.GetByRefPREPARE_SCHEMEID(IDD[0]); foreach (var item in pr.APPLIANCE_LABORATORY) { if (IDD[1] == "H") { if (account.UNDERTAKE_LABORATORYName == item.UNDERTAKE_LABORATORYID) { APPLIANCE_DETAIL_INFORMATIONID = item.APPLIANCE_DETAIL_INFORMATIONID; ViewBag.REPORTSTATUS = item.PREPARE_SCHEME.REPORTSTATUS;//报告状态用来判断是否启用 } } else { APPLIANCE_DETAIL_INFORMATIONID = item.APPLIANCE_DETAIL_INFORMATIONID; ViewBag.REPORTSTATUS = item.PREPARE_SCHEME.REPORTSTATUS;//报告状态用来判断是否启用 } } ViewBag.HEIFSP = IDD[1]; //判断是审核的下载预览还是审批的下载预览 ViewBag.FILE_UPLOADER_ID = IDD[0]; //附件的id ViewBag.PREPARE_SCHEME_ID = file.PREPARE_SCHEMEID; //预备方案的id ViewBag.APPLIANCE_DETAIL_INFORMATIONID = APPLIANCE_DETAIL_INFORMATIONID; //器具明细的id int end = file.FULLPATH.LastIndexOf("\\up"); string dizhi = file.FULLPATH.Substring(end); int end2 = file.FULLPATH2.LastIndexOf("\\up"); string dizhi2 = file.FULLPATH2.Substring(end); string x = "/"; string sx = @"\"; ViewBag.FULLPATH = dizhi.Replace(sx, x); //证书地址 ViewBag.FULLPATH2 = dizhi2.Replace(sx, x); //原始记录地址 ViewBag.NAME = file.NAME; //证书名字 ViewBag.NAME2 = file.NAME2; //原始记录 ViewBag.CONCLUSION = file.CONCLUSION; //结论 ViewBag.AUDITOPINION = pr.AUDITOPINION; //审核意见 ViewBag.APPROVAL = pr.APPROVAL; //审批意见 ViewBag.id = id; return(View()); }
/// <summary> /// 创建一个附件 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据库上下文</param> /// <param name="entity">一个附件</param> /// <returns></returns> public bool Create(ref ValidationErrors validationErrors, FILE_UPLOADER entity) { try { //DeleteByPREPARE_SCHEMEID(entity.PREPARE_SCHEMEID,entity.CREATEPERSON); repository.Create(entity); return(true); } catch (Exception ex) { validationErrors.Add(ex.Message + "创建错误"); validationErrors.Add(ex.Source); ExceptionsHander.WriteExceptions(ex); } return(false); }
public JsonResult ShengHe(PREPARE_SCHEME ps) { string[] id = ps.ID.Split('|'); ps.ID = id[0]; ps.PACKAGETYPE = Common.PACKAGETYPE..ToString(); bool ef = m_BLL3.EditField(ref validationErrors, ps); FILE_UPLOADER fu = new FILE_UPLOADER(); fu.ID = id[1]; fu.CONCLUSION = ps.CONCLUSION; bool ef2 = m_BLL2.EditField(ref validationErrors, fu); Hashtable hb = new Hashtable(); hb.Add("FX", ef == true && ef2 == true?true:false); return(Json(hb)); }
/// <summary> /// 编辑一个附件 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="entity">一个附件</param> /// <returns></returns> public bool EditField(ref ValidationErrors validationErrors, FILE_UPLOADER entity) { try { repository.EditField(db, entity); Langben.Report.ReportBLL re = new Langben.Report.ReportBLL(); string err = string.Empty; re.UpdateFuJianRemark(entity.PREPARE_SCHEMEID, out err); repository.Save(db); return(true); } catch (Exception ex) { validationErrors.Add(ex.Message); ExceptionsHander.WriteExceptions(ex); } return(false); }
/// <summary> /// 报告上传功能 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// <returns></returns> public JsonResult ShangChuang(object sender, EventArgs e) { HttpPostedFileBase files = Request.Files["file"]; string chuanzhi = Request["chuanzhi"].ToString(); string PREPARE_SCHEMEID = Request["PREPARE_SCHEMEID"].ToString(); string FILE_UPLOADERID = Request["FILE_UPLOADERID"].ToString(); FILE_UPLOADER file = JieXi((new UploadFiles()).ReportToUpload(files, files.FileName, chuanzhi == "Y" ? 0 : 1));//上传文件,解析 file.PREPARE_SCHEMEID = PREPARE_SCHEMEID; file.REMARK = "33_13|35_13|37_13";//添加签名位置 if (chuanzhi == "Y") { file.STATE2 = Common.PACKAGETYPE.已上传.ToString(); } else { file.STATE = Common.PACKAGETYPE.已上传.ToString(); } if (string.IsNullOrWhiteSpace(FILE_UPLOADERID)) { file.ID = Result.GetNewId(); file.CREATETIME = DateTime.Now; //创建时间 file.CREATEPERSON = GetCurrentPerson(); //创建人 bool fh = m_BLL2.Create(ref validationErrors, file); Hashtable hash = new Hashtable(); hash.Add("FH", true); hash.Add("Name", files.FileName); hash.Add("FILE_UPLOADERID", file.ID); return(Json(hash)); } else { file.ID = FILE_UPLOADERID; file.UPDATETIME = DateTime.Now; file.UPDATEPERSON = GetCurrentPerson(); bool fh = m_BLL2.EditField(ref validationErrors, file);//上传信息修改附件表中 Hashtable hash = new Hashtable(); hash.Add("FH", fh); hash.Add("Name", files.FileName); hash.Add("FILE_UPLOADERID", FILE_UPLOADERID); return(Json(hash)); } }
/// <summary> /// 创建 /// </summary> /// <param name="entity">实体对象</param> /// <returns></returns> public Common.ClientResult.Result Post([FromBody] FILE_UPLOADER entity) { Common.ClientResult.Result result = new Common.ClientResult.Result(); if (entity != null && ModelState.IsValid) { string currentPerson = GetCurrentPerson(); entity.CREATETIME = DateTime.Now; entity.CREATEPERSON = currentPerson; entity.ID = Result.GetNewId(); string returnValue = string.Empty; if (m_BLL.Create(ref validationErrors, entity)) { LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + ",附件的信息的Id为" + entity.ID, "附件" );//写入日志 result.Code = Common.ClientCode.Succeed; result.Message = Suggestion.InsertSucceed; return(result); //提示创建成功 } else { if (validationErrors != null && validationErrors.Count > 0) { validationErrors.All(a => { returnValue += a.ErrorMessage; return(true); }); } LogClassModels.WriteServiceLog(Suggestion.InsertFail + ",附件的信息," + returnValue, "附件" );//写入日志 result.Code = Common.ClientCode.Fail; result.Message = Suggestion.InsertFail + returnValue; return(result); //提示插入失败 } } result.Code = Common.ClientCode.FindNull; result.Message = Suggestion.InsertFail + ",请核对输入的数据的格式"; //提示输入的数据的格式不对 return(result); }
// PUT api/<controller>/5 /// <summary> /// 编辑 /// </summary> /// <param name="entity"></param> /// <returns></returns> public Common.ClientResult.Result Put([FromBody] FILE_UPLOADER entity) { Common.ClientResult.Result result = new Common.ClientResult.Result(); if (entity != null && ModelState.IsValid) { //数据校验 string currentPerson = GetCurrentPerson(); entity.UPDATETIME = DateTime.Now; entity.UPDATEPERSON = currentPerson; string returnValue = string.Empty; if (m_BLL.Edit(ref validationErrors, entity)) { LogClassModels.WriteServiceLog(Suggestion.UpdateSucceed + ",附件信息的Id为" + entity.ID, "附件" );//写入日志 result.Code = Common.ClientCode.Succeed; result.Message = Suggestion.UpdateSucceed; return(result); //提示更新成功 } else { if (validationErrors != null && validationErrors.Count > 0) { validationErrors.All(a => { returnValue += a.ErrorMessage; return(true); }); } LogClassModels.WriteServiceLog(Suggestion.UpdateFail + ",附件信息的Id为" + entity.ID + "," + returnValue, "附件" );//写入日志 result.Code = Common.ClientCode.Fail; result.Message = Suggestion.UpdateFail + returnValue; return(result); //提示更新失败 } } result.Code = Common.ClientCode.FindNull; result.Message = Suggestion.UpdateFail + "请核对输入的数据的格式"; return(result); //提示输入的数据的格式不对 }
/// <summary> /// 根据ID获取数据模型 /// </summary> /// <param name="id">编号</param> /// <returns></returns> public FILE_UPLOADER Get(string id) { FILE_UPLOADER item = m_BLL.GetById(id); return(item); }
public ActionResult BaoGaoShangChuan(FILE_UPLOADER file, string REPORTNUMBER)//文档上传 { PREPARE_SCHEME pre = new PREPARE_SCHEME(); pre.REPORTNUMBER = REPORTNUMBER;//证书编号 pre.PACKAGETYPE = Common.PACKAGETYPE..ToString(); if (!string.IsNullOrWhiteSpace(file.UNQUALIFIEDTYPE)) { pre.UNQUALIFIEDTYPE = file.UNQUALIFIEDTYPE.ToString();//不合格类型 } string msg = string.Empty; if (Request.Files.Count > 0)//前端获取文件选择控件值 { for (int i = 0; i < Request.Files.Count; i++) { HttpPostedFileBase pstFile = Request.Files[i]; //获取页面选择的文件 string upfile = pstFile.FileName; //文件名 UploadFiles upFiles = new UploadFiles(); msg += upFiles.ReportToUpload(pstFile, upfile, i); //上传文件 } } //JavaScriptSerializer js = new JavaScriptSerializer(); //FILE_UPLOADER jg = js.Deserialize<FILE_UPLOADER>(msg); //jg.PREPARE_SCHEMEID = file.ID; //jg.CONCLUSION = file.CONCLUSION; FILE_UPLOADER uplo = new FILE_UPLOADER(); msg = msg.Substring(1, msg.Length - 1).TrimEnd('}'); //去掉头尾{} string[] mg = msg.Split(','); for (int i = 0; i < mg.Length; i++) //解析上传文件方法返回的字符串 { string[] m = mg[i].Split('*'); switch (m[0].ToString()) { case "NAME": uplo.NAME = m[1]; break; case "NAME2": uplo.NAME2 = m[1]; break; case "PATH": uplo.PATH = m[1]; break; case "PATH2": uplo.PATH2 = m[1]; break; case "FULLPATH": uplo.FULLPATH = m[1]; break; case "FULLPATH2": uplo.FULLPATH2 = m[1]; break; case "SUFFIX": uplo.SUFFIX = m[1]; break; case "SUFFIX2": uplo.SUFFIX2 = m[1]; break; case "SIZE": uplo.SIZE = Convert.ToInt32(m[1]); break; case "SIZE2": uplo.SIZE2 = Convert.ToInt32(m[1]); break; default: break; } } uplo.PREPARE_SCHEMEID = file.PREPARE_SCHEMEID; //预备方案ID pre.ID = file.PREPARE_SCHEMEID; //预备方案ID(修改) uplo.CONCLUSION = file.CONCLUSION; //结论 uplo.REMARK = "33_13|35_13|37_13"; //添加签名位置 bool Create = false; bool Edit = false; if (string.IsNullOrEmpty(file.ID))//判断是否为第一次进入 { uplo.ID = Result.GetNewId(); uplo.CREATETIME = DateTime.Now; //创建时间 uplo.CREATEPERSON = GetCurrentPerson(); //创建人 uplo.STATE = Common.PACKAGETYPE.已上传.ToString(); Create = m_BLL2.Create(ref validationErrors, uplo); //上传信息写入附件表中 if (Create) { Create = m_BLL3.EditField(ref validationErrors, pre); } if (Create) { ViewBag.Create = "True"; ViewBag.Edit = ""; ViewBag.NAME2 = uplo.NAME2; //原始记录名称 ViewBag.NAME = uplo.NAME; //证书名称 } else { ViewBag.Create = "False"; ViewBag.Edit = ""; ViewBag.NAME2 = file.NAME2; //原始记录名称 ViewBag.NAME = file.NAME; //证书名称 } } else { uplo.ID = file.ID; uplo.UPDATETIME = DateTime.Now; //修改时间 uplo.UPDATEPERSON = GetCurrentPerson(); //修改人 Edit = m_BLL2.EditField(ref validationErrors, uplo); //上传信息修改附件表中 if (Edit) { //FILE_UPLOADER file_uplo = m_BLL2.GetById(uplo.ID);//取预备方案id // pre.ID = file_uplo.PREPARE_SCHEMEID; Edit = m_BLL3.EditField(ref validationErrors, pre); } if (Edit) { ViewBag.Edit = "True"; ViewBag.Create = ""; ViewBag.NAME2 = uplo.NAME2; //原始记录名称 ViewBag.NAME = uplo.NAME; //证书名称 } else { ViewBag.Edit = "False"; ViewBag.Create = ""; ViewBag.NAME2 = file.NAME2; //原始记录名称 ViewBag.NAME = file.NAME; //证书名称 }; } Langben.Report.ReportBLL rbll = new Report.ReportBLL(); string err = ""; rbll.UpdateFuJianRemark2_YuanShiJiLu(uplo.PREPARE_SCHEMEID, out err); //返回执行结果是新增还是修改并给出结论 ViewBag.FILE_UPLOADERID = uplo.ID; ViewBag.REPORTSTATUS = null; ViewBag.REPORTNUMBER = REPORTNUMBER; //证书编号 ViewBag.CONCLUSION = uplo.CONCLUSION; //结论 ViewBag.PREPARE_SCHEMEID = pre.ID; //预备方案id return(View()); }