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