/// <summary> /// 添加套餐站点可用数量表 /// </summary> /// <param name="model"></param> public void Add(Model.orders model) { if (model == null) { return; } var dic = this.GetCallIndexNumMap(model); if (dic.Count == 0) { return; } var bi = new Model.buyersitebase() { user_id = model.user_id, order_no = model.order_no, add_time = DateTime.Now, stat = 1 }; var map = dic.Select(x => new Model.buyersiteext() { call_index = x.Key, subdomain_num = x.Value, subdomain_applied = 0 }).ToList(); new BLL.buyersite().AddList(bi, map); }
/// <summary> /// 批量新增 /// </summary> /// <param name="modelbase"></param> /// <param name="datas"></param> public void AddList(Model.buyersitebase modelbase, List <Model.buyersiteext> datas) { string aSql = @"IF EXISTS(SELECT TOP 1 id FROM " + databaseprefix + @"buyersite WHERE order_no=@order_no) BEGIN SELECT 0; END ELSE BEGIN BEGIN TRANSACTION; _HOLDPLACE_ COMMIT TRANSACTION; SELECT 1; END"; List <SqlParameter> sp = new List <SqlParameter>(); List <string> sql = new List <string>(); for (int i = 0; i < datas.Count; i++) { string k = i.ToString(); sql.Add(@"INSERT INTO [" + databaseprefix + @"buyersite] ( [order_no],[user_id],[call_index], [subdomain_num], [subdomain_applied], [add_time],[stat] ) VALUES ( @order_no, @user_id, @call_index{0}, @subdomain_num{0}, @subdomain_applied{0}, @add_time, @stat );".Replace("{0}", k)); sp.Add(new SqlParameter("@call_index" + k, datas[i].call_index)); sp.Add(new SqlParameter("@subdomain_num" + k, datas[i].subdomain_num)); sp.Add(new SqlParameter("@subdomain_applied" + k, datas[i].subdomain_applied)); } sp.Add(new SqlParameter("@order_no", modelbase.order_no)); sp.Add(new SqlParameter("@user_id", modelbase.user_id)); sp.Add(new SqlParameter("@add_time", modelbase.add_time)); sp.Add(new SqlParameter("@stat", modelbase.stat)); aSql = aSql.Replace("_HOLDPLACE_", string.Join("\r\n", sql)); object obj = DbHelperSQL.GetSingle(aSql, sp.ToArray()); }
/// <summary> /// 批量新增 /// </summary> /// <param name="modelbase"></param> /// <param name="datas"></param> public void AddList(Model.buyersitebase modelbase, List <Model.buyersiteext> datas) { dal.AddList(modelbase, datas); }