/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, SaferewarddetailEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
}
catch (Exception)
{
throw;
}
}
public ActionResult SaveForm(string keyValue, SaferewarddetailEntity entity)
{
saferewarddetailbll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
/// <summary>
/// 导出安全奖励详细
/// </summary>
/// <param name="keyValue"></param>
/// <returns></returns>
public ActionResult ExportSafeRewardInfo(string keyValue)
{
HttpResponse resp = System.Web.HttpContext.Current.Response;
//报告对象
string fileName = "安全奖励审批单_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc";
string strDocPath = Request.PhysicalApplicationPath + @"Resource\ExcelTemplate\安全奖励导出模板.docx";
Aspose.Words.Document doc = new Aspose.Words.Document(strDocPath);
DocumentBuilder builder = new DocumentBuilder(doc);
DataTable dt = new DataTable();
dt.Columns.Add("RewardCode"); //编号
dt.Columns.Add("ApplyUserName"); //申请人
dt.Columns.Add("ApplyTime"); //申请时间
dt.Columns.Add("BelongDept"); //被奖励部门
dt.Columns.Add("ReardNum"); //申请奖励金额
dt.Columns.Add("RewardName"); //奖励对象名称
dt.Columns.Add("RewardRemark"); //事件描述
dt.Columns.Add("approve1"); //第一步审核意见
dt.Columns.Add("approvename1"); //第一步审核人
dt.Columns.Add("approvetime1"); //第一步审核时间
dt.Columns.Add("approve2"); //第二步审核意见
dt.Columns.Add("approvename2"); //第二步审核人
dt.Columns.Add("approvetime2"); //第二步审核时间
dt.Columns.Add("approve3"); //第三步审核意见
dt.Columns.Add("approvename3"); //第三步审核人
dt.Columns.Add("approvetime3"); //第三步审核时间
dt.Columns.Add("approve4"); //第四步审核意见
dt.Columns.Add("approvename4"); //第四步审核人
dt.Columns.Add("approvetime4"); //第四步审核时间
dt.Columns.Add("approve5"); //第五步审核意见
dt.Columns.Add("approvename5"); //第五步审核人
dt.Columns.Add("approvetime5"); //第五步审核时间
DataRow row = dt.NewRow();
//安全奖励信息
SaferewardEntity saferewardentity = saferewardbll.GetEntity(keyValue);
row["RewardCode"] = saferewardentity.SafeRewardCode;
row["ApplyUserName"] = saferewardentity.ApplyUserName;
row["ApplyTime"] = saferewardentity.ApplyTime.IsEmpty() ? "" : Convert.ToDateTime(saferewardentity.ApplyTime).ToString("yyyy-MM-dd");
row["RewardRemark"] = saferewardentity.RewardRemark;
row["approve1"] = saferewardentity.SpecialtyOpinion;
row["approvetime1"] = saferewardentity.CreateDate.IsEmpty() ? "" : Convert.ToDateTime(saferewardentity.CreateDate).ToString("yyyy-MM-dd");
UserEntity createuser = new UserBLL().GetEntity(saferewardentity.CreateUserId);
if (createuser.SignImg.IsEmpty())
{
row["approvename1"] = Server.MapPath("~/content/Images/no_1.png");
}
else
{
var filepath = Server.MapPath("~/") + createuser.SignImg.ToString().Replace("../../", "").ToString();
if (System.IO.File.Exists(filepath))
{
row["approvename1"] = filepath;
}
else
{
row["approvename1"] = Server.MapPath("~/content/Images/no_1.png");
}
}
builder.MoveToMergeField("approvename1");
builder.InsertImage(row["approvename1"].ToString(), 80, 35);
var flist = fileinfobll.GetImageListByRecid(keyValue);
builder.MoveToMergeField("RewardImage");
foreach (FileInfoEntity fmode in flist)
{
string path = "";
if (string.IsNullOrWhiteSpace(fmode.FilePath))
{
path = Server.MapPath("~/content/Images/no_1.png");
}
else
{
var filepath = Server.MapPath("~/") + fmode.FilePath.Replace("~/", "").ToString();
if (System.IO.File.Exists(filepath))
{
path = filepath;
}
else
{
path = Server.MapPath("~/content/Images/no_1.png");
}
}
builder.MoveToMergeField("RewardImage");
builder.InsertImage(path, 200, 160);
}
//获取被考核对象
SaferewarddetailEntity SaferewarddetailEntity = saferewarddetailbll.GetListByRewardId(keyValue).OrderBy(t => t.CreateDate).FirstOrDefault();
row["BelongDept"] = departmentbll.GetEntity(SaferewarddetailEntity.BelongDept) == null ? "" : departmentbll.GetEntity(SaferewarddetailEntity.BelongDept).FullName;
row["ReardNum"] = SaferewarddetailEntity.RewardNum;
row["RewardName"] = SaferewarddetailEntity.RewardName;
DataTable dtAptitude = saferewardbll.GetAptitudeInfo(keyValue);
int count = dtAptitude.Rows.Count;
for (int i = dtAptitude.Rows.Count - 1; i > 0; i--)
{
if (i == (dtAptitude.Rows.Count - 2))
{
row["approve5"] = dtAptitude.Rows[i]["auditremark"];
row["approvetime5"] = dtAptitude.Rows[i]["auditdate"].IsEmpty() ? "" : Convert.ToDateTime(dtAptitude.Rows[i]["auditdate"]).ToString("yyyy-MM-dd");
if (dtAptitude.Rows[i]["auditsignimg"].IsEmpty())
{
row["approvename5"] = Server.MapPath("~/content/Images/no_1.png");
}
else
{
var filepath = Server.MapPath("~/") + dtAptitude.Rows[i]["auditsignimg"].ToString().Replace("../../", "").ToString();
if (System.IO.File.Exists(filepath))
{
row["approvename5"] = filepath;
}
else
{
row["approvename5"] = Server.MapPath("~/content/Images/no_1.png");
}
}
builder.MoveToMergeField("approvename5");
builder.InsertImage(row["approvename5"].ToString(), 80, 35);
}
else if (i == (dtAptitude.Rows.Count - 3))
{
row["approve4"] = dtAptitude.Rows[i]["auditremark"];
row["approvetime4"] = dtAptitude.Rows[i]["auditdate"].IsEmpty() ? "" : Convert.ToDateTime(dtAptitude.Rows[i]["auditdate"]).ToString("yyyy-MM-dd");
if (dtAptitude.Rows[i]["auditsignimg"].IsEmpty())
{
row["approvename4"] = Server.MapPath("~/content/Images/no_1.png");
}
else
{
var filepath = Server.MapPath("~/") + dtAptitude.Rows[i]["auditsignimg"].ToString().Replace("../../", "").ToString();
if (System.IO.File.Exists(filepath))
{
row["approvename4"] = filepath;
}
else
{
row["approvename4"] = Server.MapPath("~/content/Images/no_1.png");
}
}
builder.MoveToMergeField("approvename4");
builder.InsertImage(row["approvename4"].ToString(), 80, 35);
}
else if (i == (dtAptitude.Rows.Count - 4))
{
row["approve3"] = dtAptitude.Rows[i]["auditremark"];
row["approvetime3"] = dtAptitude.Rows[i]["auditdate"].IsEmpty() ? "" : Convert.ToDateTime(dtAptitude.Rows[i]["auditdate"]).ToString("yyyy-MM-dd");
if (dtAptitude.Rows[i]["auditsignimg"].IsEmpty())
{
row["approvename3"] = Server.MapPath("~/content/Images/no_1.png");
}
else
{
var filepath = Server.MapPath("~/") + dtAptitude.Rows[i]["auditsignimg"].ToString().Replace("../../", "").ToString();
if (System.IO.File.Exists(filepath))
{
row["approvename3"] = filepath;
}
else
{
row["approvename3"] = Server.MapPath("~/content/Images/no_1.png");
}
}
builder.MoveToMergeField("approvename3");
builder.InsertImage(row["approvename3"].ToString(), 80, 35);
}
else if (i == (dtAptitude.Rows.Count - 5))
{
row["approve2"] = dtAptitude.Rows[i]["auditremark"];
row["approvetime2"] = dtAptitude.Rows[i]["auditdate"].IsEmpty() ? "" : Convert.ToDateTime(dtAptitude.Rows[i]["auditdate"]).ToString("yyyy-MM-dd");
if (dtAptitude.Rows[i]["auditsignimg"].IsEmpty())
{
row["approvename2"] = Server.MapPath("~/content/Images/no_1.png");
}
else
{
var filepath = Server.MapPath("~/") + dtAptitude.Rows[i]["auditsignimg"].ToString().Replace("../../", "").ToString();
if (System.IO.File.Exists(filepath))
{
row["approvename2"] = filepath;
}
else
{
row["approvename2"] = Server.MapPath("~/content/Images/no_1.png");
}
}
builder.MoveToMergeField("approvename2");
builder.InsertImage(row["approvename2"].ToString(), 80, 35);
}
}
dt.Rows.Add(row);
doc.MailMerge.Execute(dt);
doc.MailMerge.DeleteFields();
doc.Save(resp, Server.UrlEncode(fileName), ContentDisposition.Attachment, Aspose.Words.Saving.SaveOptions.CreateSaveOptions(SaveFormat.Doc));
return(Success("导出成功!"));
}
