public void dealwithcomp(object lingjianhao) { string lj_num = lingjianhao.ToString(); // 目前架构这样, 就不用联合查询了。 宁可多查询一部 #region 获得零件id Maticsoft.BLL.parts parts_bll = new Maticsoft.BLL.parts(); List <Maticsoft.Model.parts> parts_objs = parts_bll.GetModelList(string.Format(" PN = {0} ", lj_num)); if (parts_objs.Count == 1) { Maticsoft.Model.parts part_obj = parts_objs[0]; this.comp_type = Convert.ToInt32(part_obj.componentId); } else { System.Windows.Forms.MessageBox.Show("未知零件类型"); this.Close(); } #endregion #region 获得零件名字 Maticsoft.BLL.component comp_bll = new Maticsoft.BLL.component(); Maticsoft.Model.component comp_mode = comp_bll.GetModel(comp_type); if (comp_mode != null) { this.comp_name = comp_mode.name; this.mode = comp_mode.sm; } // System.Windows.Forms.MessageBox.Show(string.Format("comp_type : == {0}, comp_name : === {1}", this.comp_type, this.comp_name)); #endregion }
private void get_lingjian() { Task query_task = new Task(() => { Maticsoft.BLL.parts parts_list = new Maticsoft.BLL.parts(); List <Maticsoft.Model.parts> pa_list = parts_list.GetModelList(" 1=1 GROUP BY pn"); var datasou = new AutoCompleteStringCollection(); List <string> pn_list = pa_list.ConvertAll <string>((temp_obj) => { return(temp_obj.PN); }); datasou.AddRange(pn_list.ToArray()); textBoxX1.Invoke(new Action(() => { textBoxX1.AutoCompleteCustomSource = datasou; textBoxX1.AutoCompleteMode = AutoCompleteMode.SuggestAppend; textBoxX1.AutoCompleteSource = AutoCompleteSource.CustomSource; })); }); query_task.Start(); }
private void test_bt_Click(object sender, EventArgs e) { if (textBoxX1.Text == "") { MessageBox.Show("请输入零件号"); return; } // 获得类型 //Program.txtbh = textBoxX1.Text; Maticsoft.BLL.parts parts_bll = new Maticsoft.BLL.parts(); List <Maticsoft.Model.parts> parts_mode = parts_bll.GetModelList(string.Format(" PN='{0}' ", textBoxX1.Text)); if (parts_mode.Count <= 0) { return; } Program.type = Convert.ToInt32(parts_mode[0].componentId); StepTestFrom stf = new StepTestFrom(); stf.CompId = textBoxX1.Text; stf.ShowDialog(); }
private void button1_Click(object sender, EventArgs e) { try { if (textBox_ljh.Text == "") { MessageBox.Show("零件号为空"); return; } if (textBox_lxm.Text == "") { MessageBox.Show("序列号为空"); return; } if (textbox_gongdan.Text == "") { MessageBox.Show("工单号为空"); return; } if (comboBox1.SelectedIndex < 0) { MessageBox.Show("请选择正确的类型"); return; } Maticsoft.BLL.parts part_bll = new Maticsoft.BLL.parts(); List <Maticsoft.Model.parts> parts_list = part_bll.GetModelList(string.Format(" PN = '{0}'", textBox_ljh.Text)); if (parts_list.Count > 0) { Maticsoft.Model.parts parts_exmode = parts_list[0]; parts_exmode.Barcode = textBox_lxm.Text; parts_exmode.PN = textBox_ljh.Text; parts_exmode.remark = "管理"; parts_exmode.gongdan = textbox_gongdan.Text; parts_exmode.componentId = this.comp_list[comboBox1.SelectedIndex].componentId; if (part_bll.Update(parts_exmode)) { MessageBox.Show("更新成功"); } else { MessageBox.Show("更新失败"); } } else { Maticsoft.Model.parts parts_mode = new Maticsoft.Model.parts() { Barcode = textBox_lxm.Text, PN = textBox_ljh.Text, remark = "管理", gongdan = textbox_gongdan.Text, componentId = this.comp_list[comboBox1.SelectedIndex].componentId, }; if (part_bll.Add(parts_mode)) { MessageBox.Show("添加成功"); } else { MessageBox.Show("添加失败"); } } } catch (Exception err) { MessageBox.Show(err.Message); } finally { this.DialogResult = DialogResult.OK; } }