public JsonResult GetReport(
reportModel data,
List <reportParm> parms,
List <reportParm> extensionParms = null
)
{
MSGReturnModel <string> result = new MSGReturnModel <string>();
result.RETURN_FLAG = false;
try
{
string title = "報表名稱";
if (data.className.IsNullOrWhiteSpace())
{
result.DESCRIPTION = "報表錯誤請聯絡IT人員";
//result.DESCRIPTION = MessageType.parameter_Error.GetDescription(null, "無呼叫的className");
return(Json(result));
}
if (!data.title.IsNullOrWhiteSpace())
{
title = data.title;
}
object obj = Activator.CreateInstance(Assembly.Load("Treasury.Web").GetType($"Treasury.Web.Report.Data.{data.className}"));
MethodInfo[] methods = obj.GetType().GetMethods();
MethodInfo mi = methods.FirstOrDefault(x => x.Name == "GetData");
if (mi == null)
{
//檢查是否有實作資料獲取
result.DESCRIPTION = "報表錯誤請聯絡IT人員";
return(Json(result));
}
DataSet ds = (DataSet)mi.Invoke(obj, new object[] { parms });
List <reportParm> eparm = (List <reportParm>)(obj.GetType().GetProperty("extensionParms").GetValue(obj));
ReportWrapper rw = new ReportWrapper();
rw.ReportPath = Server.MapPath($"~/Report/Rdlc/{data.className}.rdlc");
for (int i = 0; i < ds.Tables.Count; i++)
{
rw.ReportDataSources.Add(new ReportDataSource("DataSet" + (i + 1).ToString(), ds.Tables[i]));
}
rw.ReportParameters.Add(new ReportParameter("Title", title));
if (extensionParms != null)
{
rw.ReportParameters.AddRange(extensionParms.Select(x => new ReportParameter(x.key, x.value)));
}
if (eparm.Any())
{
rw.ReportParameters.AddRange(eparm.Select(x => new ReportParameter(x.key, x.value)));
}
rw.IsDownloadDirectly = false;
var g = Guid.NewGuid().ToString();
Session[g] = rw;
result.RETURN_FLAG = true;
result.Datas = g;
}
catch (Exception ex) {
result.DESCRIPTION = ex.exceptionMessage();
}
return(Json(result));
}
public JsonResult GetReport(
reportModel data,
List <reportParm> parms,
List <reportParm> extensionParms = null)
{
MSGReturnModel result = new MSGReturnModel();
result.RETURN_FLAG = false;
try
{
string title = "(報表名稱)";
if (data.className.IsNullOrWhiteSpace())
{
result.DESCRIPTION = Message_Type.parameter_Error.GetDescription(null, "無呼叫的className");
return(Json(result));
}
if (!data.title.IsNullOrWhiteSpace())
{
title = data.title;
}
//object obj = AppDomain.CurrentDomain.CreateInstanceAndUnwrap("Transfer", $"Transfer.Report.Data.{data.className}");
object obj = Activator.CreateInstance(Assembly.Load("Transfer").GetType($"Transfer.Report.Data.{data.className}"));
MethodInfo[] methods = obj.GetType().GetMethods();
MethodInfo mi = methods.FirstOrDefault(x => x.Name == "GetData");
if (mi == null)
{
//請檢查是否實作資料獲取
result.DESCRIPTION = "報表錯誤請聯絡IT人員!";
return(Json(result));
}
DataSet ds = (DataSet)mi.Invoke(obj, new object[] { parms });
List <reportParm> eparm = (List <reportParm>)(obj.GetType().GetProperty("extensionParms").GetValue(obj));
// Set report info
ReportWrapper rw = new ReportWrapper();
rw.ReportPath = Server.MapPath($"~/Report/Rdlc/{data.className}.rdlc");
for (int i = 0; i < ds.Tables.Count; i++)
{
rw.ReportDataSources.Add(new ReportDataSource("DataSet" + (i + 1).ToString(), ds.Tables[i]));
}
rw.ReportParameters.Add(new ReportParameter("Title", title));
rw.ReportParameters.Add(new ReportParameter("ReportTitle", "富邦人壽"));
rw.ReportParameters.Add(new ReportParameter("Emp", $@"{AccountController.CurrentUserInfo.Name}({AccountController.CurrentUserName})"));
rw.ReportParameters.Add(new ReportParameter("Name", data.className));
if (extensionParms != null)
{
rw.ReportParameters.AddRange(extensionParms.Select(x => new ReportParameter(x.key, x.value)));
}
if (eparm.Any())
{
rw.ReportParameters.AddRange(eparm.Select(x => new ReportParameter(x.key, x.value)));
}
rw.IsDownloadDirectly = false;
// Pass report info via session
Session["ReportWrapper"] = rw;
result.RETURN_FLAG = true;
}
catch (Exception ex)
{
result.RETURN_FLAG = false;
result.DESCRIPTION = ex.exceptionMessage();
}
return(Json(result));
}
public JsonResult SendReport(
reportModel data,
List <reportParm> parms,
List <reportParm> extensionParms = null
)
{
MSGReturnModel <string> result = new MSGReturnModel <string>();
result.RETURN_FLAG = false;
Treasury.WebUtility.FileRelated.createFile(Server.MapPath("~/Temp/"));
try
{
var fileLocation = Server.MapPath("~/Temp/");
string title = "報表名稱";
if (data.className.IsNullOrWhiteSpace())
{
result.DESCRIPTION = "寄送報表錯誤請聯絡IT人員";
//result.DESCRIPTION = MessageType.parameter_Error.GetDescription(null, "無呼叫的className");
return(Json(result));
}
if (!data.title.IsNullOrWhiteSpace())
{
title = data.title;
}
object obj = Activator.CreateInstance(Assembly.Load("Treasury.Web").GetType($"Treasury.Web.Report.Data.{data.className}"));
MethodInfo[] methods = obj.GetType().GetMethods();
MethodInfo mi = methods.FirstOrDefault(x => x.Name == "GetData");
if (mi == null)
{
//檢查是否有實作資料獲取
result.DESCRIPTION = "寄送報表錯誤請聯絡IT人員";
return(Json(result));
}
DataSet ds = (DataSet)mi.Invoke(obj, new object[] { parms });
List <reportParm> eparm = (List <reportParm>)(obj.GetType().GetProperty("extensionParms").GetValue(obj));
var lr = new LocalReport();
lr.ReportPath = Server.MapPath($"~/Report/Rdlc/{data.className}.rdlc");
lr.DataSources.Clear();
List <ReportParameter> _parm = new List <ReportParameter>();
_parm.Add(new ReportParameter("Title", title));
if (extensionParms != null)
{
_parm.AddRange(extensionParms.Select(x => new ReportParameter(x.key, x.value)));
}
if (eparm.Any())
{
_parm.AddRange(eparm.Select(x => new ReportParameter(x.key, x.value)));
}
if (_parm.Any())
{
lr.SetParameters(_parm);
}
for (int i = 0; i < ds.Tables.Count; i++)
{
lr.DataSources.Add(new ReportDataSource("DataSet" + (i + 1).ToString(), ds.Tables[i]));
}
string _DisplayName = title;
if (_DisplayName != null)
{
_DisplayName = _DisplayName.Replace("(", "-").Replace(")", "");
var _name = _parm.FirstOrDefault(x => x.Name == "vJobProject");
if (_name != null)
{
_DisplayName = $"{_DisplayName}_{_name.Values[0]}";
}
}
lr.DisplayName = _DisplayName;
lr.Refresh();
string mimeType, encoding, extension;
Warning[] warnings;
string[] streams;
var renderedBytes = lr.Render
(
"PDF",
null,
out mimeType,
out encoding,
out extension,
out streams,
out warnings
);
var saveAs = string.Format("{0}.pdf", Path.Combine(fileLocation, _DisplayName));
var idx = 0;
while (Directory.Exists(saveAs))
{
idx++;
saveAs = string.Format("{0}.{1}.pdf", Path.Combine(fileLocation, _DisplayName), idx);
}
//using (var stream = new FileStream(saveAs, FileMode.Create, FileAccess.Write))
//{
// stream.Write(renderedBytes, 0, renderedBytes.Length);
// stream.Close();
//}
lr.Dispose();
#region 寄信
//存許項目
string vitemIdName = extensionParms.FirstOrDefault(x => x.key == "vJobProject")?.value;
//庫存日期
string aplyDt = parms.FirstOrDefault(x => x.key == "APLY_DT_From")?.value;
MAIL_TIME MT = new MAIL_TIME();
MAIL_CONTENT MC = new MAIL_CONTENT();
//List<Tuple<string, string>> _mailTo = new List<Tuple<string, string>>() { new Tuple<string, string>("*****@*****.**", "測試帳號-glsisys") };
List <Tuple <string, string> > _mailTo = new List <Tuple <string, string> >();
List <Tuple <string, string> > _ccTo = new List <Tuple <string, string> >();
using (TreasuryDBEntities db = new TreasuryDBEntities())
{
//季追蹤庫存表 抓5
MT = db.MAIL_TIME.AsNoTracking().FirstOrDefault(x => x.MAIL_TIME_ID == "5" && x.IS_DISABLED != "Y");
var _MAIL_CONTENT_ID = MT?.MAIL_CONTENT_ID;
MC = db.MAIL_CONTENT.AsNoTracking().FirstOrDefault(x => x.MAIL_CONTENT_ID == _MAIL_CONTENT_ID && x.IS_DISABLED != "Y");
var _MAIL_RECEIVE = db.MAIL_RECEIVE.AsNoTracking();
var _CODE_ROLE_FUNC = db.CODE_ROLE_FUNC.AsNoTracking();
var _CODE_USER_ROLE = db.CODE_USER_ROLE.AsEnumerable();
var _CODE_USER = db.CODE_USER.AsNoTracking();
var emps = comm.GetEmps();
using (DB_INTRAEntities dbINTRA = new DB_INTRAEntities())
{
//存許項目
string vitemId = parms.FirstOrDefault(x => x.key == "vJobProject")?.value; //Bianco 20190326 原參數 vjobProject
//權責部門
string vdept = parms.FirstOrDefault(x => x.key == "vdept")?.value; //Bianco 20190326 原參數 CHARGE_DEPT_ID
//權責科別
string vsect = parms.FirstOrDefault(x => x.key == "vsect")?.value; //Bianco 20190326 原參數 CHARGE_SECT_ID
var _VW_OA_DEPT = dbINTRA.VW_OA_DEPT.AsNoTracking();
var _V_EMPLY2 = dbINTRA.V_EMPLY2.AsNoTracking();
var _ITEM_CHARGE_UNIT = db.ITEM_CHARGE_UNIT.AsNoTracking()
.Where(x => x.ITEM_ID == vitemId, vitemId != null)
.Where(x => x.CHARGE_DEPT == vdept, vdept != "All")
.Where(x => x.CHARGE_SECT == vsect, vsect != "All")
.Where(x => x.IS_DISABLED == "N")
.AsEnumerable()
.Select(x => new ITEM_CHARGE_UNIT()
{
CHARGE_DEPT = x.CHARGE_DEPT,
CHARGE_SECT = x.CHARGE_SECT,
CHARGE_UID = x.CHARGE_UID,
IS_MAIL_SECT_MGR = x.IS_MAIL_SECT_MGR,
IS_MAIL_DEPT_MGR = x.IS_MAIL_DEPT_MGR
}).ToList();
_ITEM_CHARGE_UNIT.ForEach(x => {
//經辦
var _CHARGE_NAME = _V_EMPLY2.FirstOrDefault(y => y.USR_ID == x.CHARGE_UID);
if (_CHARGE_NAME != null && !_mailTo.Any(y => y.Item1 == _CHARGE_NAME.EMAIL))
{
_mailTo.Add(new Tuple <string, string>(_CHARGE_NAME.EMAIL, _CHARGE_NAME.EMP_NAME));
}
if (x.IS_MAIL_SECT_MGR == "Y")
{
//科主管員編
var _VW_OA_DEPT_DPT_HEAD = _VW_OA_DEPT.FirstOrDefault(y => y.DPT_CD == x.CHARGE_SECT)?.DPT_HEAD;
//人名 EMAIl
var _EMP_NAME = _V_EMPLY2.FirstOrDefault(y => y.EMP_NO == _VW_OA_DEPT_DPT_HEAD);
if (_EMP_NAME != null && !_mailTo.Any(y => y.Item1 == _EMP_NAME.EMAIL))
{
_mailTo.Add(new Tuple <string, string>(_EMP_NAME.EMAIL, _EMP_NAME.EMP_NAME));
}
}
if (x.IS_MAIL_DEPT_MGR == "Y")
{
//部主管員編
//var _UP_DPT_CD = _VW_OA_DEPT.FirstOrDefault(y => y.DPT_CD == x.CHARGE_SECT)?.UP_DPT_CD;
//var _UP_DPT_CD = _VW_OA_DEPT.FirstOrDefault(y => y.DPT_CD == x.CHARGE_SECT)?.UP_DPT_CD;
//var _VW_OA_DEPT_DPT_HEAD = _VW_OA_DEPT.FirstOrDefault(y => y.DPT_CD == _UP_DPT_CD)?.DPT_HEAD;
var _VW_OA_DEPT_DPT_HEAD = _VW_OA_DEPT.FirstOrDefault(y => y.DPT_CD == x.CHARGE_DEPT)?.DPT_HEAD;
//人名 EMAIl
var _EMP_NAME = _V_EMPLY2.FirstOrDefault(y => y.EMP_NO == _VW_OA_DEPT_DPT_HEAD);
if (_EMP_NAME != null && !_ccTo.Any(y => y.Item1 == _EMP_NAME.EMAIL) && !_mailTo.Any(y => y.Item1 == _EMP_NAME.EMAIL))
{
_ccTo.Add(new Tuple <string, string>(_EMP_NAME.EMAIL, _EMP_NAME.EMP_NAME));
}
}
});
if (MC != null)
{
var _FuncId = _MAIL_RECEIVE.Where(x => x.MAIL_CONTENT_ID == MC.MAIL_CONTENT_ID).Select(x => x.FUNC_ID);
var _RoleId = _CODE_ROLE_FUNC.Where(x => _FuncId.Contains(x.FUNC_ID)).Select(x => x.ROLE_ID);
var _UserId = _CODE_USER_ROLE.Where(x => _RoleId.Contains(x.ROLE_ID)).Select(x => x.USER_ID).Distinct();
List <string> _userIdList = new List <string>();
_userIdList.AddRange(_CODE_USER.Where(x => _UserId.Contains(x.USER_ID) && x.IS_MAIL == "Y").Select(x => x.USER_ID).ToList());
if (_userIdList.Any())
{
//人名 EMAIl
var _EMP = emps.Where(x => _userIdList.Contains(x.USR_ID)).ToList();
if (_EMP.Any())
{
_EMP.ForEach(x => {
if (!_ccTo.Any(y => y.Item1 == x.EMAIL) && !_mailTo.Any(y => y.Item1 == x.EMAIL))
{
_ccTo.Add(new Tuple <string, string>(x.EMAIL, x.EMP_NAME));
}
});
}
}
}
}
}
string passwordZip = getPassWord();
Dictionary <string, Stream> attachment = new Dictionary <string, Stream>();
//attachment.Add(string.Format("{0}.pdf", _DisplayName), new MemoryStream(renderedBytes));
using (ZipFile zip = new ZipFile(System.Text.Encoding.Default))
{
var memSteam = new MemoryStream();
var streamWriter = new StreamWriter(memSteam);
ZipEntry e = zip.AddEntry(string.Format("{0}.pdf", _DisplayName), new MemoryStream(renderedBytes));
e.Password = passwordZip;
e.Encryption = EncryptionAlgorithm.WinZipAes256;
var ms = new MemoryStream();
ms.Seek(0, SeekOrigin.Begin);
zip.Save(ms);
ms.Seek(0, SeekOrigin.Begin);
ms.Flush();
attachment.Add(string.Format("{0}.zip", _DisplayName), ms);
}
string str = MC?.MAIL_CONTENT1 ?? string.Empty;
str = str.Replace("@_DATE_", aplyDt);
str = str.Replace("@_ITEM_", vitemIdName);
StringBuilder sb = new StringBuilder();
sb.AppendLine(str);
try
{
var sms = new SendMail.SendMailSelf();
sms.smtpPort = 25;
sms.smtpServer = Properties.Settings.Default["smtpServer"]?.ToString();
sms.mailAccount = Properties.Settings.Default["mailAccount"]?.ToString();
sms.mailPwd = Properties.Settings.Default["mailPwd"]?.ToString();
sms.Mail_Send(
new Tuple <string, string>(sms.mailAccount, "金庫管理系統"),
_mailTo,
_ccTo,
MC?.MAIL_SUBJECT ?? "季追蹤庫存表",
sb.ToString(),
false,
attachment
);
}
catch (Exception ex)
{
result.DESCRIPTION = $"Email 發送失敗請人工通知。";
return(Json(result));
}
//寄密碼
try
{
var sms = new SendMail.SendMailSelf();
sms.smtpPort = 25;
sms.smtpServer = Properties.Settings.Default["smtpServer"]?.ToString();
sms.mailAccount = Properties.Settings.Default["mailAccount"]?.ToString();
sms.mailPwd = Properties.Settings.Default["mailPwd"]?.ToString();
sms.Mail_Send(
new Tuple <string, string>(sms.mailAccount, "金庫管理系統"),
_mailTo,
_ccTo,
"季追蹤庫存表-密碼",
$"密碼:{passwordZip}",
false,
null
);
}
catch (Exception ex)
{
result.DESCRIPTION = $"Email 密碼發送失敗。";
return(Json(result));
}
#endregion
result.RETURN_FLAG = true;
result.DESCRIPTION = "已寄送追蹤報表!";
}
catch (Exception ex)
{
result.DESCRIPTION = ex.exceptionMessage();
}
return(Json(result));
}