mes-client/UAS_MES_JWS/FunctionCode/Special/Special_CancelCollectionWN.cs

using System;
using System.Collections.Generic;
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_CancelCollectionWN : Form
    {

        DataHelper dh = SystemInf.dh;

        LogStringBuilder sql = new LogStringBuilder();

        public Special_CancelCollectionWN()
        {
            InitializeComponent();
        }

        private void Confirm_Click(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)dh.ExecuteSql("select ma_code,ma_status from make where ma_code='" + ma_code.Text + "'", "select");
            if (dt.Rows.Count == 0)
            {
                OperateResult.AppendText(">>工单号"+ma_code.Text+"不存在\n", Color.Red);
                return;
            }
            string ma_status = dt.Rows[0]["ma_status"].ToString();
            if (ma_status == "已冻结") {
                OperateResult.AppendText(">>工单号" + ma_code.Text + "已冻结\n", Color.Red);
                return;
            }
            dh.ExecuteSql("update make set ma_status='已冻结',ma_statuscode='FREEZE' where ma_code='"+ma_code.Text+"'", "update");
            OperateResult.AppendText(">>工单号" + ma_code.Text + "冻结成功\n", Color.Green);
        }

        private void Release_Click(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)dh.ExecuteSql("select ma_code,ma_status from make where ma_code='" + ma_code.Text + "'", "select");
            if (dt.Rows.Count == 0)
            {
                OperateResult.AppendText(">>工单号" + ma_code.Text + "不存在\n", Color.Red);
            }
            string ma_status = dt.Rows[0]["ma_status"].ToString();
            if (ma_status != "已冻结")
            {
                OperateResult.AppendText(">>工单号" + ma_code.Text + "不处于冻结状态\n", Color.Red);
                return;
            }
            dh.ExecuteSql("update make set ma_status='已下放',ma_statuscode='STARTED' where ma_code='" + ma_code.Text + "'", "update");
            OperateResult.AppendText(">>工单号" + ma_code.Text + "下放成功\n", Color.Green);
        }

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

        private void Special_CancelCollection_Load(object sender, EventArgs e)
        {
            ma_code.TableName = " make left join product on ma_prodcode=pr_code";
            ma_code.SelectField = "ma_code # 工单编号,pr_code # 产品编号,pr_spec # 型号";
            ma_code.FormName = Name;
            ma_code.SetValueField = new string[] { "ma_code" };
            ma_code.Condition = "ma_statuscode='STARTED'";
            ma_code.DbChange += pr_code_DbChange;
        }

        DataTable Dbfind;
        private void pr_code_DbChange(object sender, EventArgs e)
        {
            Dbfind = ma_code.ReturnData;
            BaseUtil.SetFormValue(this.Controls, Dbfind);
            DataTable dt = (DataTable)dh.ExecuteSql("select ma_qty,ma_prodcode,pr_detail,ma_printnum from make left join product on ma_prodcode=pr_code left join (select count(1)ma_printnum,mil_makecode from makeimeilist where mil_printstatus=-1 group by mil_makecode) on mil_makecode=ma_code where ma_code='" + ma_code.Text + "'", "select");
            if (dt.Rows.Count > 0)
            {
                pr_code.Text = dt.Rows[0]["ma_prodcode"].ToString();
                pr_detail.Text = dt.Rows[0]["pr_detail"].ToString();
            }
        }


    }
}