mes-client/UAS_MES_YD/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)
        {
            cu_code.TableName = "customer";
            cu_code.DBTitle = "出货单查询";
            cu_code.SelectField = "cu_id # ID,cu_code  # 客户编号,cu_name # 客户名城";
            cu_code.SetValueField = new string[] { "cu_code", "cu_name" };
            cu_code.FormName = Name;

            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;
            InDate.Value = DateTime.Now;
            asc.controllInitializeSize(this);
        }

        private void Confirm_Click(object sender, EventArgs e)
        {
            int in_qty = 0;
            if (!int.TryParse(inqty.Text, out in_qty))
            {
                OperateResult.AppendText(">>入库数错误\n", Color.Red, barcode);
                return;
            }
            //正常录入资料的时候
            if (!Cancel.Checked)
            {
                if (cu_code.Text == "" || pr_code.Text == "")
                {
                    OperateResult.AppendText(">>客户编号和物料编号不能为空\n", Color.Red, barcode);
                    return;
                }
                if (barcode.Text == "")
                {
                    OperateResult.AppendText(">>输入信息不允许为空\n", Color.Red, barcode);
                    return;
                }
                if (dh.CheckExist("aftersalerecord", "afr_barcode='" + barcode.Text + "'"))
                {
                    OperateResult.AppendText(">>条码" + barcode.Text + "已录入\n", Color.Red, barcode);
                    return;
                }
                sql.Clear();
                sql.Append("insert into aftersalerecord(afr_id,afr_barcode,afr_prodcode,afr_cucode,afr_indate,afr_inqty)");
                sql.Append("values(aftersalerecord_seq.nextval,'" + barcode.Text + "','" + pr_code.Text + "','" + cu_code.Text + "',sysdate," + inqty.Text + ")");
                dh.ExecuteSql(sql.GetString(), "insert");
                dh.ExecuteSql("insert into aftersalerecordlog(afl_id,afl_barcode,afl_prodcode,afl_qty,afl_type) select aftersalerecordlog_seq.nextval,afr_barcode,afr_prodcode," + inqty.Text + ",'入库' from aftersalerecord where afr_barcode='" + barcode.Text + "'", "insert");
                OperateResult.AppendText(">>条码" + barcode.Text + "录入成功\n", Color.Green, barcode);
                LoadGridData();
            }
            else
            {
                if (!dh.CheckExist("aftersalerecord", "afr_barcode='" + barcode.Text + "'"))
                {
                    OperateResult.AppendText(">>条码" + barcode.Text + "不存在\n", Color.Red, barcode);
                    return;
                }
                if (dh.CheckExist("aftersalerecord", "afr_barcode='" + barcode.Text + "' and nvl(afr_outqty,0) =0"))
                {
                    OperateResult.AppendText(">>条码" + barcode.Text + "已出库\n", Color.Red, barcode);
                    return;
                }
                sql.Clear();
                sql.Append("delete from aftersalerecord where afr_barcode='" + barcode.Text + "'");
                dh.ExecuteSql(sql.GetString(), "delete");
                dh.ExecuteSql("insert into aftersalerecordlog(afl_id,afl_barcode,afl_prodcode,afl_qty,afl_type) select aftersalerecordlog_seq.nextval,afr_barcode,afr_prodcode," + inqty.Text + ",'取消入库' from aftersalerecord where afr_barcode='" + barcode.Text + "'", "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 * from aftersalerecord where trunc(afr_indate)=trunc(to_date('" + InDate.Value.ToString("yyyy-MM-dd hh:mm:ss") + "','yyyy-mm-dd hh24:mi:ss')) ");
            if (cu_code.Text != "")
            {
                sql.Append(" and afr_cucode='" + cu_code.Text + "'");
            }
            if (pr_code.Text != "")
            {
                sql.Append(" and afr_prodcode='" + pr_code.Text + "'");
            }
            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();
        }
    }
}