protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int id = CommonMethod.ConvertToInt(Request["id"], 0);
if (id > 0)
{
RetrieveCriteria rcgoodimage = new RetrieveCriteria(typeof(XiHuan_GoodsImageEntity));
Condition c = rcgoodimage.GetNewCondition();
c.AddEqualTo(XiHuan_GoodsImageEntity.__GOODSID, id);
rcgoodimage.AddSelect(XiHuan_GoodsImageEntity.__IMGSRC);
rcgoodimage.AddSelect(XiHuan_GoodsImageEntity.__IMGDESC);
rcgoodimage.OrderBy(XiHuan_GoodsImageEntity.__CREATEDATE, false);
DataTable dt = rcgoodimage.AsDataTable();
StringBuilder sbImage = new StringBuilder();
StringBuilder sbDesc = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
sbImage.AppendFormat("\"{0}\",", dt.Rows[i][XiHuan_GoodsImageEntity.__IMGSRC]);
sbDesc.AppendFormat("\"{0}\",", dt.Rows[i][XiHuan_GoodsImageEntity.__IMGDESC]);
}
ExecStartupScript(string.Format("imageArray=new Array({0});", sbImage.ToString().TrimEnd(',')));
ExecStartupScript(string.Format("imageDesc=new Array({0});", sbDesc.ToString().TrimEnd(',')));
ExecStartupScript("getnext();$('#loadingimage').hide(); $('#saint').show();");
}
}
}
protected void btnUpDatePic_Click(object sender, EventArgs e)
{
RetrieveCriteria rcGoodsPics = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DEFAULTPHOTO);
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__NAME);
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
Condition c = rcGoodsPics.GetNewCondition();
c.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
c.AddNotEqualTo(XiHuan_UserGoodsEntity.__DEFAULTPHOTO, "images/none.jpg");
rcGoodsPics.OrderBy(XiHuan_UserGoodsEntity.__CREATEDATE, false);
rcGoodsPics.Top = 6;
EntityContainer ecGoods = rcGoodsPics.AsEntityContainer();
string pics = "var pics=\"";
string links = "var links=\"";
string texts = "var texts=\"";
foreach (XiHuan_UserGoodsEntity goods in ecGoods)
{
pics += goods.DefaultPhoto.Replace(GlobalVar.DefaultPhotoSize, GlobalVar.BigPhotoSize) + "|";
links += goods.DetailUrl + "|";
texts += ValidatorHelper.SafeSql(goods.Name) + "|";
}
pics = pics.TrimEnd('|') + "\";";
links = links.TrimEnd('|') + "\";";
texts = texts.TrimEnd('|') + "\";";
Query.ProcessSqlNonQuery(string.Format("update xihuan_systemconfig set configvalue='{0}' where configkey='HomeRounPics'", pics + links + texts), GlobalVar.DataBase_Name);
SystemConfigFacade.Refresh();
Alert("幻灯片成功更新！");
}
private void GetDetail()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__USERNAME, txtUserName.Text.Trim());
rc.AddSelect(XiHuan_UserInfoEntity.__ID);
rc.AddSelect(XiHuan_UserInfoEntity.__ORIGNALPWD);
rc.AddSelect(XiHuan_UserInfoEntity.__ISLOCKED);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
if (user != null)
{
if (user.IsLocked == 0)
{
lblResult.Text = string.Format("密码为：<span class=\"highlight\">{0}</span>，<a href=\"###\" onclick=\"LockUser({1});\">锁定此账号</a>", user.OrignalPwd, user.ID);
}
if (user.IsLocked == 1)
{
lblResult.Text = string.Format("密码为：<span class=\"highlight\">{0}</span>，<a href=\"###\" onclick=\"UnLockUser({1});\">撤消锁定此账号</a>", user.OrignalPwd, user.ID);
}
}
else
{
lblResult.Text = "<span class=\"highlight\">没有找到此会员的信息！</span>";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//图片表还需要处理，不是默认图片的，需要将图片复制到新的路径，更新路径到数据库
RetrieveCriteria rcgimages = new RetrieveCriteria(typeof(XiHuan_GoodsImageEntity));
Condition c = rcgimages.GetNewCondition();
if (txtGoodsId.Text.Trim().Length > 0)
{
c.AddEqualTo(XiHuan_GoodsImageEntity.__GOODSID, txtGoodsId.Text);
}
rcgimages.AddSelect(XiHuan_GoodsImageEntity.__ID);
rcgimages.AddSelect(XiHuan_GoodsImageEntity.__CREATEDATE);
rcgimages.AddSelect(XiHuan_GoodsImageEntity.__IMGSRC);
EntityContainer imagecontainer = rcgimages.AsEntityContainer();
string opath = string.Empty;
string filename = string.Empty;
string extention = string.Empty;
string despath = string.Empty;
string filepath = string.Empty;
string fixpath = "images/userupload/goodsimage/";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (XiHuan_GoodsImageEntity goodsimage in imagecontainer)
{
opath = Server.MapPath(goodsimage.ImgSrc);
filename = Path.GetFileNameWithoutExtension(opath);
extention = Path.GetExtension(opath);
if (File.Exists(opath))
{
filepath = fixpath + goodsimage.CreateDate.Year + "/" + goodsimage.CreateDate.Month + "/" + goodsimage.CreateDate.Day + "/";
despath = Server.MapPath(filepath + filename + extention);
if (!Directory.Exists(Server.MapPath(filepath)))
{
Directory.CreateDirectory(Server.MapPath(filepath));
}
if (!File.Exists(despath))
{
File.Copy(opath, despath, true);//复制原来的图片到新的路径
//File.Delete(opath);
}
sb.Append("Update XiHuan_GoodsImage set ImgSrc='" + filepath + filename + extention + "' WHERE Id=" + goodsimage.Id + ";");
}
}
if (sb.ToString().Length > 0)
{
Query.ProcessSqlNonQuery(sb.ToString(), GlobalVar.DataBase_Name);
}
}
private void AddFavorite(string id, string name)
{
if (!IsUserAlreadyLogin)
{
CommonMethod.ResponseAjaxContent(this.Page, "needlogin");
return;
}
else
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserFavorateEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserFavorateEntity.__USERID, CurrentUserId);
c.AddEqualTo(XiHuan_UserFavorateEntity.__GOODSID, id);
rc.AddSelect(XiHuan_UserFavorateEntity.__ID);
DataTable dt = rc.AsDataTable();
if (dt != null && dt.Rows.Count > 0)
{
CommonMethod.ResponseAjaxContent(this.Page, "already");
return;
}
else
{
XiHuan_UserFavorateEntity newfavorite = new XiHuan_UserFavorateEntity();
newfavorite.UserId = CurrentUserId;
newfavorite.GoodsId = CommonMethod.ConvertToInt(id, 0);
newfavorite.GoodsName = GlobalObject.unescape(CommonMethod.FinalString(name));
newfavorite.FacRemark = "";
newfavorite.FavDate = DateTime.Now;
newfavorite.Save();
CommonMethod.ResponseAjaxContent(this.Page, "ok");
}
}
}
private void CheckeNotes()
{
Transaction t = new Transaction();
DataTable dt = Query.ProcessSql(@"SELECT Id,Content,ReplyContent FROM XiHuan_GuestBook WITH(nolock) WHERE IsChecked=0 ", GlobalVar.DataBase_Name);
string content = string.Empty;
string replycontent = string.Empty;
int nid = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
nid = CommonMethod.ConvertToInt(dr["Id"], 0);
content = CommonMethod.FinalString(dr["Content"]);
replycontent = CommonMethod.FinalString(dr["ReplyContent"]);
if (CommonMethodFacade.ValidFFZF(content).Length == 0 && CommonMethodFacade.ValidFFZF(replycontent).Length == 0)
{
XiHuan_GuestBookEntity notesinfo = new XiHuan_GuestBookEntity();
notesinfo.Id = nid;
notesinfo.Retrieve();
if (notesinfo.IsPersistent)
{
notesinfo.IsChecked = 1;
t.AddSaveObject(notesinfo);
XiHuan_MessageEntity notechecknoticemessage = new XiHuan_MessageEntity();
notechecknoticemessage.FromId = 1;
notechecknoticemessage.FromName = "喜换网";
notechecknoticemessage.ToId = notesinfo.FromId;
notechecknoticemessage.ToName = notesinfo.FromName;
notechecknoticemessage.Content = string.Format("尊敬的喜换网会员<strong>{0}</strong>,您好：<br/>您给\"{1}\"的留言\"{2}\",已经通过审核，请注意查看!",
notesinfo.FromName, notesinfo.ToName, notesinfo.Content);
notechecknoticemessage.Flag = byte.Parse(XiHuan_MessageFacade.MessageState.未读.ToString("d"));
notechecknoticemessage.CreateDate = DateTime.Now;
t.AddSaveObject(notechecknoticemessage);
if (t.Process())
{
#region 如果是对换品页面的留言，重新生成换品页
if (CommonMethod.ConvertToInt(nid, 0) > 0)
{
RetrieveCriteria rcgoods = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
rcgoods.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
Condition cgoods = rcgoods.GetNewCondition();
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ID, notesinfo.GoodsId);
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
XiHuan_UserGoodsEntity goods = rcgoods.AsEntity() as XiHuan_UserGoodsEntity;
if (goods != null)
{
CommonMethod.readAspxAndWriteHtmlSoruce("../showdetail.aspx?id=" + notesinfo.GoodsId, "../" + goods.DetailUrl);
}
}
#endregion
}
}
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__USERNAME, txtName.Text.Trim());
rc.AddSelect(XiHuan_UserInfoEntity.__USERNAME);
rc.AddSelect(XiHuan_UserInfoEntity.__ORIGNALPWD);
rc.AddSelect(XiHuan_UserInfoEntity.__QUESTION);
rc.AddSelect(XiHuan_UserInfoEntity.__ANSWER);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
if (user != null)
{
if (user.Question == txtQuestion.Text.Trim() && user.Answer == txtAnswer.Text.Trim())
{
try
{
SendMailFacade.sendEmail(txtEmail.Text.Trim(), "喜换网-找回密码", "<strong>" + txtName.Text.Trim() + "</strong>您好，<br/>您在喜换网注册的账号密码为" + user.OrignalPwd + ",请妥善保管，此邮件为系统邮件，请勿回复！");
Alert("您的密码已成功发送到您的邮箱，请注意查收！");
ExecScript("parent.ymPrompt.close();");
}
catch
{
Alert("抱歉：邮件发送出现错误！");
return;
}
}
else
{
Alert("很抱歉：您输入的安全提问问题和答案不符合，我们不能为您提供找回密码的服务！");
return;
}
}
else
{
Alert("不存在换客名为" + txtName.Text + "的用户！");
return;
}
}
private void CheckNotes(string id, string gid)
{
#region 留言通过审核,给留言人发送提醒短消息，提醒留言已通过审核
Transaction t = new Transaction();
XiHuan_GuestBookEntity notesinfo = new XiHuan_GuestBookEntity();
notesinfo.Id = CommonMethod.ConvertToInt(id, 0);
notesinfo.Retrieve();
if (notesinfo.IsPersistent)
{
notesinfo.IsChecked = 1;
t.AddSaveObject(notesinfo);
XiHuan_MessageEntity notechecknoticemessage = new XiHuan_MessageEntity();
notechecknoticemessage.FromId = 1;
notechecknoticemessage.FromName = "喜换网";
notechecknoticemessage.ToId = notesinfo.FromId;
notechecknoticemessage.ToName = notesinfo.FromName;
notechecknoticemessage.Content = string.Format("尊敬的喜换网会员<strong>{0}</strong>,您好：<br/>您给\"{1}\"的留言\"{2}\",已经通过审核，请注意查看!",
notesinfo.FromName, notesinfo.ToName, notesinfo.Content);
notechecknoticemessage.Flag = byte.Parse(XiHuan_MessageFacade.MessageState.未读.ToString("d"));
notechecknoticemessage.CreateDate = DateTime.Now;
t.AddSaveObject(notechecknoticemessage);
}
#endregion
if (t.Process())
{
#region 如果是对换品页面的留言，重新生成换品页
if (CommonMethod.ConvertToInt(gid, 0) > 0)
{
RetrieveCriteria rcgoods = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
rcgoods.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
Condition cgoods = rcgoods.GetNewCondition();
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ID, gid);
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
XiHuan_UserGoodsEntity goods = rcgoods.AsEntity() as XiHuan_UserGoodsEntity;
if (goods != null)
{
CommonMethod.readAspxAndWriteHtmlSoruce("../showdetail.aspx?id=" + gid, "../" + goods.DetailUrl);
}
}
#endregion
Alert("恭喜：留言审核成功！");
BindNotes(0);
}
else
{
t.RollBack();
}
}
private void AddFriend(string fid, string fname)
{
if (!IsUserAlreadyLogin)
{
CommonMethod.ResponseAjaxContent(this.Page, "needlogin");
return;
}
else
{
fname = GlobalObject.unescape(fname);
if (fname.Equals(CurrentUserName))
{
CommonMethod.ResponseAjaxContent(this.Page, "self");
return;
}
else
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserFriendsEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserFriendsEntity.__OWNERID, CurrentUserId);
c.AddEqualTo(XiHuan_UserFriendsEntity.__FRIENDID, fid);
rc.AddSelect(XiHuan_UserFriendsEntity.__ID);
DataTable dt = rc.AsDataTable();
if (dt != null && dt.Rows.Count > 0)
{
CommonMethod.ResponseAjaxContent(this.Page, "already");
return;
}
else
{
XiHuan_UserFriendsEntity newfriend = new XiHuan_UserFriendsEntity();
newfriend.OwnerId = CurrentUserId;
newfriend.OwnerName = CurrentUserName;
newfriend.FriendId = CommonMethod.ConvertToInt(fid, 0);
newfriend.FriendName = fname;
newfriend.AddDate = DateTime.Now;
newfriend.FriendDesc = "";
newfriend.Save();
CommonMethod.ResponseAjaxContent(this.Page, "ok");
}
}
}
}
public static int GetIdByName(string uname)
{
uname = CommonMethodFacade.FinalString(uname);
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__USERNAME, uname);
rc.AddSelect(XiHuan_UserInfoEntity.__ID);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
if (user != null)
{
return(user.ID);
}
else
{
return(0);
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
#region 验证
if (txtContent.Text.Trim().Length == 0)
{
Alert("请输入回复内容！");
return;
}
#endregion
XiHuan_GuestBookEntity note = new XiHuan_GuestBookEntity();
note.Id = CommonMethod.ConvertToInt(Request["id"], 0);
if (note.Id > 0)
{
note.Retrieve();
}
if (note.IsPersistent)
{
note.Flag = (byte)XiHuan_UserNotesFacade.NotesState.已回复;
note.ReplyContent = CommonMethod.ClearInputText(txtContent.Text, 200);
note.IsChecked = 0;
note.Save();
if (note.GoodsId > 0)
{
RetrieveCriteria rcgoods = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
rcgoods.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
Condition cgoods = rcgoods.GetNewCondition();
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ID, note.GoodsId);
cgoods.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
XiHuan_UserGoodsEntity goods = rcgoods.AsEntity() as XiHuan_UserGoodsEntity;
if (goods != null)
{
CommonMethod.readAspxAndWriteHtmlSoruce("showdetail.aspx?id=" + note.GoodsId, goods.DetailUrl);
}
}
Alert("恭喜：留言回复成功！");
ExecScript(string.Format("parent.location='membernotes.aspx?type={0}';", Request["type"]));
}
}
private void InitPage()
{
if (GoodDetail == null)
{
return;
}
#region 界面显示
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__ID, GoodDetail.OwnerId);
rc.AddSelect(XiHuan_UserInfoEntity.__GENDER);
rc.AddSelect(XiHuan_UserInfoEntity.__SCORE);
rc.AddSelect(XiHuan_UserInfoEntity.__HUANBI);
rc.AddSelect(XiHuan_UserInfoEntity.__GOODFEED);
rc.AddSelect(XiHuan_UserInfoEntity.__XINYU);
rc.AddSelect(XiHuan_UserInfoEntity.__REGISTERDATE);
rc.AddSelect(XiHuan_UserInfoEntity.__LASTLOGINTIME);
rc.AddSelect(XiHuan_UserInfoEntity._TelePhone);
rc.AddSelect(XiHuan_UserInfoEntity._WangWang);
rc.AddSelect(XiHuan_UserInfoEntity.__EMAIL);
rc.AddSelect(XiHuan_UserInfoEntity.__QQ);
rc.AddSelect(XiHuan_UserInfoEntity.__MSN);
rc.AddSelect(XiHuan_UserInfoEntity.__OTHERLINK);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
lblScore.Text = user.Score.ToString();
lblHB.Text = user.HuanBi.ToString();
lblGoodFeed.Text = user.GoodFeed.ToString();
lblXY.Text = user.XinYu.ToString();
lblRegisterDate.Text = user.RegisterDate.ToString("yyyy-MM-dd");
lblLastLoginTime.Text = user.LastLoginTime.ToString("yyyy-MM-dd");
lblWW.Text = CommonMethod.FinalString(user.WangWang).Length > 0 ? " " + string.Format(GlobalVar.BIGSTRWW, Server.UrlEncode(user.WangWang)) : string.Empty;
lblQQ.Text = CommonMethod.FinalString(user.QQ).Length > 0 ? string.Format(GlobalVar.QQSTR, user.QQ) : string.Empty;
linkMethod.Text = string.Format(" 电话：{0} 邮箱：{1} 旺旺:{5} QQ:{2} MSN:{3}<br/> 其他联系方式：{4}", user.TelePhone, user.Email, user.QQ + lblQQ.Text, user.Msn, user.OtherLink, lblWW.Text);
lblGender.Text = CommonMethodFacade.FormatGender(user.Gender, SrcRootPath);
#endregion
#region 换主热门换品
RetrieveCriteria rchotgoods = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
Condition hotgoodscondition = rchotgoods.GetNewCondition();
hotgoodscondition.AddEqualTo(XiHuan_UserGoodsEntity.__OWNERID, GoodDetail.OwnerId);
hotgoodscondition.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
rchotgoods.AddSelect(XiHuan_UserGoodsEntity.__DEFAULTPHOTO);
rchotgoods.AddSelect(XiHuan_UserGoodsEntity.__NAME);
rchotgoods.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
rchotgoods.Top = 10;
rchotgoods.OrderBy(XiHuan_UserGoodsEntity.__VIEWCOUNT, false);
rptHotGoods.DataSource = rchotgoods.AsDataTable();
rptHotGoods.DataBind();
#endregion
#region 其它相关换品
DataTable dtrelateGoods = Query.ProcessSql(
@"select top 10 DefaultPhoto,Name,DetailUrl from XiHuan_UserGoods
with(nolock) where TypeId=" + GoodDetail.TypeId + " and OwnerId<>" + GoodDetail.OwnerId + " and IsChecked=1 order by newid() ",
GlobalVar.DataBase_Name);
rtpRelateGoods.DataSource = dtrelateGoods;
rtpRelateGoods.DataBind();
#endregion
#region 留言
BindNotes();
#endregion
#region 交换请求
BindRequire();
#endregion
#region 一换品下一换品链接
string sqlpre = "select top 1 Name,DetailUrl from XiHuan_UserGoods with(nolock) where Id<" + Request["id"] + " and IsChecked=1 order by Id desc;";
string sqlnext = "select top 1 Name,DetailUrl from XiHuan_UserGoods with(nolock) where Id>" + Request["id"] + " and IsChecked=1 order by Id asc;";
DataSet dt = Query.ProcessMultiSql(sqlpre + sqlnext, GlobalVar.DataBase_Name);
lblPre.Text = dt.Tables[0].Rows.Count > 0 ? string.Format("<a href=\"{0}\" title=\"{1}\">{2}</a>", SrcRootPath + (dt.Tables[0].Rows[0][1]), dt.Tables[0].Rows[0][0], CommonMethod.GetSubString(CommonMethod.FinalString(dt.Tables[0].Rows[0][0]), 20, "")) : "没有了";
lblNext.Text = dt.Tables[1].Rows.Count > 0 ? string.Format("<a href=\"{0}\" title=\"{1}\">{2}</a>", SrcRootPath + (dt.Tables[1].Rows[0][1]), dt.Tables[1].Rows[0][0], CommonMethod.GetSubString(CommonMethod.FinalString(dt.Tables[1].Rows[0][0]), 20, "")) : "没有了";
#endregion
#region 换品图片加载
if (GoodDetail.DefaultPhoto != null && GoodDetail.DefaultPhoto.Trim().Length > 0 && !GoodDetail.DefaultPhoto.Trim().Equals("images/none.jpg"))
{
RetrieveCriteria rcgoodimage = new RetrieveCriteria(typeof(XiHuan_GoodsImageEntity));
Condition cg = rcgoodimage.GetNewCondition();
cg.AddEqualTo(XiHuan_GoodsImageEntity.__GOODSID, GoodDetail.Id);
cg.AddEqualTo(XiHuan_GoodsImageEntity.__ISDEFAULTPHOTO, 0);
rcgoodimage.AddSelect(XiHuan_GoodsImageEntity.__IMGSRC);
rcgoodimage.AddSelect(XiHuan_GoodsImageEntity.__IMGDESC);
rcgoodimage.OrderBy(XiHuan_GoodsImageEntity.__CREATEDATE, false);
rptGoodsImage.DataSource = rcgoodimage.AsDataTable();
rptGoodsImage.DataBind();
}
#endregion
}
protected void btnSendMaiil_Click(object sender, EventArgs e)
{
string mailcontent = " <table style=\"width:98%;border: #ccc 1px solid;padding-right: 10px;padding-left: 10px;padding-bottom: 10px;padding-top: 10px;background-color: #f7f7f7; font-size:14px; color:black;\">";
RetrieveCriteria rcGoodsPics = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DEFAULTPHOTO);
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__NAME);
rcGoodsPics.AddSelect(XiHuan_UserGoodsEntity.__DETAILURL);
Condition c = rcGoodsPics.GetNewCondition();
c.AddEqualTo(XiHuan_UserGoodsEntity.__ISCHECKED, 1);
c.AddNotEqualTo(XiHuan_UserGoodsEntity.__DEFAULTPHOTO, "images/none.jpg");
rcGoodsPics.OrderBy(XiHuan_UserGoodsEntity.__CREATEDATE, false);
rcGoodsPics.Top = 70;
EntityContainer ecGoods = rcGoodsPics.AsEntityContainer();
for (int i = 0; i < ecGoods.Count; i++)
{
int rem;
XiHuan_UserGoodsEntity goods = ecGoods[i] as XiHuan_UserGoodsEntity;
Math.DivRem(i, 7, out rem);
if (rem == 0)
{
mailcontent += "<tr>";
}
else
{
mailcontent += string.Format("<td style=\"border: solid 1px #CCCCCC;height: 30px;text-align:center;padding: 2px 5px;\"> <a title=\"{0}\" href=\"{1}\" target=\"_blank\"><img style=\"width: 85px;height: 85px;border: solid 1px #CCCCCC;\" title=\"{0}\" src=\"{2}\" /><br/><br/>{3}</a></td>", goods.Name, "http://www.tsc8.com/" + goods.DetailUrl + "?from=email", "http://www.tsc8.com/" + goods.DefaultPhoto, CommonMethod.GetSubString(goods.Name, 6, "..."));
}
if (rem == 0)
{
mailcontent += "</tr>";
}
}
mailcontent += "</table>";
DataTable dt = PersistenceLayer.Query.ProcessSql("select Id,UserName,Email,QQ,Msn from XiHuan_UserInfo with(nolock) where LastLoginTime<='" + DateTime.Now.AddDays(-Math.Abs(Convert.ToDouble(txtDays.Text))).ToString("yyyy-MM-dd") + "' and (Email>'' or QQ >'' or Msn >'')", GlobalVar.DataBase_Name);
string strMailAdd = string.Empty;
string email = string.Empty;
string qq = string.Empty;
string msn = string.Empty;
foreach (DataRow dr in dt.Rows)
{
strMailAdd = string.Empty;
email = CommonMethod.FinalString(dr[XiHuan_UserInfoEntity.__EMAIL]).ToLower();
qq = GetFinalQQ(CommonMethod.FinalString(dr[XiHuan_UserInfoEntity.__QQ]));
msn = CommonMethod.FinalString(dr[XiHuan_UserInfoEntity.__MSN]);
if (IsEmail(email))
{
strMailAdd += email + ",";
}
if (IsInt(qq))
{
strMailAdd += qq + "@qq.com,";
}
if (IsEmail(msn))
{
strMailAdd += msn + ",";
}
if (strMailAdd.Length > 0)
{
SendMailFacade.sendEmail(strMailAdd.TrimEnd(','), "喜换网-物品交换，节约，时尚，好玩，精彩不容错过！", "<span style=\"color:blue;font-weight:bold;\">尊敬的换友<a href=\"http://www.tsc8.com/xh.aspx?id=" + dr[XiHuan_UserInfoEntity.__ID] + "&from=email\" target=\"_blank\" style=\"color:red;\">" + dr[XiHuan_UserInfoEntity.__USERNAME] + "</a>，我们注意到你有段时间没来<a href=\"http://www.tsc8.com/?from=eamil&id=" + dr[XiHuan_UserInfoEntity.__ID] + "\" target=\"_blank\" style=\"color:red;\">喜换网</a>逛逛了啊，<br/><br/>你不在的这段时间里好多朋友发布了很多好玩的换品：</span><br/><br/>" + mailcontent + "<br/><br/>现在快<a href=\"http://www.tsc8.com/?from=eamil\" target=\"_blank\">去看看</a>吧！");
}
}
Alert("恭喜：邮件已经成功发送！");
}
protected void btnDealGoodsImage_Click(object sender, EventArgs e)
{
string opath = string.Empty;
string thumpath = string.Empty;
string despath = string.Empty;
string filename = string.Empty;
string filepath = string.Empty;
string fixpath = "images/userupload/goodsimage/";
string extention = string.Empty;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
#region 默认图片的处理
RetrieveCriteria rcGooos = new RetrieveCriteria(typeof(XiHuan_UserGoodsEntity));
Condition c = rcGooos.GetNewCondition();
if (txtGoodsId.Text.Trim().Length > 0)
{
c.AddEqualTo(XiHuan_UserGoodsEntity.__ID, txtGoodsId.Text);
}
rcGooos.AddSelect(XiHuan_UserGoodsEntity.__ID);
rcGooos.AddSelect(XiHuan_UserGoodsEntity.__DEFAULTPHOTO);
rcGooos.OrderBy(XiHuan_UserGoodsEntity.__ID, false);
c.AddNotEqualTo(XiHuan_UserGoodsEntity.__DEFAULTPHOTO, "images/none.jpg");
EntityContainer goodscontainer = rcGooos.AsEntityContainer();
foreach (XiHuan_UserGoodsEntity goods in goodscontainer)
{
if (goods.DefaultPhoto != null && goods.DefaultPhoto.Length > 0)
{
opath = Server.MapPath(goods.DefaultPhoto);
filename = Path.GetFileNameWithoutExtension(opath);
extention = Path.GetExtension(opath);
if (File.Exists(opath))
{
filepath = fixpath + goods.CreateDate.Year + "/" + goods.CreateDate.Month + "/" + goods.CreateDate.Day + "/";
despath = Server.MapPath(filepath + filename + extention);
if (!Directory.Exists(Server.MapPath(filepath)))
{
Directory.CreateDirectory(Server.MapPath(filepath));
}
if (!File.Exists(despath))
{
File.Copy(opath, despath, true);//复制原来的图片到新的路径
//File.Delete(opath);
}
thumpath = Server.MapPath(filepath + filename + GlobalVar.DefaultPhotoSize + extention);
PicHelper.MakeThumbnail(despath, thumpath, 85, 85);
thumpath = Server.MapPath(filepath + filename + GlobalVar.BigPhotoSize + extention);
PicHelper.MakeThumbnail(despath, thumpath, 200, 220);
sb.Append("Update XiHuan_UserGoods set DefaultPhoto='" + filepath + filename + GlobalVar.DefaultPhotoSize + extention + "' WHERE Id=" + goods.Id + ";");
}
}
}
#endregion
if (sb.ToString().Length > 0)
{
Query.ProcessSqlNonQuery(sb.ToString(), GlobalVar.DataBase_Name);
}
}
