/// <summary>
/// 增加，返回记录ID
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Model.buyersite model)
{
string sql = @" IF EXISTS(SELECT TOP 1 id FROM dt_buyersite WHERE order_no=@order_no) BEGIN
SELECT 0;
END ELSE BEGIN
INSERT INTO [dt_buyersite] (
[order_no],[user_id],[call_index],[subdomain_num],[subdomain_applied],[add_time],[stat]
) VALUES (
@order_no, @user_id, @call_index, @subdomain_num, @subdomain_applied, @add_time, @stat
);
SELECT SCOPE_IDENTITY();
END ".Replace("dt_", databaseprefix);
List <SqlParameter> sp = new List <SqlParameter>();
sp.Add(new SqlParameter("@order_no", model.order_no));
sp.Add(new SqlParameter("@user_id", model.user_id));
sp.Add(new SqlParameter("@call_index", model.call_index));
sp.Add(new SqlParameter("@subdomain_num", model.subdomain_num));
sp.Add(new SqlParameter("@subdomain_applied", model.subdomain_applied));
sp.Add(new SqlParameter("@add_time", model.add_time));
sp.Add(new SqlParameter("@stat", model.stat));
object obj = DbHelperSQL.GetSingle(sql, sp.ToArray());
return(obj == null ? 0 : Convert.ToInt32(obj));
}
/// <summary>
/// 增加，返回记录ID
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Model.buyersite model)
{
return(dal.Add(model));
}
