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

using System;
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.PublicMethod;

namespace UAS_MES.Make
{
    public partial class Make_NewMatainInf : Form
    {
        /// <summary>
        /// 序列号
        /// </summary>
        string sncode = "";

        DataHelper dh;

        DataTable dt;

        LogStringBuilder sql=new LogStringBuilder();

        public Make_NewMatainInf(string iBgName, string iBcName, string iSnCode)
        {
            InitializeComponent();
            bg_name.Text = iBgName;
            bc_name.Text = iBcName;
            sncode = iSnCode;
        }

        private void Make_NewMatainInf_Load(object sender, EventArgs e)
        {
            dh = new DataHelper();
            string pr_code = dh.getFieldDataByCondition("makeserial", "ms_prodcode", "ms_sncode='" + sncode + "'").ToString();
            string pk_code = dh.getFieldDataByCondition("product left join productkind on pk_name=pr_kind", "pk_code", "pr_code='" + pr_code + "'").ToString();
            sql.Clear();
            sql.Append("select nrg_name,nrg_code from PRODUCTBADREASONGROUP left join ");
            sql.Append("QUA_NGReasonGroup  on  nrg_code=pbr_brgcode where  pbr_kindcode='" + pk_code + "'");
            dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
            AddDataToListView(nrg_name_lsv, dt);
        }

        /// <summary>
        /// 往ListView添加数据
        /// </summary>
        /// <param name="lsv"></param>
        /// <param name="dt"></param>
        private void AddDataToListView(ListView lsv, DataTable dt)
        {
            lsv.Items.Clear();
            lsv.BeginUpdate();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem lvi = new ListViewItem();
                //第一列是勾选列，设置列头文本为空
                lvi.Text = "";
                for (int j = 0; j < dt.Columns.Count; j++)
                    lvi.SubItems.Add(dt.Rows[i][j].ToString());
                lsv.Items.Add(lvi);
            }
            lsv.EndUpdate();
        }

        private void Cancel_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void OnlyCheckOne_ItemChecked(object sender, ItemCheckedEventArgs e)
        {
            if (e.Item.Checked)
            {
                foreach (ListViewItem item in (sender as ListView).CheckedItems)
                {
                    if (item != e.Item)
                        item.Checked = false;
                }
            }
        }
    }
}