mes-client/UAS-MES/FunctionCode/OQC/OQC_PlanMaintain.cs

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

namespace UAS_MES.OQC
{
    public partial class OQC_PlanMaintain : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();
        LogStringBuilder sql = new LogStringBuilder();
        DataTable dt;
        DataHelper dh;
        string ErrorMessage = "";

        public OQC_PlanMaintain()
        {
            InitializeComponent();
        }

        private void 抽样计划维护_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = new DataHelper();

            ob_projectcode.TableName = "QUA_Project";
            ob_projectcode.SelectField = "pr_code # 方案编号,pr_name # 方案名称,pr_class # 检验单类型,pr_standard # 方案标准,pr_startdate # 生效日期,pr_enddate #失效日期 ,pr_status # 状态";
            ob_projectcode.SetValueField = new string[] { "ob_projectcode" };
            ob_projectcode.FormName = Name;

            ob_aqlcode.TableName = "QUA_AQL";
            ob_aqlcode.SelectField = "AL_ID # ID,AL_CODE  # 流水编号,AL_NAME # 检验标准名称,AL_STATUS # 状态";
            ob_aqlcode.SetValueField = new string[] { "ob_aqlcode" };
            ob_aqlcode.FormName = Name;
            ob_aqlcode.Condition = "al_statuscode='AUDITED'";
        }

        private void 抽样计划维护_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        /// <summary>
        /// 获取批次点击按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GetBatch_Click(object sender, EventArgs e)
        {
            DataTable[] dt = LogicHandler.GetOQCBatch(ms_sncode.Text, obd_outboxcode.Text, ob_checkno.Text, "OQCPlanMaintain", out ErrorMessage);
            if (dt != null)
            {
                if (ErrorMessage == "")
                {
                    BaseUtil.SetFormValue(Controls, dt[0]);
                    BaseUtil.FillDgvWithDataTable(CheckTypeDGV, dt[1]);
                }
                else
                {
                    OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
                    ErrorMessage = "";
                }
            }
            else  OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
        }

        private void SaveConfiguration_Click(object sender, EventArgs e)
        {
            if (ob_status.Text == "待检验")
            {
                //新增的数据
                List<string> oi_id = new List<string>();
                List<string> ci_kind = new List<string>();
                List<string> oi_sampleqty = new List<string>();
                //更新的数据
                List<string> ci_kind_update = new List<string>();
                List<string> oi_sampleqty_update = new List<string>();
                for (int i = 0; i < CheckTypeDGV.Rows.Count; i++)
                {
                    //用户勾选的数据才进行操作
                    if (CheckTypeDGV.Rows[i].Cells["Choose"].FormattedValue.ToString() == "True")
                    {
                        if (!(int.Parse(CheckTypeDGV.Rows[i].Cells["oi_sampleqty"].Value.ToString()) > int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text)))
                        {
                            //ID不为0的时候进行更新操作，ID为0的时候进行插入操作
                            if (CheckTypeDGV.Rows[i].Cells["oi_id"].Value.ToString() != "0")
                            {
                                ci_kind_update.Add(CheckTypeDGV.Rows[i].Cells["ci_kind"].Value.ToString());
                                oi_sampleqty_update.Add(CheckTypeDGV.Rows[i].Cells["oi_sampleqty"].Value.ToString());
                            }
                            else
                            {
                                oi_id.Add(CheckTypeDGV.Rows[i].Cells["oi_id"].Value.ToString());
                                ci_kind.Add(CheckTypeDGV.Rows[i].Cells["ci_kind"].Value.ToString());
                                oi_sampleqty.Add(CheckTypeDGV.Rows[i].Cells["oi_sampleqty"].Value.ToString());
                            }
                        }
                        else
                        {
                            OperateResult.AppendText(">>第" + (i + 1) + "行的数量大于送检批数量\n", Color.Red);
                            return;
                        }
                    }
                }
                //如果ID为0的数组存在内容则进行插入操作
                if (oi_id.Count > 0)
                {
                    sql.Clear();
                    sql.Append("insert into OQCItems(oi_id,oi_checkno, oi_projectcode,oi_batchqty ,oi_checkkind,oi_sampleqty,oi_itemcode) select ");
                    sql.Append("OQCItems_seq.nextval,'" + ob_checkno.Text + "','" + ob_projectcode.Text + "','" + ob_batchqty.Text + "',:ci_kind,");
                    sql.Append(":oi_sampleqty,ci_code from QUA_PROJECT left join QUA_PROJECTDETAIL on pd_prid=pr_id ");
                    sql.Append("LEFT JOIN QUA_CHECKITEM ON PD_CIID=CI_ID  where pr_code='" + ob_projectcode.Text + "' and ci_kind=:ci_kind1");
                    dh.BatchInsert(sql.GetString(), new string[] { "ci_kind", "oi_sampleqty", "ci_kind1" }, ci_kind.ToArray(), oi_sampleqty.ToArray(), ci_kind.ToArray());
                }
                //如果有更新的类别
                if (ci_kind_update.Count > 0)
                {
                    sql.Clear();
                    sql.Append("update OQCItems set oi_sampleqty=:oi_sampleqty where oi_checkno='" + ob_checkno.Text + "' and oi_checkkind =:ci_kind");
                    dh.BatchInsert(sql.GetString(), new string[] { "oi_sampleqty", "ci_kind" }, oi_sampleqty_update.ToArray(), ci_kind_update.ToArray());
                    sql.Clear();
                }
                OperateResult.AppendText(">>保存配置成功\n", Color.Green);
            }
            else
                OperateResult.AppendText(">>送检批次必须为待检验状态\n", Color.Red);
        }

        private void RefreshConfiguration_Click(object sender, EventArgs e)
        {
            sql.Clear();
            sql.Append("select nvl(max(oi_id),0)oi_id,ci_kind,nvl(max(oi_sampleqty),0) oi_sampleqty from ");
            sql.Append("QUA_PROJECT left join QUA_ProjectDetail on pd_prid=pr_id left join QUA_CheckItem ");
            sql.Append("on pd_ciid=ci_id left join OQCITEMS on oi_checkno='" + ob_checkno.Text + "' and ");
            sql.Append("oi_projectcode='" + ob_projectcode.Text + "'and oi_projectcode = pr_code and oi_checkkind = ci_kind ");
            sql.Append("where pr_code='" + ob_projectcode.Text + "' group by ci_kind");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            BaseUtil.FillDgvWithDataTable(CheckTypeDGV, dt);
        }

        private void Save_Click(object sender, EventArgs e)
        {
            if (ob_aqlcode.Text != "" || ob_maxngacceptqty.Text != "")
            {
                SaveConfiguration.PerformClick();
                Checkob_maxngacceptqty();
                GetBatch.PerformClick();
            }
            else
                OperateResult.AppendText(">>AQL和最大不合格允许通过数至少填写一个\n", Color.Red);
        }

        //对于最大不合格允通过数的校验
        private void Checkob_maxngacceptqty()
        {
            if (ob_maxngacceptqty.Text == "" || int.Parse(ob_maxngacceptqty.Text) < 0)
            {
                OperateResult.AppendText(">>最大不合格允通过数必须大于0或者为空\n", Color.Red);
                ob_maxngacceptqty.Text = null;
            }
            else
            {
               int result =  (int)dh.ExecuteSql("update OQCBatch set ob_projectcode='" + ob_projectcode.Text + "',ob_remark = '" + ob_remark.Text + "',ob_aqlcode='" + ob_aqlcode.Text + "',ob_maxngacceptqty='" + ob_maxngacceptqty.Text + "' where ob_checkno='" + ob_checkno.Text + "' ", "update");
                if (result > 0)
                {
                    OperateResult.AppendText(">>保存成功\n", Color.Green);
                }
                else {
                    OperateResult.AppendText(">>保存失败\n", Color.Red);
                }
            }
        }

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

        private void ob_checkno_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                GetBatch.PerformClick();
        }

        private void ms_sncode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                GetBatch.PerformClick();
        }

        private void obd_outboxcode_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                GetBatch.PerformClick();
        }
    }
}