Exemple #1
0
        /// <summary>
        ///
        /// 初始化整个表格
        /// </summary>
        private void initdgv()
        {
            this.del_list.Clear();
            Maticsoft.BLL.measures use1 = new Maticsoft.BLL.measures();
            string  aa = string.Format("componentId = '{0}'ORDER BY step", LjHao);//ORDER BY step
            DataSet ds = use1.GetListByPage3(aa, "", 0, 100);

            dgv.DataSource = ds.Tables[0];
            foreach (DataGridViewRow row in dgv.Rows)
            {
                row.Cells["step"].Value = row.Index + 1;
            }

            Maticsoft.BLL.component   mea_bll   = new Maticsoft.BLL.component();
            Maticsoft.Model.component comp_mode = mea_bll.GetModel(Convert.ToInt32(LjHao));
            if (comp_mode != null)
            {
                Task a_task = new Task(new Action(() => {
                    Thread.Sleep(1000);
                    renderView.Invoke(new Action(() =>
                    {
                        string base_dir   = Environment.CurrentDirectory;
                        base_dir         += "\\shumo\\";
                        base_dir         += comp_mode.sm;
                        IgesReader reader = new IgesReader();
                        bool ret          = reader.Read(base_dir, new CadView(this.renderView));
                        Console.WriteLine("ret ====== " + ret);
                        renderView.FitAll();
                        renderView.RequestDraw();
                    }));
                }));
                a_task.Start();
            }
        }
Exemple #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string componentId = dataGridView1.CurrentRow.Cells["componentId"].Value.ToString();

            Maticsoft.BLL.component comp_bll = new Maticsoft.BLL.component();
            DataSet   ds = comp_bll.GetList(string.Format(" componentId = '{0}'", componentId));
            DataTable dt = ds.Tables[0];

            if (saveFileDialog1.ShowDialog() == DialogResult.OK)
            {
                string fName = saveFileDialog1.FileName;
                //this.DataToExcel(dt, fName);
                Maticsoft.BLL.measures mea_bll = new Maticsoft.BLL.measures();
                DataSet   ds2 = mea_bll.GetList(string.Format(" componentId = '{0}'", componentId));
                DataTable dt2 = ds2.Tables[0];

                for (int i = 0; i < dt2.Rows.Count; i++)
                {
                    for (int j = 0; j < dt2.Columns.Count; j++)
                    {
                        Console.WriteLine(dt2.Rows[i][j].ToString());
                    }
                }
                this.TableToExcelForXLSX2003(dt, dt2, fName, "s1");
                // this.TableToExcelForXLSX2003(dt2, fName, "s2");
                //string file_name = Path.GetFileNameWithoutExtension(fName) + "详情"+ Path.GetExtension(fName);
                //file_name = Path.GetDirectoryName(fName)+ "\\" + file_name;
                //this.DataToExcel(dt2, file_name);
                //this.TableToExcelForXLSX2003(dt2, file_name, "s2");
            }
        }
Exemple #3
0
 private void allupdate()
 {
     for (int i = 0; i < dgv.Rows.Count; i++)
     {
         string to                    = dgv.Rows[i].Cells["Tools"].Value.ToString();
         string tl                    = dgv.Rows[i].Cells["position"].Value.ToString();
         string bz                    = dgv.Rows[i].Cells["standardv"].Value.ToString();
         string sg                    = dgv.Rows[i].Cells["up"].Value.ToString();
         string xg                    = dgv.Rows[i].Cells["down"].Value.ToString();
         string cun                   = dgv.Rows[i].Cells["CC"].Value.ToString();
         int    componentid           = Convert.ToInt32(dgv.Rows[i].Cells["componentid"].Value);
         int    XH                    = Convert.ToInt32(dgv.Rows[i].Cells["id"].Value);
         int    st                    = Convert.ToInt32(dgv.Rows[i].Cells["step"].Value);
         int    device_type           = Convert.ToInt32(dgv.Rows[i].Cells["devicetype"].Value == null ? "0" : dgv.Rows[i].Cells["devicetype"].Value);
         int    port_id               = Convert.ToInt32(dgv.Rows[i].Cells["portid"].Value);
         Maticsoft.BLL.measures   use = new Maticsoft.BLL.measures();
         Maticsoft.Model.measures us  = new measures()
         {
             id          = XH,
             step        = st,
             Tools       = to,
             position    = tl,
             standardv   = bz,
             up          = sg,
             down        = xg,
             componentId = componentid,
             CC          = cun,
             devicetype  = device_type,
             portid      = port_id,
         };
         use.Update(us);
     }
 }
Exemple #4
0
        private void button2_Click(object sender, EventArgs e)
        {
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                DataTable dt = ExcelToDataTable(openFileDialog1.FileName, "s1", true);
                //for (int i = 0; i < dt.Rows.Count; i++)
                //{
                //    for (int j = 0; j < dt.Columns.Count; j++)
                //    {
                //        Console.WriteLine(dt.Rows[i][j].ToString());
                //    }
                //}
                Maticsoft.BLL.component comp_bll = new Maticsoft.BLL.component();

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (!comp_bll.Exists(Convert.ToInt32(dt.Rows[i]["componentId"])))
                    {
                        Maticsoft.Model.component comp_mode = new Maticsoft.Model.component()
                        {
                            componentId = Convert.ToInt32(dt.Rows[i]["componentId"]),
                            ARef        = Convert.ToString(dt.Rows[i]["ARef"]),
                            jobnum      = Convert.ToString(dt.Rows[i]["jobnum"]),
                            name        = Convert.ToString(dt.Rows[i]["name"]),
                            size        = Convert.ToString(dt.Rows[i]["size"]),
                            photo       = Convert.ToString(dt.Rows[i]["photo"]),
                            sm          = Convert.ToString(dt.Rows[i]["sm"]),
                            remark      = Convert.ToString(dt.Rows[i]["remark"])
                        };
                        comp_bll.Add(comp_mode);
                    }
                }

                DataTable dt2 = ExcelToDataTable(openFileDialog1.FileName, "s2", true);
                Maticsoft.BLL.measures mea_bll = new Maticsoft.BLL.measures();
                for (int i = 0; i < dt2.Rows.Count; i++)
                {
                    if (!mea_bll.Exists(Convert.ToInt32(dt2.Rows[i]["id"])))
                    {
                        Maticsoft.Model.measures mea_obj = new Maticsoft.Model.measures()
                        {
                            id          = Convert.ToInt32(dt2.Rows[i]["id"]),
                            componentId = Convert.ToInt32(dt2.Rows[i]["componentId"]),
                            standardv   = Convert.ToString(dt2.Rows[i]["standardv"]),
                            step        = Convert.ToInt32(dt2.Rows[i]["step"]),
                            down        = Convert.ToString(dt2.Rows[i]["down"]),
                            up          = Convert.ToString(dt2.Rows[i]["up"]),
                            devicetype  = Convert.ToInt32(dt2.Rows[i]["devicetype"]),
                            position    = Convert.ToString(dt2.Rows[i]["position"]),
                            Tools       = Convert.ToString(dt2.Rows[i]["Tools"]),
                            CC          = Convert.ToString(dt2.Rows[i]["CC"]),
                        };
                        mea_bll.Add(mea_obj);
                    }
                }
            }
        }
Exemple #5
0
        public void btnSave_Click(object sender, EventArgs e)
        {
            string strErr = "";

            if (this.txtstep.Text.Trim().Length == 0)
            {
                strErr += "step不能为空!\\n";
            }
            if (this.txt Tools.Text.Trim().Length == 0)
            {
                strErr += " Tools不能为空!\\n";
            }
            if (this.txtposition.Text.Trim().Length == 0)
            {
                strErr += "position不能为空!\\n";
            }
            if (this.txtstandardv.Text.Trim().Length == 0)
            {
                strErr += "standardv不能为空!\\n";
            }
            if (this.txtup.Text.Trim().Length == 0)
            {
                strErr += "up不能为空!\\n";
            }
            if (this.txtdown.Text.Trim().Length == 0)
            {
                strErr += "down不能为空!\\n";
            }

            if (strErr != "")
            {
                MessageBox.Show(this, strErr);
                return;
            }
            int    id        = int.Parse(this.lblid.Text);
            string step      = this.txtstep.Text;
            string Tools     = this.txt Tools.Text;
            string position  = this.txtposition.Text;
            string standardv = this.txtstandardv.Text;
            string up        = this.txtup.Text;
            string down      = this.txtdown.Text;


            Maticsoft.Model.measures model = new Maticsoft.Model.measures();
            model.id        = id;
            model.step      = step;
            model.Tools     = Tools;
            model.position  = position;
            model.standardv = standardv;
            model.up        = up;
            model.down      = down;

            Maticsoft.BLL.measures bll = new Maticsoft.BLL.measures();
            bll.Update(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx");
        }
Exemple #6
0
 private void send_bt_Click(object sender, EventArgs e)
 {
     allupdate();
     groupBox1.Enabled = true;
     Maticsoft.BLL.measures use = new Maticsoft.BLL.measures();
     foreach (int del_id in del_list)
     {
         use.Delete(del_id);
     }
     MessageBox.Show("数据已经提交");
 }
Exemple #7
0
 private void ShowInfo(int id)
 {
     Maticsoft.BLL.measures   bll   = new Maticsoft.BLL.measures();
     Maticsoft.Model.measures model = bll.GetModel(id);
     this.lblid.Text        = model.id.ToString();
     this.lblstep.Text      = model.step;
     this.lbl Tools.Text    = model.Tools;
     this.lblposition.Text  = model.position;
     this.lblstandardv.Text = model.standardv;
     this.lblup.Text        = model.up;
     this.lbldown.Text      = model.down;
 }
        private void reQuery(bool all = false, string order = "")
        {
            string where_string = this.query_wherestring();
            // 同步处理好 零件的基础信息的事情
            string lijianhao = textBox_ljhao.Text;

            if (lijianhao != null && lijianhao != "")
            {
                this.dealwithcomp(Convert.ToInt32(lijianhao));
            }
            else
            {
                return;
            }

            #region 构建基本的表形状

            DataTable mea_dt = new DataTable();
            Maticsoft.BLL.measures          mea_bll   = new Maticsoft.BLL.measures();
            List <Maticsoft.Model.measures> mea_modes = mea_bll.GetModelList(string.Format(" componentId={0}  order by step", this.comp_type));
            mea_dt.Columns.Add("零件号");
            mea_dt.Columns.Add("测量编号");
            mea_modes = mea_modes.OrderBy(obj => obj.step).ToList();
            foreach (Maticsoft.Model.measures mea_obj in mea_modes)
            {
                //string sg = "步骤" + mea_dt.Tables[0].Rows[i]["step"].ToString();// comboBox1.Items.Add()
                // comboBox1.Text = sg;
                string sg = mea_obj.CC.ToString();
                mea_dt.Columns.Add(sg.ToString());
            }
            mea_dt.Columns.Add("结果");
            mea_dt.Columns.Add("测量时间");
            if (all == false)
            {
                dgv.DataSource = null;
                dgv.DataSource = mea_dt;
                for (int i = 0; i < this.dgv.Columns.Count; i++)
                {
                    this.dgv.Columns[i].SortMode = DataGridViewColumnSortMode.Programmatic;
                }
            }
            dgv.Columns["测量编号"].Width = 140;
            dgv.Columns["测量时间"].Width = 140;
            // dgv.AutoGenerateColumns = false;
            dataGridView1.DataSource = mea_dt.Copy();
            #endregion

            // 查询出来test 数据
            Maticsoft.BLL.test test_bll = new Maticsoft.BLL.test();
            // List<Maticsoft.Model.test> test_lists =  test_bll.GetModelList(where_str);
            DataSet ds = new DataSet();

            DataTable dest_table = null;
            //DataTable dest_table2 = null;
            if (all == false)
            {
                ds         = test_bll.GetListByPage2(where_string, order, cur_page_lenb * cur_page_num, cur_page_lenb);
                dest_table = dgv.DataSource as DataTable;
            }
            else
            {
                ds         = test_bll.GetListByPage2(where_string, order, 0, 10000);
                dest_table = dataGridView1.DataSource as DataTable;
            }
            DataTable dt = ds.Tables[0];


            #region 根据数据 更新表结构  ==== 惰性加入数据
            // 放入基础信息
            Task <string[]> parent = new Task <string[]>((aa) =>
            {
                DataTable local_dt      = aa as DataTable;
                int count               = local_dt.Rows.Count;
                string[] ret            = new string[count];
                dgv.Columns["零件号"].Tag  = "PN";
                dgv.Columns["测量编号"].Tag = "measureb";
                dgv.Columns["测量时间"].Tag = "time";
                dgv.Columns["结果"].Tag   = "OKorNG";
                for (int i = 0; i < count; i++)
                {
                    DataRow xin_dr = dest_table.NewRow();
                    xin_dr["零件号"]  = local_dt.Rows[i]["PN"];
                    xin_dr["测量编号"] = local_dt.Rows[i]["measureb"];
                    xin_dr["测量时间"] = local_dt.Rows[i]["time"];
                    xin_dr["结果"]   = local_dt.Rows[i]["OKorNG"];

                    dest_table.Rows.Add(xin_dr);
                    //xin_dr.Rows[][] = local_dt.Rows[i][0]
                    new Task((index) =>
                    {
                        int ret_i = Convert.ToInt32(index);
                        // Console.WriteLine("试试   " + index);
                        ret[ret_i] = local_dt.Rows[ret_i]["step1"].ToString();
                    }, i, TaskCreationOptions.AttachedToParent).Start();
                }
                return(ret);
            }, dt);
            parent.ContinueWith((t) =>
            {
                for (int i = 0; i < t.Result.Length; i++)
                {
                    string[] sp_l = t.Result[i].Split('/');
                    foreach (Maticsoft.Model.measures mea_obj in mea_modes)
                    {
                        int ret_col_num = 1;
                        bool col_if     = int.TryParse(mea_obj.step.ToString(), out ret_col_num);
                        // string sg = "步骤" + mea_obj.CC.ToString();
                        string sg           = mea_obj.CC.ToString();
                        dgv.Columns[sg].Tag = "step1";
                        //mea_modes
                        if (col_if && ret_col_num < sp_l.Length + 1)
                        {
                            double stand_info = Convert.ToDouble(mea_obj.standardv);
                            string test_str   = sp_l[ret_col_num - 1];
                            if (test_str == "")
                            {
                                continue;
                            }
                            double test_info       = Convert.ToDouble(test_str);
                            dest_table.Rows[i][sg] = sp_l[ret_col_num - 1];
                            if (all == false)
                            {
                                if (stand_info + Convert.ToDouble(mea_obj.down) > test_info)
                                {
                                    dgv.Rows[i].Cells[sg].Style.BackColor = Color.Cyan;
                                }

                                else if (stand_info + Convert.ToDouble(mea_obj.up) < test_info)
                                {
                                    dgv.Rows[i].Cells[sg].Style.BackColor = Color.LightSalmon;
                                }
                                else
                                {
                                    dgv.Rows[i].Cells[sg].Style.BackColor = Color.Lime;
                                }
                            }
                            else
                            {
                                if (stand_info + Convert.ToDouble(mea_obj.down) > test_info)
                                {
                                    dataGridView1.Rows[i].Cells[sg].Style.BackColor = Color.Cyan;
                                }

                                else if (stand_info + Convert.ToDouble(mea_obj.up) < test_info)
                                {
                                    dataGridView1.Rows[i].Cells[sg].Style.BackColor = Color.LightSalmon;
                                }
                                else
                                {
                                    dataGridView1.Rows[i].Cells[sg].Style.BackColor = Color.Lime;
                                }
                            }
                        }
                    }
                }

                // 计算
                jisuan(all);
            });
            parent.Start();
            #endregion

            #endregion
            return;
        }
        private void jisuan(bool all = false)
        {
            DataTable dt2 = NewMethod();

            //构建一个计算用的表格
            Maticsoft.BLL.measures          mea_bll  = new Maticsoft.BLL.measures();
            List <Maticsoft.Model.measures> mea_list = mea_bll.GetModelList(string.Format(" componentId = '{0}' order by step ", this.comp_type));

            foreach (Maticsoft.Model.measures mea_obj in mea_list)
            {
                // dt2.Columns.Add(new DataColumn("s" + mea_obj.step.ToString(), typeof(Double)));
                dt2.Columns.Add(new DataColumn(mea_obj.CC.ToString(), typeof(Double)));
            }

            // 取得数据。 分解数据。 填充数据
            Maticsoft.BLL.test test_bll      = new Maticsoft.BLL.test();
            string             where_string1 = this.query_wherestring();
            // radioGroup1.SelectedIndex = 2;
            DataSet ds = test_bll.GetList3(where_string1);
            //DataTable dt = this.dgv.DataSource as DataTable;
            DataTable dt = ds.Tables[0];

            List <double[]> bbb = new List <double[]>();

            foreach (DataRow dr in dt.Rows)
            {
                string   step      = dr["step1"].ToString();
                string[] temp_step = step.Split('/');

                if (temp_step.Length == dt2.Columns.Count)
                {
                    DataRow dr_temp = dt2.NewRow();
                    for (int i = 0; i < temp_step.Length; i++)
                    {
                        double temp_d = 0;
                        Double.TryParse(temp_step[i], out temp_d);
                        // dr_temp["s" + (i + 1).ToString()] = temp_d;
                        dr_temp[i] = temp_d;
                        Console.WriteLine("temp_step[i] == " + temp_step[i] + " ===  " + i);
                    }
                    dt2.Rows.Add(dr_temp);
                    //Console.WriteLine(Environment.NewLine);
                }
            }

            /*
             * CPK=Cp*(1-|Ca|)
             * Ca (Capability of Accuracy):制程准确度;在衡量「实际平均值」与「规格中心值」之一致性。对於单边规格,因不存在规格中心,因此不存在Ca;对於双边规格,Ca=(ˉx-U)/(T/2)。
             * Cp (Capability of Precision):制程精密度;在衡量「规格公差宽度」与「制程变异宽度」之比例。对於单边规格,只有上限和中心值,Cpu = | USL-ˉx | / 3σ 或 只有下限和中心值,Cpl = | ˉx -LSL | / 3σ;对於双边规格:Cp=(USL-LSL) / 6σ=T/6σ
             * 注意: 计算Cpk时,取样数据至少应有20组数据,而且数据要具有一定代表性。
             *
             * 某零件质量要求为20±0.15,抽样100件,测得:-x =20.05mm;s=0.05mm,求过程能力指数。根据零件的规格要求,Tu=20.15,Tl=19.85
             * M=Tu+Tl/2=(20.15+19.85)/2=20.00
             * ε=|M- 20.05|=0.05
             * T = USL - LSL = 20.15 - 19.85 = 0.3
             * CPK = CP*(|1-CA|)
             * = (T-2ε)/6s = (0.3-2*0.05)/(6*0.05)=(0.3-0.1)/(6*0.05)≈0.67
             */
            // 分析数据
            // mea_list
            string all_cpk = "";
            Dictionary <int, double> cpk_dic = new Dictionary <int, double>();

            foreach (DataColumn aa in dt2.Columns)
            {
                int    step     = dt2.Columns.IndexOf(aa);
                string col_name = aa.ColumnName.Replace("s", "");
                //dt2.Columns[1].
                // List<Maticsoft.Model.measures> mea_obj = mea_list.Where(x => x.step == Convert.ToInt32(col_name)).Select(x => x).ToList<Maticsoft.Model.measures>();
                List <Maticsoft.Model.measures> mea_obj = mea_list.Where(x => x.step == step + 1).Select(x => x).ToList <Maticsoft.Model.measures>();
                //string rr = dt2.Select("", aa.ColumnName + " DESC")[0][aa.ColumnName].ToString();
                object max = dt2.Compute(string.Format("Max([{0}])", aa.ColumnName), "true");
                //  MessageBox.Show(max.ToString());
                object min   = dt2.Compute(string.Format("Min([{0}])", aa.ColumnName), "true");
                double sta   = Convert.ToDouble(mea_obj[0].standardv);
                double va_x1 = Convert.ToDouble(max is DBNull ? 0 : max);
                double va_x2 = Convert.ToDouble(min is DBNull ? 0 : min);
                double va_x  = va_x1 - sta > sta - va_x2 ? va_x1 : va_x2;
                double va_s  = sta - va_x;
                double tu    = sta + Convert.ToDouble(mea_obj[0].up);
                double ti    = sta - Convert.ToDouble(mea_obj[0].down);
                double v_m   = (tu + ti) / 2;
                double sgm   = Math.Abs(sta - va_x);
                double v_t   = tu - ti;
                double cpk   = (v_t - 2 * sgm) / (6 * va_s);
                Console.WriteLine(string.Format("max == {0} --- min {1}----- {2}::{3}", max, min, mea_obj[0].up, mea_obj[0].down));
                Console.WriteLine(Environment.NewLine);
                Console.WriteLine(string.Format("cpk == {0}", cpk));
                all_cpk += " " + aa.ColumnName + "= " + cpk;
                //cpk_dic.Add(aa.ColumnName, cpk);
                cpk_dic.Add(step + 1, cpk);
            }
            string op = "\t" + get_okpara();

            //MessageBox.Show("all_cpk" + all_cpk + "   op" + op);
            label_result.Invoke(new Action(() => {
                label_result.Text = string.Format("all_cpk" + all_cpk + "   op" + op);
            }));

            if (all == true)
            {
                dataGridView1.Invoke(new Action(() =>
                {
                    #region 添加一行总结
                    DataTable temp_table = dataGridView1.DataSource as DataTable;
                    int last_row         = temp_table.Rows.Count;
                    if (temp_table.Rows[last_row - 1]["零件号"].ToString() == "结果与CPK")
                    {
                        return;
                    }
                    DataRow temp_dr = temp_table.NewRow();
                    temp_dr["零件号"]  = "结果与CPK";
                    foreach (KeyValuePair <int, double> par in cpk_dic)
                    {
                        // string key_name = par.Key.Replace("s", "步骤");
                        // string key_name = par.Key;
                        temp_dr[par.Key + 1] = par.Value.ToString("0.00");
                    }
                    temp_dr["结果"] = op.Replace("\t", "");
                    temp_table.Rows.Add(temp_dr);
                    dataGridView1.Refresh();
                    jisuan_f = true;
                }));
            }
            else
            {
            }

            dgv.Invoke(new Action(() =>
            {
                #region 添加一行总结
                DataTable temp_table = dgv.DataSource as DataTable;
                int last_row         = temp_table.Rows.Count;
                if (last_row >= 1)
                {
                    if (temp_table.Rows[last_row - 1]["零件号"].ToString() == "结果与CPK")
                    {
                        return;
                    }
                    DataRow temp_dr = temp_table.NewRow();
                    temp_dr["零件号"]  = "结果与CPK";
                    foreach (KeyValuePair <int, double> par in cpk_dic)
                    {
                        // string key_name = par.Key.Replace("s", "步骤");
                        temp_dr[par.Key + 1] = par.Value.ToString("0.00");
                    }
                    temp_dr["结果"] = op.Replace("\t", "");
                    temp_table.Rows.Add(temp_dr);
                    dgv.Refresh();
                }
            }));
            #endregion
        }
Exemple #10
0
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void mdf_bt_Click(object sender, EventArgs e)
        {
            //for (int i=0; i<dgv.Rows.Count;i++) {
            //bomname_tb.Text = dgv.Rows[0].Cells["tool"].Value.ToString();
            //gdno_tb.Text = dgv.Rows[0].Cells["testlocal"].Value.ToString();
            //scbh_tb.Text = dgv.Rows[0].Cells["bzz"].Value.ToString();
            //sandsm_tb.Text = dgv.Rows[0].Cells["sgc"].Value.ToString();
            //tm_tb.Text = dgv.Rows[0].Cells["xgc"].Value.ToString();
            //cicun_tb.Text = dgv.Rows[0].Cells["cicun"].Value.ToString();
            #region 判断条件


            if (gdno_tb.Text == "")
            {
                MessageBox.Show("请填写位置");
                return;
            }
            if (scbh_tb.Text == "")
            {
                MessageBox.Show("请填写标准值");
                return;
            }
            if (sandsm_tb.Text == "")
            {
                MessageBox.Show("请填上公差");
                return;
            }
            if (tm_tb.Text == "")
            {
                MessageBox.Show("请填下公差");
                return;
            }
            if (cicun_tb.Text == "")
            {
                MessageBox.Show("请填写尺寸");
                return;
            }
            if (comboBox_devs.Text == "")
            {
                MessageBox.Show("请选择工具");
                return;
            }

            #endregion
            int step_index = dgv.CurrentCell.RowIndex;
            int XH         = Convert.ToInt32(dgv.Rows[step_index].Cells["id"].Value);
            //String TO = bomname_tb.Text;
            string PO = gdno_tb.Text;
            string ST = scbh_tb.Text;
            string SG = sandsm_tb.Text;
            string XG = tm_tb.Text;
            string CI = cicun_tb.Text;
            // string LJH = textbox_ljh.Text;
            Maticsoft.BLL.measures   use = new Maticsoft.BLL.measures();
            Maticsoft.Model.measures us  = new measures()
            {
                id          = XH,
                Tools       = 1.ToString(),
                position    = PO,
                standardv   = ST,
                up          = SG,
                down        = XG,
                CC          = CI,
                componentId = Convert.ToInt32(this.LjHao),
                step        = Convert.ToInt32(dgv.Rows[step_index].Cells["step"].Value),
                //devicetype = this.td_lists[comboBox_devs.SelectedIndex].devicetype
                devicetype = port_list[comboBox_devs.SelectedIndex].devicetype,
                portid     = port_list[comboBox_devs.SelectedIndex].id,
            };
            use.Update(us);
            // }
            MessageBox.Show("修改成功");
            //Ctrol.Text = "";
            //bomname_tb.Text = "";
            gdno_tb.Text     = "";
            scbh_tb.Text     = "";
            sandsm_tb.Text   = "";
            tm_tb.Text       = "";
            cicun_tb.Text    = "";
            textbox_ljh.Text = "";
            Maticsoft.BLL.measures use1 = new Maticsoft.BLL.measures();
            string  aa = string.Format("componentId = '{0}'ORDER BY step", LjHao);
            DataSet ds = use1.GetListByPage3(aa, "", 0, 100);
            dgv.DataSource = ds.Tables[0];
            foreach (DataGridViewRow row in dgv.Rows)
            {
                row.Cells["step"].Value = row.Index + 1;
            }


            // 选中下一行
            dgv.ClearSelection();
            step_index += 1;
            int last_line = dgv.Rows.Count;
            if (step_index >= last_line - 1)
            {
                step_index = last_line - 1;
            }

            dgv.Rows[step_index].Selected          = true;
            dgv.Rows[step_index].Cells[0].Selected = true;
            dgv.CurrentCell = dgv.Rows[step_index].Cells["step"];
        }
Exemple #11
0
        /// <summary>
        ///
        /// 新建规矩
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void new_bt_Click(object sender, EventArgs e)
        {
            try
            {
                #region 判断条件

                if (gdno_tb.Text == "")
                {
                    MessageBox.Show("请填写位置");
                    return;
                }
                if (scbh_tb.Text == "")
                {
                    MessageBox.Show("请填写标准值");
                    return;
                }
                if (sandsm_tb.Text == "")
                {
                    MessageBox.Show("请填上公差");
                    return;
                }
                if (tm_tb.Text == "")
                {
                    MessageBox.Show("请填下公差");
                    return;
                }
                if (cicun_tb.Text == "")
                {
                    MessageBox.Show("请填写尺寸");
                    return;
                }
                if (comboBox_devs.Text == "")
                {
                    MessageBox.Show("请选择工具");
                    return;
                }
                else
                {
                    int index = comboBox_devs.SelectedIndex;
                }
                #endregion
                int max_step = dgv.Rows.Count;

                Maticsoft.BLL.measures   use = new Maticsoft.BLL.measures();
                Maticsoft.Model.measures us  = new measures()
                {
                    // step=Convert.ToInt32( bz.Text),
                    // S Tools = bomname_tb.Text,
                    position    = gdno_tb.Text,
                    standardv   = scbh_tb.Text,
                    up          = sandsm_tb.Text,
                    down        = tm_tb.Text,
                    CC          = cicun_tb.Text,
                    componentId = Convert.ToInt32(this.LjHao),
                    devicetype  = port_list[comboBox_devs.SelectedIndex].devicetype,
                    portid      = port_list[comboBox_devs.SelectedIndex].id,
                    step        = max_step + 1,
                    Tools       = comboBox_devs.Text,
                };
                // MessageBox.Show(this.comboBox_devs.SelectedIndex.ToString());
                use.Add(us);
                MessageBox.Show("已经提交保存");
                gdno_tb.Text   = "";
                scbh_tb.Text   = "";
                sandsm_tb.Text = "";
                tm_tb.Text     = "";
                cicun_tb.Text  = "";
                this.initdgv();
            }
            catch (Exception err)
            {
                Console.WriteLine(err.Message);
            }
        }