mes-client/UAS_MES_YDCY/FunctionCode/Special/Special_CancelMac.cs

using System;
using System.Data;
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_CancelMac : Form
    {
        DataHelper dh;

        LogStringBuilder sql = new LogStringBuilder();

        public Special_CancelMac()
        {
            InitializeComponent();
        }

        private void Special_BoxSplit_Load(object sender, EventArgs e)
        {
            dh = SystemInf.dh;
        }

        private void Split_Click(object sender, EventArgs e)
        {

        }

        private void SaveRepairInf_Click(object sender, EventArgs e)
        {
            if (Reason.Text == "")
            {
                MessageBox.Show("必须填写原因");
                return;
            }
            DataTable dt = (DataTable)dh.ExecuteSql("select ms_sncode,ms_mac from makeserial where ms_mac ='" + MAC.Text + "'", "select");
            if (dt.Rows.Count > 0)
            {
                dt = (DataTable)dh.ExecuteSql("select ms_sncode,substr(pr_detail,0,15)pr_detail from makeserial left join product on pr_code=ms_prodcode where ms_mac='" + MAC.Text + "'", "select");
                if (dt.Rows.Count > 0)
                {
                    string sn = dt.Rows[0]["ms_sncode"].ToString();
                    string pr_detail = dt.Rows[0]["pr_detail"].ToString();
                    dh.ExecuteSql("update makeserial set ms_imei='" + Reason.Text + "',ms_mac='' where ms_mac='" + MAC.Text + "'", "update");
                    dh.ExecuteSql("update sninfo set ms_mac='' where ms_mac='" + MAC.Text + "'", "update");
                    LogicHandler.DoCommandLog("CancelMac", User.UserCode, "", User.UserLineCode, User.UserSourceCode, sn + " " + Reason.Text, "取消成功", MAC.Text, "");
                    OperateResult.AppendText("SN:" + sn + ",MAC:" + MAC.Text + ",机型:" + pr_detail + "取消成功\n", System.Drawing.Color.Black);
                }
                else
                {
                    OperateResult.AppendText(MAC.Text + "未录入系统\n", System.Drawing.Color.Black);
                }
            }
            else
            {
                dt = (DataTable)dh.ExecuteSql("select ms_sncode,ms_bt from makeserial where ms_bt ='" + MAC.Text + "'", "select");
                if (dt.Rows.Count > 0)
                {
                    dt = (DataTable)dh.ExecuteSql("select ms_sncode,substr(pr_detail,0,15)pr_detail from makeserial left join product on pr_code=ms_prodcode where ms_bt='" + MAC.Text + "'", "select");
                    if (dt.Rows.Count > 0)
                    {
                        string sn = dt.Rows[0]["ms_sncode"].ToString();
                        string pr_detail = dt.Rows[0]["pr_detail"].ToString();
                        dh.ExecuteSql("update makeserial set ms_imei='" + Reason.Text + "',ms_bt='' where ms_bt='" + MAC.Text + "'", "update");
                        dh.ExecuteSql("update sninfo set si_bt='' where si_bt='" + MAC.Text + "'", "update");
                        LogicHandler.DoCommandLog("CancelMac", User.UserCode, "", User.UserLineCode, User.UserSourceCode, sn + " " + Reason.Text, "取消成功", MAC.Text, "");
                        OperateResult.AppendText("SN:" + sn + ",BT:" + MAC.Text + ",机型:" + pr_detail + "取消成功\n", System.Drawing.Color.Black);
                    }
                    else
                    {
                        OperateResult.AppendText(MAC.Text + "未录入系统\n", System.Drawing.Color.Black);
                    }
                }
                else
                {
                    dt = (DataTable)dh.ExecuteSql("select ms_sncode,ms_netcard from makeserial where ms_netcard ='" + MAC.Text + "'", "select");
                    if (dt.Rows.Count > 0)
                    {
                        dt = (DataTable)dh.ExecuteSql("select ms_sncode,substr(pr_detail,0,15)pr_detail from makeserial left join product on pr_code=ms_prodcode where ms_netcard='" + MAC.Text + "'", "select");
                        if (dt.Rows.Count > 0)
                        {
                            string sn = dt.Rows[0]["ms_sncode"].ToString();
                            string pr_detail = dt.Rows[0]["pr_detail"].ToString();
                            dh.ExecuteSql("update makeserial set ms_imei='" + Reason.Text + "',ms_netcard='' where ms_netcard='" + MAC.Text + "'", "update");
                            dh.ExecuteSql("update sninfo set si_netcard='' where si_netcard='" + MAC.Text + "'", "update");
                            LogicHandler.DoCommandLog("CancelMac", User.UserCode, "", User.UserLineCode, User.UserSourceCode, sn + " " + Reason.Text, "取消成功", MAC.Text, "");
                            OperateResult.AppendText("SN:" + sn + ",NETCARD:" + MAC.Text + ",机型:" + pr_detail + "取消成功\n", System.Drawing.Color.Black);
                        }
                        else
                        {
                            OperateResult.AppendText(MAC.Text + "未录入系统\n", System.Drawing.Color.Black);
                        }
                    }
                    else
                    {
                        OperateResult.AppendText(MAC.Text + "未录入系统\n", System.Drawing.Color.Black);
                    }
                }
            }
        }
    }
}