/// <summary>
/// 添加到购物车 单个产品
/// </summary>
/// <param name="pUserID">用户ID</param>
/// <param name="pID">产品ID</param>
/// <returns></returns>
public static string Add(int pUserID, int pID, byte pType, int pMaxN)
{
string sMsg = string.Empty;
string sSql = "select FK_All,InfoType from User_Fav where FK_User="******"商品收藏最多 " + pMaxN + " 个";
return(sMsg);
}
foreach (DataRow drw in dt.Rows)
{
if (int.Parse(drw["FK_All"].ToString()) == pID && byte.Parse(drw["InfoType"].ToString()) == pType)
{
return(sMsg);
}
}
User_FavM mod = new User_FavM
{
FK_User = pUserID,
FK_All = pID,
InfoType = pType,
};
Add(mod);
return(sMsg);
}
//列表
//public static Paging List(int pUserId)
//{
// string sOrder = " order by a.AddDate desc";
// string sWhere = " where a.FK_User="******"select count(0) from User_Fav a" + sWhere;
// pv.SQLRead = "select FavSN from User_Fav a" + sWhere + sOrder;
// pv.SQL = "select FavSN,FK_All,FK_User,ProName,Price,PicS,Item,a.AddDate from User_Fav a left join Pro_Info b on a.FK_All=b.ProSN where FavSN in({0})" + sOrder;
// Paging pg = new Paging(pv, new PagingUrlVar(10));
// pg.load();
// return pg;
//}
//列表
//public static DataTable List(int pUserID)
//{
// string sSQL = "select FavSN,FK_All,FK_User,ProName,Price,PicS,Item from User_Fav left join Pro_Info on User_Fav.FK_All=Pro_Info.ProSN where FK_User="******" order by AddDate desc";
// return DbHelp.GetDataTable(sSQL);
//}
#endregion
#region 添加
public static bool Add(User_FavM pMod)
{
string sSQL = "insert into User_Fav(FK_All,FK_User,InfoType) values(@FK_All,@FK_User,@InfoType)";
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@FK_All", pMod.FK_All),
DbHelp.Def.AddParam("@FK_User", pMod.FK_User),
DbHelp.Def.AddParam("@InfoType", pMod.InfoType),
};
return(DbHelp.Update(sSQL, dp) > 0);
}
