public static bool update_rawmaterialCount2(model.rawmaterial r)//出库时在原材料添加时减少数量
{
MySqlConnection conn = Util.Util.getConn();
MySqlCommand command;
try
{
command = conn.CreateCommand();
command.CommandText = "update rawmaterial set rawMaterial_count = rawMaterial_count-" + r.Rawmaterial_count +
" where rawMaterial_number='" + r.Rawmaterial_number + "'";
Console.WriteLine("sql:" + command.CommandText);
command.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(true);
}
public static bool add_rawmaterial(model.rawmaterial r)//入库时添加原材料
{
MySqlConnection conn = Util.Util.getConn();
MySqlCommand command;
try
{
command = conn.CreateCommand();
command.CommandText = "INSERT INTO rawmaterial(rawMaterial_number,rawMaterial_name," +
"rawMaterial_type,rawMaterial_count,rawMaterial_unit) VALUES('"
+ r.Rawmaterial_number + "','" + r.Rawmaterial_name + "','" +
r.Rawmaterial_type + "'," + r.Rawmaterial_count + ",'" + r.Rawmaterial_unit + "')";
Console.WriteLine("sql:" + command.CommandText);
command.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(true);
}
public static List <model.rawmaterial> selectAll(String number)
{
MySqlConnection conn = Util.Util.getConn();
MySqlDataReader dataReader = null;
MySqlCommand command = null;
List <model.rawmaterial> kehus = new List <model.rawmaterial>();
model.rawmaterial r = new model.rawmaterial();
try
{
command = conn.CreateCommand();
command.CommandText = "SELECT * FROM rawmaterial where rawMaterial_number='" + number + "'";
dataReader = command.ExecuteReader();
Console.WriteLine();
while (dataReader.Read())
{
r.Id = dataReader.GetInt16(0);
r.Rawmaterial_number = dataReader.GetString(1);
r.Rawmaterial_name = dataReader.GetString(2);
r.Rawmaterial_type = dataReader.GetString(3);
r.Rawmaterial_count = dataReader.GetDouble(4);
r.Rawmaterial_unit = dataReader.GetString(5);
kehus.Add(r);
}
}
catch (Exception)
{
MessageBox.Show("查询出错！");
}
finally
{
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(kehus);
}
public static List <model.rawmaterial> find_all()//查询出所有客户
{
MySqlConnection conn = Util.Util.getConn();
String sql = "select * from rawmaterial";
MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
Console.WriteLine("ds:" + ds);
da.Fill(ds);
conn.Close();
//获得DataSet里的数据
List <model.rawmaterial> rs = new List <model.rawmaterial>();
Console.Write("88888888888888888888881");
if (ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)//判断DataSet里是否有值
{
rs = new List <model.rawmaterial>();
int count = ds.Tables[0].Rows.Count;//获得表的行数
for (int i = 0; i < count; i++)
{
Console.Write("1111111111111");
model.rawmaterial r = new model.rawmaterial();
r.Id = (int)ds.Tables[0].Rows[i]["id"];
Console.Write("17777777777777771111111");
r.Rawmaterial_number = (string)ds.Tables[0].Rows[i]["rawMaterial_number"];
Console.Write("111111155555555555555551");
r.Rawmaterial_name = (string)ds.Tables[0].Rows[i]["rawMaterial_name"];
r.Rawmaterial_type = (string)ds.Tables[0].Rows[i]["rawMaterial_type"];
r.Rawmaterial_count = (double)ds.Tables[0].Rows[i]["rawMaterial_count"];
r.Rawmaterial_unit = (string)ds.Tables[0].Rows[i]["rawMaterial_unit"];
rs.Add(r);
}
}
return(rs);
}
private void rawmaterial_update_Load(object sender, EventArgs e)
{
Console.Write("！！！！！" + number);
model.rawmaterial r = dao.rawmaterialDaoz.select(number);
Number.Text = r.Rawmaterial_number;
}
