public Hao123Api(string apiUrl)
{
urlset data = new urlset().GetRemoteData(apiUrl);
if (data.url.Count > 0)
{
TuanGouList = new List <TuanGou>();
foreach (url m in data.url)
{
TuanGou tuanGou = new TuanGou();
tuanGou.CityID = Utils.CityToID(m.data.display.city);
tuanGou.Title = m.data.display.title;
tuanGou.ImageUrl = m.data.display.image;
tuanGou.ImageThumbUrl = m.data.display.image;
tuanGou.BeginTime = TryConvert.ToDateTime(m.data.display.startTime);
tuanGou.EndTime = TryConvert.ToDateTime(m.data.display.endTime);
tuanGou.MarketPrice = m.data.display.value;
tuanGou.TuanPrice = m.data.display.price;
tuanGou.Rebate = m.data.display.rebate;
tuanGou.BuyCount = m.data.display.bought;
tuanGou.TuanUrl = m.loc;
tuanGou.AddDate = DateTime.Now;
TuanGouList.Add(tuanGou);
}
}
}
public Tuan800Api(string apiUrl)
{
urlset data = new urlset().GetRemoteData(apiUrl);
if (data.url.Count > 0)
{
TuanGouList = new List <TuanGou>();
foreach (url m in data.url)
{
TuanGou tuanGou = new TuanGou();
tuanGou.CityID = Utils.CityToID(m.data.display.city);
tuanGou.Title = m.data.display.title;
tuanGou.ImageUrl = m.data.display.image;
tuanGou.ImageThumbUrl = m.data.display.image;
tuanGou.BeginTime = TryConvert.ToDateTime(m.data.display.startTime);
tuanGou.EndTime = TryConvert.ToDateTime(m.data.display.endTime);
tuanGou.MarketPrice = m.data.display.value;
tuanGou.TuanPrice = m.data.display.price;
tuanGou.Rebate = (float)Math.Round((tuanGou.TuanPrice / tuanGou.MarketPrice) * 10, 2);
tuanGou.TotalCount = m.data.display.maxQuota;
tuanGou.BuyCount = m.data.display.bought;
tuanGou.TuanUrl = m.loc;
tuanGou.Description = m.data.display.tip;
tuanGou.TuanDetail = m.data.display.detail;
tuanGou.MerchantName = m.data.shops.shop.name;
tuanGou.MerchantPhone = m.data.shops.shop.tel;
tuanGou.AddDate = DateTime.Now;
TuanGouList.Add(tuanGou);
}
}
}
/// <summary>
/// 采集团购商品
/// </summary>
public override int AddOrUpdate(TuanGou model)
{
SqlParameter[] parms =
{
SqlHelper.CreateParameter <int>("@CategoryID", model.CategoryID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@CityID", model.CityID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@SiteID", model.SiteID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <string>("@Title", model.Title, SqlDbType.VarChar, 200),
SqlHelper.CreateParameter <string>("@Description", model.Description, SqlDbType.VarChar, 500),
SqlHelper.CreateParameter <string>("@TuanDetail", model.TuanDetail, SqlDbType.Text, 5000),
SqlHelper.CreateParameter <string>("@TuanUrl", model.TuanUrl, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <string>("@ImageUrl", model.ImageUrl, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <string>("@ImageThumbUrl", model.ImageThumbUrl, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <decimal>("@MarketPrice", model.MarketPrice, SqlDbType.Money, 8),
SqlHelper.CreateParameter <decimal>("@TuanPrice", model.TuanPrice, SqlDbType.Money, 8),
SqlHelper.CreateParameter <float>("@Rebate", model.Rebate, SqlDbType.Float, 8),
SqlHelper.CreateParameter <string>("@MerchantName", model.MerchantName, SqlDbType.VarChar, 50),
SqlHelper.CreateParameter <string>("@MerchantPhone", model.MerchantPhone, SqlDbType.VarChar, 20),
SqlHelper.CreateParameter <string>("@MerchantAddress", model.MerchantAddress, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <double>("@Longitude", model.Longitude, SqlDbType.Float, 8),
SqlHelper.CreateParameter <double>("@Latitude", model.Latitude, SqlDbType.Float, 8),
SqlHelper.CreateParameter <int>("@TotalCount", model.TotalCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@BuyCount", model.BuyCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <DateTime>("@BeginTime", model.BeginTime, SqlDbType.DateTime, 8),
SqlHelper.CreateParameter <DateTime>("@EndTime", model.EndTime, SqlDbType.DateTime, 8)
};
return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "Proc_TuanGou_AddOrUpdate", parms));
}
public LashouOldApi(string apiUrl)
{
urlset data = new urlset().GetRemoteData(apiUrl);
if (data.goods.Count > 0)
{
TuanGouList = new List <TuanGou>();
foreach (goods m in data.goods)
{
TuanGou tuanGou = new TuanGou();
tuanGou.CityID = Utils.CityToID(data.cityname);
tuanGou.Title = m.goods_title;
tuanGou.ImageUrl = m.goods_image_url;
tuanGou.ImageThumbUrl = m.goods_image_url;
tuanGou.BeginTime = TryConvert.ToDateTime(m.goods_start_time);
tuanGou.EndTime = TryConvert.ToDateTime(m.goods_deadline);
tuanGou.MarketPrice = m.goods_value;
tuanGou.TuanPrice = m.goods_price;
tuanGou.Rebate = m.goods_rebate;
tuanGou.BuyCount = m.goods_bought;
tuanGou.TuanUrl = m.goods_site_url;
tuanGou.Description = m.goods_rules;
tuanGou.TuanDetail = m.goods_description;
tuanGou.AddDate = DateTime.Now;
TuanGouList.Add(tuanGou);
}
}
}
public SohuApi(string apiUrl)
{
ActivitySet data = new ActivitySet().GetRemoteData(apiUrl);
if (data.Activity.Count > 0)
{
TuanGouList = new List <TuanGou>();
foreach (Activity m in data.Activity)
{
TuanGou tuanGou = new TuanGou();
tuanGou.CityID = Utils.CityToID(m.CityName);
tuanGou.Title = m.Title;
tuanGou.ImageUrl = m.ImageUrl;
tuanGou.ImageThumbUrl = m.ImageUrl;
tuanGou.BeginTime = DateTime.ParseExact(m.StartTime, "yyyyMMddhhmmss", System.Globalization.CultureInfo.CurrentCulture);
tuanGou.EndTime = DateTime.ParseExact(m.EndTime, "yyyyMMddhhmmss", System.Globalization.CultureInfo.CurrentCulture);
tuanGou.MarketPrice = m.Value;
tuanGou.TuanPrice = m.Price;
tuanGou.Rebate = m.ReBate;
tuanGou.TotalCount = m.Quantity;
tuanGou.BuyCount = m.Bought;
tuanGou.TuanUrl = m.Url;
tuanGou.Description = m.Description;
tuanGou.TuanDetail = m.Goods.Description;
tuanGou.MerchantName = m.Goods.ProviderName;
tuanGou.MerchantPhone = m.Goods.Contact;
tuanGou.MerchantAddress = m.Goods.Address;
tuanGou.AddDate = DateTime.Now;
TuanGouList.Add(tuanGou);
}
}
}
public FanweApi(string apiUrl)
{
response data = new response().GetRemoteData(apiUrl);
if (data.goods.Count > 0)
{
TuanGouList = new List <TuanGou>();
foreach (goods m in data.goods)
{
TuanGou tuanGou = new TuanGou();
tuanGou.CityID = Utils.CityToID(m.cityname);
tuanGou.Title = m.title;
tuanGou.ImageUrl = m.bigimg;
tuanGou.ImageThumbUrl = m.smallimg;
tuanGou.BeginTime = DateTime.Parse(m.begintime);
tuanGou.EndTime = DateTime.Parse(m.endtime);
tuanGou.MarketPrice = m.marketprice;
tuanGou.TuanPrice = m.groupprice;
tuanGou.Rebate = (float)Math.Round((tuanGou.TuanPrice / tuanGou.MarketPrice) * 10, 2);
tuanGou.BuyCount = m.buycount;
tuanGou.TuanUrl = m.url;
tuanGou.TuanDetail = m.brief;
tuanGou.MerchantName = m.suppliers;
tuanGou.AddDate = DateTime.Now;
TuanGouList.Add(tuanGou);
}
}
}
/// <summary>
/// 获取一条实体数据
/// </summary>
public override TuanGou GetModel(int tuanID)
{
string strSql = "SELECT TuanID,CategoryID,CityID,UserID,SiteID,Title,Description,TuanDetail,TuanUrl,ImageThumbUrl,ImageUrl,MarketPrice,TuanPrice,Rebate,MerchantName,MerchantPhone,MerchantAddress,Longitude,Latitude,TotalCount,BuyCount,ClickCount,CommentCount,PointCount,BeginTime,EndTime,Statu,Rank,AddDate,OrderID FROM TN_TuanGou WHERE TuanID=@TuanID";
SqlParameter[] parms =
{
SqlHelper.CreateParameter <int>("@TuanID", tuanID, SqlDbType.Int, 4)
};
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, strSql, parms))
{
if (dr.Read())
{
TuanGou model = new TuanGou();
model.TuanID = SqlHelper.GetInt(dr["TuanID"]);
model.CategoryID = SqlHelper.GetInt(dr["CategoryID"]);
model.CityID = SqlHelper.GetInt(dr["CityID"]);
model.UserID = SqlHelper.GetInt(dr["UserID"]);
model.SiteID = SqlHelper.GetInt(dr["SiteID"]);
model.Title = SqlHelper.GetString(dr["Title"]);
model.Description = SqlHelper.GetString(dr["Description"]);
model.TuanDetail = SqlHelper.GetString(dr["TuanDetail"]);
model.TuanUrl = SqlHelper.GetString(dr["TuanUrl"]);
model.ImageThumbUrl = SqlHelper.GetString(dr["ImageThumbUrl"]);
model.ImageUrl = SqlHelper.GetString(dr["ImageUrl"]);
model.MarketPrice = SqlHelper.GetDecimal(dr["MarketPrice"]);
model.TuanPrice = SqlHelper.GetDecimal(dr["TuanPrice"]);
model.Rebate = SqlHelper.GetFloat(dr["Rebate"]);
model.MerchantName = SqlHelper.GetString(dr["MerchantName"]);
model.MerchantPhone = SqlHelper.GetString(dr["MerchantPhone"]);
model.MerchantAddress = SqlHelper.GetString(dr["MerchantAddress"]);
model.Longitude = SqlHelper.GetDouble(dr["Longitude"]);
model.Latitude = SqlHelper.GetDouble(dr["Latitude"]);
model.TotalCount = SqlHelper.GetInt(dr["TotalCount"]);
model.BuyCount = SqlHelper.GetInt(dr["BuyCount"]);
model.ClickCount = SqlHelper.GetInt(dr["ClickCount"]);
model.CommentCount = SqlHelper.GetInt(dr["CommentCount"]);
model.PointCount = SqlHelper.GetInt(dr["PointCount"]);
model.BeginTime = SqlHelper.GetDateTime(dr["BeginTime"]);
model.EndTime = SqlHelper.GetDateTime(dr["EndTime"]);
model.Statu = SqlHelper.GetByte(dr["Statu"]);
model.Rank = SqlHelper.GetByte(dr["Rank"]);
model.AddDate = SqlHelper.GetDateTime(dr["AddDate"]);
model.OrderID = SqlHelper.GetInt(dr["OrderID"]);
return(model);
}
return(null);
}
}
private void AddTuanGou()
{
TuanGou tuanGou = new TuanGou();
tuanGou.Title = Utils.GetFormString("txt_Title");
tuanGou.CityID = Utils.GetFormInt("ddl_City");
tuanGou.SiteID = Utils.GetFormInt("hid_SiteID");
tuanGou.CategoryID = Utils.GetFormInt("ddl_Category");
tuanGou.Description = Utils.GetFormString("txt_Description"); //如果有包含html标记需要htmldecode
tuanGou.MarketPrice = TryConvert.ToDecimal(Request.Form["txt_MarketPrice"]);
tuanGou.TuanPrice = TryConvert.ToDecimal(Request.Form["txt_TuanPrice"]);
tuanGou.Rebate = TryConvert.ToSingle(Request.Form["txt_Rebate"]);
tuanGou.TotalCount = Utils.GetFormInt("txt_TotalCount");
tuanGou.BuyCount = Utils.GetFormInt("txt_BuyCount");
tuanGou.ClickCount = Utils.GetFormInt("txt_ClickCount");
tuanGou.CommentCount = Utils.GetFormInt("txt_CommentCount");
tuanGou.PointCount = Utils.GetFormInt("txt_PointCount");
tuanGou.BeginTime = Convert.ToDateTime(Request.Form["txt_BeginTime"]);
tuanGou.EndTime = Convert.ToDateTime(Request.Form["txt_EndTime"]);
tuanGou.TuanUrl = Utils.GetFormString("txt_TuanUrl");
tuanGou.ImageThumbUrl = Utils.GetFormString("txt_ImageThumbUrl");
tuanGou.ImageUrl = Utils.GetFormString("txt_ImageUrl");
tuanGou.MerchantName = Utils.GetFormString("txt_MerchantName");
tuanGou.MerchantPhone = Utils.GetFormString("txt_MerchantPhone");
tuanGou.MerchantAddress = Utils.GetFormString("txt_MerchantAddress");
tuanGou.Longitude = TryConvert.ToDouble(Request.Form["txt_Longitude"]);
tuanGou.Latitude = TryConvert.ToDouble(Request.Form["txt_Latitude"]);
tuanGou.Rank = TryConvert.ToByte(Request.Form["txt_Rank"]);
tuanGou.OrderID = Utils.GetFormInt("txt_OrderID");
tuanGou.Statu = TryConvert.ToByte(Request.Form["rdo_Statu"]);
tuanGou.AddDate = DateTime.Now;
int result;
tuanID = Utils.GetQueryInt("ID");
if (tuanID < 1)
{
tuanGou.UserID = loginUser.UserID;
result = TuanGouDAO.Instance.Add(tuanGou);
}
else
{
tuanGou.TuanID = tuanID;
result = TuanGouDAO.Instance.Update(tuanGou);
}
Ajax.Message(result);
}
protected void Page_Load(object sender, EventArgs e)
{
Ajax.RegMethod(AddTuanGou);
cityList = CityDAO.Instance.GetCityList();
DataTable category = CategoryDAO.Instance.GetDataList();
DropDownTree.BindToDropDownList(ddl_Category, category, "0");
tuanID = Utils.GetQueryInt("ID");
if (tuanID > 0)
{
TuanGou tuanGou = TuanGouDAO.Instance.GetModel(tuanID);
if (tuanGou != null)
{
txt_Title.Value = tuanGou.Title;
cityID = tuanGou.CityID;
hid_SiteID.Value = tuanGou.SiteID.ToString();
ddl_Category.Value = tuanGou.CategoryID.ToString();
txt_Description.Value = tuanGou.Description;
txt_MarketPrice.Value = tuanGou.MarketPrice.ToString();
txt_TuanPrice.Value = tuanGou.TuanPrice.ToString();
txt_Rebate.Value = tuanGou.Rebate.ToString();
txt_TotalCount.Value = tuanGou.TotalCount.ToString();
txt_BuyCount.Value = tuanGou.BuyCount.ToString();
txt_ClickCount.Value = tuanGou.ClickCount.ToString();
txt_CommentCount.Value = tuanGou.CommentCount.ToString();
txt_PointCount.Value = tuanGou.PointCount.ToString();
txt_BeginTime.Value = tuanGou.BeginTime.ToString();
txt_EndTime.Value = tuanGou.EndTime.ToString();
txt_TuanUrl.Value = tuanGou.TuanUrl;
txt_ImageThumbUrl.Value = tuanGou.ImageThumbUrl;
txt_ImageUrl.Value = tuanGou.ImageUrl;
txt_MerchantName.Value = tuanGou.MerchantName;
txt_MerchantAddress.Value = tuanGou.MerchantAddress;
txt_MerchantPhone.Value = tuanGou.MerchantPhone;
txt_Longitude.Value = tuanGou.Longitude.ToString();
txt_Latitude.Value = tuanGou.Latitude.ToString();
txt_Rank.Value = tuanGou.Rank.ToString();
hid_Statu.Value = tuanGou.Statu.ToString();
txt_OrderID.Value = tuanGou.OrderID.ToString();
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public override int Update(TuanGou model)
{
string strSql = @"UPDATE TN_TuanGou SET CategoryID=@CategoryID,CityID=@CityID,UserID=@UserID,SiteID=@SiteID,Title=@Title,Description=@Description,TuanDetail=@TuanDetail,TuanUrl=@TuanUrl,ImageThumbUrl=@ImageThumbUrl,ImageUrl=@ImageUrl,MarketPrice=@MarketPrice,TuanPrice=@TuanPrice,Rebate=@Rebate,MerchantName=@MerchantName,MerchantPhone=@MerchantPhone,MerchantAddress=@MerchantAddress,Longitude=@Longitude,Latitude=@Latitude,TotalCount=@TotalCount,BuyCount=@BuyCount,ClickCount=@ClickCount,CommentCount=@CommentCount,PointCount=@PointCount,BeginTime=@BeginTime,EndTime=@EndTime,Statu=@Statu,Rank=@Rank,AddDate=@AddDate,OrderID=@OrderID
WHERE TuanID=@TuanID";
SqlParameter[] parms =
{
SqlHelper.CreateParameter <int>("@TuanID", model.TuanID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@CategoryID", model.CategoryID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@CityID", model.CityID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@UserID", model.UserID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@SiteID", model.SiteID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <string>("@Title", model.Title, SqlDbType.VarChar, 400),
SqlHelper.CreateParameter <string>("@Description", model.Description, SqlDbType.VarChar, 1000),
SqlHelper.CreateParameter <string>("@TuanDetail", model.TuanDetail, SqlDbType.Text, 5000),
SqlHelper.CreateParameter <string>("@TuanUrl", model.TuanUrl, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <string>("@ImageThumbUrl", model.ImageThumbUrl, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <string>("@ImageUrl", model.ImageUrl, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <decimal>("@MarketPrice", model.MarketPrice, SqlDbType.VarChar, 8),
SqlHelper.CreateParameter <decimal>("@TuanPrice", model.TuanPrice, SqlDbType.VarChar, 8),
SqlHelper.CreateParameter <float>("@Rebate", model.Rebate, SqlDbType.Float, 8),
SqlHelper.CreateParameter <string>("@MerchantName", model.MerchantName, SqlDbType.VarChar, 100),
SqlHelper.CreateParameter <string>("@MerchantPhone", model.MerchantPhone, SqlDbType.VarChar, 20),
SqlHelper.CreateParameter <string>("@MerchantAddress", model.MerchantAddress, SqlDbType.VarChar, 510),
SqlHelper.CreateParameter <double>("@Longitude", model.Longitude, SqlDbType.Decimal, 8),
SqlHelper.CreateParameter <double>("@Latitude", model.Latitude, SqlDbType.Decimal, 8),
SqlHelper.CreateParameter <int>("@TotalCount", model.TotalCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@BuyCount", model.BuyCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@ClickCount", model.ClickCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@CommentCount", model.CommentCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@PointCount", model.PointCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <DateTime>("@BeginTime", model.BeginTime, SqlDbType.DateTime, 8),
SqlHelper.CreateParameter <DateTime>("@EndTime", model.EndTime, SqlDbType.DateTime, 8),
SqlHelper.CreateParameter <byte>("@Statu", model.Statu, SqlDbType.TinyInt, 1),
SqlHelper.CreateParameter <byte>("@Rank", model.Rank, SqlDbType.TinyInt, 1),
SqlHelper.CreateParameter <DateTime>("@AddDate", model.AddDate, SqlDbType.DateTime, 8),
SqlHelper.CreateParameter <int>("@OrderID", model.OrderID, SqlDbType.Int, 4)
};
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSql, parms));
}
/// <summary>
/// 新增一条数据
/// </summary>
public override int Add(TuanGou model)
{
string strSql = @"INSERT INTO TN_TuanGou(TuanID,CategoryID,CityID,UserID,SiteID,Title,Description,TuanDetail,TuanUrl,ImageThumbUrl,ImageUrl,MarketPrice,TuanPrice,Rebate,MerchantName,MerchantPhone,MerchantAddress,Longitude,Latitude,TotalCount,BuyCount,ClickCount,CommentCount,PointCount,BeginTime,EndTime,Statu,Rank,AddDate,OrderID)
VALUES(@TuanID,@CategoryID,@CityID,@UserID,@SiteID,@Title,@Description,@TuanDetail,@TuanUrl,@ImageThumbUrl,@ImageUrl,@MarketPrice,@TuanPrice,@Rebate,@MerchantName,@MerchantPhone,@MerchantAddress,@Longitude,@Latitude,@TotalCount,@BuyCount,@ClickCount,@CommentCount,@PointCount,@BeginTime,@EndTime,@Statu,@Rank,@AddDate,@OrderID)";
SqlParameter[] parms =
{
SqlHelper.CreateParameter <int>("@CategoryID", model.CategoryID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@CityID", model.CityID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@UserID", model.UserID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@SiteID", model.SiteID, SqlDbType.Int, 4),
SqlHelper.CreateParameter <string>("@Title", model.Title, SqlDbType.VarChar, 200),
SqlHelper.CreateParameter <string>("@Description", model.Description, SqlDbType.VarChar, 500),
SqlHelper.CreateParameter <string>("@TuanDetail", model.TuanDetail, SqlDbType.Text, 5000),
SqlHelper.CreateParameter <string>("@TuanUrl", model.TuanUrl, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <string>("@ImageUrl", model.ImageUrl, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <string>("@ImageThumbUrl", model.ImageThumbUrl, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <decimal>("@MarketPrice", model.MarketPrice, SqlDbType.Money, 8),
SqlHelper.CreateParameter <decimal>("@TuanPrice", model.TuanPrice, SqlDbType.Money, 8),
SqlHelper.CreateParameter <float>("@Rebate", model.Rebate, SqlDbType.Float, 8),
SqlHelper.CreateParameter <string>("@MerchantName", model.MerchantName, SqlDbType.VarChar, 50),
SqlHelper.CreateParameter <string>("@MerchantPhone", model.MerchantPhone, SqlDbType.VarChar, 20),
SqlHelper.CreateParameter <string>("@MerchantAddress", model.MerchantAddress, SqlDbType.VarChar, 255),
SqlHelper.CreateParameter <double>("@Longitude", model.Longitude, SqlDbType.Float, 8),
SqlHelper.CreateParameter <double>("@Latitude", model.Latitude, SqlDbType.Float, 8),
SqlHelper.CreateParameter <int>("@TotalCount", model.TotalCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@BuyCount", model.BuyCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@ClickCount", model.ClickCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@CommentCount", model.CommentCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <int>("@PointCount", model.PointCount, SqlDbType.Int, 4),
SqlHelper.CreateParameter <DateTime>("@BeginTime", model.BeginTime, SqlDbType.DateTime, 8),
SqlHelper.CreateParameter <DateTime>("@EndTime", model.EndTime, SqlDbType.DateTime, 8),
SqlHelper.CreateParameter <byte>("@Statu", model.Statu, SqlDbType.TinyInt, 1),
SqlHelper.CreateParameter <byte>("@Rank", model.Rank, SqlDbType.TinyInt, 1),
SqlHelper.CreateParameter <DateTime>("@AddDate", model.AddDate, SqlDbType.DateTime, 8),
SqlHelper.CreateParameter <int>("@OrderID", model.OrderID, SqlDbType.Int, 4)
};
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSql, parms));
}
/// <summary> /// 更新一条数据 /// </summary> public abstract int Update(TuanGou model);
/// <summary> /// 采集团购商品 /// </summary> public abstract int AddOrUpdate(TuanGou model);
/// <summary> /// 新增一条数据 /// </summary> public abstract int Add(TuanGou model);