mes-client/UAS_MES_PNE/FunctionCode/Special/Special_AfterSaleIn.cs

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

namespace UAS_MES_NEW.Special
{
    public partial class Special_AfterSaleIn : Form
    {

        DataHelper dh = SystemInf.dh;

        LogStringBuilder sql = new LogStringBuilder();

        AutoSizeFormClass asc = new AutoSizeFormClass();

        public Special_AfterSaleIn()
        {
            InitializeComponent();
        }

        private void Special_CancelProdinout_Load(object sender, EventArgs e)
        {
            pr_code.TableName = "product";
            pr_code.DBTitle = "出货单查询";
            pr_code.SelectField = "pr_code  # 物料编号,pr_detail # 物料名称,pr_spec # 物料规格";
            pr_code.SetValueField = new string[] { "pr_code", "pr_detail", "pr_spec" };
            pr_code.FormName = Name;
            asc.controllInitializeSize(this);
        }

        private void Confirm_Click(object sender, EventArgs e)
        {
            //正常录入资料的时候
            if (barcode.Text == "")
            {
                OperateResult.AppendText(">>输入信息不允许为空\n", Color.Red, barcode);
                return;
            }
            if (pr_code.Text == "")
            {
                OperateResult.AppendText(">>物料编号不允许为空\n", Color.Red, barcode);
                return;
            }

            DataTable dt = (DataTable)dh.ExecuteSql("select pr_spec,as_sn from AFSALES left join product on pr_code=as_prodcode where as_sn='" + barcode.Text + "'", "select");
            if (dt.Rows.Count > 0)
            {
                string as_sn = dt.Rows[0]["as_sn"].ToString();
                OperateResult.AppendText(">>条码号" + as_sn + "已采集\n", Color.Red, barcode);
                return;
            }
            dh.ExecuteSql("insert into AFSALES(as_id,as_sn,as_prodcode,as_indate)values(AFSALES_seq.nextval,'" + barcode.Text + "','" + pr_code.Text + "',sysdate)", "insert");
            OperateResult.AppendText(">>条码号" + barcode.Text + "采集成功\n", Color.Green, barcode);
            LoadGridData();
        }

        private void Clean_Click(object sender, EventArgs e)
        {
            OperateResult.Clear();
        }

        private void LoadGridData()
        {
            sql.Clear();
            sql.Append("select as_sn,as_prodcode,to_char(as_indate,'yyyy-mm-dd hh24:mi:ss')as_indate from AFSALES where as_prodcode='" + pr_code.Text + "' order by as_indate desc");
            DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            BaseUtil.FillDgvWithDataTable(Info, dt);
        }

        private void Special_AfterSaleIn_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void barcode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                Confirm.PerformClick();
            }
        }

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {
            LoadGridData();
        }

        private void cu_code_UserControlTextChanged(object sender, EventArgs e)
        {
            LoadGridData();
        }

        private void pr_code_UserControlTextChanged(object sender, EventArgs e)
        {
            LoadGridData();
        }
    }
}