using System;
using System.Data;
using System.Windows.Forms;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;

namespace UAS_MES_NEW.Query
{
    public partial class BarCodePrint : Form
    {
        DataHelper dh = SystemInf.dh;

        string bar = "";
        public BarCodePrint(string barcode)
        {
            InitializeComponent();
            bar = barcode;
        }

        private void BarCodePrint_Load(object sender, EventArgs e)
        {
            bar_remain.Text = dh.getFieldDataByCondition("barcode", "bar_remain", "bar_code='" + bar + "'").ToString();

        }

        private void PrintBarCode_Click(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)dh.ExecuteSql("select bar_remain,bar_prodcode,to_char(bar_madedate,'yyyymmdd')bar_madedate" +
             ",bar_vendbarcode from barcode where bar_code='" + bar + "'", "select");
            if (dt.Rows.Count > 0)
            {
                string remain = dt.Rows[0]["bar_remain"].ToString();
                string bar_prodcode = dt.Rows[0]["bar_prodcode"].ToString();
                string bar_madedate = dt.Rows[0]["bar_madedate"].ToString();
                string bar_vendbarcode = dt.Rows[0]["bar_vendbarcode"].ToString();
                string barcode = "";
                LogicHandler.SP_GETBARCODE(bar_prodcode, "", out barcode);
                newbarcode.Text = barcode.Replace("BARCODE:","") + "," + bar_prodcode + "," + bar_remain.Text + "," + bar_vendbarcode + "," + bar_madedate + ",";
            }
            Close();
        }
    }
}