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

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

namespace UAS_MES.Make
{
    public partial class Make_RePrintLabel : Form
    {
        DataHelper dh;

        LogStringBuilder sql = new LogStringBuilder();

        AutoSizeFormClass asc = new AutoSizeFormClass();

        ApplicationClass lbl;

        Thread InitPrint;//实例化打印进程

        DataTable dt;

        System.DateTime[] indate;

        ftpOperater ftp;

        DataTable listA;

        string getlabel = "";

        DataTable mapB;

        String TSN="";//记录第一次输入的SN

        DataTable infoc;

        string re_ms_id = "";

        string ms_id="";

        DataTable formValue;//界面赋值

        string type = "";
        public Make_RePrintLabel()
        {
            InitializeComponent();
        }

        private void Make_RePrintLabel_Load(object sender, EventArgs e)
        {
            dh = new DataHelper();
            inputText.Focus();
            asc.controllInitializeSize(this);
            OperateResult.AppendText(">>请输入SN\n", Color.Black);
            InitPrint = new Thread(InPrint);
            SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
            BaseUtil.SetFormCenter(stw);
            stw.ShowDialog();
        }
        private void InPrint()
        {
            try
            {
                lbl = new ApplicationClass();
                BaseUtil.WriteLbl(lbl);
            }
            catch (Exception ex)
            {
                OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red);
            }
        }

        private void Make_RePrintLabel_SizeChanged(object sender, EventArgs e)
        {
            //窗体大小变化的时候
            asc.controlAutoSize(this);
        }

        private void Make_RePrintLabel_FormClosing(object sender, FormClosingEventArgs e)
        {
            //窗口关闭的时候
        }

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            //切换打印类型，清除输入值、工单代码、产品编号，名称、打印模板、核对第一次输入的SN
            if (giftBox.Checked)
            {
                //如果是切换成彩盒或者机身标提示用户 输入SN
                OperateResult.AppendText(">>请输入SN\n", Color.Black);
                clearAll();
            }
        }
        private void CartonBox_CheckedChanged(object sender, EventArgs e)
        {
            if (CartonBox.Checked) {
                OperateResult.AppendText(">>请输入卡通箱号\n", Color.Black);
                clearAll();
            }
        }

        private void fuselagel_CheckedChanged(object sender, EventArgs e)
        {
            if (fuselagel.Checked)
            {
                OperateResult.AppendText(">>请输入SN\n", Color.Black);
                clearAll();
            }
        }
        private void inputText_KeyDown(object sender, KeyEventArgs e)
        {
            //按下enter键
            if (e.KeyCode == Keys.Enter)
            {
                if (inputText.Text == "") {
                    OperateResult.AppendText("<<输入不能为空\n", Color.Red);
                    return;
                }
                //打印类型为彩盒或者机身标
                if (giftBox.Checked || fuselagel.Checked)
                {
                    //select max(ms_id)ms_id from makeserial where ms_sncode=? 
                    ms_id = dh.getFieldDataByCondition("makeserial", "max(ms_id) ms_id", "ms_sncode='" + inputText.Text + "'").ToString();
                    //如果ms_id 无值或者为空，提示用户SN不存在，请输入SN
                    if (ms_id == "") {
                        OperateResult.AppendText("<<SN:" + inputText.Text + "不存在\n", Color.Red, inputText);
                        OperateResult.AppendText(">>请输入SN\n", Color.Black);
                        return;
                    }
                    //判断是否装箱通过
                    if (checkPacked()) {
                        return;
                    }
                    //界面赋值
                    formValue = (DataTable)dh.ExecuteSql("select ms_makecode,pr_code,pr_detail from makeserial left join product on MS_PRODCODE=pr_code where ms_id='"+ms_id+"'", "select");
                    BaseUtil.SetFormValue(this.Controls,formValue);
                    //无值,可补打
                    inputValue.Text = inputText.Text;
                    inputText.Text = "";
                }
                //打印类型为卡通箱
                else if(CartonBox.Checked)
                {
                    //查询箱号是否存在
                    dt = (DataTable)dh.ExecuteSql("select pa_id,pa_prodcode pr_code,pa_makecode ms_makecode,pr_detail from package left join product on pr_code=pa_prodcode where pa_outboxcode='" + inputText.Text + "' and pa_type=1", "select");
                    if (dt.Rows.Count==0) {
                        //无值，返回提示用户“箱号不存在”， “>>请输入卡通箱号”
                        OperateResult.AppendText("<<箱号:" + inputText.Text + "不存在\n", Color.Red, inputText);
                        OperateResult.AppendText(">>请输入卡通箱号\n", Color.Black);
                        return;
                    }
                    //界面赋值
                    BaseUtil.SetFormValue(this.Controls,dt);
                    //有值,可以打
                    //展示产品编号和标签模板到界面
                    inputValue.Text = inputText.Text;
                    inputText.Text = "";
                }
            }
        }

        private void PrintLabel_TextChanged(object sender, EventArgs e)
        {
            if (pr_code.Text=="") {
                return;
            }
            if (fuselagel.Checked)
            {
                type = "机身标";
                getlabel = "select pl_labelcode ||':'||pl_labelname pl_name,pl_labelname,pl_labelcode, pl_indate,pl_labelurl from productlabel where pl_prodcode='" + pr_code.Text + "'and PL_LABELTYPE='机身标' order by pl_isdefault desc";
            }
            else if (giftBox.Checked)
            {
                type = "彩盒标";
                getlabel = "select pl_labelcode ||':'||pl_labelname pl_name,pl_labelname,pl_labelcode, pl_indate,pl_labelurl from productlabel where pl_prodcode='" + pr_code.Text + "'and PL_LABELTYPE='彩盒标' order by pl_isdefault desc";
            }
            else
            {
                type = "卡通箱标";
                getlabel = "select pl_labelcode ||':'||pl_labelname pl_name,pl_labelname,pl_labelcode, pl_indate,pl_labelurl from productlabel where pl_prodcode='" + pr_code.Text + "'and PL_LABELTYPE='卡通箱标' order by pl_isdefault desc";
            }
            listA = (DataTable)dh.ExecuteSql(getlabel, "select");
            if (listA.Rows.Count == 0)
            {
                OperateResult.AppendText("<<产品:" + pr_code.Text + "未维护"+type+"模板\n", Color.Red);
            }
            PrintLabel.DataSource = listA;
            PrintLabel.DisplayMember = "pl_name";
            PrintLabel.ValueMember = "pl_labelcode";
            ftp = new ftpOperater();
            indate = new System.DateTime[listA.Rows.Count];
            for (int i = 0; i < listA.Rows.Count; i++)
            {
                BaseUtil.GetPrintLabel(listA.Rows[i]["pl_labelname"].ToString(), listA.Rows[i]["pl_labelurl"].ToString(), listA.Rows[i]["pl_indate"].ToString());
                indate[i] = Convert.ToDateTime(listA.Rows[i]["pl_indate"].ToString());
            }
        }

        private void normalButton1_Click(object sender, EventArgs e)
        {
            //输入值字段值不为空，打印不为空，有选中打印模板，才可以进行打印，打印前再次判断
            if (inputValue.Text=="") {
                OperateResult.AppendText("<<无箱号或者序列号\n", Color.Red);
                return;
            }
            if (PrintLabel.Text=="") {
                OperateResult.AppendText("<<无打印模板\n", Color.Red);
                return;
            }
            //打印类型 彩盒或者标签，再次判断是否已装箱，未转号
            if (giftBox.Checked || fuselagel.Checked)
            {
                mapB = (DataTable)dh.ExecuteSql("select ms_outboxcode, nvl(ms_downstatus,0) ms_downstatus from makeserial where ms_id='"+ms_id+"' and ms_sncode='"+ inputValue.Text+"'", "select");
                if (mapB.Rows.Count==0)
                {
                    //无值提示用户序列号错误，不存在或者已经发生转号
                    OperateResult.AppendText("<<序列号错误,不存在或已经发生转号\n", Color.Red);
                    return;
                }
                //如果ms_outboxcode 不为空，则提示用户，已经装箱不允许单独打印
                if (mapB.Rows[0]["ms_outboxcode"].ToString() != "")
                {
                    OperateResult.AppendText("<<SN:" + inputValue.Text + "已经装箱" + mapB.Rows[0]["ms_outboxcode"].ToString() + "不允许单独补打\n", Color.Red);
                    return;
                }
                //判定通过进行打印
                //按照打印张数打印
                OperateResult.AppendText("<<打印成功\n", Color.Green);
                Print.CodeSoft(Tag.ToString(), lbl, PrintLabel.Text.Split(':')[1], PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), indate[PrintLabel.SelectedIndex]);
                //打印成功,记录日志commandlog , cl_operate彩盒或者机身标补打印，cl_result补打印成功
                LogicHandler.DoCommandLog(Tag.ToString(),User.UserCode, "", User.UserLineCode, User.UserSourceCode, giftBox.Checked?"彩盒标补打印":"机身标补打印", "补打印成功", inputValue.Text, "");
                //如果ms_downstatus<>0，则更新ms_downstatus=-1 where ms_id=?id，同时插入记录至表 MAKEDOWN
                if (mapB.Rows[0]["ms_downstatus"].ToString()=="0")
                {
                    dh.ExecuteSql("update makeserial set ms_downstatus='-1' where ms_id='"+ms_id+"'","update");
                    //插入数据
                    putInfo2MakeDown();
                }
            }
            //打印类型为卡通箱标签
            else if(CartonBox.Checked)
            {
                //select pa_downstatus from package where pa_outboxcode=? 输入值code
                mapB = (DataTable)dh.ExecuteSql("select pa_downstatus from package where pa_outboxcode='"+inputValue.Text+"'", "select");
                //无值提示用户箱号错误，不存在。
                if (mapB.Rows.Count==0) {
                    OperateResult.AppendText("<<箱号:"+inputValue.Text+"错误,不存在\n", Color.Red);
                    return;
                }
                //判断通过,打印
                OperateResult.AppendText("<<打印成功\n", Color.Green);
                Print.CodeSoft(Tag.ToString(), lbl, PrintLabel.Text.Split(':')[1], PrintLabel.SelectedValue.ToString(), Printer.Text, inputValue.Text, int.Parse(printNum.Text), indate[PrintLabel.SelectedIndex]);
                //打印成功,记录日志commandlog , cl_operate彩盒或者机身标补打印，cl_result补打印成功
                //LogicHandler.DoCommandLog(User.UserCode, "", User.UserLineCode, User.UserSourceCode, "卡通箱标签补打印,箱号:"+ inputValue.Text, "补打印成功","", "");
                sql.Clear();
                sql.Append("insert into commandlog(cl_id,cl_man,cl_date,cl_linecode,cl_sourcecode,cl_makecode,cl_operate,");
                sql.Append("cl_result,cl_sncode,cl_code) values (commandlog_seq.nextval,:inman,sysdate,:linecode,:sourcecode,:makecode,");
                sql.Append(":operate,:result,'','')");
                dh.ExecuteSql(sql.GetString(), "insert",User.UserCode,User.UserLineCode,User.UserSourceCode,ms_makecode.Text,"卡通箱标签补打印,箱号:" + inputValue.Text, "补打印成功");
                //如果pa_downstatus<>0，则更新pa_downstatus=-1 where pa_outboxcode=?code，同时插入记录至表 MAKEDOWN
                if (mapB.Rows[0]["pa_downstatus"].ToString()=="0") {
                    dh.ExecuteSql("update package set pa_downstatus='-1' where pa_outboxcode='"+ inputValue.Text+"'", "update");
                    //插入MakeDown表
                    putInfo2MakeDown();
                }
            }
        }
        /// <summary>
        /// 判断彩盒和机身标序列是否已经装箱
        /// </summary>
        /// <returns></returns>
        private bool checkPacked() {
            //如果存在，则判断是否装箱
            dt = (DataTable)dh.ExecuteSql("select ms_id,ms_prodcode,ms_makecode,pr_detail, ms_outboxcode from makeserial left join product on pr_code=ms_prodcode where ms_id='" + ms_id + "'", "select");
            //判断ms_outboxcode 是否为空，如果有值，则返回提示用户“已经装箱
            if (dt.Rows.Count == 0)
            {
                OperateResult.AppendText("<<SN:" + inputText.Text + "不存在\n", Color.Red, inputText);
                return true;
            }
            if (dt.Rows[0]["ms_outboxcode"].ToString() != "")
            {
                OperateResult.AppendText("<<SN:" + inputText.Text + "已经装箱" + dt.Rows[0]["ms_outboxcode"].ToString() + "不允许单独补打\n", Color.Red, inputText);
                return true;
            }
            return false;
        }
        /// <summary>
        /// 插入表MAKEDOWN
        /// </summary>
        private void putInfo2MakeDown()
        {
            //插入数据至表MAKEDOWN
            string md_code = "";
            LogicHandler.GetSerialNumByCaller("MakeDown", out md_code);
            //拼接sql插入语句
            sql.Clear();
            sql.Append("INSERT INTO MAKEDOWN (MD_ID,MD_LINECODE,MD_SCCODE,MD_STEPCODE,");
            sql.Append(CartonBox.Checked?"MD_OUTBOXCODE":"MD_SNCODE"+",MD_PRODCODE,MD_MACODE, MD_DOWNREASON, MD_CODE,");
            sql.Append("MD_DOWNDATE,MD_DOWNMAN,MD_STATUS) values (MAKEDOWN_seq.nextval,'" + User.UserLineCode + "','" + User.UserSourceCode + "',");
            sql.Append("'" + User.CurrentStepCode + "','" + inputValue.Text + "','" + pr_code.Text + "','" + ms_makecode.Text + "','补打标签','" + md_code + "',sysdate,'" + User.UserCode + "','-1')");
            //执行
            dh.ExecuteSql(sql.GetString(), "insert");
        }

        private void rePrintCheck_KeyDown(object sender, KeyEventArgs e)
        {
            //输入ENTER
            if (e.KeyCode==Keys.Enter)
            {
                if (rePrintCheck.Text=="")
                {
                    OperateResult.AppendText("<<输入不能为空\n", Color.Red);
                    return;
                }
                if (giftBox.Checked || fuselagel.Checked)
                {
                    //TSN为空，说明是第一次
                    if (TSN == "")
                    {
                        re_ms_id = dh.getFieldDataByCondition("makeserial", "max(ms_id) ms_id", "ms_sncode='" + rePrintCheck.Text + "'").ToString();
                        //如果ms_id 无值或者为空，提示用户SN不存在，请输入SN
                        if (re_ms_id == "")
                        {
                            OperateResult.AppendText("<<SN:" + rePrintCheck.Text + "不存在\n", Color.Red, rePrintCheck);
                            OperateResult.AppendText(">>请输入SN\n", Color.Black);
                            return;
                        }
                        //存在则记录下这一次输入的SN
                        TSN = rePrintCheck.Text;
                        //查询其他的数据
                        infoc = (DataTable)dh.ExecuteSql("select ms_downstatus,ms_prodcode,ms_makecode from makeserial where ms_id='" + re_ms_id + "'", "select");
                        //提示用户输入核对SN
                        OperateResult.AppendText(">>请输入核对SN\n", Color.Green);
                        rePrintCheck.Text = "";
                    }
                    //说明输入的是核对的SN
                    else
                    {
                        //两次输入的序列号一致
                        if (rePrintCheck.Text == TSN)
                        {
                            OperateResult.AppendText("<<核对成功\n", Color.Green);
                            //如果序列号是下地状态 ms_downstatus<>0 ,更新ms_downstatus=0;
                            if (infoc.Rows[0]["ms_downstatus"].ToString() != "0")
                            {
                                //同时更新 update makedown set ms_status=0,MS_UPREASON=’标签补打核对’，MS_UPMAN=’人员编号’,MS_UPDATE=SYSDATE WHERE MS_SNCODE=? AND MS_MACODE=? AND MS_STATUS=-1
                                sql.Clear();
                                sql.Append("update makedown set md_status=0,Md_UPREASON='标签补打核对',Md_UPMAN='" + User.UserCode + "',Md_UPDATE=SYSDATE WHERE Md_SNCODE='" + TSN + "' AND Md_MACODE='" + infoc.Rows[0]["ms_makecode"].ToString() + "' AND Md_STATUS=-1");
                                dh.ExecuteSQLTran("update makeserial set ms_downstatus='0' where ms_id='" + re_ms_id + "'", sql.GetString());
                            }
                            //记录操作日志commandlog ， 补打核对，核对成功
                            LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, "", User.UserLineCode, User.UserSourceCode, "标签补打核对", "核对成功", TSN, "");
                        }
                        else
                        {
                            OperateResult.AppendText("<<核对失败\n", Color.Red);
                        }
                        //清空TSN的值
                        TSN = "";
                        rePrintCheck.Text = "";
                    }
                }
                //勾选的是卡通箱
                else if(CartonBox.Checked)
                {
                    //第一次输入
                    if (TSN == "")
                    {
                        infoc = (DataTable)dh.ExecuteSql("select pa_prodcode,pa_makecode,pa_downstatus from package where pa_outboxcode='"+rePrintCheck.Text+"' and pa_type=1", "select");
                        //如果查询无值，提示用户卡通箱号不存在，请输入卡通箱号
                        if (infoc.Rows.Count==0)
                        {
                            OperateResult.AppendText("<<卡通箱号:" + rePrintCheck.Text + "不存在\n", Color.Red, rePrintCheck);
                            OperateResult.AppendText(">>请输入卡通箱号\n", Color.Black);
                            return;
                        }
                        //存在则保存,用于和第二次的比对
                        TSN = rePrintCheck.Text;
                        //提示用户输入卡通箱号
                        OperateResult.AppendText(">>请输入核对卡通箱号\n", Color.Green,rePrintCheck);
                    }
                    else
                    {
                        //比对两次输入的是否一致
                        if (TSN == rePrintCheck.Text)
                        {
                            //提示用户核对成功
                            OperateResult.AppendText("<<核对成功\n", Color.Green);
                            //如果卡通箱号是下地状态 pa_downstatus<>0 ,更新pa_downstatus=0;
                            if (infoc.Rows[0]["pa_downstatus"].ToString() != "0")
                            {
                                sql.Clear();
                                sql.Append("update makedown set md_status=0,Md_UPREASON='标签补打核对',Md_UPMAN='" + User.UserCode + "',Md_UPDATE=SYSDATE WHERE Md_OUTBOXCODE='" + TSN + "' AND Md_PRODCODE='" + infoc.Rows[0]["pa_prodcode"].ToString() + "' AND Md_STATUS=-1");
                            }
                            //记录操作日志commandlog ， 补打核对，核对成功
                            //LogicHandler.DoCommandLog(User.UserCode, "", User.UserLineCode, User.UserSourceCode, "标签补打核对,卡通箱号:" + TSN, "核对成功", "", "");
                            sql.Clear();
                            sql.Append("insert into commandlog(cl_id,cl_man,cl_date,cl_linecode,cl_sourcecode,cl_makecode,cl_operate,");
                            sql.Append("cl_result,cl_sncode,cl_code) values (commandlog_seq.nextval,:inman,sysdate,:linecode,:sourcecode,:makecode,");
                            sql.Append(":operate,:result,'','')");
                            dh.ExecuteSql(sql.GetString(), "insert", User.UserCode, User.UserLineCode, User.UserSourceCode,infoc.Rows[0]["pa_makecode"].ToString(), "标签补打核对,卡通箱号:" + TSN, "核对成功");
                        }
                        else
                        {
                            OperateResult.AppendText("<<核对失败\n", Color.Red);
                        }
                        //清空TSN的值
                        TSN = "";
                        rePrintCheck.Text = "";
                    }
                }
            }
        }
        /// <summary>
        /// 清除信息
        /// </summary>
        private void clearAll()
        {
            //清除输入值、工单代码、产品编号，名称、打印模板、核对第一次输入的SN
            inputValue.Text = "";
            ms_makecode.Text = "";
            pr_code.Text = "";
            pr_detail.Text = "";
            TSN = "";
            if (listA != null)
            {
                listA.Clear();
            }
        }
    }
}