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

namespace UAS_MES_NEW.OQC
{
    public partial class OQC_PlanMaintain_NEW : Form
    {
        AutoSizeFormClass asc = new AutoSizeFormClass();
        LogStringBuilder sql = new LogStringBuilder();
        DataTable dt;
        DataHelper dh;
        string ErrorMessage = "";
        DataTable Dbfind;
        public OQC_PlanMaintain_NEW()
        {
            InitializeComponent();
        }

        private void 抽样计划维护_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = SystemInf.dh;
            pr_code.TableName = "QUA_Project";
            pr_code.SelectField = "pr_code # 方案编号,pr_name # 方案名称,pr_class # 检验单类型,pr_standard # 方案标准,pr_startdate # 生效日期,pr_enddate #失效日期 ,pr_status # 状态";
            pr_code.SetValueField = new string[] { "pr_code" };
            pr_code.FormName = Name;
            pr_code.DbChange += Pr_code_DbChange;

            ChooseAll.ChooseAll(CheckTypeDGV);
        }


        private void Pr_code_DbChange(object sender, EventArgs e)
        {
            Dbfind = pr_code.ReturnData;
            BaseUtil.SetFormValue(this.Controls, Dbfind);
        }

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

        /// <summary>
        /// 获取批次点击按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        private void SaveConfiguration_Click(object sender, EventArgs e)
        {

        }

        private void Save_Click(object sender, EventArgs e)
        {

        }

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


        private void ob_projectcode_UserControlTextChanged(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 QUA_PROJECT left join ");
            sql.Append(" QUA_ProjectDetail on pd_prid=pr_id  left join QUA_CheckItem on pd_ciid=ci_id ");
            sql.Append("left join OQCITEMS on oi_checkno ='' and oi_projectcode='" + pr_code.Text + "' ");
            sql.Append("and oi_projectcode = pr_code and oi_checkkind = ci_kind where  pr_code='" + pr_code.Text + "'  group by ci_kind");
            DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            BaseUtil.FillDgvWithDataTable(CheckTypeDGV, dt);
        }

        private void OQC_PlanMaintain_FormClosing(object sender, FormClosingEventArgs e)
        {
            dh.Dispose();
        }

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

            }
        }
    }
}