예제 #1
0
        private void btn_generate_Click(object sender, EventArgs e)
        {
            Boolean msgsend = true;

            try
            {
                Dictionary <string, object> parameters = new Dictionary <string, object>();

                #region getEmailUserServerPasword

                string sEmailServer   = "";
                string sEmailUser     = "";
                string sEmailPassword = "";


                var getServerDet = (from emailSer in context.emrcorcmps
                                    where emailSer.emrcmpcpcd.Equals(txt_company.Text.TrimEnd())
                                    select emailSer).SingleOrDefault();
                if (getServerDet != null)
                {
                    sEmailServer   = Utility.NullToString(getServerDet.emrcmpemsr);
                    sEmailUser     = Utility.NullToString(getServerDet.emrcmpesur);
                    sEmailPassword = Utility.NullToString(getServerDet.emrcmpespd);
                }

                if (String.IsNullOrWhiteSpace(sEmailServer))
                {
                    sEmailServer   = Settings.Default.DefaultEmailServerName;
                    sEmailUser     = Settings.Default.DefaultEmailServerLogin;
                    sEmailPassword = Settings.Default.DefaultEmailServerPasword;
                }

                /* Local Testing Only */
#if DEBUG
                sEmailServer = "mail13.infoware.com.hk";
#endif

                #endregion

                string email     = txt_email.Text;
                string sEmail    = "";
                string sEmailMsg = "";

                if (Utility.NullToString(txt_email.Text) != "")
                {
                    sEmail = Utility.NullToString(txt_email.Text);
                }
                else
                {
                    sEmail = GetAllMailByGroupCode(txt_company.Text.TrimEnd(), txt_branch.Text.TrimEnd(), txt_GroupCode.Text.TrimEnd());
                }

                sEmailMsg = "Dear user,\n\n" + "Here is the background job reporting process, and find the attached report.\n\n" + "Regards,\n" + "webmaster\n";


                String sFileDirectory = Settings.Default.OutputFilePath + Path.DirectorySeparatorChar + txt_rptJobId.Text.TrimEnd();
                if (!Directory.Exists(sFileDirectory))
                {
                    Directory.CreateDirectory(sFileDirectory);
                }

                String sFilePath = sFileDirectory + Path.DirectorySeparatorChar + txt_filename.Text + "." + cbx_fileformat.SelectedItem.ToString();


                String sModuleID  = txt_module.Text.Trim();
                String sProgramID = txt_program.Text.Trim();

                Type       reportType = Type.GetType("IS21DotNet.Reports." + sModuleID + "." + sProgramID + "Report");
                BaseReport xrreport   = (BaseReport)Activator.CreateInstance(reportType);


                Dictionary <string, object> reportParameters = new Dictionary <string, object>();

                foreach (DataGridViewRow row in dgv_param.Rows)
                {
                    String sKey   = Utility.NullToString(row.Cells[0].Value);
                    String sType  = Utility.NullToString(row.Cells[3].Value).ToUpper();
                    Object oValue = row.Cells[1].Value;

                    reportParameters[sKey] = Program.CaseValueByDataType(oValue, sType);
                }
                xrreport.SetParameters(reportParameters);
                xrreport.TranslateLabels(Translation.Instance, Settings.Default.Language);

                xrreport.RequestParameters = false;


                if (cbx_fileformat.SelectedItem.Equals("pdf"))
                {
                    xrreport.ExportToPdf(sFilePath);
                }
                else if (cbx_fileformat.SelectedItem.Equals("xls"))
                {
                    xrreport.ExportToXls(sFilePath);
                }
                else if (cbx_fileformat.SelectedItem.Equals("xlsx"))
                {
                    xrreport.ExportToXlsx(sFilePath);
                }


                Email           emailService = Email.Instance;
                EmailServerInfo emailInfo    = new EmailServerInfo();
                emailInfo.ServerName = sEmailServer;
                emailInfo.UserID     = sEmailUser;
                emailInfo.Password   = sEmailPassword;

                List <String> attachmentList = new List <string>();
                attachmentList.Add(sFilePath);

                emailService.SendEmail(sEmail, "Reporting Mail for report " + txt_program.Text.Trim(), sEmailMsg, attachmentList, emailInfo);
                msgsend = true;
            }

            catch (System.Exception ex)
            {
                Utility.WriteLog(DateTime.Now.ToString("yyy-MM-dd HH:mm:ss") + ", ReportName: " + txt_program.Text.Trim() + ", Cannot generate Report : Failed\n Exception Message: " + ex.Message, sLogFile);
                Utility.WriteLog("\n" + ex.StackTrace, sLogFile);

                msgsend = false;
            }

            if (msgsend == true)
            {
                MessageBox.Show("Email Send Successfully ");
            }
            else
            {
                MessageBox.Show("Email Not Sent : ERROR ...Please check the Log");
            }
        }
예제 #2
0
        private void TranslateLabels(Translation translate, XRControlCollection Controls, string lang)
        {
            for (int i = 0; i < Controls.Count; i++)
            {
                XRControl item = Controls[i];

                if (item is XRSubreport)
                {
                    XRSubreport control = (XRSubreport)item;
                    if (control.ReportSource is BaseReport)
                    {
                        BaseReport report = (BaseReport)control.ReportSource;
                        report.TranslateLabels(translate, lang);
                    }
                }
                else if (item is XRTable)
                {
                    XRTableRowCollection control = (XRTableRowCollection)item.Controls;
                    foreach (XRTableRow row in control)
                    {
                        TranslateLabels(translate, row.Controls, lang);
                    }
                }

                else if (item is XRTableCell)
                {
                    XRTableCell label = (XRTableCell)item;
                    if (label.Name.ToLower() == "programid")
                    {
                        string reportName = GetType().Name.Replace("Report", "");
                        label.Text = translate.GetProgramName(lang, reportName) + " (" + reportName + ")";
                    }
                    else
                    {
                        string caption = GetControlLabel(translate, label.Name, lang);
                        if (caption.Length > 0 && !caption.StartsWith("["))
                        {
                            label.Text = caption;
                        }
                    }
                    foreach (XRBinding binding in label.DataBindings)
                    {
                        if (binding.FormatString != null)
                        {
                            if (binding.FormatString.Contains("$"))
                            {
                                binding.FormatString = "{0:c}";
                            }
                            else if (binding.FormatString.Contains("%"))
                            {
                                binding.FormatString = "{0:p}";
                            }
                        }
                    }

                    if (item.Controls.Count > 0)
                    {
                        TranslateLabels(translate, item.Controls, lang);
                    }
                }

                else if (item is XRLabel)
                {
                    XRLabel label = (XRLabel)item;
                    if (label.Name.ToLower() == "programid")
                    {
                        string reportName = GetType().Name.Replace("Report", "");
                        label.Text = translate.GetProgramName(lang, reportName) + " (" + reportName + ")";
                    }
                    else
                    {
                        string caption = GetControlLabel(translate, label.Name, lang);
                        if (caption.Length > 0 && !caption.StartsWith("["))
                        {
                            label.Text = caption;
                        }
                    }

                    foreach (XRBinding binding in label.DataBindings)
                    {
                        if (binding.FormatString != null)
                        {
                            if (binding.FormatString.Contains("$"))
                            {
                                binding.FormatString = "{0:c}";
                            }
                            else if (binding.FormatString.Contains("%"))
                            {
                                binding.FormatString = "{0:p}";
                            }
                        }
                    }
                }
                else if (item is XRPivotGrid)
                {
                    XRPivotGrid grid = (XRPivotGrid)item;

                    foreach (XRPivotGridField field in grid.Fields)
                    {
                        string caption = GetControlLabel(translate, field.Name, lang);
                        if (caption.Length > 0 && !caption.StartsWith("["))
                        {
                            field.Caption = caption;
                        }

                        if (field.CellFormat.FormatType == DevExpress.Utils.FormatType.Numeric)
                        {
                            String sFormatString = field.CellFormat.FormatString.ToLower();
                            if (!sFormatString.Contains("c") && !sFormatString.Contains("n") && !sFormatString.Contains("p"))
                            {
                                if (sFormatString.Contains("$"))
                                {
                                    field.CellFormat.FormatString = "c";
                                }
                                else if (sFormatString.Contains("%"))
                                {
                                    field.CellFormat.FormatString = "p";
                                }
                                else
                                {
                                    field.CellFormat.FormatString = "n";
                                }
                            }
                        }

                        if (field.ValueFormat.FormatType == DevExpress.Utils.FormatType.Numeric)
                        {
                            String sFormatString = field.ValueFormat.FormatString.ToLower();
                            if (!sFormatString.Contains("c") && !sFormatString.Contains("n") && !sFormatString.Contains("p"))
                            {
                                if (sFormatString.Contains("$"))
                                {
                                    field.ValueFormat.FormatString = "c";
                                }
                                else if (sFormatString.Contains("%"))
                                {
                                    field.ValueFormat.FormatString = "p";
                                }
                                else
                                {
                                    field.ValueFormat.FormatString = "n";
                                }
                            }
                            field.CellFormat.FormatType   = field.ValueFormat.FormatType;
                            field.CellFormat.FormatString = field.ValueFormat.FormatString;
                        }
                    }
                }
            }
        }
예제 #3
0
        static void Main(System.String[] argss)
        {
            string[] args = { "report", "334", "PCD", "0000003,0000005,Job0000000001" };
            Dictionary <string, object> dicto = new Dictionary <string, object>();

            Utility.SetDefaultFormat(Thread.CurrentThread.CurrentCulture.Name);
            if (args.Length == 0)
            {
                Application.EnableVisualStyles();
                Application.SetCompatibleTextRenderingDefault(false);
                Application.Run(new ReportingForm());
            }
            else
            {
                if (args[0].ToLower() == "report")
                {
                    //Call and execute ALL the valid report jobs
                    string sLogFile             = "";
                    InfowareDataContext context = new InfowareDataContext();

                    IQueryable <rptmallst> rptMaster = from rptmaster in context.rptmallsts
                                                       where rptmaster.rptmltenab.Equals("Y")
                                                       orderby rptmaster.rptmltseqn ascending
                                                       select rptmaster;


                    IQueryable <rptJobMst_rptDetail> progRptQuery = from rptlist in context.rptjobmsts
                                                                    from rptdetail in context.rptmaldtls
                                                                    where rptlist.rptmstbrcd == rptdetail.rptmdlbrcd &&
                                                                    rptlist.rptmstcpcd == rptdetail.rptmdlcpcd &&
                                                                    rptlist.rptmstjbcd == rptdetail.rptmdljbcd &&
                                                                    rptdetail.rptmdlenab.Equals("Y")
                                                                    select new rptJobMst_rptDetail {
                        detail = rptdetail, master = rptlist
                    };


                    Dictionary <String, EmailServerInfo> emailInfoDict = new Dictionary <string, EmailServerInfo>();

                    emailInfoDict = (from rptlist in progRptQuery
                                     join emailSer in context.emrcorcmps
                                     on rptlist.detail.rptmdlcpcd equals emailSer.emrcmpcpcd
                                     select new
                    {
                        Key = rptlist.detail.rptmdlcpcd.Trim(),
                        Value = new EmailServerInfo
                        {
                            ServerName = emailSer.emrcmpemsr == null ? "" : emailSer.emrcmpemsr.Trim(),
                            UserID = emailSer.emrcmpesur == null ? "" : emailSer.emrcmpesur.Trim(),
                            Password = emailSer.emrcmpespd == null ? "" : emailSer.emrcmpespd.Trim()
                        }
                    }).Distinct().ToDictionary(p => p.Key, p => p.Value);
                    Email           emailService = Email.Instance;
                    EmailServerInfo emailInfo    = new EmailServerInfo();
                    if (String.IsNullOrWhiteSpace(emailInfo.ServerName))
                    {
                        emailInfo.ServerName = Settings.Default.DefaultEmailServerName;
                        emailInfo.UserID     = Settings.Default.DefaultEmailServerLogin;
                        emailInfo.Password   = Settings.Default.DefaultEmailServerPasword;
                    }

                    List <rptJobMst_rptDetail> progRptList       = new List <rptJobMst_rptDetail>();
                    List <rptmallst>           progRptMasterList = new List <rptmallst>();
                    if (args.Length == 3)
                    {
                        if (!string.IsNullOrEmpty(args[1]) && !string.IsNullOrEmpty(args[2]))
                        {
                            rptMaster    = rptMaster.Where(x => x.rptmltcpcd == args[1] && x.rptmltbrcd == args[2]);
                            progRptQuery = progRptQuery.Where(x => x.detail.rptmdlcpcd == args[1] && x.detail.rptmdlbrcd == args[2]);
                        }
                    }
                    if (args.Length == 4)
                    {
                        String[]      code     = args[3].Split(',');
                        List <string> codeList = new List <string>();
                        for (int i = 0; i < code.Length; i++)
                        {
                            if (code[i].Trim() != "")
                            {
                                codeList.Add(code[i]);
                            }
                        }
                        rptMaster    = rptMaster.Where(x => x.rptmltcpcd == args[1] && x.rptmltbrcd == args[2] && codeList.Contains(x.rptmltmlcd));
                        progRptQuery = progRptQuery.Where(x => x.detail.rptmdlcpcd == args[1] && x.detail.rptmdlbrcd == args[2] && codeList.Contains(x.detail.rptmdlmlcd));
                    }
                    progRptMasterList = rptMaster.ToList();
                    foreach (var value in progRptMasterList)
                    {
                        sLogFile    = Settings.Default.DefaultLogPath + Path.DirectorySeparatorChar + value.rptmltcpcd + Path.DirectorySeparatorChar + value.rptmltbrcd + Path.DirectorySeparatorChar + value.rptmltmlcd + Path.DirectorySeparatorChar + "log_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".txt";
                        progRptList = progRptQuery.Where(x => x.detail.rptmdlmlcd == value.rptmltmlcd && x.detail.rptmdlcpcd == value.rptmltcpcd && x.detail.rptmdlbrcd == value.rptmltbrcd).ToList();
                        Dictionary <String, List <string> > attachDic = new Dictionary <string, List <string> >();
                        List <string> attachmentList = new List <string>();
                        string        result         = "";
                        foreach (var rptValue in progRptList)
                        {
                            String sCpcd = Utility.NullToString(rptValue.detail.rptmdlcpcd.TrimEnd());
                            String sBrcd = Utility.NullToString(rptValue.detail.rptmdlbrcd.TrimEnd());
                            String sJbcd = Utility.NullToString(rptValue.detail.rptmdljbcd.TrimEnd());

                            String sModuleID   = Utility.NullToString(rptValue.master.rptmstmdcd);
                            String sProgramID  = Utility.NullToString(rptValue.master.rptmstpgid);
                            String sReportDesc = Utility.NullToString(rptValue.master.rptmstdesc);
                            if (sReportDesc == "")
                            {
                                sReportDesc = sProgramID;
                            }
                            string sepMail = Utility.NullToString(value.rptmltemal.TrimEnd());
                            IQueryable <rptjobpam> paramQuery = from rptpar in context.rptjobpams
                                                                where rptpar.rptpamjbcd.Equals(sJbcd) &&
                                                                rptpar.rptpamcpcd.Equals(sCpcd) &&
                                                                rptpar.rptpambrcd.Equals(sBrcd)
                                                                orderby rptpar.rptpampram ascending
                                                                select rptpar;

                            #region reportGeneration

                            try
                            {
                                String sFileDirectory = Settings.Default.OutputFilePath + Path.DirectorySeparatorChar + sCpcd + Path.DirectorySeparatorChar + sBrcd + Path.DirectorySeparatorChar + sJbcd;
                                if (!Directory.Exists(sFileDirectory))
                                {
                                    Directory.CreateDirectory(sFileDirectory);
                                }
                                string prefix = "";
                                if (Utility.NullToString(rptValue.master.rptmstrpnm) != "")
                                {
                                    prefix = Utility.NullToString(rptValue.master.rptmstrpnm);
                                }
                                else
                                {
                                    prefix = Utility.NullToString(rptValue.master.rptmstpgid);
                                }
                                string fileNameValue = prefix + "_" + DateTime.Now.ToString("yyyyMMdd") + "_" + DateTime.Now.ToString("HHmmss");

                                String sFilePath = sFileDirectory + Path.DirectorySeparatorChar + fileNameValue + "." + rptValue.master.rptmstfmcd.TrimEnd();

                                //if program id end with data, use the new approach
                                if (sProgramID.Trim().EndsWith("Data"))
                                {
                                    Type           reportType = Type.GetType("IS21DotNet.Reports." + sModuleID + "." + sProgramID + "");
                                    BaseReportData report     = (BaseReportData)Activator.CreateInstance(reportType);
                                    Dictionary <string, object> reportParameters = new Dictionary <string, object>();
                                    foreach (var row in paramQuery)    //neeed to be ordered
                                    {
                                        String sKey   = Utility.NullToString(row.rptpampram);
                                        String sType  = Utility.NullToString(row.rptpamvtyp).ToUpper();
                                        Object oValue = Utility.NullToString(row.rptpampval);

                                        reportParameters[sKey] = CaseValueByDataType(oValue, sType);
                                    }
                                    report.createFile(report.export(reportParameters, sFilePath), sFileDirectory, fileNameValue + "." + rptValue.master.rptmstfmcd.TrimEnd());
                                    attachmentList.Add(sFilePath);
                                }
                                else if (sProgramID.Trim().EndsWith("Alert"))
                                {
                                    Dictionary <string, object> reportParameters = new Dictionary <string, object>();
                                    Dictionary <string, object> rptLocc          = new Dictionary <string, object>();
                                    foreach (var row in paramQuery)    //neeed to be ordered
                                    {
                                        String sKey   = Utility.NullToString(row.rptpampram);
                                        String sType  = Utility.NullToString(row.rptpamvtyp).ToUpper();
                                        Object oValue = Utility.NullToString(row.rptpampval);

                                        reportParameters[sKey] = CaseValueByDataType(oValue, sType);
                                    }

                                    Type          reportType = Type.GetType("IS21DotNet.Reports.Alert." + sProgramID + "");
                                    BaseAlertData report     = (BaseAlertData)Activator.CreateInstance(reportType, reportParameters);
                                    if (!report.IsAttachFile)
                                    {
                                        result += report.ExportToHTML(reportParameters) + "<br>";
                                    }
                                    else
                                    {
                                        report.createFile(report.export(reportParameters, sFilePath), sFileDirectory, fileNameValue + "." + rptValue.master.rptmstfmcd.TrimEnd());
                                        attachmentList.Add(sFilePath);
                                    }
                                }
                                else
                                {
                                    Type       reportType = Type.GetType("IS21DotNet.Reports." + sModuleID + "." + sProgramID + "Report");
                                    BaseReport xrreport   = (BaseReport)Activator.CreateInstance(reportType);
                                    Dictionary <string, object> reportParameters = new Dictionary <string, object>();

                                    foreach (var row in paramQuery)
                                    {
                                        String sKey   = Utility.NullToString(row.rptpampram);
                                        String sType  = Utility.NullToString(row.rptpamvtyp).ToUpper();
                                        Object oValue = Utility.NullToString(row.rptpampval);

                                        reportParameters[sKey] = CaseValueByDataType(oValue, sType);
                                    }

                                    xrreport.SetParameters(reportParameters);
                                    xrreport.TranslateLabels(Translation.Instance, Settings.Default.Language);
                                    xrreport.RequestParameters = false;

                                    if (rptValue.master.rptmstfmcd.TrimEnd().Equals("pdf"))
                                    {
                                        xrreport.ExportToPdf(sFilePath);
                                    }
                                    else if (rptValue.master.rptmstfmcd.TrimEnd().Equals("xls"))
                                    {
                                        xrreport.ExportToXls(sFilePath);
                                    }
                                    else if (rptValue.master.rptmstfmcd.TrimEnd().Equals("xlsx"))
                                    {
                                        xrreport.ExportToXlsx(sFilePath);
                                    }
                                    attachmentList.Add(sFilePath);
                                }
                            }
                            catch (System.Exception ex)
                            {
                                Utility.WriteLog(DateTime.Now.ToString("yyy-MM-dd HH:mm:ss") + ", ReportName: " + sReportDesc + ", Cannot generate Report : Failed\n Exception Message: " + ex.Message + ex.InnerException + "\n" + ex.StackTrace, sLogFile);
                            }

                            #endregion
                            //}
                        }
                        if (emailInfoDict.ContainsKey(value.rptmltcpcd.TrimEnd()))
                        {
                            emailInfo = emailInfoDict[value.rptmltcpcd.TrimEnd()];
                        }
                        string message = GetMessage(value.rptmltmsgh, value.rptmltmsgc, value.rptmltmsgf, "", "");
                        if (attachmentList.Count > 0 || result != "")
                        {
                            if (result != "")
                            {
                                string sCpcdName = "";
                                try
                                {
                                    sCpcdName = Utility.NullToString(context.emrcorcmps
                                                                     .Where(a => a.emrcmpcpcd == value.rptmltcpcd.TrimEnd())
                                                                     .Select(b => b.emrcmpfnmp).SingleOrDefault(), "");
                                }
                                catch
                                {
                                    sCpcdName = "";
                                }

                                message = GetMessage(value.rptmltmsgh, value.rptmltmsgc, value.rptmltmsgf, result, sCpcdName);
                            }
                            emailService.SendEmail(value.rptmltemal, value.rptmltsubj, message, attachmentList, emailInfo);
                        }
                    }
                }
            }
        }