液体试剂自动配置系统.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 System.Data.SqlClient;

namespace 液体配置系统
{
   
    public partial class 液体配置系统 : Form
    {
        //其中myds为浏览列表的数据集，ds为新建方案的数据集，ds1为查看方案的数据集
        public 液体配置系统()
        {
            InitializeComponent();
            strconn = "Data Source=NJ6BWDH0T6FG8CY\\LIUZHU;Initial Catalog=reagent;Integrated Security=True";
            strsql = "select id as'方案编号',prereagentid as '试剂编号' ,prereagent as '试剂名称',preamount as '试剂用量'  from project where id = (select Max(id)+1 from remarks)";
            this.myconn = new SqlConnection(strconn);
            this.da = new SqlDataAdapter(strsql, strconn);
            this.ds = new DataSet();
            isupdated = false;
            myconn.Open();
            string strsql10 = "select max(id) from remarks ";   //找出最大的方案信息id
            SqlCommand cmd10 = new SqlCommand(strsql10, myconn);
            SqlDataReader reader10 = cmd10.ExecuteReader();  //读出最大的方案编号的值
            while (reader10.Read())
            {
                i = Convert.ToInt64(reader10[0]);
            }
            reader10.Close();
            myconn.Close();
        }

        private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
        //查看具体方案信息
        {
            myconn.Close();
            string i = dataGridView1.CurrentRow.Cells[0].Value.ToString();
            long a = 0;
            a = Convert.ToInt64(i);
            if (a == 0)
                MessageBox.Show("请选择正确的方案查看");
            else
            {
                long ID = a;
                ViewProject(ID);
            }
        }

        private void ViewProject(long id)
        {
            panel1.Show();
            long b = id;
            //string strconn = "Data Source=NJ6BWDH0T6FG8CY\\LIUZHU;Initial Catalog=reagent;Integrated Security=True";
            try
            {
                //SqlConnection conn = new SqlConnection(strconn);
                
                string strsql2 = "select * from remarks   where id= '" + b + "'";
                string strsql3 = "select finalamount from project   where id='" + b + "'group by finalamount";
                myconn.Open();
                string strsql1 = "select pid as '方案id',prereagentid as '试剂编号' ,prereagent as '试剂名称',preamount as '试剂用量',id as'方案编号id' from project where id=" + b;
                da1 = new SqlDataAdapter(strsql1, strconn);
                ds1 = new DataSet();
                da1.Fill(ds1,"data1");
               //da1.MissingSchemaAction = MissingSchemaAction.AddWithKey;
                
                //以下显示方案编号
                this.label10.Text = b.ToString();
                dataGridView2.DataSource = ds1.Tables["data1"];
                dataGridView2.Columns[0].Visible=false;
                dataGridView2.Columns[4].Visible = false;

                SqlCommand cmd2 = new SqlCommand(strsql2, myconn);

                SqlDataReader rd2 = cmd2.ExecuteReader();

                while (rd2.Read())
                {
                    this.label12.Text  = rd2[3].ToString();
                    this.textBox7.Text = rd2[1].ToString();
                    this.textBox6.Text = rd2[2].ToString();
                    this.textBox4.Text = rd2[4].ToString();
                }
                rd2.Close();

                SqlCommand cmd3 = new SqlCommand(strsql3, myconn);
                SqlDataReader rd3 = cmd3.ExecuteReader();
                while (rd3.Read())
                {
                    this.textBox5.Text = rd3[0].ToString();
                }
                rd3.Close();
                myconn.Close();
                dataGridView2.DataSource = ds1.Tables[0];              
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }


        private void button4_Click(object sender, EventArgs e)//保存方案
        {

            if(Convert.ToInt64(label10.Text.Trim().ToString())<=i)
                //查看方案的保存按钮
            {
           
                try
                {
                    myconn.Close();
                    myconn.Open();
                    //da1.MissingSchemaAction=MissingSchemaAction.AddWithKey;
                    SqlCommandBuilder bd1 = new SqlCommandBuilder(da1);

                    da1.DeleteCommand = bd1.GetDeleteCommand();
                    da1.UpdateCommand = bd1.GetUpdateCommand();
                    da1.Update(ds1.Tables["data1"]);
                    MessageBox.Show("保存成功！");
                    dataGridView2.DataSource=ds1.Tables[0].DefaultView;
                    myconn.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
         
            }
            else      //新建方案的保存按钮
            {
                try
                {
                    myconn.Close();
                    myconn.Open();
                    SqlCommandBuilder bd = new SqlCommandBuilder(da);
                    da.InsertCommand = bd.GetInsertCommand();
                    da.Update(ds.Tables["data"]);

                    string strsql4 = "update project set finalreagent='" + this.textBox7.Text.Trim().ToString() + "',finalamount='" + this.textBox5.Text.Trim() + "' where id=(select MAX(id) from project)";
                    SqlCommand cmd4 = new SqlCommand(strsql4, myconn);
                    cmd4.ExecuteNonQuery();
                    string strsql3 = "insert into remarks values('" + (i + 1) + "','" + this.textBox7.Text.Trim() + "','" + this.textBox6.Text.Trim() + "','" + DateTime.Now + "','" + this.textBox4.Text.Trim() + "')";
                    SqlCommand cmd3 = new SqlCommand(strsql3, myconn);
                    cmd3.ExecuteNonQuery();
                    MessageBox.Show("方案" + (i + 1).ToString() + "添加成功！");
                    myconn.Close();
                    ViewProject(i+1);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            }

        }

        private void button2_Click_1(object sender, EventArgs e)//新建新方案
        {
            try
            {
                myconn.Close();
                myconn.Open();
     
                ds.Clear();
                textBox7.Text = "";
                textBox5.Text = "";
                textBox6.Text = "";
                textBox4.Text = "";
                da.Fill(ds, "data");
                
                ds.Tables[0].Columns[0].DefaultValue = i + 1;
                
                label10.Text =( i + 1).ToString();
                label12.Text = DateTime.Now.ToString();
                dataGridView2.DataSource = ds.Tables[0];
                dataGridView2.AutoGenerateColumns = false;
                myconn.Close();
                panel1.Visible = true;
                dataGridView2.Columns[0].Visible = false;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

        private void button1_Click(object sender, EventArgs e)//查找方案
        {
            try
            {
                string str = textBox1.Text.Trim();
                string   sql1;
                string   sql2;
                if (str != "")
                {
                    int m = Convert.ToInt32(str);
                    //MessageBox.Show(""+m);//m的值
                    sql1 = "select count(*) from remarks  where  finalreagent like'%" + textBox2.Text.Trim().ToString() + "%' and designer like'%" + textBox3.Text.Trim().ToString() + "%' and id =" + m + "";// 查询结果的条数
                    sql2 = "select * from remarks   where  finalreagent like'%" + textBox2.Text.Trim().ToString() + "%' and designer like'%" + textBox3.Text.Trim().ToString() + "%' and id=" + m + "";// 查询的结果列表
                }
                else
                {
                    sql1 = "select count(*) from remarks  where  finalreagent like'%" + textBox2.Text.Trim().ToString() + "%' and designer like'%" + textBox3.Text.Trim().ToString() + "%'";// 查询结果的条数
                    sql2 = "select * from remarks   where  finalreagent like'%" + textBox2.Text.Trim().ToString() + "%' and designer like'%" + textBox3.Text.Trim().ToString() + "%' " ;// 查询的结果列表
                }
                SqlConnection myconn = new SqlConnection(strconn);
                myconn.Close();
                myconn.Open();
                SqlCommand cmd = new SqlCommand(sql1, myconn);
                int p = 0;
                p= (int)cmd.ExecuteScalar();

                if (p>= 0)
                {
                    SqlDataAdapter myda = new SqlDataAdapter(sql2, myconn);
                    DataSet myds = new DataSet();
                    myda.Fill(myds, "remarks");      //此处remarks为myds数据集的名称
                    dataGridView1.Show(); dataGridView1.DataSource = myds.Tables[0];
                    myds.Tables[0].Columns[0].ColumnName = "方案编号";
                    myds.Tables[0].Columns[1].ColumnName = "配置试剂";
                    myds.Tables[0].Columns[2].ColumnName = "配置者";
                    myds.Tables[0].Columns[3].ColumnName = "配置时间";
                    myds.Tables[0].Columns[4].ColumnName = "备注";
                }
                else
                    MessageBox.Show("没有查找到相关数据！");

                myconn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

        

        private void button3_Click(object sender, EventArgs e)//取消新建方案
        {
            panel1.Visible = false;
        }

        private void 液体配置系统_Load(object sender, EventArgs e)//显示方案列表
        {
            myconn.Close();
            myconn.Open();
            string sql = "select * from remarks";
            SqlDataAdapter myda = new SqlDataAdapter(sql, myconn);
            DataSet myds = new DataSet();
            myda.Fill(myds);      //此处remarks为myds数据集的名称
            dataGridView1.Show(); dataGridView1.DataSource = myds.Tables[0];
            myds.Tables[0].Columns[0].ColumnName = "方案编号";
            myds.Tables[0].Columns[1].ColumnName = "配置试剂";
            myds.Tables[0].Columns[2].ColumnName = "配置者";
            myds.Tables[0].Columns[3].ColumnName = "配置时间";
            myds.Tables[0].Columns[4].ColumnName = "备注";
            myconn.Close();
        }

        private void button5_Click(object sender, EventArgs e)//浏览方案
        {
            myconn.Close();
            myconn.Open();
            string sql = "select * from remarks";
            SqlDataAdapter myda = new SqlDataAdapter(sql, myconn);
            DataSet myds = new DataSet();
            myda.Fill(myds);      //此处remarks为myds数据集的名称
            dataGridView1.Show(); 
            dataGridView1.DataSource = myds.Tables[0];
            myds.Tables[0].Columns[0].ColumnName = "方案编号";
            myds.Tables[0].Columns[1].ColumnName = "配置试剂";
            myds.Tables[0].Columns[2].ColumnName = "配置人";
            myds.Tables[0].Columns[3].ColumnName = "配置时间";
            myds.Tables[0].Columns[4].ColumnName = "备注";
            myconn.Close();
        }

        private void dataGridView2_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        //显示具体方案时，有改动的地方
        {
            isupdated = true;
            
        }
        //以下为对某一具体方案时，对数据的增删改操作。
        private void button6_Click(object sender, EventArgs e)
            //修改按钮
        {
            dataGridView2.ReadOnly = false;
            MessageBox.Show("您可以在左边的表中直接修改数据");
        }

        private void button7_Click(object sender, EventArgs e)
            //添加行
        {
            this.button4.Visible = false;
            myconn.Close();
            myconn.Open();
            long p=0;
            string strsql11 = "select max(pid) from project";
            SqlCommand sql11 = new SqlCommand(strsql11,myconn);
            SqlDataReader reader11 = sql11.ExecuteReader();
            while (reader11.Read())
            {
                p =Convert.ToInt64(reader11[0]);
            } 
            
            dataGridView2.ReadOnly = false;
            ds1.Clear();
            da1.Fill(ds1,"data1");
            DataRow newrow = ds1.Tables[0].NewRow();
            Int32 k = ds1.Tables[0].Rows.Count;
            MessageBox.Show(k.ToString());
            
            newrow["方案id"] = (p + 1);
            newrow["试剂编号"] =1;
            newrow["试剂名称"] ="名称";
            newrow["试剂用量"] =100;
            newrow["方案编号id"] = Convert.ToInt64(label10.Text.Trim().ToString());
            ds1.Tables[0].Rows.InsertAt(newrow,k);
            SqlCommandBuilder bd1 = new SqlCommandBuilder(da1);
            da1.InsertCommand = bd1.GetInsertCommand();
            da1.Update(ds1.Tables["data1"]);
            myconn.Close();
            this.button4.Visible = false;
        }

        private void button9_Click(object sender, EventArgs e)
            //删除行
        {
            try
            {
                int delrowindex = dataGridView2.CurrentRow.Index;
                MessageBox.Show(delrowindex.ToString());
                this.dataGridView2.Rows.RemoveAt(delrowindex);
            }
            catch (Exception ex)
            {
                MessageBox.Show("请选对正确的行！");
            }
            
        }

        private void button8_Click(object sender, EventArgs e)
            //配置液体
        {
            long[] sid=new long[dataGridView2.Rows.Count];
            double[] sweight=new double[dataGridView2.Rows.Count];
            for (int i = 0; i < dataGridView2.Rows.Count; i++)
			{
			    sid[i]=Convert.ToInt64(dataGridView2.Rows[i].Cells[1].Value.ToString());
                sweight[i]=Convert.ToDouble(dataGridView2.Rows[i].Cells[3].Value.ToString());
                //MessageBox.Show(sid[i].ToString()+"  "+sweight[i].ToString());
			}
            does.does start = new does.does(sid,sweight);
            start.Show();
                
        }

       

       
   
    }
}