public static List<Tag> GetHotTags()
{
List<Tag> tagList = new List<Tag>();
ISingleResult<getAllTagResult> result = dc.getAllTag();
//for (int i = 1; i <= num; i++)
foreach (getAllTagResult tagResult in result)
{
//getAllTagResult tagResult = new getAllTagResult();
Tag tag = new Tag();
tag.name = tagResult.id;
tag.popularity = tagResult.popularity.Value;
tagList.Add(tag);
}
return tagList;
}
//
public Commodity GetCommodityByID(Guid id)
{
Commodity commodity = new Commodity();
//List<Commodity> commodityList = new List<Commodity>();
ISingleResult<getCommodityByIDResult> result = dc.getCommodityByID(id);
foreach (getCommodityByIDResult singleCommodity in result)
{
commodity.description = singleCommodity.discription;
commodity.EndTime = singleCommodity.endtime.Value;
commodity.ID = singleCommodity.id;
commodity.ImageUrl = singleCommodity.picturepath;
commodity.kind = (CommodityKind)(singleCommodity.kind.Value);
commodity.Name = singleCommodity.name;
commodity.popularity = (int)singleCommodity.popularity;
commodity.Price = singleCommodity.price.Value;
commodity.StartTime = singleCommodity.starttime.Value;
List<Tag> TagList = new List<Tag>();
try
{
ISingleResult<getTagByCommodityResult> TagResult = dc.getTagByCommodity(singleCommodity.id);
foreach (getTagByCommodityResult Newtag in TagResult)
{
Tag tag = new Tag();
tag.name = Newtag.id;
tag.popularity = Newtag.popularity.Value;
TagList.Add(tag);
}
commodity.tagList = TagList;
}
catch (Exception e)
{
commodity = new Commodity();
commodity.Name = "";
}
commodity.UserName = singleCommodity.userfrom;
//commodityList.Add(commodity);
}
return commodity;
}
//获得用户发布的商品列表24 OK
public List<Commodity> GetUserPublishCommoditys(String UserName)
{
List<Commodity> commodityList = new List<Commodity>();
//数据访存器
DatabaseAccess.DataClasses1DataContext DBAccessor = new DataClasses1DataContext();
try
{
ISingleResult<getCommodityByUserResult> resultList = DBAccessor.getCommodityByUser(UserName);
foreach (getCommodityByUserResult result in resultList)
{
Commodity commodity = new Commodity();
commodity.ID = result.id;
commodity.Name = result.name;
commodity.UserName = result.userfrom;
commodity.StartTime = (DateTime)result.starttime; //等亮亮的返回参数
commodity.EndTime = (DateTime)result.endtime;
commodity.description = result.discription;
commodity.kind = (CommodityKind)((int)result.kind);
commodity.ImageUrl = result.picturepath;
commodity.Price = (double)result.price;
commodity.popularity = (int)result.popularity;
commodity.tagList = new List<Tag>();
//查找属于商品的Tag列表
ISingleResult<getTagByCommodityResult> TagList = DBAccessor.getTagByCommodity(result.id);
foreach (getTagByCommodityResult atag in TagList)
{
Tag tag = new Tag();
tag.name = atag.id;//id就是tag名数据库中做主码
tag.popularity = (int)atag.popularity;
commodity.tagList.Add(tag); //加入tag列表
}
commodityList.Add(commodity); //加入商品列表
}
}
catch (Exception e)
{
}
return commodityList;
}
//获得用户的收藏19 ok
public List<Commodity> GetUserCollectItems(String UserName)
{
List<Commodity> CommodityiList = new List<Commodity>();
//数据访存器
DatabaseAccess.DataClasses1DataContext DBAccessor = new DataClasses1DataContext();
try
{
ISingleResult<getCollectByUserResult> resultList = DBAccessor.getCollectByUser(UserName);
foreach (getCollectByUserResult result in resultList)
{
Commodity commodity = new Commodity();
commodity.ID = result.id;
commodity.Name = result.name;
commodity.UserName = result.userfrom;
commodity.description = result.discription;
commodity.StartTime = (DateTime)result.starttime;
commodity.EndTime = (DateTime)result.endtime;
commodity.kind = (CommodityKind)(int)result.kind;
commodity.Price = (double)result.price;
commodity.ImageUrl = result.picturepath;
commodity.popularity = (int)result.popularity;
commodity.tagList = new List<Tag>();
//下面获得商品的Tag列表
ISingleResult<getTagByCommodityResult> TagResultList = DBAccessor.getTagByCommodity(result.id);
foreach (getTagByCommodityResult Tagresult in TagResultList)
{
Tag tag = new Tag();
tag.name = Tagresult.id;
tag.popularity = (int)Tagresult.popularity;
commodity.tagList.Add(tag);
}
CommodityiList.Add(commodity);
}
}
catch(Exception e)
{
}
return CommodityiList;
}
//获得发向用户的订单8 ok
public List<Order> GetOreders(String UserID)
{
List<Order> OrderList = new List<Order>();
//数据访存器
DatabaseAccess.DataClasses1DataContext DBAccessor = new DataClasses1DataContext();
try
{
ISingleResult<getOrderByUsertoResult> resultList = DBAccessor.getOrderByUserto(UserID);
foreach (getOrderByUsertoResult result in resultList)
{
Order order = new Order();
order.ID = result.id;
order.userTo.UserName = result.userto;
//下面获得发订单的用户
order.userFrom.UserName = result.userfrom;
//发订单用户的信息
ISingleResult<getUserByUserNameResult> UserInfoList = DBAccessor.getUserByUserName(result.userfrom);
foreach (getUserByUserNameResult UserInfo in UserInfoList)
{
order.userFrom.NickName = UserInfo.nickname;
order.userFrom.Phone = UserInfo.phone;
order.userFrom.Address = UserInfo.address;
order.userFrom.Email = UserInfo.email;
order.userFrom.City = UserInfo.city;
order.userFrom.Portrait = UserInfo.portraitPath;
}
//查找次订单所对应的所有商品
ISingleResult<getCommodityByOrederResult> commmodityListresult = DBAccessor.getCommodityByOreder(result.id);
//获得订单所对应的商品列表
foreach (getCommodityByOrederResult commmodityResult in commmodityListresult)
{
Commodity commodity = new Commodity();
commodity.ID = commmodityResult.id;
commodity.Name = commmodityResult.name;
commodity.UserName = commmodityResult.userfrom;
commodity.kind = (CommodityKind)(int)commodity.kind;
commodity.StartTime = (DateTime)commmodityResult.starttime;
commodity.EndTime = (DateTime)commmodityResult.endtime;
commodity.description = commmodityResult.discription;
commodity.ImageUrl = commmodityResult.picturepath;
commodity.Price = (int)commmodityResult.price;
//获得商品的tag列表
ISingleResult<getTagByCommodityResult> tagResultList = DBAccessor.getTagByCommodity(commmodityResult.id);
foreach (getTagByCommodityResult tagResult in tagResultList)
{
Tag tag = new Tag();
tag.name = tagResult.id;
tag.popularity = (int)tagResult.popularity;
//加入商品的Tag列表
commodity.tagList.Add(tag);
}
//把商品加入订单的商品列表
order.commodityList.Add(commodity);
}
//订单加入订单列表
OrderList.Add(order);
}
}
catch (Exception e)
{
}
return OrderList;
}
//通过给出用户id的到这个用户的商品列表
public List<Commodity> GetOtherUserCommodity(string otherUserName)
{
List<Commodity> commodityList = new List<Commodity>();
ISingleResult<getCommodityByUserResult> result = dc.getCommodityByUser(otherUserName);
foreach (getCommodityByUserResult commodityByUserId in result)
{
Commodity userCommodity = new Commodity();
userCommodity.description = commodityByUserId.discription;
userCommodity.EndTime = commodityByUserId.endtime.Value;
userCommodity.ID = commodityByUserId.id;
userCommodity.ImageUrl = commodityByUserId.picturepath;
userCommodity.kind = (CommodityKind)(commodityByUserId.kind.Value);
userCommodity.Name = commodityByUserId.name;
userCommodity.popularity = commodityByUserId.popularity.Value;
userCommodity.Price = commodityByUserId.price.Value;
userCommodity.StartTime = commodityByUserId.starttime.Value;
///////
List<Tag> tagList = new List<Tag>();
ISingleResult<getTagByCommodityResult> result2 = dc.getTagByCommodity(userCommodity.ID);
foreach (getTagByCommodityResult tagResult in result2)
{
Tag tag = new Tag();
tag.name = tagResult.id;
tag.popularity = tagResult.popularity.Value;
tagList.Add(tag);
}
userCommodity.tagList = tagList;
userCommodity.UserName = commodityByUserId.userfrom;
commodityList.Add(userCommodity);
}
return commodityList;
}
//搜索推荐商品 参数为查询字符串和种类。
public List<Commodity> SearchPaymentCommodity(String quryString, CommodityKind kind)
{
//string SKind = null;
//if (kind == null)
//{
// //如果用户没有传递中了的参数则默认的传递ALL
// SKind = "ALL";
//}
//else
//{
// SKind = kind.ToString();
//}
if (quryString == null)
{
quryString = "%";
}
else
{}
List<Commodity> commodityList = new List<Commodity>();
ISingleResult<searchPaymentCommodityResult> result = dc.searchPaymentCommodity(quryString, (int)kind);
foreach (searchPaymentCommodityResult singleCommodity in result)
{
Commodity commodity = new Commodity();
commodity.description = singleCommodity.discription;
commodity.EndTime = singleCommodity.endtime.Value;
commodity.ID = singleCommodity.id;
commodity.ImageUrl = singleCommodity.picturepath;
//commodity.kind = (CommodityKind)Enum.Parse(typeof(CommodityKind),singleCommodity.kind.ToString(),true);
commodity.kind = (CommodityKind)(singleCommodity.kind.Value);
commodity.Name = singleCommodity.name;
commodity.popularity = singleCommodity.popularity.Value;
commodity.Price = (double)singleCommodity.price;
commodity.StartTime = System.DateTime.Now;
//得到商品的tag列表
///////
//得到taglist
try
{
ISingleResult<getTagByCommodityResult> TagResult = dc.getTagByCommodity(singleCommodity.id);
List<Tag> TagList = new List<Tag>();
foreach (getTagByCommodityResult Newtag in TagResult)
{
Tag tag = new Tag();
tag.name = Newtag.id;
tag.popularity = Newtag.popularity.Value;
TagList.Add(tag);
}
commodity.tagList = TagList;
}
catch (Exception e)
{
commodity = null;
}
////////
commodity.UserName = singleCommodity.userfrom;
commodityList.Add(commodity);
}
return commodityList;
}
//搜索所有一般商品
public List<Commodity> SearchNoPaymentCommodity(String quryString, CommodityKind kind)
{
//string SKind = kind.ToString();
if (quryString == null)
{
quryString = "%";
}
else
{}
List<Commodity> commodityList = new List<Commodity>();
ISingleResult<searchNoPaymentCommodityResult> result = dc.searchNoPaymentCommodity(quryString, (int)kind);
foreach (searchNoPaymentCommodityResult singleCommodity in result)
{
Commodity commodity = new Commodity();
commodity.description = singleCommodity.discription;
commodity.EndTime = singleCommodity.endtime.Value;
commodity.ID = singleCommodity.id;
commodity.ImageUrl = singleCommodity.picturepath;
commodity.kind = (CommodityKind)(singleCommodity.kind.Value);
commodity.Name = singleCommodity.name;
commodity.popularity = (int)singleCommodity.popularity;
commodity.Price = singleCommodity.price.Value;
commodity.StartTime = singleCommodity.starttime.Value ;
///////
//得到taglist
List<Tag> TagList = new List<Tag>();
try
{
ISingleResult<getTagByCommodityResult> TagResult = dc.getTagByCommodity(singleCommodity.id);
foreach (getTagByCommodityResult Newtag in TagResult)
{
Tag tag = new Tag();
tag.name = Newtag.id;
tag.popularity = Newtag.popularity.Value;
TagList.Add(tag);
}
commodity.tagList = TagList;
}
catch (Exception e)
{
commodity = null;
}
////////
commodity.UserName = singleCommodity.userfrom;
commodityList.Add(commodity);
}
return commodityList;
}
public static List<Commodity> GetTopPaymentCommodity()
{
List<Commodity> commodityList= new List<Commodity>();
//getAllPayment commodity
ISingleResult<searchPaymentCommodityResult> result = dc.searchPaymentCommodity("%", (int)CommodityKind.ALL);
//for (int i = 1; i <= num; i++)
foreach (searchPaymentCommodityResult commodityResult in result)
{
//searchPaymentCommodityResult commodityResult = new searchPaymentCommodityResult();
Commodity commodity = new Commodity();
commodity.description = commodityResult.discription;
commodity.EndTime = commodityResult.endtime.Value;
commodity.ID = commodityResult.id;
commodity.ImageUrl = commodityResult.picturepath;
commodity.kind = (CommodityKind)commodityResult.kind.Value;
commodity.Name = commodityResult.name;
commodity.popularity = commodityResult.popularity.Value;
commodity.Price = commodityResult.price.Value;
commodity.StartTime = commodityResult.starttime.Value;
List<Tag> tagList = new List<Tag>();
ISingleResult<getTagByCommodityResult> result2 = dc.getTagByCommodity(commodity.ID);
foreach (getTagByCommodityResult tagResult in result2)
{
Tag tag = new Tag();
tag.name = tagResult.id;
tag.popularity = tagResult.popularity.Value;
tagList.Add(tag);
}
commodity.tagList = tagList;
commodity.UserName = commodityResult.userfrom;
commodityList.Add(commodity);
}
return commodityList;
}
//发布商品
protected void PublisButton_Click(object sender, EventArgs e)
{
List<Commodity> CommodityList = new List<Commodity>();
Commodity commodity = new Commodity();
commodity.ID = System.Guid.NewGuid();
//commodity.UserName = ((RegistedUser)Session["User"]).UserName;
commodity.Name = this.CommodityNameTextBox.Text.Trim();
commodity.kind = (CommodityKind)Enum.Parse(typeof(CommodityKind), this.CommodityKindDropDownList.SelectedItem.ToString(), false);
commodity.popularity = 0;
//处理标签
commodity.tagList = new List<Tag>();
char[] Spiliter = new char[1];
Spiliter[0] = '；';
String[] Taglist = this.CommodityTagsTextBox.Text.Split(Spiliter, StringSplitOptions.None);
foreach (String tag in Taglist)
{
Tag newtag = new Tag();
newtag.name = tag;
newtag.popularity = 0;
commodity.tagList.Add(newtag);
}
commodity.StartTime = DateTime.Now;
commodity.EndTime = DateTime.Parse(this.CommodityPeriodTextBox.Text.ToString());
commodity.Price = Double.Parse(this.CommodityPriceTextBox.Text.Trim());
commodity.description = this.CommodityDescriptionTextBox.Text.Trim();
//处理上传的图片
bool fileOk = false;
String path = Server.MapPath("~/Images/user/commodity/");
String fileExtension = "";
if(this.CommodityImageFileUpload.HasFile)
{
//文件后缀名
fileExtension = System.IO.Path.GetExtension(this.CommodityImageFileUpload.FileName).ToLower();
String[] allowExtension = {".gif",".png",".jpeg",".jpg"};
foreach(String extension in allowExtension)
{
if(fileExtension.Trim() == extension)
{
fileOk = true;
}
}
}
if(fileOk)
{
try
{
this.CommodityImageFileUpload.SaveAs(path+commodity.ID.ToString()+ fileExtension);
commodity.ImageUrl = path+commodity.ID.ToString()+ fileExtension;
//发布商品
CommodityList.Add(commodity);
bool IsSucceed = (new RegisterUserService()).PublishCommodity(CommodityList);
if (IsSucceed)
{
this.SubmitInfoLabel.Text = "发布成功";
}
else
{
this.SubmitInfoLabel.Text = "发布失败，可能是商品已存在！";
}
}
catch(Exception ee)
{
this.SubmitInfoLabel.Text = "发布失败商品图片无法上传，请检查图片文件格式！";
}
}
//没有选择文件或者文件格式不正确
else
{
this.SubmitInfoLabel.Text = "没有选择商品图片或者图片格式不正确！";
}
this.SubmitInfoLabel.Visible = true;
}