1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11using SqlServerBLL;
 12using Model;
 13
 14public partial class Controls_Article : System.Web.UI.UserControl
 15...{
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        if (!IsPostBack)
 19        ...{
 20            DataBindPage();
 21        }
 22    }
 23    public void DataBindPage()
 24    ...{
 25        string sUrl = "";
 26        int iPageIndex = 0;
 27        int iPageSize = 20;
 28        int iType = 0;
 29        int iUserID = 0;
 30        string sName = HttpUtility.UrlDecode(Request.QueryString["title"]);
 31        string sSummary = HttpUtility.UrlDecode(Request.QueryString["summary"]);
 32        string sType = Request.QueryString["type"];
 33        string sUser = Request.QueryString["user"];
 34        string sPageIndex = Request.QueryString["PageIndex"];
 35        string sCheck = Request.QueryString["check"];
 36        if (Session["User"] != null)
 37        ...{
 38            if (!string.IsNullOrEmpty(sCheck))
 39            ...{
 40                if ("0".Equals(sCheck))
 41                ...{
 42                    iUserID = ((UsersModel)Session["User"]).UserID;
 43                }
 44                sUrl += "&check=" + sCheck;
 45            }
 46            else
 47            ...{
 48                iUserID = ((UsersModel)Session["User"]).UserID;
 49            }
 50        }
 51        if (!string.IsNullOrEmpty(sName))
 52        ...{
 53            sUrl += "&title=" + HttpUtility.UrlEncode(sName);
 54        }
 55        if (!string.IsNullOrEmpty(sSummary))
 56        ...{
 57            sUrl += "&summary=" + HttpUtility.UrlEncode(sSummary);
 58        }
 59        if (!string.IsNullOrEmpty(sType))
 60        ...{
 61            sUrl += "&type=" + sType;
 62            int.TryParse(sType, out iType);
 63        }
 64        if (!string.IsNullOrEmpty(sUser))
 65        ...{
 66            sUrl += "&user=" + sUser;
 67            int.TryParse(sUser, out iUserID);
 68        }
 69        if (!string.IsNullOrEmpty(sPageIndex))
 70        ...{
 71            int.TryParse(sPageIndex, out iPageIndex);
 72        }
 73
 74        Users userBLL = new Users();
 75        DataSet dsArticle = userBLL.GetArticle(iPageIndex, iPageSize, iType, iUserID, sName, sSummary);
 76        if (dsArticle != null && dsArticle.Tables.Count == 2)
 77        ...{
 78            if (dsArticle.Tables[0].Rows.Count > 0)
 79            ...{
 80                this.PanelList.Visible = true;
 81                this.NonePanel.Visible = false;
 82                repeaterList.DataSource = dsArticle.Tables[0];
 83                repeaterList.DataBind();
 84                int iCount = Convert.ToInt32(dsArticle.Tables[1].Rows[0][0]);
 85                spTop.PageCount = iCount;
 86                spTop.PageIndex = iPageIndex;
 87                spTop.PageSize = iPageSize;
 88                spTop.Parameter = sUrl;
 89                spBottom.PageCount = iCount;
 90                spBottom.PageIndex = iPageIndex;
 91                spBottom.PageSize = iPageSize;
 92                spBottom.Parameter = sUrl;
 93                dsArticle.Dispose();
 94            }
 95            else
 96            ...{
 97                this.PanelList.Visible = false;
 98                this.NonePanel.Visible = true;
 99            }
100        }
101    }
102
103    protected void repeaterList_ItemDataBound(object sender, RepeaterItemEventArgs e)
104    ...{
105        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
106        ...{
107            int iUserID = Convert.ToInt32(((HiddenField)e.Item.FindControl("hf_Userid")).Value);
108            if (Session["User"] != null)
109            ...{
110                UsersModel um = (UsersModel)Session["User"];
111                if (iUserID == um.UserID)
112                ...{
113                    HyperLink hLinkUser = (HyperLink)e.Item.FindControl("hLinkUser");
114                    hLinkUser.Enabled = false;
115                    HyperLink hLinkEdit = (HyperLink)e.Item.FindControl("hLinkEdit");
116                    hLinkEdit.Visible = true;
117                    Literal ltl = (Literal)e.Item.FindControl("ltl");
118                    ltl.Visible = true;
119                    Literal ltlDelete = (Literal)e.Item.FindControl("ltlDelete");
120                    ltlDelete.Visible = true;
121                    LinkButton lBtnDelete = (LinkButton)e.Item.FindControl("lBtnDelete");
122                    lBtnDelete.Visible = true;
123                }
124            }
125        }
126    }
127
128    protected void repeaterList_ItemCommand(object sender, RepeaterCommandEventArgs e)
129    ...{
130        if (e.CommandName == "delete")
131        ...{
132            string sArticleID = e.CommandArgument.ToString();
133            Admins adminBLL = new Admins();
134            if (adminBLL.DeleteArticleByIds(sArticleID))
135            ...{
136                Page.ClientScript.RegisterClientScriptResource(GetType(), "js/jquery-1.2.6.js");
137                Page.ClientScript.RegisterClientScriptResource(GetType(), "js/jquery-impromptu.1.5.js");
138                Page.ClientScript.RegisterStartupScript(GetType(), "deleted", "deletedSuccess();", true);
139            }
140            else
141            ...{
142                Page.ClientScript.RegisterClientScriptResource(GetType(), "js/jquery-1.2.6.js");
143                Page.ClientScript.RegisterClientScriptResource(GetType(), "js/jquery-impromptu.1.5.js");
144                Page.ClientScript.RegisterStartupScript(GetType(), "deleted", "deleteError();", true);
145            }
146        }
147    }
148}
149