讨厌地忽略提出问题的建议 [英] Obnoxiously ignoring advice to formulate a question

问题描述

我开发了一个社交门户.我已经开发了一个webuserControl名称UserFriendRequest.ascx和userdetails.aspx是当user1向user2发送有要求的请求发送代码时该控件出现的页面，但是当用户2登录userfreindrequest控件没有出现时，也将数据插入了Friends表. br/>

I have developed a social portal. I have develop a webusercontrol name UserFriendRequest.ascx and userdetails.aspx is page on which this control appears when user1 send request to user2 frined request is send code works but when user 2 login userfreindrequest control not appears also data is inserted in Friends table.

tablename Friends
Id             int
MyId           int
FriendId       int
Message        text
FriendStatus   bit //this datatype creates the table  allow nulls
FriendShipDate datetime
ImageName      varchar(500)

UserFriendRequest的控制代码为

UserFriendRequest control code is

DataBaseClass dbClass = new DataBaseClass();
   public DataTable dt;
   protected void Page_Load(object sender, EventArgs e)
   {
       if (!Page.IsPostBack)
       {
           GetUserFriendsRequest(int.Parse(Request.QueryString["Id"].ToString()));
       }
   }
   public void GetUserFriendsRequest(int Id)
   {
       string getFriendRequestQuery = "Select * FROM [User] where Id IN (SELECT MyId as Id FROM Friends WHERE FriendId=''" + Id + "'' AND FriendStatus=0)";//this query does not work when freind request is send FriendStatus column is null and UserFriendRequest control is not display FriendStatus datatype is bit which store null or 1 0r 0  i use logic Friendid=id and Friend status=0  FriendId is updated  but i not understand about FriendStatus the i use the logic when userfriend request control appears When user accepts friendstatus is updated to 1 and when deny friendstatus is 2 i use the right logic?
       dt = dbClass.ConnectDataBaseReturnDT(getFriendRequestQuery);
       if (dt.Rows.Count > 0)
       {
           FreindRequestList.DataSource = dt;
           FreindRequestList.DataBind();
       }
   }
   public string getHREF(object sURL)
   {
       DataRowView dRView = (DataRowView)sURL;
       string Id = dRView["Id"].ToString();
       return ResolveUrl("~/UserDetails.aspx?Id=" + Id);
   }
   public string getSRC(object imgSRC)
   {
       DataRowView dRView = (DataRowView)imgSRC;
       string ImageName = dRView["ImageName"].ToString();
       if (ImageName == "NoImage")
       {
           return ResolveUrl(@"~/UserImage/missing.jpg");
       }
       else
       {
           return ResolveUrl("~/UserImage/" + dRView["ImageName"].ToString());
       }
   }
   protected void FreindRequestList_ItemCommand(object source, DataListCommandEventArgs e)
   {
       if (!object.Equals(Session["UserId"], null))
       {
           if (e.CommandName == "Accept")
           {
               string SenderFriendId = ((HtmlInputHidden)e.Item.FindControl("hiddenId")).Value;
               string MyID = Session["UserId"].ToString();
               string AcceptFriendQuery = "Update Friends set FriendStatus=1 where MyId=''" + SenderFriendId + "'' AND FriendId=''" + MyID + "''";
               dbClass.ConnectDataBaseToInsert(AcceptFriendQuery);
               Response.Redirect("UserDetails.aspx?Id=" + Request.QueryString["Id"].ToString());
           }
           if (e.CommandName == "Deny")
           {
               string SenderFriendId = ((HtmlInputHidden)e.Item.FindControl("hiddenId")).Value;
               string MyID = Session["UserId"].ToString();
               string AcceptFriendQuery = "Update Friends set FriendStatus=0 where MyId=''" + SenderFriendId + "'' AND FriendId=''" + MyID + "''";
               dbClass.ConnectDataBaseToInsert(AcceptFriendQuery);
               Response.Redirect("UserDetails.aspx?Id=" + Request.QueryString["Id"].ToString());
           }
       }
   }

[edit]已添加代码块，忽略HTML ..."选项已禁用-OriginalGriff [/edit]

[edit]Code block added, "Ignore HTML..." option disabled - OriginalGriff[/edit]

推荐答案

您丢失了此内容:

You''re missing this:

foreach (Bacon slice in Fridge.getBacon() {
   slice.addSeasoning(new LiquideNitrogen());
}

现在，长大并写下一个适当的问题.

Now, grow up and write a proper question.

这篇关于讨厌地忽略提出问题的建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！