private void InitPage()
{
int uid = CommonMethod.ConvertToInt(Request["Id"], 0);
if (uid > 0)
{
#region 浏览过该换品的人
#region 浏览历史
int gid = GoodDetail.ID;
if (IsUserAlreadyLogin)
{
RetrieveCriteria rcview = new RetrieveCriteria(typeof(XiHuan_GoodsViewUserEntity));
Condition cview = rcview.GetNewCondition();
cview.AddEqualTo(XiHuan_GoodsViewUserEntity.__GOODSID, gid);
cview.AddEqualTo(XiHuan_GoodsViewUserEntity.__VISITORID, CurrentUserId);
cview.AddEqualTo(XiHuan_GoodsViewUserEntity._TYPE, 1);
XiHuan_GoodsViewUserEntity newview = rcview.AsEntity() as XiHuan_GoodsViewUserEntity;
if (CurrentUserId != gid)
{
if (newview == null)
{
newview = new XiHuan_GoodsViewUserEntity();
newview.GoodsId = gid;
newview.VisitorId = CurrentUserId;
newview.VisitorName = CurrentUserName;
newview.Type = 1;
}
newview.VisitorHeadImage = CurrentUser.HeadImage;
newview.VisitDate = DateTime.Now;
newview.Save();
}
}
#endregion
#endregion
StringBuilder sbSql = new StringBuilder("select top 18 Id,Name,DefaultPhoto,ViewCount,DetailUrl from XiHuan_UserGoods with(nolock) where OwnerId={0} and IsChecked=1 order by CreateDate desc, ViewCount desc ;");
sbSql.Append("select * from XiHuan_UserGoodsChangeRequire with(nolock) where OwnerId={0} order by RequireDate desc; ");
sbSql.Append("select * from XiHuan_UserGoodsChangeRequire with(nolock) where SenderId={0} order by RequireDate desc; ");
sbSql.Append("select * from XiHuan_GuestBook with(nolock) where ToId={0} order by CreateDate desc; ");
sbSql.Append("select FriendId,FriendName from XiHuan_UserFriends with(nolock) where OwnerId={0} order by AddDate desc; ");
sbSql.Append("select top 10 VisitorId,VisitorName,VisitorHeadImage,VisitDate from XiHuan_GoodsViewUser with(nolock) where Type=1 and GoodsId=" + gid + " order by VisitDate desc;");
DataSet ds = Query.ProcessMultiSql(string.Format(sbSql.ToString(), uid), GlobalVar.DataBase_Name);
dlsHotGoods.DataSource = ds.Tables[0];
dlsHotGoods.DataBind();
rptSend.DataSource = ds.Tables[1];
rptSend.DataBind();
rptRequire.DataSource = ds.Tables[2];
rptRequire.DataBind();
rptUserNotes.DataSource = ds.Tables[3];
rptUserNotes.DataBind();
rptGoodFriends.DataSource = ds.Tables[4];
rptGoodFriends.DataBind();
rptVisitor.DataSource = ds.Tables[5];
rptVisitor.DataBind();
}
}
private void LoadDetail()
{
#region 浏览过该换品的人
#region 浏览历史
int gid = CommonMethod.ConvertToInt(Request["gid"], 0);
if (gid > 0)
{
if (IsUserAlreadyLogin)
{
RetrieveCriteria rcview = new RetrieveCriteria(typeof(XiHuan_GoodsViewUserEntity));
Condition cview = rcview.GetNewCondition();
cview.AddEqualTo(XiHuan_GoodsViewUserEntity.__GOODSID, gid);
cview.AddEqualTo(XiHuan_GoodsViewUserEntity.__VISITORID, CurrentUserId);
cview.AddEqualTo(XiHuan_GoodsViewUserEntity._TYPE, 0);
XiHuan_GoodsViewUserEntity newview = rcview.AsEntity() as XiHuan_GoodsViewUserEntity;
if (newview == null)
{
newview = new XiHuan_GoodsViewUserEntity();
newview.GoodsId = gid;
newview.VisitorId = CurrentUserId;
newview.VisitorName = CurrentUserName;
newview.Type = 0;
}
newview.VisitorHeadImage = CurrentUser.HeadImage;
newview.VisitDate = DateTime.Now;
newview.Save();
}
#endregion
string sql = @"select top 10 VisitorId,VisitorName,VisitorHeadImage,VisitDate from XiHuan_GoodsViewUser with(nolock) where Type=0 and GoodsId={0} order by VisitDate desc;
declare @vcount int;
update xihuan_usergoods set viewcount=viewcount+1,@vcount=viewcount+1 where id= {0};
select @vcount;";
DataSet ds = Query.ProcessMultiSql(string.Format(sql, gid), GlobalVar.DataBase_Name);
DataTable dt = ds.Tables[0];
DataTable dt2 = ds.Tables[1];
int viewcount = (dt2 != null && dt2.Rows.Count > 0 ? CommonMethod.ConvertToInt(dt2.Rows[0][0], 0) : 0);
StringBuilder sbViewContent = new StringBuilder();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
sbViewContent.AppendFormat("<li style=\"width: 170px; text-align: left;\"><a title=\"浏览时间{0}\" href=\"{1}\" target=\"_blank\"><img style=\"border: 0px; vertical-align: middle;\" title=\"{2}\" src=\"{3}\" width=\"50\" height=\"40\" /> {4}</a></li>",
dr["VisitDate"], SrcRootPath + "xh.aspx?id=" + dr["VisitorId"], dr["VisitorName"], SrcRootPath + dr["VisitorHeadImage"], dr["VisitorName"]);
}
}
else
{
CommonMethod.ResponseAjaxContent(this.Page, "尚无登录用户浏览过...$" + viewcount);
return;
}
CommonMethod.ResponseAjaxContent(this.Page, "<ul>" + sbViewContent + "</ul>$" + viewcount);
}
#endregion
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!IsUserAlreadyLogin)
{
MemberCenterPageRedirect("", "goodsadd.aspx" + (IsEdit ? "?id=" + CommonMethod.FinalString(Request["id"]) : ""));
}
else
{
#region 务器端验证 以后完善
#endregion
#region 保存换品信息
Transaction t = new Transaction();
XiHuan_UserGoodsEntity newgoods = null;
if (IsEdit)
{
newgoods = XiHuan_UserGoodsEntityAction.RetrieveAXiHuan_UserGoodsEntity(CommonMethod.ConvertToInt(Request["id"], 0));
}
else
{
newgoods = new XiHuan_UserGoodsEntity();
}
newgoods.OwnerId = CurrentUserId;
newgoods.OwnerName = CurrentUserName;
newgoods.Name = txtGoodName.Text.Trim();
newgoods.IsTJ = chkTJ.Checked ? (byte)1 : (byte)0;
newgoods.TypeId = CommonMethod.ConvertToInt(ddlGoodType.SelectedValue, 0);
newgoods.ChildId = CommonMethod.ConvertToInt(ddlGoodChildType.SelectedValue, 0);
newgoods.IsHavePhoto = rbtYes.Checked ? (byte)XiHuan_UserGoodsFacade.IsGoodHavePhoto. : (byte)XiHuan_UserGoodsFacade.IsGoodHavePhoto.无;
newgoods.Description = txtGoodDesc.Value.Trim();
newgoods.NewDeep = byte.Parse(ddlNewOldDeep.SelectedValue.Trim());
newgoods.OnlyCityChange = chkValidCity.Checked ? (byte)1 : (byte)0;
newgoods.OnlySchoolChange = chkValidSchool.Checked ? (byte)1 : (byte)0;
newgoods.HopeToChangeTypeId = CommonMethod.ConvertToInt(ddlGoodType1.SelectedValue, 0);
newgoods.HopeToChangeChildTypeId = CommonMethod.ConvertToInt(ddlGoodChildType1.SelectedValue, 0);
newgoods.HopeToChangeDesc = txtHopeToChangeDesc.Text.Trim();
newgoods.ProvinceId = CurrentUser.ProvinceId;
newgoods.ProvinceName = CurrentUser.ProvinceName;
newgoods.CityId = CurrentUser.CityId;
newgoods.CityName = CurrentUser.CityName;
newgoods.AreaId = CurrentUser.AreaId;
newgoods.AreaName = CurrentUser.AreaName;
newgoods.SchoolId = CurrentUser.SchoolId;
newgoods.SchoolName = CurrentUser.SchoolName;
if (!IsEdit)
{
newgoods.CreateDate = DateTime.Now;
newgoods.ViewCount = new Random().Next(10, 30);
newgoods.GoodState = (byte)XiHuan_UserGoodsFacade.GoodsState.新登记;
}
newgoods.IsChecked = (byte)(SystemConfigFacade.Instance().IsGoodsAddNeedCheck ? 0 : 1);
t.DoSaveObject(newgoods);
if (!IsEdit)
{
#region 换品图片上传
string gooddefaultphoto = string.Empty;
if (rbtYes.Checked)
{
string extention = string.Empty;
int filesize = 0;
string filepath = string.Empty;
string savepath = string.Empty;
string filename = string.Empty;
HttpFileCollection goodimages = HttpContext.Current.Request.Files;
for (int i = 0; i < goodimages.Count; i++)
{
HttpPostedFile currentfile = goodimages[i];
extention = Path.GetExtension(currentfile.FileName);
filesize = currentfile.ContentLength;
filepath = "images/userupload/goodsimage/" + DateTime.Now.Year + "/" + DateTime.Now.Month + "/" + DateTime.Now.Day + "/";
//不符合条件的直接跳过，不进行保存
if (!(currentfile.FileName.Length > 0) || filesize == 0 || !CommonMethod.IsUploadImageValid("", extention) || filesize > 500 * 1024)
{
continue;
}
else
{
if (!Directory.Exists(Server.MapPath(filepath)))
{
Directory.CreateDirectory(Server.MapPath(filepath));
}
filename = newgoods.Id.ToString() + "_" + DateTime.Now.ToString("yyyyMMddhhmmssfff");
currentfile.SaveAs(Server.MapPath(filepath + filename + extention));
XiHuan_GoodsImageEntity newgoodimage = new XiHuan_GoodsImageEntity();
newgoodimage.GoodsId = newgoods.Id;
newgoodimage.GoodsName = newgoods.Name;
newgoodimage.ImgSrc = filepath + filename + extention;
newgoodimage.CreateDate = DateTime.Now;
if (i == 0)
{
gooddefaultphoto = filepath + filename + GlobalVar.DefaultPhotoSize + extention;
newgoodimage.IsDefaultPhoto = 1;
//生成不同规格的图片
PicHelper.MakeThumbnail(Server.MapPath(filepath + filename + extention), Server.MapPath(filepath + filename + GlobalVar.DefaultPhotoSize + extention), 85, 85);
PicHelper.MakeThumbnail(Server.MapPath(filepath + filename + extention), Server.MapPath(filepath + filename + GlobalVar.BigPhotoSize + extention), 200, 220);
}
t.DoSaveObject(newgoodimage);
}
}
}
#endregion
#region 默认图片保存
string sql = string.Format("update XiHuan_UserGoods set DefaultPhoto='{0}' where Id={1} ", gooddefaultphoto.Length > 0 ? gooddefaultphoto : "images/none.jpg", newgoods.Id);
t.DoSqlNonQueryString(sql, GlobalVar.DataBase_Name);
#endregion
#region 更新用户换品数量和积分，换币
string updategoodsnumber = string.Format(@"update XiHuan_UserInfo set GoodsNumber=GoodsNumber+1, Score=Score+{0},HuanBi=HuanBi+{1} where Id={2}"
, SystemConfigFacade.Instance().AddScoreByAddGoods(), SystemConfigFacade.Instance().AddHBByAddGoods(), CurrentUser.ID);
t.DoSqlNonQueryString(updategoodsnumber, GlobalVar.DataBase_Name);
#endregion
#region 浏览人
XiHuan_GoodsViewUserEntity view = new XiHuan_GoodsViewUserEntity();
view.GoodsId = newgoods.Id;
view.Type = 0;
view.VisitDate = DateTime.Now;
view.VisitorName = "喜换网";
view.VisitorId = 1;
view.VisitorHeadImage = "images/userupload/20092113032102_1.png";
t.DoSaveObject(view);
#endregion
}
try
{
string detailurl = "goods/" + newgoods.CreateDate.Year + "/" + newgoods.CreateDate.Month + "/" + newgoods.CreateDate.Day + "/goods" + newgoods.Id + ".html";
t.DoSqlNonQueryString("update XiHuan_UserGoods set DetailUrl='" + detailurl + "' where Id=" + newgoods.Id, GlobalVar.DataBase_Name);
t.Commit();
if (!SystemConfigFacade.Instance().IsGoodsAddNeedCheck)
{
DataTable dt = Query.ProcessSql("select Id,DetailUrl,GoodState from XiHuan_UserGoods with(nolock) where OwnerId= " + CurrentUserId + " and IsChecked=1 ", GlobalVar.DataBase_Name);
foreach (DataRow dr in dt.Rows)
{
CommonMethod.readAspxAndWriteHtmlSoruce("showdetail.aspx?id=" + dr["Id"], dr["DetailUrl"].ToString());
}
}
if (IsEdit)
{
Alert("恭喜：换品信息保存成功" + (SystemConfigFacade.Instance().IsGoodsAddNeedCheck ? ",我们会尽快进行审核" : string.Empty) + "^_^！");
}
else
{
Alert("恭喜：换品登记成功" + (SystemConfigFacade.Instance().IsGoodsAddNeedCheck ? ",我们会尽快进行审核" : string.Empty) + "^_^！");
SendMailFacade.sendEmail("[email protected],[email protected]", "有人在喜换网发换品了", "有人在喜换网发换品:" + txtGoodName.Text);
}
ExecScript("window.location='goodlist.aspx?s='+Math.random();");
}
catch (Exception ex)
{
t.RollBack();
Alert("抱歉：换品保存出错，" + ex.Message);
return;
}
#endregion
}
}
