using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace SMS.LookandSum
{
    public partial class frmWGLook : Form
    {
        public frmWGLook()
        {
            InitializeComponent();
        }

        private int G_int_Lnum;
        private int G_int_Mnum;
        SMS.BaseClass.DataCon datacon = new SMS.BaseClass.DataCon();
        private void frmWGLook_Load(object sender, EventArgs e)
        {
            dgvWGInfo.Controls.Add(hScrollBar1);
            SqlDataReader sqlread = datacon.getread("select GoodsLeast,GoodsMost from tb_GoodsInfo");
            if (sqlread.Read())
            {
                G_int_Lnum = Convert.ToInt32(sqlread["GoodsLeast"].ToString().Trim());
                G_int_Mnum = Convert.ToInt32(sqlread["GoodsMost"].ToString().Trim());
            }
            sqlread.Close();
            DataSet myds = datacon.getds("select GoodsID as 貨物編號,GoodsName as 貨物名稱,"
                + "StoreName as 倉庫名稱,GoodsSpec as 貨物規格,GoodsUnit as 計量單位,"
                + "GoodsNum as 貨物數量,GoodsInPrice as 進貨價格,GoodsOutPrice as 出貨價格,"
                + "GoodsLeast as 庫存下線,GoodsMost as 庫存上線,Editer as 修改人,EditDate as 修改日期 from tb_GoodsInfo"
                + " where GoodsNum<=" + G_int_Lnum + " or GoodsNum>=" + G_int_Mnum + "", "tb_GoodsInfo");
            dgvWGInfo.DataSource = myds.Tables[0];
        }

        private void btnLook_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtLKWord.Text.Trim() == "")
                {
                    frmWGLook_Load(sender, e);
                }
                else
                {
                    SqlDataReader sqlread = datacon.getread("select GoodsLeast,GoodsMost from tb_GoodsInfo "
                        + "where GoodsName like '%" + txtLKWord.Text.Trim() + "%'");
                    if (sqlread.Read())
                    {
                        if (cboxLCondition.Text.Trim() == "庫存下線")
                        {
                            DataSet myds = datacon.getds("select GoodsID as 貨物編號,GoodsName as 貨物名稱,"
                                + "StoreName as 倉庫名稱,GoodsSpec as 貨物規格,GoodsUnit as 計量單位,"
                                + "GoodsNum as 貨物數量,GoodsInPrice as 進貨價格,GoodsOutPrice as 出貨價格,"
                                + "GoodsLeast as 庫存下線,GoodsMost as 庫存上線,Editer as 修改人,EditDate as 修改日期"
                                + " from tb_GoodsInfo where GoodsName like '%" + txtLKWord.Text.Trim()
                                + "%' and GoodsNum<=" + Convert.ToInt32(sqlread["GoodsLeast"].ToString().Trim()) + "", "tb_GoodsInfo");
                            dgvWGInfo.DataSource = myds.Tables[0];
                        }
                        else
                        {
                            DataSet myds = datacon.getds("select GoodsID as 貨物編號,GoodsName as 貨物名稱,"
                                + "StoreName as 倉庫名稱,GoodsSpec as 貨物規格,GoodsUnit as 計量單位,"
                                + "GoodsNum as 貨物數量,GoodsInPrice as 進貨價格,GoodsOutPrice as 出貨價格,"
                                + "GoodsLeast as 庫存下線,GoodsMost as 庫存上線,Editer as 修改人,EditDate as 修改日期"
                                + " from tb_GoodsInfo where GoodsName like '%" + txtLKWord.Text.Trim()
                                + "%' and GoodsNum>=" + Convert.ToInt32(sqlread["GoodsMost"].ToString().Trim()) + "", "tb_GoodsInfo");
                            dgvWGInfo.DataSource = myds.Tables[0];
                        }
                    }
                    sqlread.Close();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void frmWGLook_FormClosed(object sender, FormClosedEventArgs e)
        {
            this.Close();
        }
    }
}