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