/// <summary> /// 添加订单详细信息 /// </summary> /// <param name="name"></param> /// <param name="goods"></param> /// <param name="gcnt"></param> /// <returns></returns> public static bool AddOrderDetail(string name, List <Goods> goods, List <int> gcnt) { try { string sql = "select orderID from tb_order where customerName=?name order by orderDate limit 0,1;"; MySqlParameter para = new MySqlParameter("?name", name); string id = DAL_MysqlHelper.ExecuteDataSet(sql, para).Tables[0].Rows[0][0].ToString(); List <string> sqls = new List <string>(); List <MySqlParameter[]> paras = new List <MySqlParameter[]>(); for (int i = 0; i < goods.Count; i++) { var _goods = goods.ElementAt(i); string _sql = "insert into tb_orderdetail values(?orderID,?goodsID,?count);"; MySqlParameter[] _para = { new MySqlParameter("?orderID", id), new MySqlParameter("?goodsID", _goods.Id), new MySqlParameter("?count", gcnt.ElementAt(i)) }; sqls.Add(_sql); paras.Add(_para); } bool ret = DAL_MysqlHelper.ExecuteNoQueryTran(sqls, paras); return(ret); } catch (Exception e) { throw e; } }
/// <summary> /// 一次删除多个商品,中途失败自动回滚(删除大量商品的情况,多次调用DeleteGood需要多次连接数据库) /// </summary> /// <param name="ids"></param> /// <returns></returns> public static bool DeleteGoods(List <string> ids) { try { List <String> sqls = new List <string>(); List <MySqlParameter[]> paras = new List <MySqlParameter[]>(); foreach (string id in ids) { string sql = "delete from tb_goods where goodsID=?id;"; MySqlParameter[] para = { new MySqlParameter("?id", id) }; sqls.Add(sql); paras.Add(para); } bool ret = DAL_MysqlHelper.ExecuteNoQueryTran(sqls, paras); return(ret); } catch (Exception e) { throw e; } }