/// <summary> /// "select CarID,ItemID,UserID,IsPay,Visible,AddDate,IID,ProductID,BrandID,Name,AgoraPrice,MemberPrice,VipPrice,SeckillPrice,Area,Details,ViewTimes,BuyTimes,IsSecondKill,LimitTime,Count from MyCar,Items where UserID=" + intUID + " and IID=ItemID and Visible='true'" /// </summary> /// <param name="UserID"></param> /// <returns></returns> public static List<string> getUnPayAndPayedInfo(int UserID) { List<string> list = new List<string>(); DataSet ds = new BLL.ShopingCar().GetUnPayAndPayed(UserID); foreach (DataRow dr in ds.Tables[0].Rows) { //"Count from MyCar,Items where UserID=" + intUID + " and IID=ItemID and Visible='true' " list.Add(dr[0].ToString()); //CarID list.Add(dr[1].ToString());//ItemID list.Add(dr[2].ToString());//UserID list.Add(dr[3].ToString()); //IsPay list.Add(dr[4].ToString()); //Visible list.Add(dr[5].ToString());//AddDate //list.Add(dr[6].ToString());//IID list.Add(dr[7].ToString());// ProductID list.Add(dr[8].ToString());// BrandID list.Add(dr[9].ToString());// Name, list.Add(dr[10].ToString());//AgoraPrice, list.Add(dr[11].ToString());//MemberPrice, list.Add(dr[12].ToString());//VipPrice, list.Add(dr[13].ToString());//SeckillPrice, list.Add(dr[14].ToString());//Area, list.Add(dr[15].ToString());//Details, list.Add(dr[16].ToString());//ViewTimes, list.Add(dr[17].ToString());//BuyTimes, list.Add(dr[18].ToString());//IsSecondKill, list.Add(dr[19].ToString());//LimitTime list.Add(dr[20].ToString());//Count } return list; }
/// <summary> /// "select CarID,ItemID,UserID,IsPay,Visible,AddDate,IID,ProductID,BrandID,Name,AgoraPrice,MemberPrice,VipPrice,SeckillPrice,Area,Details,ViewTimes,BuyTimes,IsSecondKill,LimitTime,Count from MyCar,Items where UserID=" + intUID + " and IID=ItemID and Visible='true'" /// </summary> /// <param name="UserID"></param> /// <returns></returns> public static List <string> getUnPayAndPayedInfo(int UserID) { List <string> list = new List <string>(); DataSet ds = new BLL.ShopingCar().GetUnPayAndPayed(UserID); foreach (DataRow dr in ds.Tables[0].Rows) { //"Count from MyCar,Items where UserID=" + intUID + " and IID=ItemID and Visible='true' " list.Add(dr[0].ToString()); //CarID list.Add(dr[1].ToString()); //ItemID list.Add(dr[2].ToString()); //UserID list.Add(dr[3].ToString()); //IsPay list.Add(dr[4].ToString()); //Visible list.Add(dr[5].ToString()); //AddDate //list.Add(dr[6].ToString());//IID list.Add(dr[7].ToString()); // ProductID list.Add(dr[8].ToString()); // BrandID list.Add(dr[9].ToString()); // Name, list.Add(dr[10].ToString()); //AgoraPrice, list.Add(dr[11].ToString()); //MemberPrice, list.Add(dr[12].ToString()); //VipPrice, list.Add(dr[13].ToString()); //SeckillPrice, list.Add(dr[14].ToString()); //Area, list.Add(dr[15].ToString()); //Details, list.Add(dr[16].ToString()); //ViewTimes, list.Add(dr[17].ToString()); //BuyTimes, list.Add(dr[18].ToString()); //IsSecondKill, list.Add(dr[19].ToString()); //LimitTime list.Add(dr[20].ToString()); //Count } return(list); }
public static List<string> getCoutForNoPay(int intUserID) { List<string> list = new List<string>(); BLL.ShopingCar car=new BLL.ShopingCar(); int count=car.GetNoPayCounts(intUserID)<1?0:car.GetNoPayCounts(intUserID); list.Add(count.ToString()); return list; }
public static List <string> getCountForAll(int intUserID) { List <string> list = new List <string>(); BLL.ShopingCar car = new BLL.ShopingCar(); int count = car.GetPayedCounts(intUserID) < 1 ? 0 : car.GetNoPayCounts(intUserID); list.Add(count.ToString()); return(list); }