mes-client/UAS-MES/FunctionCode/Make/Make_PalletWeigh.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;

namespace UAS_MES.Make
{
    public partial class Make_PalletWeigh : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();

        DataHelper dh;

        DataTable dt;

        LogStringBuilder sql = new LogStringBuilder();

        DataTable ListC;
        //箱类型
        string pa_type;
        //标签类型
        string pl_labeltype1;
        //物料编号
        string pr_code;
        //箱内件数
        int pa_packageqty;
        //Package表的主键
        string pa_id;

        string sncode;
        //栈板和大箱不同的判断箱号是否存在的条件
        string CheckOutBoxCondition;

        public Make_PalletWeigh()
        {
            InitializeComponent();
        }

        private void 栈板称重_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = new DataHelper();
            //根据不同的Caller显示不同的                                
            switch (Tag.ToString())
            {
                case "Make!BigBoxWeigh":
                    palletcode_label.Text = "大箱号";
                    pa_type = "2";
                    pl_labeltype1 = "大箱标";
                    NewPallet.Text = "新增大箱";
                    ReleasePallet.Text = "解除大箱";
                    SearchPallet.Text = "大箱查询";
                    CheckOutBoxCondition = " pa_type=1 ";
                    break;
                case "Make!PalletWeigh":
                    palletcode_label.Text = "栈板号";
                    pa_type = "3";
                    pl_labeltype1 = "栈板标";
                    CheckOutBoxCondition = " pa_type in (1,2)";
                    break;
                default:
                    break;
            }
        }

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

        //栈板号或者大箱号Enter事件
        private void palletcode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (palletcode.Text == "")
                {
                    OperateResult.AppendText(">>栈板号不能为空\n", Color.Red);
                    return;
                }
                //根据箱号查询信息
                sql.Clear();
                sql.Append("select pa_prodcode,nvl(pd_barcode,PD_INNERBOXCODE) code ,pd_innerqty,");
                sql.Append("pa_salecode,pa_makecode,pa_custcode,pa_packageqty  from package left join product ");
                sql.Append("on pr_code=pa_prodcode left join  packagedetail on pd_paid=pa_id  where ");
                sql.Append("pa_outboxcode='" + palletcode.Text + "' and pa_type=" + pa_type);
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                if (dt.Rows.Count > 0)
                {
                    BaseUtil.FillDgvWithDataTable(PackageInf, dt);
                    pr_code = dt.Rows[0]["pa_prodcode"].ToString();
                    dt = dh.getFieldsDataByCondition("Package", new string[] { "pa_packageqty", "pa_id" }, "pa_outboxcode='" + palletcode.Text + "'");
                    pa_packageqty = int.Parse(dt.Rows[0]["pa_packageqty"].ToString());
                    pa_id = dt.Rows[0]["pa_id"].ToString();
                    FillPrintLabel();
                    outboxcode.Focus();
                }
                else
                    OperateResult.AppendText(">>" + palletcode_label.Text + palletcode.Text + "不存在\n", Color.Red);
            }
        }

        //箱号Enter事件
        private void outboxcode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                if (outboxcode.Text == "")
                {
                    OperateResult.AppendText(">>箱号不能为空\n", Color.Red);
                    return;
                }
                string ErrorMessage;
                bool ifFirst;
                sql.Clear();
                sql.Append("select pa_makecode,pa_prodcode,pa_outboxcode,pa_totalqty,pa_custcode,pa_salecode ");
                sql.Append("from package where pa_outboxcode='" + outboxcode.Text + "'  and pa_type <>3");
                dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
                BaseUtil.SetFormValue(Controls, dt);
                sncode = dh.getFieldDataByCondition("makeserial left join package on ms_prodcode=pa_prodcode", "ms_sncode", "pa_outboxcode='" + outboxcode.Text + "'").ToString();
                //检测当前岗位资源和对应工序是否一致
                if (LogicHandler.CheckCurrentStepAndIfFirst(sncode, pa_makecode.Text,  User.UserSourceCode, Tag.ToString(), out ifFirst, out ErrorMessage))
                {
                    if (dt.Rows.Count > 0)
                    {
                        sql.Clear();
                        sql.Append("select count(0) cn from package left join packagedetail on pa_id=pd_paid  where ");
                        sql.Append("pa_outboxcode='" + outboxcode.Text + "'");
                        int packageqty = int.Parse((dh.ExecuteSql(sql.GetString(), "select") as DataTable).Rows[0][0].ToString());
                        //如果未装满的话
                        if (packageqty < pa_packageqty)
                        {
                            //验证箱号是否存在
                            if (dh.CheckExist("Package", "pa_outboxcode='" + outboxcode.Text + "' and " + CheckOutBoxCondition))
                            {
                                //判断是否已经装箱
                                if (!dh.CheckExist("PackageDetail", "pd_innerboxcode='" + outboxcode.Text + "'"))
                                {
                                    sql.Clear();
                                    sql.Append("insert into packagedetail(pd_id, pd_paid, pd_outboxcode, pd_barcode, pd_innerqty)");
                                    sql.Append("values(packagedetail_seq.nextval,'" + pa_id + "','" + palletcode.Text + "','" + outboxcode.Text + "','" + pa_totalqty.Text + "')");
                                    dh.ExecuteSql(sql.GetString(), "insert");
                                    OperateResult.AppendText(">>采集成功！\n", Color.Green);
                                    //判断明细和箱内的件数的差是不是1，如果只相差1则表示此时已经采集慢了
                                    if (packageqty + 1 == pa_packageqty)
                                        OperateResult.AppendText(">>箱已装满，自动打印！\n", Color.Green);
                                }
                                //已装箱
                                else
                                    OperateResult.AppendText(">>箱号" + outboxcode.Text + "已采集\n", Color.Red);
                            }
                            else
                                OperateResult.AppendText(">>箱号" + outboxcode.Text + "不存在\n", Color.Red);
                        }
                        //已装满提示用户已装满
                        else
                            OperateResult.AppendText(">>" + palletcode.Text + "已装满\n", Color.Red);
                    }
                    else
                        OperateResult.AppendText(">>" + palletcode_label.Text + palletcode.Text + "不存在\n", Color.Red);
                }
                else
                    OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
            }
        }

        private void FillPrintLabel()
        {
            sql.Clear();
            sql.Append("select pl_id,pl_labeltype,pl_labelurl,pl_isdefault from productlabel where pl_prodcode='" + pr_code + "' and pl_labeltype='" + pl_labeltype1 + "'");
            ListC = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            if (ListC.Rows.Count == 0)
                OperateResult.AppendText(">>该序列号对应的产品未维护（机身标或者彩盒的）标签模板\n", Color.Red);
        }

        private void 栈板称重_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void NewPallet_Click(object sender, EventArgs e)
        {
            Make_NewPallet NewPallet = new Make_NewPallet(Tag.ToString());
            BaseUtil.SetFormCenter(NewPallet);
            NewPallet.ShowDialog();
        }

        private void Print_Click(object sender, EventArgs e)
        {

        }

        private void ReleasePallet_Click(object sender, EventArgs e)
        {

        }

        private void SearchPallet_Click(object sender, EventArgs e)
        {

        }
    }
}