/// <summary> /// 更新商品(会存在新增和更新二种状态的数据,通过ID来区分) /// </summary> /// <returns>The bill goods.</returns> /// <param name="goods">Goods.</param> public int UpdateBillGoods(string enterpriseId, BillGoods goods) { List <string> sqlList = new List <string>(); // 没有对应商品ID且输入的商品名称不为空时,插入商品表 if (goods.GoodsId == "" && goods.GoodsName != "") { goods.GoodsId = TimeParser.GetTimeRandom(); sqlList.Add(GenerateSql.ReturnAddGoodsSql(goods.GoodsId, goods.GoodsName, enterpriseId)); } if (goods.IsAdd) { sqlList.Add(GenerateSql.ReturnInsertBillGoodsSql(goods)); } else { sqlList.Add(GenerateSql.ReturnUpdateBillGoodsSql(goods)); } return(DbHelper.ExecuteSqlTran(sqlList)); }
private List <string> UpdateBillGoods(BillGoods goods, Passport passport) { List <string> sqlList = new List <string>(); // 没有对应商品ID且输入的商品名称不为空时,插入商品表 //if (goods.GoodsId == "" && goods.GoodsName != "") //{ // goods.GoodsId = TimeParser.GetTimeRandom(); // sqlList.Add(GenerateSql.ReturnAddGoodsSql(goods.GoodsId, goods.GoodsName)); //} //if (goods.IsNewGoods && goods.GoodsName != "") //{ // sqlList.Add(GenerateSql.ReturnAddGoodsSql(goods.GoodsId, goods.GoodsName)); //} if (goods.IsAdd) { sqlList.Add(GenerateSql.ReturnInsertBillGoodsSql(goods)); } else { sqlList.Add(GenerateSql.ReturnUpdateBillGoodsSql(goods)); } return(sqlList); }