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