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