public ActionResult GetFormJson(string keyValue)
{
try
{
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
var data = suppliesacceptbll.GetEntity(keyValue);
if (data.Status == 1)
{
ManyPowerCheckBLL bll = new ManyPowerCheckBLL();
ManyPowerCheckEntity power = bll.GetListByModuleNo(user.OrganizeCode, "YJWZLYSP").OrderByDescending(t => t.SERIALNUM).FirstOrDefault();
ManyPowerCheckEntity flow = bll.GetEntity(data.FlowId);
if (power != null && power.SERIALNUM == flow.SERIALNUM)
{
data.IsLastAudit = true;
}
else
{
data.IsLastAudit = false;
}
}
else
{
data.IsLastAudit = false;
}
return(ToJsonResult(data));
}
catch (System.Exception ex)
{
return(Error(ex.ToString()));
}
}
public ActionResult GetFormJson(string keyValue)
{
var data = manyPowerCheckbll.GetEntity(keyValue);
//返回值
var josnData = new
{
data = data
};
return(Content(josnData.ToJson()));
}
public ActionResult ApporveForm(string keyValue, AptitudeinvestigateauditEntity aentity)
{
Operator curUser = ERCHTMS.Code.OperatorProvider.Provider.Current();
FivesafetycheckEntity entity = fivesafetycheckbll.GetEntity(keyValue);
string state = string.Empty;
string moduleName = "五定安全检查";
ManyPowerCheckEntity mpcEntity = peoplereviewbll.CheckAuditPower(curUser, out state, moduleName, "", false, entity.FLOWID);
#region //审核信息表
AptitudeinvestigateauditEntity aidEntity = new AptitudeinvestigateauditEntity();
aidEntity.AUDITRESULT = aentity.AUDITRESULT; //通过
aidEntity.AUDITTIME = Convert.ToDateTime(aentity.AUDITTIME.Value.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss")); //审核时间
aidEntity.AUDITPEOPLE = aentity.AUDITPEOPLE; //审核人员姓名
aidEntity.AUDITPEOPLEID = aentity.AUDITPEOPLEID; //审核人员id
aidEntity.APTITUDEID = keyValue; //关联的业务ID
aidEntity.AUDITDEPTID = aentity.AUDITDEPTID; //审核部门id
aidEntity.AUDITDEPT = aentity.AUDITDEPT; //审核部门
aidEntity.AUDITOPINION = aentity.AUDITOPINION; //审核意见
aidEntity.FlowId = entity.FLOWID; //流程步骤
if (null != mpcEntity)
{
aidEntity.REMARK = (mpcEntity.AUTOID.Value - 1).ToString(); //备注 存流程的顺序号
}
else
{
aidEntity.REMARK = "7";
}
aptitudeinvestigateauditbll.SaveForm(aidEntity.ID, aidEntity);
#endregion
#region 保存
//审核通过
if (aentity.AUDITRESULT == "0")
{
//判断是否走的会签，走会签就要判断是不是所有的部门都有签到,未完成的会签只添加审核记录
var checkstep = powerCheckbll.GetEntity(entity.FLOWID);
int hqresult = 0; // 0：会签完成，走后续流程 1：会签未完成
if (checkstep.SERIALNUM == 1) // 脚本会签
{
var deptauditlist = fivesafetycheckbll.GetStepDept(checkstep, keyValue); //获取未会签的部门
foreach (UserEntity userinfp in deptauditlist)
{
if (userinfp.DepartmentId != curUser.DeptId)
{
hqresult = 1;
}
else //更新当前人会签记录
{
if (entity.CHECKDEPTALL == "" || entity.CHECKDEPTALL == null)
{
entity.CHECKDEPTALL = curUser.DeptId;
entity.CHECKUSERALL = curUser.UserId;
}
else
{
entity.CHECKDEPTALL += "," + curUser.DeptId;
entity.CHECKUSERALL += "," + curUser.UserId;
}
}
}
}
if (hqresult == 0) // 会签完成，走后续流程
{
//0表示流程未完成，1表示流程结束 会签走完了才执行后面的代码
if (null != mpcEntity)
{
entity.ISOVER = 0;
entity.FLOWID = mpcEntity.ID;
entity.FLOWDEPT = mpcEntity.CHECKDEPTID;
entity.FLOWDEPTNAME = mpcEntity.CHECKDEPTNAME;
entity.FLOWROLE = mpcEntity.CHECKROLEID;
entity.FLOWROLENAME = mpcEntity.CHECKROLENAME;
entity.FLOWNAME = mpcEntity.FLOWNAME;
}
else
{
entity.ISOVER = 1;
entity.FLOWID = "";
entity.FLOWDEPT = "";
entity.FLOWDEPTNAME = "";
entity.FLOWROLE = "";
entity.FLOWROLENAME = "";
entity.FLOWNAME = "";
}
}
}
else //审核不通过
{
entity.ISSAVED = 0;
entity.ISOVER = 0;
entity.CHECKDEPTALL = "";
entity.CHECKUSERALL = "";
entity.FLOWID = "";
// 审批不通过，将历史审批记录打标（为流程图）
//获取当前业务对象的所有审核记录
var shlist = aptitudeinvestigateauditbll.GetAuditList(keyValue);
//批量更新审核记录关联ID
foreach (AptitudeinvestigateauditEntity mode in shlist)
{
mode.REMARK = "-1"; //历史审批记录改成-1
aptitudeinvestigateauditbll.SaveForm(mode.ID, mode);
}
}
fivesafetycheckbll.SaveForm(keyValue, entity);
#endregion
return(Success("操作成功!"));
}
/// <summary>
/// 导出审批单
/// </summary>
/// <param name="keyValue"></param>
public void ExportData(string keyValue)
{
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
HttpResponse resp = System.Web.HttpContext.Current.Response;
//报告对象
string fileName = Server.MapPath("~/Resource/ExcelTemplate/应急物资领用单模板.docx");
Aspose.Words.Document doc = new Aspose.Words.Document(fileName);
DocumentBuilder builder = new DocumentBuilder(doc);
DataTable dt = new DataTable();
dt.Columns.Add("applydept"); //申请部门
dt.Columns.Add("applyperson"); //申请人
dt.Columns.Add("applytime"); //申请时间
dt.Columns.Add("reason"); //申请原因
dt.Columns.Add("idea1"); //部门负责人意见
dt.Columns.Add("person1"); //部门负责人
dt.Columns.Add("time1"); //部门负责人审批时间
dt.Columns.Add("idea2"); //安环部负责人意见
dt.Columns.Add("person2"); //安环部负责人
dt.Columns.Add("time2"); //安环部负责人审批时间
dt.Columns.Add("idea3"); //物料部负责人意见
dt.Columns.Add("person3"); //物料部负责人
dt.Columns.Add("time3"); //物料部负责人审批时间
dt.Columns.Add("idea4"); //分管领导意见
dt.Columns.Add("person4"); //分管领导签名
dt.Columns.Add("time4"); //分管领导时间
dt.Columns.Add("idea5"); //应急物资出库人审批意见
dt.Columns.Add("person5"); //应急物资出库人
dt.Columns.Add("time5"); //应急物资出库人审批时间
DataRow row = dt.NewRow();
SuppliesacceptEntity entity = suppliesacceptbll.GetEntity(keyValue);
row["applydept"] = entity.ApplyDept;
row["applyperson"] = entity.ApplyPerson;
row["applytime"] = entity.ApplyDate.Value.ToString("yyyy年MM月dd日HH时mm分");
row["reason"] = entity.AcceptReason;
//物资信息
DataTable dt1 = new DataTable("A");
dt1.Columns.Add("num");
dt1.Columns.Add("suppliesname");
dt1.Columns.Add("models");
dt1.Columns.Add("acceptnum");
SuppliesAcceptDetailBLL suppliesacceptdetailbll = new SuppliesAcceptDetailBLL();
var list = suppliesacceptdetailbll.GetList("").Where(t => t.RecId == keyValue).ToList();
for (int i = 0; i < list.Count; i++)
{
DataRow row1 = dt1.NewRow();
row1["num"] = i + 1;
row1["suppliesname"] = list[i].SuppliesName;
row1["models"] = list[i].Models;
row1["acceptnum"] = list[i].AcceptNum;
dt1.Rows.Add(row1);
}
doc.MailMerge.ExecuteWithRegions(dt1);
//审核记录
AptitudeinvestigateauditBLL aptitudeinvestigateauditbll = new AptitudeinvestigateauditBLL();
ManyPowerCheckBLL manypowercheckbll = new ManyPowerCheckBLL();
var data = aptitudeinvestigateauditbll.GetAuditRecList(keyValue);
for (int i = 0; i < data.Rows.Count; i++)
{
try
{
var power = manypowercheckbll.GetEntity(data.Rows[i]["flowid"].ToString());
row["idea" + power.SERIALNUM] = data.Rows[i]["auditopinion"].ToString();
if (string.IsNullOrWhiteSpace(data.Rows[i]["auditsignimg"].ToString()))
{
row["person" + power.SERIALNUM] = Server.MapPath("~/content/Images/no_1.png");
}
else
{
var filepath = Server.MapPath("~/") + data.Rows[i]["auditsignimg"].ToString().Replace("../../", "").ToString();
if (System.IO.File.Exists(filepath))
{
row["person" + power.SERIALNUM] = filepath;
}
else
{
row["person" + power.SERIALNUM] = Server.MapPath("~/content/Images/no_1.png");
}
}
row["time" + power.SERIALNUM] = Convert.ToDateTime(data.Rows[i]["audittime"].ToString()).ToString("yyyy年MM月dd日");
}
catch (System.Exception ex)
{
}
}
dt.Rows.Add(row);
doc.MailMerge.Execute(dt);
doc.MailMerge.DeleteFields();
doc.Save(resp, Server.UrlEncode("应急物资领用单" + DateTime.Now.ToString("yyyyMMdd") + ".docx"), ContentDisposition.Attachment, Aspose.Words.Saving.SaveOptions.CreateSaveOptions(SaveFormat.Docx));
}
