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 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); } } } }
private void button1_Click(object sender, EventArgs e) { try { if (textBox_name.Text == "") { MessageBox.Show("名称不可以为空"); return; } if (textBox_bianhao.Text == "") { MessageBox.Show("生产编号不可以为空"); return; } if (textBox_cc.Text == "") { MessageBox.Show("尺寸不可以为空"); return; } if (textBox_sm.Text == "") { MessageBox.Show("数模不可以为空"); return; } //if (textBox_picname.Text == "") //{ // MessageBox.Show("图片不可以为空"); // return; //} Maticsoft.BLL.component com_bll = new Maticsoft.BLL.component(); Maticsoft.Model.component copm_mode = new Maticsoft.Model.component() { name = textBox_name.Text, jobnum = textBox_gongdan.Text, ARef = textBox_bianhao.Text, size = textBox_cc.Text, sm = textBox_sm.Text, photo = textBox_picname.Text, remark = "管理" }; if (com_bll.Add(copm_mode)) { MessageBox.Show("新建成功"); } else { MessageBox.Show("新建失败"); } } catch (Exception err) { MessageBox.Show(err.Message); } this.Close(); }
public void dealwithcomp(int type) { comp_type = type; #region 获得零件名字 Maticsoft.BLL.component comp_bll = new Maticsoft.BLL.component(); Maticsoft.Model.component comp_mode = comp_bll.GetModel(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 }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.component model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update component set "); strSql.Append("name=@name,"); strSql.Append("remark=@remark,"); strSql.Append("jobnum=@jobnum,"); strSql.Append("ARef=@ARef,"); strSql.Append("size=@size,"); strSql.Append("sm=@sm,"); strSql.Append("photo=@photo"); strSql.Append(" where componentId=@componentId "); MySqlParameter[] parameters = { new MySqlParameter("@name", MySqlDbType.VarChar, 64), new MySqlParameter("@remark", MySqlDbType.VarChar, 64), new MySqlParameter("@jobnum", MySqlDbType.VarChar, 64), new MySqlParameter("@ARef", MySqlDbType.VarChar, 64), new MySqlParameter("@size", MySqlDbType.VarChar, 64), new MySqlParameter("@sm", MySqlDbType.VarChar, 64), new MySqlParameter("@photo", MySqlDbType.VarChar, 255), new MySqlParameter("@componentId", MySqlDbType.Int32, 11) }; parameters[0].Value = model.name; parameters[1].Value = model.remark; parameters[2].Value = model.jobnum; parameters[3].Value = model.ARef; parameters[4].Value = model.size; parameters[5].Value = model.sm; parameters[6].Value = model.photo; parameters[7].Value = model.componentId; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void bt_update_Click(object sender, EventArgs e) { Maticsoft.BLL.component comp_bll = new Maticsoft.BLL.component(); foreach (DataGridViewRow dgr in dataGridView1.Rows) { if (dgr != null) { Maticsoft.Model.component comp_mode = new Maticsoft.Model.component { ARef = dgr.Cells["ARef"].Value.ToString(), componentId = Convert.ToInt32(dgr.Cells["componentId"].Value), jobnum = dgr.Cells["jobnum"].Value.ToString(), size = dgr.Cells["size"].Value.ToString(), name = dgr.Cells["name"].Value.ToString(), photo = dgr.Cells["photo"].Value.ToString(), remark = dgr.Cells["remark"].Value.ToString(), sm = dgr.Cells["sm"].Value.ToString(), }; if (comp_bll.Update(comp_mode)) { // MessageBox.Show("更新成功"); } else { MessageBox.Show("更新失败"); } } } foreach (int del_id in del_list) { if (comp_bll.Delete(del_id)) { // MessageBox.Show("删除成功"); } else { MessageBox.Show("没有删除成功"); } } MessageBox.Show("提交成功"); // DataGridViewRow dgr = dataGridView1.CurrentRow }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.component DataRowToModel(DataRow row) { Maticsoft.Model.component model = new Maticsoft.Model.component(); if (row != null) { if (row["componentId"] != null && row["componentId"].ToString() != "") { model.componentId = int.Parse(row["componentId"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } if (row["jobnum"] != null) { model.jobnum = row["jobnum"].ToString(); } if (row["ARef"] != null) { model.ARef = row["ARef"].ToString(); } if (row["size"] != null) { model.size = row["size"].ToString(); } if (row["sm"] != null) { model.sm = row["sm"].ToString(); } if (row["photo"] != null) { model.photo = row["photo"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.component model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into component("); strSql.Append("componentId,name,remark,jobnum,ARef,size,sm,photo)"); strSql.Append(" values ("); strSql.Append("@componentId,@name,@remark,@jobnum,@ARef,@size,@sm,@photo)"); MySqlParameter[] parameters = { new MySqlParameter("@componentId", MySqlDbType.Int32, 11), new MySqlParameter("@name", MySqlDbType.VarChar, 64), new MySqlParameter("@remark", MySqlDbType.VarChar, 64), new MySqlParameter("@jobnum", MySqlDbType.VarChar, 64), new MySqlParameter("@ARef", MySqlDbType.VarChar, 64), new MySqlParameter("@size", MySqlDbType.VarChar, 64), new MySqlParameter("@sm", MySqlDbType.VarChar, 64), new MySqlParameter("@photo", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.componentId; parameters[1].Value = model.name; parameters[2].Value = model.remark; parameters[3].Value = model.jobnum; parameters[4].Value = model.ARef; parameters[5].Value = model.size; parameters[6].Value = model.sm; parameters[7].Value = model.photo; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.component GetModel(int componentId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select componentId,name,remark,jobnum,ARef,size,sm,photo from component "); strSql.Append(" where componentId=@componentId "); MySqlParameter[] parameters = { new MySqlParameter("@componentId", MySqlDbType.Int32, 11) }; parameters[0].Value = componentId; Maticsoft.Model.component model = new Maticsoft.Model.component(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }