using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;

using System.Windows.Forms;

namespace HcgClientExport
{
    public partial class Form1 : Form
    {
        private static String selectorg = "全部";
        private static Dictionary<string, string> orgds;
        public string uid = "-1";
        public List<string> qx=new List<string>();
        public Form1()
        {
            InitializeComponent();
        }

        public static  string orgguid ;

        private DataControl control = new DataControl();
        private DataTable tablekuc = new DataTable();
        private DataTable tablekucmx = new DataTable();
        private DataTable tabgoodsusecurrent = new DataTable();
        private DataTable tabgoodsuse = new DataTable();
        private DataTable tabgoodshzuse = new DataTable();
        private DataTable tabgoodexpired = new DataTable();
        private DataTable tabgoodskuc = new DataTable();
        private DataTable tabgoodsrk = new DataTable();
        private DataTable tabgoodspick = new DataTable();
        private DataTable tabgoodsback = new DataTable();
        private DataTable tabbhcx = new DataTable();
        private DataTable tabbhxh = new DataTable();
        private List<DataGridView> dvs = new List<DataGridView>(); //表格集合
        string currentdate = string.Empty;
        private void Form1_Load(object sender, EventArgs e)
        {
            string org = ConfigurationManager.AppSettings["orgguid"];
            Form1.orgds  = new Dictionary<string, string>();
            if (org != null) {
                string[] gs = org.Split(',');
                int i = 0;
                foreach (string each in gs) {
                    string[] orgdet = each.Split('~');
                    if (i == 0) {
                        orgguid = orgdet[1];
                    }
                    Form1.orgds.Add(orgdet[0], orgdet[1]);
                    i++;
                }
            }
            
            string sysname = ConfigurationManager.AppSettings["SysName"];
            this.Text = sysname;
            cxb_expired.SelectedIndex = 0;
            GetkucMx();
            for (int i = 0; i < tabkcxx.Controls.Count; i++) {
                if (tabkcxx.Controls[i].Name.Equals("tabPage13"))
                {
                    continue;
                }
                Label l = new Label();
                l.Text = "科室：";
                l.Location = new Point(800, 25);
                l.Size = new Size(55, 24);
                ComboBox c = new ComboBox();
                c.Tag = "org";
                // c.Items.Add("全部");
                //c.Items.Add("测试1");
                foreach (var item in Form1.orgds) {
                    c.Items.Add(item.Key);
                }
                c.SelectedIndex = 0;
                
                c.SelectedIndexChanged += cxb_c_SelectedIndexChanged;
              
                c.Location = new Point(855, 22);
                tabkcxx.Controls[i].Controls[0].Controls[1].Controls[0].Controls.Add(l);
              //  tabControl1.Controls[i].Controls[0].Controls[1].Controls[0].Controls.SetChildIndex(c, 3);
                tabkcxx.Controls[i].Controls[0].Controls[1].Controls[0].Controls.Add(c);
                // MessageBox.Show(tabControl1.Controls[i].Controls[0].Controls[1].Controls[0].Controls.Count.ToString());
                // for(int )
            }
            
            this.Width = 1100;
            
            for(int i=0;i<this.tabkcxx.TabCount;i++)
            {
                if(this.tabkcxx.TabPages[i].Controls[0].Controls.Count!=3)//排除设置
                {
                    return;
                }
                if(((this.tabkcxx.TabPages[i].Controls[0].Controls)[2].Controls[0] is DataGridView))
                {
                    dvs.Add((this.tabkcxx.TabPages[i].Controls[0].Controls)[2].Controls[0] as DataGridView);
                    ((this.tabkcxx.TabPages[i].Controls[0].Controls)[2].Controls[0] as DataGridView).ContextMenuStrip = this.concopy;
                    ((this.tabkcxx.TabPages[i].Controls[0].Controls)[2].Controls[0] as DataGridView).CellContextMenuStripNeeded+= new System.Windows.Forms.DataGridViewCellContextMenuStripNeededEventHandler(this.dgv_Change_CellContextMenuStripNeeded);
                    //((this.tabkcxx.TabPages[i].Controls[0].Controls)[2].Controls[0] as DataGridView).Columns[]
                }
            }
        }
        private string message = "-1";
        private void dgv_Change_CellContextMenuStripNeeded(object sender, DataGridViewCellContextMenuStripNeededEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                if ((sender as DataGridView).Rows.Count == 0)
                {
                    this.toolStripMenuItem1.Text = "复制";
                }
                else
                {
                    message = (sender as DataGridView).Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
                    this.toolStripMenuItem1.Text = "复制" + (sender as DataGridView).Columns[e.ColumnIndex].HeaderText;
                    e.ContextMenuStrip = this.concopy;
                }
            }
        }
        private void cxb_c_SelectedIndexChanged(object sender, EventArgs e)
        {
          
            Form1.selectorg = ((ComboBox)sender).Text;
            orgguid = Form1.orgds[Form1.selectorg];
            MySQLHelper.connectionString = ConfigurationManager.AppSettings[orgguid];
            reft();
            for (int i = 0; i < tabkcxx.Controls.Count; i++)
            {
               
                for (int j = 0; j < tabkcxx.Controls[i].Controls[0].Controls[1].Controls[0].Controls.Count; j++)
                {
                    if (tabkcxx.Controls[i].Controls[0].Controls[1].Controls[0].Controls[j] is ComboBox) {
                        if (((ComboBox)tabkcxx.Controls[i].Controls[0].Controls[1].Controls[0].Controls[j]).Tag!=null && ((ComboBox)tabkcxx.Controls[i].Controls[0].Controls[1].Controls[0].Controls[j]).Tag.Equals("org")) {
                            ((ComboBox)tabkcxx.Controls[i].Controls[0].Controls[1].Controls[0].Controls[j]).SelectedIndexChanged -= cxb_c_SelectedIndexChanged;
                            // ((ComboBox)tabControl1.Controls[i].Controls[0].Controls[1].Controls[0].Controls[j]).SelectedIndexChanged += null;
                            ((ComboBox)tabkcxx.Controls[i].Controls[0].Controls[1].Controls[0].Controls[j]).SelectedIndex = ((ComboBox)sender).SelectedIndex;
                            ((ComboBox)tabkcxx.Controls[i].Controls[0].Controls[1].Controls[0].Controls[j]).SelectedIndexChanged += cxb_c_SelectedIndexChanged;
                            break;
                        }
                    }
                }
                // GetexpiredKucMx();
            }
        }
        private void GetKucInfo()
        {
            try
            {
                tablekuc = control.GetKucInfo(orgguid);
                this.dgv_Detail.DataSource = tablekuc;
                DataTable table = GetDgvToTable(this.dgv_Detail);
                int sum = 0;
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    sum = sum + Convert.ToInt32(table.Rows[i]["数量"].ToString());
                }
                lab_kuchz.Text = "库存数"+ " "+ sum.ToString();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        public DataTable GetDgvToTable(DataGridView dgv)
        {
            DataTable dt = new DataTable();
            dt.TableName = dgv.Tag.ToString();
            for (int count = 0; count < dgv.Columns.Count; count++)
            {
                DataColumn dc = new DataColumn(dgv.Columns[count].HeaderText.ToString());
                dt.Columns.Add(dc);
            }
            for (int count = 0; count < dgv.Rows.Count; count++)
            {
                DataRow dr = dt.NewRow();
                for (int countsub = 0; countsub < dgv.Columns.Count; countsub++)
                {
                    dr[countsub] = Convert.ToString(dgv.Rows[count].Cells[countsub].Value);
                }

                dt.Rows.Add(dr);
            }
            return dt;
        }

        private void btn_export_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_Detail);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }

     
        private void btn_refresh_Click(object sender, EventArgs e)
        {
            GetKucInfo();
        }

        private void txt_Goods_TextChanged(object sender, EventArgs e)
        {
            KucFilter();
        }

        private void KucFilter()
        {
            try
            {
                if (txt_Goods.Text.Trim().Length < 1)
                {
                    tablekuc.DefaultView.RowFilter = "";
                }
                else
                {
                    tablekuc.DefaultView.RowFilter = string.Format("  商品编码 LIKE '%{0}%' OR 商品名称 LIKE '%{0}%' OR 生产厂家 LIKE '%{0}%'  OR 供应商 LIKE '%{0}%' OR  规格 LIKE '%{0}%' OR  柜子 LIKE '%{0}%' ", txt_Goods.Text);
                }
                dgv_Detail.DataSource = tablekuc.DefaultView.Table;
                DataTable table = GetDgvToTable(this.dgv_Detail);
                int sum = 0;
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    sum = sum + Convert.ToInt32(table.Rows[i]["数量"].ToString());
                }
                lab_kuchz.Text = "库存数" + " " + sum.ToString();

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void GoodsUseDayFilter()
        {
           
         try
            {
                if (txb_currentdayfilter.Text.Trim().Length < 1)
                {
                    tabgoodsusecurrent.DefaultView.RowFilter = "";
                }
                else
                {
                    tabgoodsusecurrent.DefaultView.RowFilter = string.Format("  商品编码1 LIKE '%{0}%' OR 商品名称1 LIKE '%{0}%' OR 生产厂家1 LIKE '%{0}%'  OR 供应商1 LIKE '%{0}%' OR  规格1 LIKE '%{0}%' ", txb_currentdayfilter.Text);
                }
                dgv_goodsusecurrentday.DataSource = tabgoodsusecurrent.DefaultView.Table;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void GoodsUseFilter()
        {

            try
            {
                if (txb_goodsuse.Text.Trim().Length < 1)
                {
                    tabgoodsuse.DefaultView.RowFilter = "";
                }
                else
                {
                    tabgoodsuse.DefaultView.RowFilter = string.Format("  商品编码2 LIKE '%{0}%' OR 商品名称2 LIKE '%{0}%' OR 生产厂家2 LIKE '%{0}%'  OR 供应商2 LIKE '%{0}%' OR  规格2 LIKE '%{0}%'", txb_goodsuse.Text);
                }
               dgv_goodsuse.DataSource = tabgoodsuse.DefaultView.Table;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            GetGoodsUseCurretDay();
        }

        private void GetGoodsUseCurretDay()
        {
            try
            {
                string begin_time = this.dtp_Start_A.Value.Year.ToString() + "/" + this.dtp_Start_A.Value.Month.ToString() + "/" + this.dtp_Start_A.Value.Day.ToString() + " " + this.dtp_Start_A.Value.Hour.ToString() + ":00:00";
                string end_time = this.dtp_End_A.Value.Year.ToString() + "/" + this.dtp_End_A.Value.Month.ToString() + "/" + this.dtp_End_A.Value.Day.ToString() + " " + this.dtp_End_A.Value.Hour.ToString() + ":59:59";

                tabgoodsusecurrent = control.GetGoodsUseHzCurrentDayInfo(orgguid, begin_time, end_time);
                dgv_goodsusecurrentday.DataSource = tabgoodsusecurrent;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void GetGoodsUse()
        {
            try
            {
                string begin_time = this.dtp_Start_B.Value.Year.ToString() + "/" + this.dtp_Start_B.Value.Month.ToString() + "/" + this.dtp_Start_B.Value.Day.ToString() + " 00:00:00";
                string end_time =  this.dtp_End_B.Value.AddDays(1).Year.ToString() + "/"+ this.dtp_End_B.Value.AddDays(1).Month.ToString() + "/" + this.dtp_End_B.Value.AddDays(1).Day.ToString()+" 00:00:00";

                tabgoodsuse = control.GetGoodsUseInfo(orgguid, begin_time, end_time);
                dgv_goodsuse.DataSource = tabgoodsuse;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
        {
            reft();
        }
        private void reft(){

            if (tabkcxx.SelectedIndex == 0)
            { GetkucMx(); }
            else if (tabkcxx.SelectedIndex == 1)
            { GetKucInfo(); }
            else if (tabkcxx.SelectedIndex == 2)
            {
                GetGoodskucInfo();
            }
            else if (tabkcxx.SelectedIndex == 3)
            {
                GetGoodsUseCurretDay();
            }
            else if (tabkcxx.SelectedIndex == 4)
            { GetGoodsUse(); }
            else if (tabkcxx.SelectedIndex == 5)
            {
                GetGoodsHzUse();
            }
            else if (tabkcxx.SelectedIndex == 6)
            {
                GetexpiredKucMx();
            }
            else if (tabkcxx.SelectedIndex == 7)
            { GetGoodsRkInfo(); }
            else if (tabkcxx.SelectedIndex == 8)
            { GetGoodspickInfo(); }
            else if (tabkcxx.SelectedIndex == 9)
            { GetGoodsbackInfo(); }
            else if (tabkcxx.SelectedIndex == 10) {
                Getbhcc();
            }
            else if (tabkcxx.SelectedIndex == 11)
            {
                Getxh();
            }
        }
        private void txb_currentdayfilter_TextChanged(object sender, EventArgs e)
        {
            GoodsUseDayFilter();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_goodsusecurrentday);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            GetGoodsUse();
        }



        private void txb_goodsuse_TextChanged(object sender, EventArgs e)
        {
            GoodsUseFilter();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_goodsuse);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void GetGoodsHzUse()
        {
            try
            {
                string begin_time = this.dtp_Start_C.Value.Year.ToString() + "/" + this.dtp_Start_C.Value.Month.ToString() + "/" + this.dtp_Start_C.Value.Day.ToString() + " 00:00:00";
                string end_time = this.dtp_End_C.Value.AddDays(1).Year.ToString() + "/" + this.dtp_End_C.Value.AddDays(1).Month.ToString() + "/"  + this.dtp_End_C.Value.AddDays(1).Day.ToString() + " 00:00:00";

                tabgoodshzuse = control.GetGoodsUseHzInfo(orgguid, begin_time, end_time);
                dgv_goodsusehz.DataSource = tabgoodshzuse;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void GoodsUseHzFilter()
        {

            try
            {
                if (txb_goodsusehz.Text.Trim().Length < 1)
                {
                    tabgoodshzuse.DefaultView.RowFilter = "";
                }
                else
                {
                    tabgoodshzuse.DefaultView.RowFilter = string.Format("  商品编码3 LIKE '%{0}%' OR 商品名称3 LIKE '%{0}%' OR 生产厂家3 LIKE '%{0}%'  OR 供应商3 LIKE '%{0}%'  OR  规格3 LIKE '%{0}%'", txb_goodsusehz.Text);
                }
                dgv_goodsusehz.DataSource = tabgoodshzuse.DefaultView.Table;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }
        private void btn_refresh_goodshzuse_Click(object sender, EventArgs e)
        {
            GetGoodsHzUse();
        }

        private void txb_goodsusehz_TextChanged(object sender, EventArgs e)
        {
            GoodsUseHzFilter();
        }

        private void button6_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_goodsusehz);
                
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void GetkucMx()
        {
            try
            {
                tablekucmx = control.GetKucMxInfo(orgguid);
                this.dgv_kucmx.DataSource = tablekucmx;
                int sum = 0;
                DataTable table = GetDgvToTable(this.dgv_kucmx);
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    sum = sum + Convert.ToInt32(table.Rows[i]["数量"].ToString());
                }
                lab_kucmx.Text = "库存数:" +"  "+ sum.ToString();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void btn_kucmx_Click(object sender, EventArgs e)
        {
            GetkucMx();

      
        }

        private void GetexpiredKucMx()
        {
            try
            {
                tabgoodexpired = control.GetExpiteKucMxInfo(orgguid,cxb_expired.Text.ToString());
                this.dgv_expired.DataSource = tabgoodexpired;
                int sum = 0;
                DataTable table = GetDgvToTable(this.dgv_expired);
                
                lbl_expired.Text = "库存数:" + "  " + table.Rows.Count.ToString();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void Getbhcc()
        {
            try
            {
                tabbhcx = control.Getbhxxinfo(orgguid);
               
                this.databh.DataSource = tabbhcx;
                this.databh.Columns["dataGridViewTextBoxColumn15"].DisplayIndex = 6;
                for (int i = 0; i < this.databh.Rows.Count; i++)
                {
                    this.databh.Rows[i].Cells["dataGridViewTextBoxColumn15"].Value = control.Getgoodskccount(orgguid, tabbhcx.Rows[i]["商品编码bh"].ToString());
                    this.databh.Rows[i].Cells["dataGridViewTextBoxColumn7"].Value = i + 1;
                    int sx = int.Parse(tabbhcx.Rows[i]["库存上限bh"].ToString());
                    int xx = int.Parse(tabbhcx.Rows[i]["库存下限bh"].ToString());
                    int cursl = int.Parse(tabbhcx.Rows[i]["数量bh"].ToString());
                    tabbhcx.Rows[i]["数量bh"] = this.databh.Rows[i].Cells["dataGridViewTextBoxColumn15"].Value;
                    tabbhcx.Rows[i]["rownumbh"] = this.databh.Rows[i].Cells["dataGridViewTextBoxColumn7"].Value;
                    if (cursl > sx)
                    {

                        this.databh.Rows[i].Cells["dataGridViewTextBoxColumn17"].Value = "超出: " + (cursl - sx);
                        this.databh.Rows[i].Cells["dataGridViewTextBoxColumn17"].Style.ForeColor = Color.Orange;
                    }
                    else if (cursl < xx)
                    {
                        this.databh.Rows[i].Cells["dataGridViewTextBoxColumn17"].Value = "需补: " + (sx - cursl);
                        this.databh.Rows[i].Cells["dataGridViewTextBoxColumn17"].Style.ForeColor = Color.Red;
                    }
                    else
                    {
                        this.databh.Rows[i].Cells["dataGridViewTextBoxColumn17"].Value = "正常";
                        this.databh.Rows[i].Cells["dataGridViewTextBoxColumn17"].Style.ForeColor = Color.Green;
                    }
                    tabbhcx.Rows[i]["建议补货bh"] = this.databh.Rows[i].Cells["dataGridViewTextBoxColumn17"].Value;
                }
                DataTable table = GetDgvToTable(this.databh);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.StackTrace);
            }
        }
        private void expiredMxFilter()
        {

            try
            {
                if (txb_expired.Text.Trim().Length < 1)
                {
                    tabgoodexpired.DefaultView.RowFilter = "";
                }
                else
                {
                    tabgoodexpired.DefaultView.RowFilter = string.Format("  商品编码5 LIKE '%{0}%' OR 商品名称5 LIKE '%{0}%' OR 生产厂家5 LIKE '%{0}%'  OR 供应商5 LIKE '%{0}%' OR 高值码5 LIKE '%{0}%' OR  规格5 LIKE '%{0}%'  OR  柜子5 LIKE '%{0}%'", txb_expired.Text);
                }
                dgv_expired.DataSource = tabgoodexpired.DefaultView.Table;
                DataTable table = GetDgvToTable(this.dgv_expired);
                
                lbl_expired.Text = "库存数:" + "  " + table.Rows.Count;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }


        private void kucMxFilter()
        {

            try
            {
                if (txb_kucmx.Text.Trim().Length < 1)
                {
                    tablekucmx.DefaultView.RowFilter = "";
                }
                else
                {
                    tablekucmx.DefaultView.RowFilter = string.Format("  商品编码4 LIKE '%{0}%' OR 商品名称4 LIKE '%{0}%' OR 生产厂家4 LIKE '%{0}%'  OR 供应商4 LIKE '%{0}%' OR 高值码4 LIKE '%{0}%' OR  规格4 LIKE '%{0}%'  OR  柜子4 LIKE '%{0}%' ", txb_kucmx.Text);
                }
                dgv_kucmx.DataSource = tablekucmx.DefaultView.Table;
                DataTable table = GetDgvToTable(this.dgv_kucmx);
                lab_kucmx.Text = "库存数:" + "  " +table.Rows.Count.ToString();

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void txb_kucmx_TextChanged(object sender, EventArgs e)
        {
            kucMxFilter();
        }

        private void btn_kucmxexport_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_kucmx);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void dgv_goodsuse_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void cxb_expired_SelectedIndexChanged(object sender, EventArgs e)
        {
            GetexpiredKucMx();
        }

        private void btn_refresh_expired_Click(object sender, EventArgs e)
        {
            GetexpiredKucMx();
        }

        private void btn_export_expired_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_expired);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void txb_expired_TextChanged(object sender, EventArgs e)
        {
            expiredMxFilter();
        }

        private void GetGoodskucInfo()
        {
            try
            {
                tabgoodskuc = control.GetGoodsKucInfo(orgguid);
                this.dgv_goodskuc.DataSource = tabgoodskuc;
                int sum = 0;
                DataTable table = GetDgvToTable(this.dgv_goodskuc);
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    int cursl = Convert.ToInt32(table.Rows[i]["数量"].ToString());
                    sum = sum + cursl;
                   
                }
                lbl_goodskuc.Text = "库存数:" + "  " + sum.ToString();
        


            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }

        private void btn_goodskuc_Click(object sender, EventArgs e)
        {
            GetGoodskucInfo();

        }

        private void btn_exportgoodskuc_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_goodskuc);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void txt_goodskuc_TextChanged(object sender, EventArgs e)
        {
            GoodsKucFilter();
        }

        private void GoodsKucFilter()
        {

            try
            {
                if (txt_goodskuc.Text.Trim().Length < 1)
                {
                    tabgoodskuc.DefaultView.RowFilter = "";
                }
                else
                {
                    tabgoodskuc.DefaultView.RowFilter = string.Format("  商品编码6 LIKE '%{0}%' OR 商品名称6 LIKE '%{0}%' OR 生产厂家6 LIKE '%{0}%'  OR 供应商6 LIKE '%{0}%'  OR  规格6 LIKE '%{0}%'  OR  柜子6 LIKE '%{0}%' ", txt_goodskuc.Text);
                }
                dgv_goodskuc.DataSource = tabgoodskuc.DefaultView.Table;
                int sum = 0;
                DataTable table = GetDgvToTable(this.dgv_goodskuc);
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    sum = sum + Convert.ToInt32(table.Rows[i]["数量"].ToString());
                }
                lbl_goodskuc.Text = "库存数:" + "  " + sum.ToString();

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void GetGoodsRkInfo()
        {
            try
            {
                string begin_time = this.date_start_rk.Value.Year.ToString() + "/" + this.date_start_rk.Value.Month.ToString() + "/" + this.date_start_rk.Value.Day.ToString() + " 00:00:00";
                string end_time = this.date_end_rk.Value.AddDays(1).Year.ToString() + "/" + this.date_end_rk.Value.AddDays(1).Month.ToString() + "/" + this.date_end_rk.Value.AddDays(1).Day.ToString() + " 00:00:00";

                tabgoodsrk = control.GetGoodsRkInfo(orgguid,begin_time,end_time);
                this.dgv_rk.DataSource = tabgoodsrk;
               
          }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }

        private void GoodsRkFilter()
        {

            try
            {
                if (txb_rk.Text.Trim().Length < 1)
                {
                    tabgoodsrk.DefaultView.RowFilter = "";
                }
                else
                {
                    tabgoodsrk.DefaultView.RowFilter = string.Format("  商品编码7 LIKE '%{0}%' OR 商品名称7 LIKE '%{0}%' OR 生产厂家7 LIKE '%{0}%'  OR 供应商7 LIKE '%{0}%'  OR  规格7 LIKE '%{0}%'  OR  柜子7 LIKE '%{0}%' ", txb_rk.Text);
                }
                dgv_rk.DataSource = tabgoodsrk.DefaultView.Table;
               
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void btn_rk_refresh_Click(object sender, EventArgs e)
        {
            GetGoodsRkInfo();
        }

        private void txb_rk_TextChanged(object sender, EventArgs e)
        {
            GoodsRkFilter();
        }

        private void btn_rk_export_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_rk);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }



        private void GetGoodspickInfo()
        {
            try
            {
                string begin_time = this.date_start_pick.Value.Year.ToString() + "/" + this.date_start_pick.Value.Month.ToString() + "/" + this.date_start_pick.Value.Day.ToString() + " 00:00:00";
                string end_time = this.date_end_pick.Value.AddDays(1).Year.ToString() + "/" + this.date_end_pick.Value.AddDays(1).Month.ToString() + "/" + this.date_end_pick.Value.AddDays(1).Day.ToString() + " 00:00:00";

                tabgoodspick = control.GetGoodsPickInfo(orgguid, begin_time, end_time);
                this.dgv_pick.DataSource = tabgoodspick;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }

        private void GoodsPickFilter()
        {

            try
            {
                if (txb_pick.Text.Trim().Length < 1)
                {
                    tabgoodspick.DefaultView.RowFilter = "";
                }
                else
                {
                    tabgoodspick.DefaultView.RowFilter = string.Format("  商品编码8 LIKE '%{0}%' OR 商品名称8 LIKE '%{0}%' OR 生产厂家8 LIKE '%{0}%'  OR 供应商8 LIKE '%{0}%'  OR  规格8 LIKE '%{0}%'  OR  柜子8 LIKE '%{0}%' ", txb_pick.Text);
                }
                dgv_pick.DataSource = tabgoodspick.DefaultView.Table;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }
        private void btn_pick_refresh_Click(object sender, EventArgs e)
        {
            GetGoodspickInfo();
        }

        private void txb_pick_TextChanged(object sender, EventArgs e)
        {
            GoodsPickFilter();

        }

        private void btn_pick_export_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_pick);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void GetGoodsbackInfo()
        {
            try
            {
                string begin_time = this.date_start_back.Value.Year.ToString() + "/" + this.date_start_back.Value.Month.ToString() + "/" + this.date_start_back.Value.Day.ToString() + " 00:00:00";
                string end_time = this.date_end_back.Value.AddDays(1).Year.ToString() + "/" + this.date_end_back.Value.AddDays(1).Month.ToString() + "/" + this.date_end_back.Value.AddDays(1).Day.ToString() + " 00:00:00";

                tabgoodsback = control.GetGoodsBackInfo(orgguid, begin_time, end_time);
                this.dgv_back.DataSource = tabgoodsback;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }

        private void GoodsBackFilter()
        {

            try
            {
                if (txb_back.Text.Trim().Length < 1)
                {
                    tabgoodsback.DefaultView.RowFilter = "";
                }
                else
                {
                    tabgoodsback.DefaultView.RowFilter = string.Format("  商品编码9 LIKE '%{0}%' OR 商品名称9 LIKE '%{0}%' OR 生产厂家9 LIKE '%{0}%'  OR 供应商9 LIKE '%{0}%'  OR  规格9 LIKE '%{0}%'  OR  柜子9 LIKE '%{0}%' ", txb_back.Text);
                }
                dgv_back.DataSource = tabgoodsback.DefaultView.Table;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void btn_back_refresh_Click(object sender, EventArgs e)
        {
            GetGoodsbackInfo();
        }

        private void btn_back_export_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dgv_back);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void txb_back_TextChanged(object sender, EventArgs e)
        {
            GoodsBackFilter();
        }

        private void Form1_Click(object sender, EventArgs e)
        {

        }

        private void Form1_MouseDoubleClick(object sender, MouseEventArgs e)
        {
          
        }

        private void dgv_kucmx_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            //MessageBox.Show("12121213");
        }

        private void dgv_kucmx_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            //foreach(var item in dgv_kucmx)
            for (int i = 0; i < dgv_kucmx.RowCount; i++){
                //MessageBox.Show(.ToString());
                dgv_kucmx.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_Detail_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            //foreach(var item in dgv_kucmx)
            for (int i = 0; i < dgv_Detail.RowCount; i++)
            {
                //MessageBox.Show(.ToString());
                dgv_Detail.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_goodskuc_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            for (int i = 0; i < dgv_goodskuc.RowCount; i++)
            {
                //MessageBox.Show(.ToString());
                dgv_goodskuc.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_goodsusecurrentday_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            for (int i = 0; i < dgv_goodsusecurrentday.RowCount; i++)
            {
                //MessageBox.Show(.ToString());
                dgv_goodsusecurrentday.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_goodsuse_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            for (int i = 0; i < dgv_goodsuse.RowCount; i++)
            {
                //MessageBox.Show(.ToString());
                dgv_goodsuse.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_goodsusehz_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            for (int i = 0; i < dgv_goodsusehz.RowCount; i++)
            {
                //MessageBox.Show(.ToString());
                dgv_goodsusehz.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_expired_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            for (int i = 0; i < dgv_expired.RowCount; i++)
            {
                //MessageBox.Show(.ToString());
                dgv_expired.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_rk_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            for (int i = 0; i < dgv_rk.RowCount; i++)
            {
                //MessageBox.Show(.ToString());
                dgv_rk.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_pick_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            for (int i = 0; i < dgv_pick.RowCount; i++)
            {
                //MessageBox.Show(.ToString());
                dgv_pick.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_back_ColumnHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            for (int i = 0; i < dgv_back.RowCount; i++)
            {
                //MessageBox.Show(.ToString());
                dgv_back.Rows[i].Cells[0].Value = i + 1;
            }
        }

        private void dgv_kucmx_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
        {
           // MessageBox.Show("1111");

        }

        private void button5_Click(object sender, EventArgs e)
        {
            try
            {
                Getbhcc();
                if (txbbhtj.Text.Trim().Length < 1)
                {
                    tabbhcx.DefaultView.RowFilter = "";
                }
                else
                {
                    tabbhcx.DefaultView.RowFilter = string.Format("  商品编码bh LIKE '%{0}%' OR 商品名称bh LIKE '%{0}%' OR 生产厂家bh LIKE '%{0}%'  OR  规格型号bh LIKE '%{0}%' ", txbbhtj.Text);
                }
                databh.DataSource = tabbhcx.DefaultView.Table;
                DataTable table = GetDgvToTable(this.databh);

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void button7_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.databh);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (txbbhtj.Text.Trim().Length < 1)
                {
                    tabbhcx.DefaultView.RowFilter = "";
                }
                else
                {
                    tabbhcx.DefaultView.RowFilter = string.Format("  商品编码bh LIKE '%{0}%' OR 商品名称bh LIKE '%{0}%' OR 生产厂家bh LIKE '%{0}%'  OR  规格型号bh LIKE '%{0}%' ", txbbhtj.Text);
                }
                databh.DataSource = tabbhcx.DefaultView.Table;
                DataTable table = GetDgvToTable(this.databh);

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void dgv_goodsusehz_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        string xh = ConfigurationManager.AppSettings["xh"];
        string url= ConfigurationManager.AppSettings["url"];
        string bs = ConfigurationManager.AppSettings["bs"];
        private void button8_Click(object sender, EventArgs e)
        {
            RestClient client = new RestClient(url);
            string result = client.Get(xh);
            GetkucMx();
            MessageBox.Show(result);
        }

        private void button9_Click(object sender, EventArgs e)
        {
            RestClient client = new RestClient(url);
            string result = client.Get(bs);
            GetkucMx();
            MessageBox.Show(result);
        }

        private void button12_Click(object sender, EventArgs e)
        {
            Getxh();
        }
        private void Getxh()
        {
            try
            {
                tabbhxh = control.Getxh(orgguid);
                this.dataGridView1.DataSource = tabbhxh;
                int sum = 0;
                DataTable table = GetDgvToTable(this.dataGridView1);
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    sum = sum + 1;
                }
                label27.Text = "库存数:" + "  " + sum.ToString();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 
        /// </summary>
        private void kucxhFilter()
        {

            try
            {
               
                if (textBox1.Text.Trim().Length < 1)
                {
                    tabbhxh.DefaultView.RowFilter = "";
                }
                else
                {
                    tabbhxh.DefaultView.RowFilter = string.Format("  商品编码12 LIKE '%{0}%' OR 商品名称12 LIKE '%{0}%' OR 生产厂家12 LIKE '%{0}%'  OR 供应商12 LIKE '%{0}%' OR 高值码12 LIKE '%{0}%' OR  规格12 LIKE '%{0}%'  OR  柜子12 LIKE '%{0}%' ", textBox1.Text);
                }
                dataGridView1.DataSource = tabbhxh.DefaultView.Table;
                DataTable table = GetDgvToTable(this.dataGridView1);
                label27.Text = "库存数:" + "  " + table.Rows.Count.ToString();

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }

        private void textBox1_TextChanged_1(object sender, EventArgs e)
        {
            kucxhFilter();
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == 11)
            {
                bool sq = false;
                foreach (string each in qx)
                {
                    if(this.dataGridView1.Tag.Equals(each))
                    {
                        sq = true;
                        break;
                    }
                }
                if (sq)
                {
                    if (MessageBox.Show("确认恢复库存吗？", "消息", MessageBoxButtons.OKCancel,MessageBoxIcon.Warning) == DialogResult.OK)
                    {
                        if(control.hfkc(this.dataGridView1.SelectedRows[0].Cells[8].Value.ToString()))
                        {
                            Getxh();
                        }
                        else
                        {
                            MessageBox.Show("恢复失败!");
                        }
                    }
                }
                else
                {
                    MessageBox.Show("您无权此操作");
                }
            }
        }

        private void btnpwup_Click(object sender, EventArgs e)
        {
            if (pwnew.Text.Length < 6)
            {
                MessageBox.Show( "新密码不能小于6位");
                return;
            }
            MessageBox.Show(control.ChangePwd(En.GenerateMD5(pwold.Text),En.GenerateMD5(pwnew.Text),uid));
        }

        private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            if (this.linkoldpwd.Tag.ToString().Equals("0"))
            {
                this.pwold.PasswordChar = new char();
                this.linkoldpwd.Tag = "1";
                this.linkoldpwd.Text = "隐藏密码";
            }
            else
            {
                this.pwold.PasswordChar = '*';
                this.linkoldpwd.Tag = "0";
                this.linkoldpwd.Text = "显示密码";
            }
        }

        private void linknewpwd_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            if (this.linknewpwd.Tag.ToString().Equals("0"))
            {
                this.pwnew.PasswordChar = new char();
                this.linknewpwd.Tag = "1";
                this.linknewpwd.Text = "隐藏密码";
            }
            else
            {
                this.pwnew.PasswordChar = '*';
                this.linknewpwd.Tag = "0";
                this.linknewpwd.Text = "显示密码";
            }
        }

        private void btnpwinit_Click(object sender, EventArgs e)
        {
            MessageBox.Show(control.ChangePwd("-1", "", uid));
        }

        private void button13_Click(object sender, EventArgs e)
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog();
                sfd.Title = "保存";
                sfd.Filter = "xls文件.xlsx|*.xlsx";
                sfd.ShowDialog();
                string sFilePath = sfd.FileName;
                DataTable table = GetDgvToTable(this.dataGridView1);
                ExportHelper.TableToExcel(table, sFilePath);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void concopy_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            if(message.Length==0)
            {
                Clipboard.Clear();
                return;
            }
            Clipboard.SetText(message);
        }
    }
}