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);
}
}
