private MerchandiseLabelData BuildLabelData(DataRow dr)
{
MerchandiseLabelData data = new MerchandiseLabelData();
data.ID = (string)dr["goods_id"];
if (!string.IsNullOrEmpty(dr["code"].ToString()))
{
data.MerchID = (string)dr["code"];
}
if (!string.IsNullOrEmpty(dr["name"].ToString()))
{
data.MerchName = (string)dr["name"];
}
if (!string.IsNullOrEmpty(dr["category_name"].ToString()))
{
data.Category = (string)dr["category_name"];
}
if (!string.IsNullOrEmpty(dr["units"].ToString()))
{
data.Uint = (string)dr["units"];
}
if (!string.IsNullOrEmpty(dr["selling_price"].ToString()))
{
data.UintPrice = (decimal)dr["selling_price"];
}
if (!string.IsNullOrEmpty(dr["label_print_num"].ToString()))
{
data.TotalPrint = (int)dr["label_print_num"];
}
if (!string.IsNullOrEmpty(dr["net_content"].ToString()))
{
data.NetContent = (string)dr["net_content"];
}
if (!string.IsNullOrEmpty(dr["additive"].ToString()))
{
data.Additive = (string)dr["additive"];
}
if (!string.IsNullOrEmpty(dr["expiration"].ToString()))
{
data.Expiration = (string)dr["expiration"];
}
if (!string.IsNullOrEmpty(dr["material"].ToString()))
{
data.Ingredient = (string)dr["material"];
}
data.MakeDate = DateTime.Now;
return(data);
}
public List <MerchandiseLabelData> QueryMerchandise(string content, string cagegoryID)
{
DataSet ds;
List <MerchandiseLabelData> exinfo_list = new List <MerchandiseLabelData>();
if (string.IsNullOrEmpty(cagegoryID))
{
ds = ExecuteDataSet(@"select a.goods_id,a.code,a.name,a.selling_price,a.units,b.*,c.category_name from goods a,
goods_info_ext b,goods_category c where a.goods_id=b.goods_id and c.id=a.category and (a.code like @id or a.name like @name or a.abbr like @abbr)",
new MySqlParameter("@id", "%" + content + "%"),
new MySqlParameter("@name", "%" + content + "%"),
new MySqlParameter("@abbr", "%" + content + "%")
);
}
else
{
ds = ExecuteDataSet(@"select a.goods_id,a.code,a.name,a.selling_price,a.units,b.*,c.category_name from goods a,
goods_info_ext b,splb c where a.goods_id=b.goods_id and c.id=a.category and (a.code like @id or a.name like @name or a.abbr like @abbr) and a.category=@category",
new MySqlParameter("@id", "%" + content + "%"),
new MySqlParameter("@name", "%" + content + "%"),
new MySqlParameter("@abbr", "%" + content + "%"),
new MySqlParameter("@category", cagegoryID)
);
}
if (null != ds && ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
MerchandiseLabelData data = BuildLabelData(dr);
exinfo_list.Add(data);
}
}
return(exinfo_list);
}
