using System;
using System.IO;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Web.UI.WebControls;
using SuperMap.RealEstate.Data;
using SuperMap.RealEstate.Windows.Forms;
using SuperMap.RealEstate.Windows.Utility;
using SuperMap.RealEstate.Enums;
using SuperMap.RealEstate.Utility;
using SuperMap.RealEstate.CoreFrameWork;
using SuperMap.RealEstate.ServiceModel;
using SuperMap.RealEstate.Configuration;

namespace EndaccountManage
{
    public partial class Form1 : FormModule
    {
        string SERVERPART_CODE = System.Configuration.ConfigurationManager.AppSettings["SERVERPART_CODE"].ToString();
        string _TxtServerIP = System.Configuration.ConfigurationManager.AppSettings["TxtServerIP"].ToString();

        public Form1(string ModuleGuid, string UserName = "", string Password = "")
            : base(ModuleGuid, UserName, Password)
        {
            InitializeComponent();
            this.StartPosition = FormStartPosition.CenterScreen;
        }
        public Form1(string ModuleGuid, string[] args)
            : base(ModuleGuid, args)
        {
            InitializeComponent();
            this.StartPosition = FormStartPosition.CenterScreen;
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //toolStrip1.Items.Insert(3, new ToolStripControlHost(dtp));
            //toolStrip1.Items.Insert(5, new ToolStripControlHost(_DateTimePicker));
            InitInvoiceControlValue();
            SHOPMESSAGE.SelectedIndex = 0;
        }

        #region InitInvoiceControlValue 初始化 || 赋值
        /// <summary>
        /// 初始化
        /// </summary>
        private void InitInvoiceControlValue()
        {
            OracleHelper _OracleHelper = new OracleHelper(_TxtServerIP, "ORCL", "HIGHWAY_EXCHANGE", "qrwl");
            try
            {
                _OracleHelper.TestConn();

                try
                {
                    string SHOPMESSAGESql = "SELECT * FROM T_SHOPMESSAGE";
                    SHOPMESSAGE.Items.Clear();
                    SHOPMESSAGE.Items.Add("全部");
                    foreach (DataRow dr in _OracleHelper.ExcuteSqlGetDataSet(SHOPMESSAGESql, "T_SHOPMESSAGE").Tables[0].Rows)
                    {
                        ListItem _ListItemEx = new ListItem();
                        _ListItemEx.Text = "[" + dr["SHOPCODE"].ToString() + "]" + dr["SHOPNAME"].ToString();
                        _ListItemEx.Value = dr["SHOPCODE"].ToString();
                        SHOPMESSAGE.Items.Add(_ListItemEx);
                    }
                }
                catch
                {
                    //Process.Start("00_交互数据批处理脚本.bat");
                    if (File.Exists("导入交互数据表.txt"))
                    {
                        string WriteTxt = File.ReadAllText("导入交互数据表.txt");
                        string[] StringSql = WriteTxt.Replace("\r", "").Split('/');
                        _OracleHelper.ExecuteSqlTran(StringSql);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("连接错误,错误可能原因是:" + ex.Message);
            }
        }
        #endregion

        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            try
            {
                OracleHelper _OracleHelper = new OracleHelper(_TxtServerIP, "ORCL", "HIGHWAY_EXCHANGE", "qrwl");
                DataTable _DataTable = _OracleHelper.ExcuteSqlGetDataSet(
                    "SELECT * FROM T_ENDACCOUNT WHERE ENDACCOUNT_DATE IS NOT NULL AND SERVERPARTCODE = '" + SERVERPART_CODE +
                    ((string.IsNullOrEmpty(SHOPMESSAGE.Text) || SHOPMESSAGE.Text == "全部") ? "" : "' AND SHOPCODE = '" +
                    SHOPMESSAGE.Text.Split('[')[1].Split(']')[0]) + "' AND ENDACCOUNT_DATE >= TO_DATE('" + StartDate.Text +
                    "','YYYY/MM/DD') AND ENDACCOUNT_DATE < TO_DATE('" + EndDate.Text + "','YYYY/MM/DD') + 1", "T_ENDACCOUNT").Tables[0];
                dataGridView1.DataSource = _DataTable;
            }
            catch { }
        }
    }
}