public int Add_detail(FishEntity.ingredientsdetailEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_ingredientsdetail(code,Goods,tonnage,protein,TVN,acid,Ash,histamine,Lysine,Methionine,Finishedproduct,unitprice,cost,salt)");
strSql.Append("values(@code,@Goods,@tonnage,@protein,@TVN,@acid,@Ash,@histamine,@Lysine,@Methionine,@Finishedproduct,@unitprice,@cost,@salt)");
MySqlParameter[] parameter =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@Goods", MySqlDbType.VarChar, 45),
new MySqlParameter("@tonnage", MySqlDbType.Decimal, 45),
new MySqlParameter("@protein", MySqlDbType.Decimal, 45),
new MySqlParameter("@TVN", MySqlDbType.Decimal, 45),
new MySqlParameter("@acid", MySqlDbType.Decimal, 45),
new MySqlParameter("@Ash", MySqlDbType.Decimal, 45),
new MySqlParameter("@histamine", MySqlDbType.Decimal, 45),
new MySqlParameter("@Lysine", MySqlDbType.Decimal, 45),
new MySqlParameter("@Methionine", MySqlDbType.Decimal, 45),
new MySqlParameter("@Finishedproduct", MySqlDbType.VarChar, 45),
new MySqlParameter("@unitprice", MySqlDbType.Decimal, 45),
new MySqlParameter("@cost", MySqlDbType.Decimal, 45),
new MySqlParameter("@salt", MySqlDbType.Decimal, 45),
};
parameter[0].Value = model.Code;
parameter[1].Value = model.Goods;
parameter[2].Value = model.Tonnage;
parameter[3].Value = model.Protein;
parameter[4].Value = model.TVN;
parameter[5].Value = model.Acid;
parameter[6].Value = model.Ash;
parameter[7].Value = model.Histamine;
parameter[8].Value = model.Lysine;
parameter[9].Value = model.Methionine;
parameter[10].Value = model.Finishedproduct;
parameter[11].Value = model.Unitprice;
parameter[12].Value = model.Cost;
parameter[13].Value = model.Salt;
int id = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameter);
return(id);
}
public bool Update_detail(FishEntity.ingredientsdetailEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_ingredientsdetail set ");
strSql.Append("code=@code,");
strSql.Append("Goods=@Goods,");
strSql.Append("tonnage=@tonnage,");
strSql.Append("protein=@protein,");
strSql.Append("TVN=@TVN,");
strSql.Append("acid=@acid,");
strSql.Append("Ash=@Ash,");
strSql.Append("histamine=@histamine,");
strSql.Append("Lysine=@Lysine,");
strSql.Append("Methionine=@Methionine,");
strSql.Append("Finishedproduct=@Finishedproduct,");
strSql.Append("unitprice=@unitprice,");
strSql.Append("cost=@cost,");
strSql.Append("salt=@salt ");
strSql.Append("where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@Goods", MySqlDbType.VarChar, 45),
new MySqlParameter("@tonnage", MySqlDbType.Decimal, 45),
new MySqlParameter("@protein", MySqlDbType.Decimal, 45),
new MySqlParameter("@TVN", MySqlDbType.Decimal, 45),
new MySqlParameter("@acid", MySqlDbType.Decimal, 45),
new MySqlParameter("@Ash", MySqlDbType.Decimal, 45),
new MySqlParameter("@histamine", MySqlDbType.Decimal, 45),
new MySqlParameter("@Lysine", MySqlDbType.Decimal, 45),
new MySqlParameter("@Methionine", MySqlDbType.Decimal, 45),
new MySqlParameter("@Finishedproduct", MySqlDbType.VarChar, 45),
new MySqlParameter("@unitprice", MySqlDbType.Decimal, 45),
new MySqlParameter("@cost", MySqlDbType.Decimal, 45),
new MySqlParameter("@salt", MySqlDbType.Decimal, 45),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Goods;
parameters[2].Value = model.Tonnage;
parameters[3].Value = model.Protein;
parameters[4].Value = model.TVN;
parameters[5].Value = model.Acid;
parameters[6].Value = model.Ash;
parameters[7].Value = model.Histamine;
parameters[8].Value = model.Lysine;
parameters[9].Value = model.Methionine;
parameters[10].Value = model.Finishedproduct;
parameters[11].Value = model.Unitprice;
parameters[12].Value = model.Cost;
parameters[13].Value = model.Salt;
parameters[14].Value = model.Id;
int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public FishEntity.ingredientsdetailEntity DataRowToModel(DataRow row)
{
FishEntity.ingredientsdetailEntity model = new FishEntity.ingredientsdetailEntity();
if (row != null)
{
if (row["tid"] != null && row["tid"].ToString() != "")
{
model.Id = int.Parse(row["tid"].ToString());
}
if (row["tcode"] != null && row["tcode"].ToString() != "")
{
model.Code = row["tcode"].ToString();
}
if (row["Goods"] != null && row["Goods"].ToString() != "")
{
model.Goods = row["Goods"].ToString();
}
if (row["tonnage"] != null && row["tonnage"].ToString() != "")
{
model.Tonnage = decimal.Parse(row["tonnage"].ToString());
}
if (row["protein"] != null && row["protein"].ToString() != "")
{
model.Protein = decimal.Parse(row["protein"].ToString());
}
if (row["TVN"] != null && row["TVN"].ToString() != "")
{
model.TVN = decimal.Parse(row["TVN"].ToString());
}
if (row["salt"] != null && row["salt"].ToString() != "")
{
model.Salt = decimal.Parse(row["salt"].ToString());
}
if (row["acid"] != null && row["acid"].ToString() != "")
{
model.Acid = decimal.Parse(row["acid"].ToString());
}
if (row["Ash"] != null && row["Ash"].ToString() != "")
{
model.Ash = decimal.Parse(row["Ash"].ToString());
}
if (row["histamine"] != null && row["histamine"].ToString() != "")
{
model.Histamine = decimal.Parse(row["histamine"].ToString());
}
if (row["Lysine"] != null && row["Lysine"].ToString() != "")
{
model.Lysine = decimal.Parse(row["Lysine"].ToString());
}
if (row["Methionine"] != null && row["Methionine"].ToString() != "")
{
model.Methionine = decimal.Parse(row["Methionine"].ToString());
}
if (row["Finishedproduct"] != null && row["Finishedproduct"].ToString() != "")
{
model.Finishedproduct = row["Finishedproduct"].ToString();
}
if (row["unitprice"] != null && row["unitprice"].ToString() != "")
{
model.Unitprice = decimal.Parse(row["unitprice"].ToString());
}
if (row["unitprice"] != null && row["unitprice"].ToString() != "")
{
model.Unitprice = decimal.Parse(row["unitprice"].ToString());
}
if (row["cost"] != null && row["cost"].ToString() != "")
{
model.Cost = decimal.Parse(row["cost"].ToString());
}
}
return(model);
}
public bool Update_detail(FishEntity.ingredientsdetailEntity model)
{
return(dal.Update_detail(model));
}
public int Add_detail(FishEntity.ingredientsdetailEntity model)
{
return(dal.Add_detail(model));
}
