using AegisImplicitMail;
using ClientLib;
using ClientLib.CommonService;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Views.Grid.ViewInfo;
using Popbill.Fax;
using PublicLib;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Net.Mail;
using System.Text;
using System.Windows.Forms;

namespace HANMI_SALE
{
    public partial class BillManager : PublicLib.CommonMDI
    {
        private DataTable m_Data, m_CustData;

        private string m_EMAIL, m_USER_ID, m_USER_PWD, m_SERVER_ADDR, m_BizNO;
        private int m_SERVER_PORT;

        private FaxService m_FaxService;

        public BillManager()
        {
            InitializeComponent();

          //  textEdit_CUST_NM.ImeMode = System.Windows.Forms.ImeMode.Hangul;

            gridControl_Main.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Flat;
            gridControl_Main.LookAndFeel.UseDefaultLookAndFeel = false;
            gridView_Main.Appearance.HeaderPanel.BackColor = Color.FromArgb(170, 204, 255);

            m_BizNO = UtilClass.toStr(ConstClass._GET_USER_INFO("BIZ_NO")).Replace("-", "");
            m_EMAIL = "";
            m_USER_ID = "";
            m_USER_PWD = "";
            m_SERVER_ADDR = "";
            m_SERVER_PORT = 0;

            m_CustData = new DataTable();
            m_CustData.Columns.Add("SEL_FIELD", typeof(string));
            m_CustData.Columns.Add("CUST_CD", typeof(string));
            m_CustData.Columns.Add("CUST_NM", typeof(string));
            m_CustData.Columns.Add("OWNER_NM", typeof(string));
            m_CustData.Columns.Add("FAX_NO", typeof(string));
            m_CustData.Columns.Add("EMAIL", typeof(string));
            m_CustData.Columns.Add("MAIL_YN", typeof(string));
            m_CustData.Columns.Add("FAX_YN", typeof(string));
            m_CustData.Columns.Add("SMS_YN", typeof(string));

            progressBarControl_Send.Visible = false;

            DateTime today = DateTime.Now.Date;
            if (today.Day <= 10)
            {
                today.AddMonths(-1);
            }

            DateTime firstDay = today.AddDays(1 - today.Day);
            DateTime lastDay = firstDay.AddMonths(1).AddDays(-1);

            dateEdit_SDATE.DateTime = firstDay;
            dateEdit_FDATE.DateTime = lastDay;

            simpleButton_PREV_DATE.Click += (sender, e) =>
            {
                DateTime BaseDate = dateEdit_SDATE.DateTime;
                DateTime MonthLastDate = BaseDate.AddDays(0 - BaseDate.Day);
                DateTime MonthFirstDate = MonthLastDate.AddDays(1 - MonthLastDate.Day);

                dateEdit_SDATE.DateTime = MonthFirstDate;
                dateEdit_FDATE.DateTime = MonthLastDate;
                searchProc();
            };

            simpleButton_NEXT_DATE.Click += (sender, e) =>
            {
                DateTime BaseDate = dateEdit_FDATE.DateTime.AddDays(1);
                DateTime MonthFirstDate = BaseDate.AddDays(1 - BaseDate.Day);
                DateTime MonthLastDate = MonthFirstDate.AddMonths(1).AddDays(-1);


                dateEdit_SDATE.DateTime = MonthFirstDate;
                dateEdit_FDATE.DateTime = MonthLastDate;
                searchProc();
            };

            simpleButton_Cust_Search.Click += (sender, e) =>
            {
                selectCustProc();
            };

            textEdit_CUST_NM.KeyPress += (sender, e) =>
            {
                if (e.KeyChar == '\r')
                {
                    selectCustProc();
                }
            };

            textEdit_CUST_NM.EditValueChanged += (sender, e) =>
            {
                if (UtilClass.isNull(textEdit_CUST_NM.Text))
                {
                    labelControl_CUST_CD.Text = "";
                }
            };

            gridView_Main.CustomDrawCell += (sender, e) =>
            {
                DataRow row = gridView_Main.GetDataRow(e.RowHandle);

                if (UtilClass.isEqual(row["TAG_STR"], "P"))
                {
                    e.Appearance.BackColor = Color.FromArgb(255, 255, 192);
                    e.Appearance.ForeColor = Color.DarkBlue;
                }
                else if (UtilClass.isEqual(row["TAG_STR"], "C"))
                {
                    e.Appearance.ForeColor = Color.Red;
                }
                else if (UtilClass.isEqual(row["TAG_STR"], "N"))
                {
                    e.Appearance.BackColor = Color.FromArgb(192, 255, 192);
                    e.Appearance.ForeColor = Color.DarkBlue;
                }
                else if (UtilClass.isEqual(row["TAG_STR"], "M"))
                {
                    e.Appearance.BackColor = Color.FromArgb(224, 224, 224);
                    e.Appearance.ForeColor = Color.DarkBlue;
                }
            };

            gridView_Main.CustomColumnDisplayText += (sender, e) =>
            {
                if (e.Column == gridView_Main.Columns["VAT_MY"] && UtilClass.toInt(e.Value) == -1)
                {
                    e.DisplayText = "전월잔액";
                }
                else if (e.Column == gridView_Main.Columns["VAT_MY"] && UtilClass.toInt(e.Value) == -2)
                {
                    e.DisplayText = "현재잔액";
                }
                //else if (e.Column == gridView_Main.Columns["ORDER_MY"] && m_bNoJan == true && UtilClass.toInt(e.Value) == int.MinValue)
                //{
                //    e.DisplayText = "--------";
                //}
            };

            gridView_Main.CustomDrawFooterCell += (sender, e) =>
            {
                //if (e.Column == gridView_Main.Columns["CASH_MY"])
                //{
                //    e.Info.DisplayText = m_CASH_MY.ToString("#,##0");
                //}
                //else if (e.Column == gridView_Main.Columns["DEP_MY"])
                //{
                //    e.Info.DisplayText = m_DEP_MY.ToString("#,##0");
                //}
                //else if (e.Column == gridView_Main.Columns["ETC_MY"])
                //{
                //    e.Info.DisplayText = m_ETC_MY.ToString("#,##0");
                //}
                //else if (e.Column == gridView_Main.Columns["COL_MY"])
                //{
                //    e.Info.DisplayText = m_COL_MY.ToString("#,##0");
                //}
            };

            m_FaxService = null;

            simpleButton_FAX_LOG.Click += (sender, e) =>
            {
                DataView s08 = new DataView(ConstClass._DATA);
                s08.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '08'";

                if (s08.Count < 1)
                {
                    XtraMessageBox.Show("팩스 전송을 위한 환경정보가 없습니다.");
                }
                string userID = UtilClass.toStr(s08[0]["NO_CD_NM"]);
                if (UtilClass.isNull(userID))
                {
                    XtraMessageBox.Show("팩스 전송을 위한 팝빌 등록정보가 없습니다.");
                    return;
                }

                string url = m_FaxService.GetSentListURL(m_BizNO, userID);
                Process.Start(url);
            };

            this.Shown += (sender, e) =>
            {
                try
                {
                    DataView s06 = new DataView(ConstClass._DATA);
                    s06.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '06'";
                    DataView s07 = new DataView(ConstClass._DATA);
                    s07.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '07'";
                    DataView s11 = new DataView(ConstClass._DATA);
                    s11.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '11'";

                    if (s06.Count > 0 || s07.Count > 0 || s11.Count > 0)
                    {
                        string linkID = UtilClass.toStr(s06[0]["NO_CD_NM"]);
                        string key = UtilClass.toStr(s07[0]["NO_CD_NM"]);
                        if (!UtilClass.isNull(linkID) && !UtilClass.isNull(key))
                        {
                            m_FaxService = new FaxService(linkID, key);
                            m_FaxService.IsTest = s11.Count > 0 && UtilClass.isEqual(s11[0]["NO_CD_NM"], "Y");
                        }
                    }

                    DataView s01 = new DataView(ConstClass._DATA);
                    s01.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '01'";
                    if (s01.Count > 0)
                    {
                        m_EMAIL = UtilClass.toStr(s01[0]["NO_CD_NM"]);
                    }
                    DataView view = new DataView(ConstClass._DATA);
                    view.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '01'";
                    m_USER_ID = UtilClass.toStr(view[0]["NO_CD_NM"]);
                    view.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '02'";
                    m_USER_PWD = UtilClass.toStr(view[0]["NO_CD_NM"]);
                    view.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '03'";
                    m_SERVER_ADDR = UtilClass.toStr(view[0]["NO_CD_NM"]);
                    view.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '04'";
                    m_SERVER_PORT = UtilClass.toInt(view[0]["NO_CD_NM"]);

                    if (m_FaxService != null)
                    {
                        double remainPoint = m_FaxService.GetBalance(m_BizNO);
                        labelControl_Point.Text = remainPoint.ToString("#,##0") + " P";
                    }
                }
                catch (Exception ex)
                {
                    XtraMessageBox.Show(ex.Message);
                    this.Close();
                }
            };
        }

        private void selectCustProc()
        {
            SelectCustomerForm form = new SelectCustomerForm(textEdit_CUST_NM.Text);
            if (form.ShowDialog() != System.Windows.Forms.DialogResult.Yes)
            {
                return;
            }
            textEdit_CUST_NM.Text = form.m_CUST_NN;
            labelControl_CUST_CD.Text = form.m_CUST_CD;
            searchProc();
        }

        //private bool m_bNoJan = false;
        private bool m_b2018 = false;

        public override void searchProc()
        {
            //if (dateEdit_SDATE.DateTime < new DateTime(2019, 1, 1))
            //    m_bNoJan = true;
            //else if (dateEdit_FDATE.DateTime < new DateTime(2019, 1, 1))
            //    m_bNoJan = true;
            //else
            //    m_bNoJan = false;

            if (dateEdit_SDATE.DateTime < new DateTime(2019, 1, 1))
                m_b2018 = true;
            else
                m_b2018 = false;

            try
            {

                this.Cursor = Cursors.WaitCursor;

                labelControl_PREV_JAN_MY.Text = "";
                labelControl_TOT_ORDER_MY.Text = "";
                labelControl_TOT_VAT_MY.Text = "";
                labelControl_TOT_COL_MY.Text = "";
                labelControl_TOT_JAN_MY.Text = "";

                gridControl_Main.DataSource = null;

                SerializedSqlParam[] aParam = new SerializedSqlParam[] {
                    ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
                    ClientClass.CreateSqlParameter("ORDER_SDATE", SqlDbType.NVarChar, dateEdit_SDATE.Text),
                    ClientClass.CreateSqlParameter("ORDER_FDATE", SqlDbType.NVarChar, dateEdit_FDATE.Text),
                    ClientClass.CreateSqlParameter("CUST_CD", SqlDbType.NVarChar, labelControl_CUST_CD.Text),
                    ClientClass.CreateSqlParameter("DT", SqlDbType.NVarChar, dateEdit_SDATE.Text),
                    ClientClass.CreateSqlParameter("PRINT_OPTION", SqlDbType.Int, comboBoxEdit_PRINT_OPTION.SelectedIndex),
                    ClientClass.CreateSqlParameter("REMARK_CONDITION", SqlDbType.Int, comboBoxEdit_REMARK_CONDITION.SelectedIndex)
                };

                ResultData resultData = null;
                if (m_b2018)
                    resultData = ClientClass.GetData("GetBillManager2018", aParam);
                else
                    resultData = ClientClass.GetData("GetBillManager", aParam);

                if (resultData.isError)
                {
                    throw new Exception(resultData.ResultValue);
                }

                m_CustData.Rows.Clear();

                decimal prev_jan_my = 0, tot_jan_my = 0, tot_curr_my = 0, tot_vat_my = 0, tot_order_my = 0, tot_col_my = 0;
                decimal now_jan_my = 0, mm_curr_my = 0, mm_vat_my = 0, mm_order_my = 0, mm_sum_my = 0;
                string cust_cd = "", yymm = "";
                DataRow row;
                m_Data = resultData.TableData;
                DataTable aData = m_Data.Clone();
                DataRow[] rows;
                DataRow cRow;
                for (int i = 0; i < m_Data.Rows.Count; i++)
                {
                    rows = m_CustData.Select("CUST_CD = '" + UtilClass.toStr(m_Data.Rows[i]["CUST_CD"]) + "'");
                    if (rows == null || rows.Length < 1)
                    {
                        cRow = m_CustData.NewRow();
                        cRow["SEL_FIELD"] = "Y";
                        cRow["CUST_CD"] = m_Data.Rows[i]["CUST_CD"];
                        cRow["CUST_NM"] = m_Data.Rows[i]["CUST_NM"];
                        cRow["OWNER_NM"] = m_Data.Rows[i]["OWNER_NM"];
                        cRow["FAX_NO"] = m_Data.Rows[i]["FAX_NO"];
                        cRow["EMAIL"] = m_Data.Rows[i]["EMAIL"];
                        cRow["MAIL_YN"] = "N";
                        cRow["FAX_YN"] = "N";
                        cRow["SMS_YN"] = "N";
                        m_CustData.Rows.Add(cRow);
                    }

                    if (!UtilClass.isEqual(cust_cd, m_Data.Rows[i]["CUST_CD"]))
                    {
                        if (i > 0)
                        {
                            // 월계 표현여부
                            if (checkEdit_MONTH_SUM.Checked && (mm_curr_my + mm_vat_my + mm_order_my) > 0)
                            {
                                row = aData.NewRow();
                                row["ORDER_DATE"] = "";
                                row["CUST_CD"] = m_Data.Rows[i - 1]["CUST_CD"];
                                row["FILE_NM"] = "월계";
                                row["ITEM_NM"] = "";
                                row["CURR_MY"] = mm_curr_my;
                                row["VAT_MY"] = mm_vat_my;
                                row["ORDER_MY"] = mm_order_my;
                                row["SUM_MY"] = mm_sum_my;
                                row["LN_RMK"] = "";
                                row["TAG_STR"] = "M";
                                row["SEND_MAIL_YN"] = m_Data.Rows[i - 1]["SEND_MAIL_YN"];
                                row["SEND_FAX_YN"] = m_Data.Rows[i - 1]["SEND_FAX_YN"];
                                row["SEND_SMS_YN"] = m_Data.Rows[i - 1]["SEND_SMS_YN"];
                                aData.Rows.Add(row);
                            }

                            row = aData.NewRow();
                            row["ORDER_DATE"] = "☆";
                            row["CUST_CD"] = m_Data.Rows[i - 1]["CUST_CD"];
                            row["FILE_NM"] = m_Data.Rows[i - 1]["CUST_NM"];
                            row["ITEM_NM"] = m_Data.Rows[i - 1]["CUST_CD"];
                            row["VAT_MY"] = -2;
                            row["ORDER_MY"] = now_jan_my; //m_bNoJan ? int.MinValue : now_jan_my;
                            row["SUM_MY"] = mm_sum_my;
                            row["LN_RMK"] = "";
                            row["TAG_STR"] = "N";
                            row["SEND_MAIL_YN"] = m_Data.Rows[i - 1]["SEND_MAIL_YN"];
                            row["SEND_FAX_YN"] = m_Data.Rows[i - 1]["SEND_FAX_YN"];
                            row["SEND_SMS_YN"] = m_Data.Rows[i - 1]["SEND_SMS_YN"];
                            aData.Rows.Add(row);

                            tot_jan_my += now_jan_my;
                        }

                        now_jan_my = 0;
                        mm_curr_my = 0;
                        mm_vat_my = 0;
                        mm_order_my = 0;
                        mm_sum_my = 0;
                        yymm = UtilClass.toStr(m_Data.Rows[i]["YYMM"]);

                        row = aData.NewRow();
                        row["ORDER_DATE"] = "★";
                        row["CUST_CD"] = m_Data.Rows[i]["CUST_CD"];
                        row["FILE_NM"] = m_Data.Rows[i]["CUST_NM"];
                        row["ITEM_NM"] = m_Data.Rows[i]["CUST_CD"];
                        row["VAT_MY"] = -1;
                        row["ORDER_MY"] = m_Data.Rows[i]["PREV_MONTH_MY"]; //m_bNoJan ? int.MinValue : m_Data.Rows[i]["PREV_MONTH_MY"];
                        row["LN_RMK"] = m_Data.Rows[i]["FAX_NO"];
                        row["TAG_STR"] = "P";
                        row["SEND_MAIL_YN"] = m_Data.Rows[i]["SEND_MAIL_YN"];
                        row["SEND_FAX_YN"] = m_Data.Rows[i]["SEND_FAX_YN"];
                        row["SEND_SMS_YN"] = m_Data.Rows[i]["SEND_SMS_YN"];
                        now_jan_my = UtilClass.toInt(m_Data.Rows[i]["PREV_MONTH_MY"]);
                        prev_jan_my += UtilClass.toInt(m_Data.Rows[i]["PREV_MONTH_MY"]);
                        aData.Rows.Add(row);
                    }

                    if (checkEdit_MONTH_SUM.Checked && !UtilClass.isEqual(yymm, m_Data.Rows[i]["YYMM"]))
                    {
                        row = aData.NewRow();
                        row["ORDER_DATE"] = "";
                        row["CUST_CD"] = m_Data.Rows[i]["CUST_CD"];
                        row["FILE_NM"] = "월계";
                        row["ITEM_NM"] = "";
                        row["CURR_MY"] = mm_curr_my;
                        row["VAT_MY"] = mm_vat_my;
                        row["ORDER_MY"] = mm_order_my;
                        row["SUM_MY"] = mm_sum_my;
                        row["LN_RMK"] = "";
                        row["TAG_STR"] = "M";
                        row["SEND_MAIL_YN"] = m_Data.Rows[i]["SEND_MAIL_YN"];
                        row["SEND_FAX_YN"] = m_Data.Rows[i]["SEND_FAX_YN"];
                        row["SEND_SMS_YN"] = m_Data.Rows[i]["SEND_SMS_YN"];
                        aData.Rows.Add(row);

                        mm_curr_my = 0;
                        mm_vat_my = 0;
                        mm_order_my = 0;
                    }

                    cust_cd = UtilClass.toStr(m_Data.Rows[i]["CUST_CD"]);
                    yymm = UtilClass.toStr(m_Data.Rows[i]["YYMM"]);

                    mm_curr_my += UtilClass.toInt(m_Data.Rows[i]["CURR_MY"]);
                    mm_vat_my += UtilClass.toInt(m_Data.Rows[i]["VAT_MY"]);
                    mm_order_my += UtilClass.toInt(m_Data.Rows[i]["ORDER_MY"]);

                    row = aData.NewRow();
                    row.ItemArray = m_Data.Rows[i].ItemArray;
                    if (UtilClass.isEqual(row["TAG_STR"], "S"))
                    {
                        now_jan_my += UtilClass.toInt(row["ORDER_MY"]);
                        tot_curr_my += UtilClass.toInt(m_Data.Rows[i]["CURR_MY"]);
                        tot_vat_my += UtilClass.toInt(m_Data.Rows[i]["VAT_MY"]);
                        tot_order_my += UtilClass.toInt(m_Data.Rows[i]["ORDER_MY"]);
                        mm_sum_my += UtilClass.toInt(m_Data.Rows[i]["ORDER_MY"]);
                    }
                    else if (UtilClass.isEqual(row["TAG_STR"], "C"))
                    {
                        now_jan_my -= UtilClass.toInt(row["CURR_MY"]);
                        tot_col_my += UtilClass.toInt(row["CURR_MY"]);
                    }
                    row["JAN_MY"] = now_jan_my;
                    aData.Rows.Add(row);

                    if (i == m_Data.Rows.Count - 1)
                    {
                        // 월계 표현여부
                        if (checkEdit_MONTH_SUM.Checked && (mm_curr_my + mm_vat_my + mm_order_my) > 0)
                        {
                            row = aData.NewRow();
                            row["ORDER_DATE"] = "";
                            row["CUST_CD"] = m_Data.Rows[i]["CUST_CD"];
                            row["FILE_NM"] = "월계";
                            row["ITEM_NM"] = "";
                            row["CURR_MY"] = mm_curr_my;
                            row["VAT_MY"] = mm_vat_my;
                            row["ORDER_MY"] = mm_order_my;
                            row["SUM_MY"] = mm_sum_my;
                            row["LN_RMK"] = "";
                            row["TAG_STR"] = "M";
                            row["SEND_MAIL_YN"] = m_Data.Rows[i]["SEND_MAIL_YN"];
                            row["SEND_FAX_YN"] = m_Data.Rows[i]["SEND_FAX_YN"];
                            row["SEND_SMS_YN"] = m_Data.Rows[i]["SEND_SMS_YN"];
                            aData.Rows.Add(row);
                        }

                        row = aData.NewRow();
                        row["ORDER_DATE"] = "☆";
                        row["CUST_CD"] = m_Data.Rows[i]["CUST_CD"];
                        row["FILE_NM"] = m_Data.Rows[i]["CUST_NM"];
                        row["ITEM_NM"] = m_Data.Rows[i]["CUST_CD"];
                        row["VAT_MY"] = -2;
                        row["ORDER_MY"] = now_jan_my; // m_bNoJan ? int.MinValue : now_jan_my;
                        row["SUM_MY"] = mm_sum_my;
                        row["LN_RMK"] = "";
                        row["TAG_STR"] = "N";
                        row["SEND_MAIL_YN"] = m_Data.Rows[i]["SEND_MAIL_YN"];
                        row["SEND_FAX_YN"] = m_Data.Rows[i]["SEND_FAX_YN"];
                        row["SEND_SMS_YN"] = m_Data.Rows[i]["SEND_SMS_YN"];
                        aData.Rows.Add(row);
                        tot_jan_my += now_jan_my;
                    }
                }

                labelControl_PREV_JAN_MY.Text = prev_jan_my.ToString("#,##0"); // m_bNoJan ? "--------" : prev_jan_my.ToString("#,##0");
                labelControl_TOT_CURR_MY.Text = tot_curr_my.ToString("#,##0");
                labelControl_TOT_VAT_MY.Text = tot_vat_my.ToString("#,##0");
                labelControl_TOT_ORDER_MY.Text = tot_order_my.ToString("#,##0");
                labelControl_TOT_COL_MY.Text = tot_col_my.ToString("#,##0");
                labelControl_TOT_JAN_MY.Text = tot_jan_my.ToString("#,##0"); // m_bNoJan ? "--------" : tot_jan_my.ToString("#,##0");

                aData.AcceptChanges();

                gridControl_Main.DataSource = aData;
                this.Cursor = Cursors.Arrow;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Arrow;
                XtraMessageBox.Show(ex.Message);
            }
        }

        public override void printProc()
        {
            SelectBillCustForm custForm = new SelectBillCustForm(m_CustData);
            if (custForm.ShowDialog() != DialogResult.Yes)
            {
                return;
            }

            try
            {
                this.Cursor = Cursors.WaitCursor;

                DataTable rTable = custForm.m_Data;

                DataRow[] srows = rTable.Select("SEL_FIELD = 'Y'");
                if (srows == null || srows.Length < 1)
                {
                    throw new Exception("선택된 거래처가 없습니다.");
                }

                DataTable data = m_Data.Clone();
                DataRow cRow;
                DataRow[] rows;
                decimal sum;
                decimal curr_my;
                DataView dv = new DataView(gridControl_Main.DataSource as DataTable);
                foreach (DataRow sRow in srows)
                {
                    rows = m_Data.Select("CUST_CD = '" + UtilClass.toStr(sRow["CUST_CD"]) + "'");
                    dv.RowFilter = "CUST_CD = '" + UtilClass.toStr(sRow["CUST_CD"]) + "' and ORDER_DATE = '☆'";
                    sum = 0; curr_my = 0;
                    for (int i = 0; i < rows.Length; i++)
                    {
                        cRow = data.NewRow();
                        cRow.ItemArray = rows[i].ItemArray;
                        data.Rows.Add(cRow);
                        if (UtilClass.isEqual(rows[i]["TAG_STR"], "S"))
                        {
                            sum += UtilClass.toInt(rows[i]["ORDER_MY"]);
                            curr_my += UtilClass.toInt(rows[i]["CURR_MY"]);
                        }

                        cRow["TMP_JAN"] = dv.Count > 0 ? UtilClass.toDecimal(dv[0]["ORDER_MY"]) : 0;
                        cRow["SUM_MY"] = sum;
                        cRow["SUM_CURR_MY"] = curr_my;
                    }
                }

                BillManagerReport report = new BillManagerReport(this);

                string order_date = dateEdit_SDATE.Text + " ~ " + dateEdit_FDATE.Text;
                //report.SetData(m_Data, data, order_date);
                report.setDataBinding(data, order_date);

                CommonPreview form = new CommonPreview("청구서", true, true);
                form.H1MultiMainSeld = true;
                form.SetH1Report(report);
                this.Cursor = Cursors.Arrow;
                if (form.ShowDialog() == DialogResult.Yes)
                {
                    ResultClass resultClass;
                    DataTable aData = report.DataSource as DataTable;
                    if (UtilClass.isEqual(form.m_SendType, "EMAIL"))
                    {
                        resultClass = this.mailProc(aData, srows);
                    }
                    else
                    {
                        if (m_FaxService == null)
                        {
                            MessageBox.Show("팩스 전송을 위한 환경이 갖추어지지 않았습니다.");
                            return;
                        }
                        resultClass = this.faxProc(aData, srows);
                    }

                    if (!resultClass.isError)
                    {
                        this.Cursor = Cursors.WaitCursor;

                        DataTable sendTable = new DataTable();
                        sendTable.Columns.Add("CUST_CD", typeof(string));
                        sendTable.Columns.Add("MAIL_YN", typeof(string));
                        sendTable.Columns.Add("FAX_YN", typeof(string));
                        sendTable.Columns.Add("SMS_YN", typeof(string));

                        DataRow sendRow;
                        foreach (DataRow ssRow in srows)
                        {
                            if (!UtilClass.isEqual(ssRow["MAIL_YN"], "Y") && !UtilClass.isEqual(ssRow["FAX_YN"], "Y")
                                        && !UtilClass.isEqual(ssRow["SMS_YN"], "Y"))
                            {
                                continue;
                            }
                            sendRow = sendTable.NewRow();
                            sendRow["CUST_CD"] = ssRow["CUST_CD"];
                            sendRow["MAIL_YN"] = ssRow["MAIL_YN"];
                            sendRow["FAX_YN"] = ssRow["FAX_YN"];
                            sendRow["SMS_YN"] = ssRow["SMS_YN"];
                            sendTable.Rows.Add(sendRow);
                        }

                        sendTable.TableName = "ADATA";
                        ResultData data1 = new ResultData();
                        data1.TableData = sendTable;
                        ResultData[] dataList = new ResultData[] { data1 };

                        SerializedSqlParam[] aParam = new SerializedSqlParam[] {
                            ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
                            ClientClass.CreateSqlParameter("YYMM", SqlDbType.NVarChar, dateEdit_FDATE.DateTime.ToString("yyyy-MM")),
                            ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID)
                        };

                        ResultData resultData = ClientClass.SetTableData("SaveBillManagerSendLog", dataList, aParam);
                        if (resultData.isError)
                        {
                            throw new Exception(resultData.ResultValue);
                        }

                        this.Cursor = Cursors.Arrow;

                        searchProc();
                    }
                }
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Arrow;
                XtraMessageBox.Show(ex.Message);
            }
        }

        public override void excelProc()
        {
            this.ExportExcelGrid(gridControl_Main);
        }

        private ResultClass mailProc(DataTable aData, DataRow[] argRows)
        {
            ResultClass mailResult = new ResultClass();

            try
            {
                this.Cursor = Cursors.WaitCursor;

                if (UtilClass.isNull(m_EMAIL) || UtilClass.isNull(m_USER_ID) || UtilClass.isNull(m_USER_PWD) ||
                        UtilClass.isNull(m_SERVER_ADDR) || UtilClass.toInt(m_SERVER_PORT) < 1)
                {
                    throw new Exception("메일 설정을 먼저 해야 합니다. 개발사에게 연락부탁드립니다.");
                }

                DataRow[] rows = aData.Select("EMAIL = ''");
                if (rows != null && rows.Length > 0)
                {
                    this.Cursor = Cursors.Arrow;
                    if (XtraMessageBox.Show("메일이 누락된 업체정보가 " + rows.Length + " 건이 있습니다.\n해당업체는 메일발송을 하지 못합니다.\n\n계속 하시겠습니까?", "메일발송", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) != DialogResult.Yes)
                    {
                        mailResult.isError = true;
                        mailResult.ResultStr = "메일 발송 취소";
                        return mailResult;
                    }
                }

                this.Cursor = Cursors.WaitCursor;

                BillManagerReport report;
                DataTable data = aData.Clone();
                DataRow row, aRow;
                string email, hp;
                ResultClass result;
                
                progressBarControl_Send.Properties.DisplayFormat.FormatString = "{0:#,##0} / " + argRows.Length.ToString("#,##0");
                progressBarControl_Send.Position = 0;
                progressBarControl_Send.Properties.Minimum = 0;
                progressBarControl_Send.Properties.Maximum = argRows.Length;
                progressBarControl_Send.Visible = true;
                Application.DoEvents();

                DataView dataView = new DataView(aData);
                for (int i = 0; i < argRows.Length; i++)
                {
                    progressBarControl_Send.Position++;
                    Application.DoEvents();

                    dataView.RowFilter = "CUST_CD = '" + UtilClass.toStr(argRows[i]["CUST_CD"]) + "'";
                    if (dataView.Count < 1)
                    {
                        continue;
                    }

                    aRow = dataView[0].Row;

                    email = UtilClass.toStr(aRow["EMAIL"]);
                    hp = UtilClass.toStr(aRow["TEL_NO"]);
                    //if (ConstClass._DEBUG_MODE)
                    //{
                    //    if (i % 3 == 0)
                    //    {
                    //        email = "zeromo@naver.com";
                    //        hp = "010-5571-3734";
                    //    }
                    //    else if (i % 3 == 1)
                    //    {
                    //        email = "jbeauty@naver.com";
                    //        hp = "010-2568-9089";
                    //    }
                    //    else if (i % 3 == 2)
                    //    {
                    //        email = "coldjun@nate.com";
                    //        hp = "010-7179-2554";
                    //    }
                    //    else
                    //    {
                    //        email = "uckuck@daum.net";
                    //        hp = "010-2568-9089";
                    //    }
                    //}

                    if (UtilClass.isNull(email))
                    {
                        continue;
                    }

                    for (int j = 0; j < dataView.Count; j++)
                    {
                        row = data.NewRow();
                        row.ItemArray = dataView[j].Row.ItemArray;
                        data.Rows.Add(row);
                    }

                    report = new BillManagerReport(this);
                    report.setDataBinding(data, dateEdit_SDATE.Text + " ~ " + dateEdit_FDATE.Text);

                    result = sendMail(report, email, hp, argRows[i]);
                    if (result.isError)
                    {
                        throw new Exception(result.ResultStr);
                    }
                    data.Rows.Clear();
                }

                this.Cursor = Cursors.Arrow;
                XtraMessageBox.Show("메일 발송 완료.");
                progressBarControl_Send.Visible = false;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Arrow;
                progressBarControl_Send.Visible = false;
                mailResult.isError = true;
                mailResult.ResultStr = ex.Message;
            }

            return mailResult;
        }

        private ResultClass faxProc(DataTable aData, DataRow[] argRows)
        {
            ResultClass faxResult = new ResultClass();

            try
            {
                this.Cursor = Cursors.WaitCursor;

                DataView s08 = new DataView(ConstClass._DATA);
                s08.RowFilter = "CATE_CD = 'S' and GRP_CD = 'S01' and NO_CD = '08'";

                if (s08.Count < 1)
                {
                    throw new Exception("팩스 전송을 위한 환경정보가 없습니다.");
                }

                string userID = UtilClass.toStr(s08[0]["NO_CD_NM"]);
                if (UtilClass.isNull(userID))
                {
                    throw new Exception("팩스 전송을 위한 팝빌 등록정보가 없습니다.");
                }

                object faxObj = ConstClass._GET_USER_INFO("FAX_NO");
                string myFaxNo = UtilClass.toStr(faxObj);
                
                if (UtilClass.isNull(myFaxNo) || UtilClass.isNull(m_BizNO))
                {
                    throw new Exception("회사정보관리에서 팩스번호 및 사업자번호를 입력하신 후, 시스템을 재시작하시길 바랍니다.");
                }

                DataRow[] rows = aData.Select("FAX_NO = ''");
                if (rows != null && rows.Length > 0)
                {
                    this.Cursor = Cursors.Arrow;
                    if (XtraMessageBox.Show("팩스번호가 누락된 업체정보가 " + rows.Length + " 건이 있습니다.\n해당업체는 팩스발송을 하지 못합니다.\n\n계속 하시겠습니까?", "메일발송", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) != DialogResult.Yes)
                    {
                        faxResult.isError = true;
                        faxResult.ResultStr = "팩스 발송 취소";
                        return faxResult;
                    }
                }

                this.Cursor = Cursors.WaitCursor;

                BillManagerReport report;
                DataTable data = aData.Clone();
                DataRow row, aRow;
                string fax, hp, cust_nm;
                ResultClass result;

                progressBarControl_Send.Properties.DisplayFormat.FormatString = "{0:#,##0} / " + argRows.Length.ToString("#,##0");
                progressBarControl_Send.Position = 0;
                progressBarControl_Send.Properties.Minimum = 0;
                progressBarControl_Send.Properties.Maximum = argRows.Length;
                progressBarControl_Send.Visible = true;
                Application.DoEvents();

                //int sendCnt = 0;
                DataView dataView = new DataView(aData);
                for (int i = 0; i < argRows.Length; i++)
                {
                    progressBarControl_Send.Position++;
                    Application.DoEvents();

                    dataView.RowFilter = "CUST_CD = '" + UtilClass.toStr(argRows[i]["CUST_CD"]) + "'";
                    if (dataView.Count < 1)
                    {
                        continue;
                    }

                    aRow = dataView[0].Row;

                    fax = UtilClass.toStr(aRow["FAX_NO"]);
                    hp = UtilClass.toStr(aRow["TEL_NO"]);
                    //if (ConstClass._DEBUG_MODE)
                    //{
                    //    if (i % 3 == 0)
                    //    {
                    //        fax = "0504-146-3734";
                    //        hp = "010-5571-3734";
                    //    }
                    //    else if (i % 3 == 1)
                    //    {
                    //        fax = "0504-146-3734";
                    //        hp = "010-2568-9089";
                    //    }
                    //    else if (i % 3 == 2)
                    //    {
                    //        fax = "0504-146-3734";
                    //        hp = "010-7179-2554";
                    //    }
                    //}

                    if (UtilClass.isNull(fax))
                    {
                        continue;
                    }

                    for (int j = 0; j < dataView.Count; j++)
                    {
                        row = data.NewRow();
                        row.ItemArray = dataView[j].Row.ItemArray;
                        data.Rows.Add(row);
                    }

                    report = new BillManagerReport(this);
                    report.setDataBinding(data, dateEdit_SDATE.Text + " ~ " + dateEdit_FDATE.Text);

                    cust_nm = UtilClass.toStr(aRow["CUST_NM"]);
                    result = sendFax(userID, m_BizNO, report, myFaxNo, fax, cust_nm, hp, argRows[i]);
                    if (result.isError)
                    {
                        throw new Exception(result.ResultStr);
                    }
                    //if (ConstClass._DEBUG_MODE)
                    //{
                    //    sendCnt++;
                    //    if (sendCnt > 2)
                    //    {
                    //        break;
                    //    }
                    //}
                    data.Rows.Clear();
                }

                if (m_FaxService != null)
                {
                    double remainPoint = m_FaxService.GetBalance(m_BizNO);
                    labelControl_Point.Text = remainPoint.ToString("#,##0") + " P";
                }

                this.Cursor = Cursors.Arrow;
                XtraMessageBox.Show("팩스 발송 완료.");
                progressBarControl_Send.Visible = false;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Arrow;
                progressBarControl_Send.Visible = false;

                faxResult.isError = true;
                faxResult.ResultStr = ex.Message;
            }

            return faxResult;
        }

        private ResultClass sendMail(BillManagerReport report, string email, string hp, DataRow sendRow)
        {
            ResultClass result = new ResultClass();
            try
            {
                MimeMailMessage mail = new MimeMailMessage();
                mail.AlternateViews.Add(AlternateView.CreateAlternateViewFromString("청구서",
                    Encoding.UTF8, "text/html"));
                mail.IsBodyHtml = false;
                mail.Body = "기간 : " + dateEdit_SDATE.Text + " ~ " + dateEdit_FDATE.Text + " 동안 발생한 거래분에 대해 청구서를 발송합니다.";
                mail.BodyEncoding = Encoding.UTF8;
                mail.SubjectEncoding = Encoding.UTF8;
                mail.Subject = ConstClass._COMP_NM + " 청구서(" + dateEdit_SDATE.Text + " ~ " + dateEdit_FDATE.Text + ")";

                mail.Sender = new MimeMailAddress(m_EMAIL, getEncodeDisplayName(ConstClass._COMP_NM));
                mail.From = new MimeMailAddress(m_EMAIL, getEncodeDisplayName(ConstClass._COMP_NM));
                mail.To.Add(email);

                string fileName = ConstClass._TEMP_PATH + ConstClass._TEMP_FILE_HEADER + DateTime.Now.ToString("yyyyMMdd_HHmmssfff") + ".pdf";
                report.ExportToPdf(fileName);
                Application.DoEvents();
                MimeAttachment attch = new MimeAttachment(fileName);
                Application.DoEvents();
                mail.Attachments.Add(attch);
                Application.DoEvents();

                SmtpSocketClient smtp = new SmtpSocketClient();
                smtp.Host = m_SERVER_ADDR;
                smtp.Port = m_SERVER_PORT;
                smtp.SslType = SslMode.Ssl;
                smtp.User = m_USER_ID;
                smtp.Password = m_USER_PWD;
                smtp.AuthenticationMode = AuthenticationType.Base64;
                smtp.SendCompleted += (sendere, ee) =>
                {
                    //if (File.Exists(fileName))
                    //{
                    //    File.Delete(fileName);
                    //}
                    if (ee.Error != null)
                    {
                        throw new Exception(ee.Error.Message);
                    }
                    else
                    {
                        sendRow["MAIL_YN"] = "Y";
                        if (!UtilClass.isNull(hp) && hp.StartsWith("01"))
                        {
                            sendRow["SMS_YN"] = "Y";
                            string msg = ConstClass._COMP_NM + "에서 기간 : " + dateEdit_SDATE.Text + " ~ " + dateEdit_FDATE.Text + " 동안 발생한 거래분에 대해 청구서를 발송하였습니다.";
                            //ClientClass.sendSMS(hp, msg);
                        }
                    }
                };

                smtp.SendMail(mail);
            }
            catch (Exception ex)
            {
                result.isError = true;
                result.ResultStr = ex.Message;
            }
            return result;
        }

        private ResultClass sendFax(string userID, string bizNo, BillManagerReport report,
                    string fromFax, string toFax, string toName, string hp, DataRow sendRow)
        {
            ResultClass result = new ResultClass();
            try
            {
                string requestNum = "HANMI" + DateTime.Now.ToString("yyyyMMddHHmmssfff");

                string fileName = ConstClass._TEMP_PATH + ConstClass._TEMP_FILE_HEADER + DateTime.Now.ToString("yyyyMMdd_HHmmssfff") + ".pdf";
                report.ExportToPdf(fileName);
                Application.DoEvents();
                
                DateTime? reserveDT = null;
                toName = toName + " 귀하";
                m_FaxService.SendFAX(bizNo.Replace("-", "").Replace(" ", ""), fromFax, toFax, toName,
                        fileName, reserveDT, userID, false, "청구서", requestNum);

                sendRow["FAX_YN"] = "Y";

                if (!UtilClass.isNull(hp) && hp.StartsWith("01"))
                {
                    sendRow["SMS_YN"] = "Y";
                    string msg = ConstClass._COMP_NM + "에서 기간 : " + dateEdit_SDATE.Text + " ~ " + dateEdit_FDATE.Text + " 동안 발생한 거래분에 대해 청구서를 발송하였습니다.";
                    //ClientClass.sendSMS(hp, msg);
                }

                //Application.DoEvents();
                //if (File.Exists(fileName))
                //{
                //    File.Delete(fileName);
                //}
            }
            catch (Exception ex)
            {
                result.isError = true;
                result.ResultStr = ex.Message;
            }
            return result;
        }

        private string getEncodeDisplayName(string str)
        {
            var fromEncoding = Encoding.UTF8;
            var encodingName = fromEncoding.BodyName.ToLower();
            return "=?" + encodingName + "?B?" + TransferEncoder.ToBase64(fromEncoding.GetBytes(str)) + "?=";
        }
    }
}