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