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");
}
}
}
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();");
}
}
}
/// <summary>
/// 读取所有系统设置选项并保存到静态哈希表
/// </summary>
public void GetAppSetup()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(Entity系统选项表));
DataTable dt = rc.AsDataTable();
foreach (DataRow row in dt.Rows)
{
Main.staticAppSetup.Add(row["关键字"].ToString(), row["值"].ToString());
}
}
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");
}
}
}
}
/// <summary>
/// 获取用户的留言信息
/// </summary>
/// <param name="uid">用户Id</param>
/// <param name="gid">大于0表示过滤针对某个换品的留言</param>
/// <param name="type">0：表示接收到的 1表示发出的</param>
/// <param name="isfilter">是否过滤掉待审核的留言</param>
/// <returns></returns>
public static DataTable GetUserNotes(int uid, int gid, int type, bool isfilter)
{
RetrieveCriteria rcnote = new RetrieveCriteria(typeof(XiHuan_GuestBookEntity));
Condition cnote = rcnote.GetNewCondition();
rcnote.OrderBy(XiHuan_GuestBookEntity.__CREATEDATE, false);
if (type == 0)
{
cnote.AddEqualTo(XiHuan_GuestBookEntity.__TOID, uid);
}
if (type == 1)
{
cnote.AddEqualTo(XiHuan_GuestBookEntity.__FROMID, uid);
}
if (gid > 0)
{
cnote.AddEqualTo(XiHuan_GuestBookEntity.__GOODSID, gid);
}
if (isfilter)
{
cnote.AddEqualTo(XiHuan_GuestBookEntity.__ISCHECKED, 1);
}
return(rcnote.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetFUNCTIONEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FUNCTIONEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetFNFORBIDRETRIEVALEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNFORBIDRETRIEVALEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_TraderateContextEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_TraderateContextEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetT_BLINDMEMBEREntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_BLINDMEMBEREntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_User_SwitchEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_User_SwitchEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetEntity系统选项表()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(Entity系统选项表));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetXiHuan_UserGoodsChangeRequireEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserGoodsChangeRequireEntity));
return(rc.AsDataTable());
}
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
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetFNTERMONAREAEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNTERMONAREAEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetT_SERVICETRACINGEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_SERVICETRACINGEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetXiHuan_SchoolInfoEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_SchoolInfoEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetT_TRANSACTIONBACKEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_TRANSACTIONBACKEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_RelistReslutEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_RelistReslutEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetT_SECHOUSEPICEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_SECHOUSEPICEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_ScheduleRecommendQueueEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_ScheduleRecommendQueueEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetT_DOCTORINFOEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_DOCTORINFOEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetFHDIFFERENCESTOCKEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FHDIFFERENCESTOCKEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetFHRETRIEVALRESULTEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FHRETRIEVALRESULTEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetXiHuan_UserFriendsEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserFriendsEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_InGoldTimeItemsEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_InGoldTimeItemsEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_RecommendResultEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_RecommendResultEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_GoldTimeslotSchemeDetailsEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_GoldTimeslotSchemeDetailsEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetST_PROTYPEEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(ST_PROTYPEEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_MessageQueueEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_MessageQueueEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetT_SURVEYANSWEREntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_SURVEYANSWEREntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetSYS_BASE_USERSEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(SYS_BASE_USERSEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable Gettb_LdleTimeslotEntity()
{
RetrieveCriteria rc=new RetrieveCriteria(typeof(tb_LdleTimeslotEntity));
return rc.AsDataTable();
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetUSERTERMINALEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(USERTERMINALEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetFHSTORAGEINFOEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FHSTORAGEINFOEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetMAINMENUEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(MAINMENUEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetT_NEWSBASEEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_NEWSBASEEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetprovinceEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(provinceEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetFNPRINTBODYEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(FNPRINTBODYEntity));
return(rc.AsDataTable());
}
/// <summary>获取所有实体(EntityContainer)</summary>
public static DataTable GetT_ADVERTISMENTEntity()
{
RetrieveCriteria rc = new RetrieveCriteria(typeof(T_ADVERTISMENTEntity));
return(rc.AsDataTable());
}
