/// <summary>
/// 查詢固定組合商品的總信息
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public List<ProductItemMap> QueryProductItemMap(ProductItemMap p)
{
p.Replace4MySQL();
tempStr = string.Format("select rid,channel_id,channel_detail_id,item_id,product_name,product_cost,product_price,product_id,group_item_id,price_master_id from product_item_map where channel_id={0} and product_id={1} and group_item_id='{2}' and price_master_id={3}", p.channel_id, p.product_id, p.group_item_id, p.price_master_id);//edit by xiangwang0413w 20714/07/02
return _accessMySql.getDataTableForObj<ProductItemMap>(tempStr.ToString());
}
public List<ProductItemMap> QueryAll(ProductItemMap p)
{
p.Replace4MySQL();
tempStr = string.Format(@"SELECT rid,channel_id,channel_detail_id,item_id,product_name,product_cost,product_price,product_id,group_item_id,price_master_id FROM product_item_map WHERE channel_id = {0} AND channel_detail_id = '{1}'", p.channel_id, p.channel_detail_id);
return _accessMySql.getDataTableForObj<ProductItemMap>(tempStr);
}
public string saveString(ProductItemMap p)
{
p.Replace4MySQL();
return string.Format("insert into product_item_map (`channel_id`, `channel_detail_id`, `item_id`, `product_name`, `product_cost`, `product_price`,`product_id`,`group_item_id`,`price_master_id`) values ({0},'{1}',{2},'{3}',{4},{5},{6},'{7}',{8});select @@identity;", p.channel_id, p.channel_detail_id, p.item_id, p.product_name, p.product_cost, p.product_price, p.product_id, p.group_item_id, p.price_master_id); //edit by xiangwang0413w 2014/07/20 增加站台價格
}
public int UpdatePIM(ProductItemMap p)
{
p.Replace4MySQL();
tempStr = string.Format("update product_item_map set product_name='{1}',product_price={2} where channel_detail_id = '{0}' ", p.channel_detail_id, p.product_name, p.product_price);
return _accessMySql.execCommand(tempStr);
}
//public int Save(ProductCompare p)
//{
// tempStr = string.Format("insert into product_item_map (`channel_id`, `channel_detail_id`, `item_id`, `product_name`, `product_cost`, `product_price`) values ({0},'{1}',{2},'{3}',{4},{5});", p.channel_id, p.channel_detail_id, p.item_id, p.product_name, p.product_cost, p.product_price);
// return _accessMySql.execCommand(tempStr);
//}
/// <summary>
/// 保存商品對照(單一)
/// </summary>
/// <param name="p">一條商品信息</param>
/// <returns></returns>
public int Save(ProductItemMap p)
{
p.Replace4MySQL();
tempStr = string.Format("insert into product_item_map (`channel_id`, `channel_detail_id`, `item_id`, `product_name`, `product_cost`, `product_price`,`product_id`,`price_master_id`) values ({0},'{1}',{2},'{3}',{4},{5},{6},{7})", p.channel_id, p.channel_detail_id, p.item_id, p.product_name, p.product_cost, p.product_price, p.product_id, p.price_master_id);
return _accessMySql.execCommand(tempStr);
}
