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

using System;
using System.Collections;
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_UpdateCollectCode : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();

        LogStringBuilder sql = new LogStringBuilder();

        DataHelper dh;

        DataTable dt;

        DataTable info;

        int step = 0;

        List<CheckBox> list = new List<CheckBox>();//记录勾选的控件

        string ms_id = "";

        StringBuilder sb ;

        string sncode = "";
        StringBuilder oldData ;
        //记录新数据
        StringBuilder newData ;
        public Make_UpdateCollectCode()
        {
            InitializeComponent();
        }

        private void Make_UpdateCollectCode_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = new DataHelper();
            OperateResult.AppendText(">>请先勾选需要更新的项，通过采集栏输入SN,更新项具体数据\n", Color.Black);
            inputValue.Focus();
        }

        private void Make_UpdateCollectCode_FormClosing(object sender, FormClosingEventArgs e)
        {

        }

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

        private void inputValue_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode==Keys.Enter)
            {
                //输入不能为空
                if (inputValue.Text=="")
                {
                    OperateResult.AppendText("<<输入不能为空\n", Color.Red);
                    return;
                }
                OperateResult.AppendText(">>"+inputValue.Text+"\n", Color.Black);
                if (step == 0)
                {
                    //判断是否有已勾选的项次
                    foreach (Control ctl in collects.Controls)
                    {
                        if ((ctl as CheckBox).Checked)
                        {
                            list.Add((ctl as CheckBox));
                        }
                    }
                    if (list.Count==0)
                    {
                        //无勾选的内容
                        OperateResult.AppendText("<<请先勾选需要更新的信息\n", Color.Red,inputValue);
                        return;
                    }
                    //判断TSN或者SN是否存在
                    ms_id = dh.getFieldDataByCondition("makeserial", "max(ms_id)", "ms_sncode ='" + inputValue.Text + "' or exists (select 1 from  makesnrelation where beforesn='" + inputValue.Text + "'  and ms_makecode=makecode)").ToString();
                    sncode = inputValue.Text;
                    if (ms_id == "")
                    {
                        OperateResult.AppendText("<<SN错误，不存在\n", Color.Red, inputValue);
                        return;
                    }
                    //查询序列号状态
                    dt = (DataTable)dh.ExecuteSql("select ms_status,ms_makecode from makeserial where ms_id='"+ms_id+"'", "select");
                    //序列号状态码必须是3
                    if (dt.Rows[0]["ms_status"].ToString()!="3")
                    {
                        OperateResult.AppendText("<<序列号必须是待维修状态\n", Color.Red, inputValue);
                        return;
                    }
                    sql.Clear();
                    sql.Append("select * from (select rownum rn, ms_prodcode,ms_makecode,ms_salecode,");
                    sql.Append("ms_mac,ms_imei1,ms_bt,ms_netcode,ms_imei2,ms_imei3  from makeserial ");
                    sql.Append("where ms_firstsn=(select ms_firstsn from makeserial where ms_id='"+ms_id+"')");
                    sql.Append(" and (nvl(ms_mac,' ')<>' ' or nvl(ms_bt,' ')<>' ' or nvl(ms_imei1,' ')<>' ' ) order by ms_id asc)where rn=1");
                    dt = (DataTable)dh.ExecuteSql(sql.GetString(),"select");
                    //无值则提示没有需要更新的信息
                    if (dt.Rows.Count == 0)
                    {
                        OperateResult.AppendText("<<序列号" + inputValue.Text + "没有需要更新的信息\n", Color.Red, inputValue);
                        return;
                    }
                    else
                    {
                        info = (DataTable)dh.ExecuteSql("select psr_type,psr_prefix,psr_length from productsnrelation where psr_prodcode='"+dt.Rows[0]["ms_prodcode"].ToString() +"'", "select");
                        //查询规则显示
                        collectCodeRules.DataSource = info;
                    }
                    step = 1;
                    OperateResult.AppendText("<<请输入"+((CheckBox)list[0]).Text+"\n", Color.Green, inputValue);
                    sb = new StringBuilder();
                    oldData = new StringBuilder();
                    newData = new StringBuilder();
                }
                else
                //采集的关联采集信息
                {
                    //从第一个开始
                    switch (((CheckBox)list[step-1]).Text)
                    {
                        case "MAC/WIFI":
                        case "BT":
                            if (dh.CheckExist("makeserial", "ms_" + ((CheckBox)list[step - 1]).Text.Split('/')[0] + " ='" + inputValue.Text + "' and ms_id='" + ms_id + "'"))
                            {
                                //如果一样提示用户“MAC 不允许与原来的值一致”，“请采集MAC”；
                                OperateResult.AppendText("<<" + ((CheckBox)list[step - 1]).Text.Split('/')[0] + "不允许与原来的值一致\n", Color.Red);
                                OperateResult.AppendText(">>请采集" + ((CheckBox)list[step - 1]).Text.Split('/')[0] + "\n", Color.Black,inputValue);
                                return;
                            }
                            else
                            {
                                //判断是否有合同号MAC范围
                                if (dh.CheckExist("SaleMacBTRange", "sr_sacode='"+dt.Rows[0]["ms_salecode"].ToString()+"' and sr_type='"+ ((CheckBox)list[step - 1]).Text.Split('/')[0] + "'"))
                                {
                                    //有范围的情况下看是否在范围内
                                    if (!dh.CheckExist("SaleMacBTRange", "sr_sacode='" + dt.Rows[0]["ms_salecode"].ToString() + "' and  sr_type='" + ((CheckBox)list[step - 1]).Text.Split('/')[0] + "' AND  '" + inputValue.Text + "' between sr_startcode and sr_endcode"))
                                    {
                                        OperateResult.AppendText("<<" + ((CheckBox)list[step - 1]).Text.Split('/')[0] + ":" + inputValue.Text + "错误，不在合同防呆范围内\n", Color.Red, inputValue);
                                        OperateResult.AppendText(">>请采集" + ((CheckBox)list[step - 1]).Text.Split('/')[0] + "\n", Color.Black);
                                        return;
                                    }
                                }
                                //验证长度前缀
                                if (!checkPrefixAndLength()) {
                                    return;
                                }
                                //验证长度前缀通过,验证数据库
                                if (dh.CheckExist("makeserial", "ms_status in (1,2,3) and nvl(ms_nextmacode,' ')<>' ' and  ms_"+ ((CheckBox)list[step - 1]).Text.Split('/')[0] + " ='"+inputValue.Text+"'"))
                                {
                                    OperateResult.AppendText("<<" + ((CheckBox)list[step - 1]).Text + ":" + inputValue.Text + "错误，已被使用\n", Color.Red, inputValue);
                                    return;
                                }
                                //通过校验
                                sb.Append("ms_"+((CheckBox)list[step - 1]).Text.Split('/')[0]+" = '"+inputValue.Text+"',");
                                oldData.Append("ms_" + ((CheckBox)list[step - 1]).Text.Split('/')[0] + ":"+ dt.Rows[0]["ms_" + ((CheckBox)list[step - 1]).Text.Split('/')[0]].ToString()+",");
                                newData.Append("ms_" + ((CheckBox)list[step - 1]).Text.Split('/')[0] + ":" +inputValue.Text+",");
                            }
                            break;
                        case "网标":
                        case "IMEI1":
                        case "IMEI2":
                        case "IMEI3":
                            //验证长度前缀
                            if (!checkPrefixAndLength()) {
                                return;
                            }
                            //验证长度前缀通过,验证数据库
                            if (dh.CheckExist("makeserial", "ms_status in (1,2,3) and nvl(ms_nextmacode,' ')<>' ' and  ms_" + (((CheckBox)list[step - 1]).Text == "网标" ? "NETCODE" : ((CheckBox)list[step - 1]).Text) + " ='" + inputValue.Text + "'"))
                            {
                                OperateResult.AppendText("<<" + ((CheckBox)list[step - 1]).Text + ":" + inputValue.Text + "错误，已被使用\n", Color.Red, inputValue);
                                return;
                            }
                            //通过校验
                            sb.Append("ms_" + (((CheckBox)list[step - 1]).Text == "网标" ? "NETCODE" : ((CheckBox)list[step - 1]).Text)+" = '"+inputValue.Text+"',");
                            oldData.Append("ms_" + (((CheckBox)list[step - 1]).Text == "网标" ? "NETCODE" : ((CheckBox)list[step - 1]).Text) + ":" + dt.Rows[0]["ms_" + (((CheckBox)list[step - 1]).Text == "网标" ? "NETCODE" : ((CheckBox)list[step - 1]).Text)].ToString() + ",");
                            newData.Append("ms_" + (((CheckBox)list[step - 1]).Text == "网标" ? "NETCODE" : ((CheckBox)list[step - 1]).Text) + ":" + inputValue.Text + ",");
                            break;
                    }
                    //判断是否是最后一个
                    if (step == list.Count)
                    {
                        //更新数据库
                        sql.Clear();
                        sql.Append("update makeserial set ");
                        sql.Append(sb.ToString().Substring(0,sb.ToString().Length-1));
                        sql.Append(" where ms_id='"+ms_id+"'");
                        dh.ExecuteSql(sql.GetString(),"update");
                        //提示烧录成功
                        OperateResult.AppendText(">>烧录成功\n", Color.Green);
                        //记录日志
                        LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, dt.Rows[0]["ms_makecode"].ToString(), User.UserLineCode, User.UserSourceCode, "更新烧录", "原数据:"+oldData.ToString()+"新数据:"+newData.ToString(), sncode,"");
                        step = 0;
                        //清除规则
                        BaseUtil.CleanDataTableData(info);
                        //聚焦，提示
                        inputValue.Focus();
                        OperateResult.AppendText("<<请采集SN\n", Color.Black,inputValue);
                        //清除LIST
                        list.Clear();
                    }
                    else
                    {
                        step++;
                        //请输入下一个
                        OperateResult.AppendText(">>请输入" + ((CheckBox)list[step-1]).Text.Split('/')[0] + "\n", Color.Green,inputValue);
                    }
                }
            }
        }
        private bool checkPrefixAndLength()
        {
            //找到对应的规则
            for(int i=0;i<info.Rows.Count;i++)
            {
                if ((((CheckBox)list[step - 1]).Text.Split('/')[0]=="网标"?"NETCODE": ((CheckBox)list[step - 1]).Text.Split('/')[0])==info.Rows[i]["psr_type"].ToString())
                {
                    //校验长度
                    if ((info.Rows[i]["psr_length"].ToString() == "" ? true : inputValue.Text.Length != int.Parse(info.Rows[i]["psr_length"].ToString())))
                    {
                        OperateResult.AppendText(">>" + info.Rows[i]["psr_type"] + "长度校验不通过,请重新输入\n", Color.Red);
                        OperateResult.AppendText(">>请重新输入" + info.Rows[i]["psr_type"] + "\n", Color.Black, inputValue);
                        return false;
                    }
                    //校验前缀
                    //以|符号分割前缀
                    string[] preFixs = info.Rows[i]["psr_prefix"].ToString().Split('|');
                    //只要满足其中一个前缀条件即可
                    bool isfit = false;
                    for (int j = 0; j < preFixs.Length; j++)
                    {
                        if (preFixs[j] == "" ? true : inputValue.Text.StartsWith(preFixs[j]))
                        {
                            //满足其中一条即可
                            isfit = true;
                            break;
                        }
                    }
                    if (!isfit)
                    {
                        OperateResult.AppendText(">>" + info.Rows[i]["psr_type"] + "前缀校验不通过,请重新输入\n", Color.Red);
                        OperateResult.AppendText(">>请重新输入" + info.Rows[i]["psr_type"] + "\n", Color.Black, inputValue);
                        return false;
                    }
                    return true;
                }
            }
            return true;
        }

        private void Mac_CheckedChanged(object sender, EventArgs e)
        {
            //当有checkBox状态改变的时候
            if (step!=0)
            {
                //步骤码归零
                step = 0;
                //清除list,信息栏
                list.Clear();
                BaseUtil.CleanDataTableData(info);
                //聚焦，提示
                inputValue.Focus();
                OperateResult.AppendText(">>请采集SN\n", Color.Black);
            }
        }
    }
}