/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.measures model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into measures(");
strSql.Append("step, Tools,position,standardv,up,down)");
strSql.Append(" values (");
strSql.Append("@step,@ Tools,@position,@standardv,@up,@down)");
MySqlParameter[] parameters =
{
new MySqlParameter("@step", MySqlDbType.VarChar, 64),
new MySqlParameter("@ Tools", MySqlDbType.VarChar, 64),
new MySqlParameter("@position", MySqlDbType.VarChar, 64),
new MySqlParameter("@standardv", MySqlDbType.VarChar, 64),
new MySqlParameter("@up", MySqlDbType.VarChar, 64),
new MySqlParameter("@down", MySqlDbType.VarChar, 64)
};
parameters[0].Value = model.step;
parameters[1].Value = model.Tools;
parameters[2].Value = model.position;
parameters[3].Value = model.standardv;
parameters[4].Value = model.up;
parameters[5].Value = model.down;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
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);
}
}
}
}
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");
}
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;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.measures model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update measures set ");
strSql.Append("step=@step,");
strSql.Append("Tools=@Tools,");
strSql.Append("position=@position,");
strSql.Append("standardv=@standardv,");
strSql.Append("up=@up,");
strSql.Append("down=@down,");
strSql.Append("componentId=@componentId,");
strSql.Append("CC=@CC,");
strSql.Append("devicetype=@devicetype,");
strSql.Append("portid=@portid");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@step", MySqlDbType.Int32, 64),
new MySqlParameter("@Tools", MySqlDbType.VarChar, 64),
new MySqlParameter("@position", MySqlDbType.VarChar, 64),
new MySqlParameter("@standardv", MySqlDbType.VarChar, 64),
new MySqlParameter("@up", MySqlDbType.VarChar, 64),
new MySqlParameter("@down", MySqlDbType.VarChar, 64),
new MySqlParameter("@componentId", MySqlDbType.Int32, 11),
new MySqlParameter("@CC", MySqlDbType.VarChar, 64),
new MySqlParameter("@devicetype", MySqlDbType.Int32, 11),
new MySqlParameter("@portid", MySqlDbType.Int32, 11),
new MySqlParameter("@id", MySqlDbType.Int32, 64)
};
parameters[0].Value = model.step;
parameters[1].Value = model.Tools;
parameters[2].Value = model.position;
parameters[3].Value = model.standardv;
parameters[4].Value = model.up;
parameters[5].Value = model.down;
parameters[6].Value = model.componentId;
parameters[7].Value = model.CC;
parameters[8].Value = model.devicetype;
parameters[9].Value = model.portid;
parameters[10].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.measures DataRowToModel(DataRow row)
{
Maticsoft.Model.measures model = new Maticsoft.Model.measures();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["step"] != null && row["step"].ToString() != "")
{
model.step = int.Parse(row["step"].ToString());
}
if (row["Tools"] != null)
{
model.Tools = row["Tools"].ToString();
}
if (row["position"] != null)
{
model.position = row["position"].ToString();
}
if (row["standardv"] != null)
{
model.standardv = row["standardv"].ToString();
}
if (row["up"] != null)
{
model.up = row["up"].ToString();
}
if (row["down"] != null)
{
model.down = row["down"].ToString();
}
if (row["componentId"] != null && row["componentId"].ToString() != "")
{
model.componentId = int.Parse(row["componentId"].ToString());
}
if (row["CC"] != null)
{
model.CC = row["CC"].ToString();
}
if (row["devicetype"] != null && row["devicetype"].ToString() != "")
{
model.devicetype = int.Parse(row["devicetype"].ToString());
}
if (row["portid"] != null && row["portid"].ToString() != "")
{
model.portid = int.Parse(row["portid"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.measures model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into measures(");
strSql.Append("step,Tools,position,standardv,up,down,componentId,CC,devicetype,portid)");
strSql.Append(" values (");
strSql.Append("@step,@Tools,@position,@standardv,@up,@down,@componentId,@CC,@devicetype,@portid)");
MySqlParameter[] parameters =
{
new MySqlParameter("@step", MySqlDbType.Int32, 64),
new MySqlParameter("@Tools", MySqlDbType.VarChar, 64),
new MySqlParameter("@position", MySqlDbType.VarChar, 64),
new MySqlParameter("@standardv", MySqlDbType.VarChar, 64),
new MySqlParameter("@up", MySqlDbType.VarChar, 64),
new MySqlParameter("@down", MySqlDbType.VarChar, 64),
new MySqlParameter("@componentId", MySqlDbType.Int32, 11),
new MySqlParameter("@CC", MySqlDbType.VarChar, 64),
new MySqlParameter("@devicetype", MySqlDbType.Int32, 11),
new MySqlParameter("@portid", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.step;
parameters[1].Value = model.Tools;
parameters[2].Value = model.position;
parameters[3].Value = model.standardv;
parameters[4].Value = model.up;
parameters[5].Value = model.down;
parameters[6].Value = model.componentId;
parameters[7].Value = model.CC;
parameters[8].Value = model.devicetype;
parameters[9].Value = model.portid;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.measures GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,step, Tools,position,standardv,up,down from measures ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
Maticsoft.Model.measures model = new Maticsoft.Model.measures();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
