/// <summary> /// 定义数据绑定方法 /// </summary> protected override void BindData() { string strWhere = " where FS_PID=0"; XYECOM.Business.FriendLinkSort fl = new XYECOM.Business.FriendLinkSort(); if (XYECOM.Core.XYRequest.GetQueryString("FS_PID") != "") { strWhere = " where FS_PID=" + XYECOM.Core.XYRequest.GetQueryString("FS_PID"); //this.title.InnerHtml = fl.GetFriendLinkName(XYECOM.Core.XYRequest.GetQueryInt("FS_PID",0)) + "链接类别列表"; this.lnkAdd.Text = "返回"; //this.lnkA.Visible = true; } this.page1.RecTotal = Function.GetRows("b_FriendLinkSort", "FS_ID", strWhere); DataTable dt = Function.GetPages(this.page1.PageSize, this.page1.CurPage, strWhere, "Order by FS_ID DESC", "b_FriendLinkSort", "FS_ID,FS_Name,FS_PID,FS_Alt", "FS_ID"); if (dt.Rows.Count > 0) { this.gvlist.DataSource = dt; this.gvlist.DataBind(); } else { this.gvlist.DataBind(); this.lblMessage.Text = "没有相关信息"; } }
/// <summary> /// 定义修改信息时的数据绑定事件 /// </summary> /// <param name="id"></param> protected void BindData(int id) { string strWhere = "where FS_ID=" + id; XYECOM.Business.FriendLinkSort fl = new XYECOM.Business.FriendLinkSort(); DataTable dt = fl.GetDataTable(strWhere, ""); if (dt.Rows.Count > 0) { this.tbfltypename.Text = dt.Rows[0]["FS_Name"].ToString(); this.tbfltypealt.Text = dt.Rows[0]["FS_Alt"].ToString(); } }
/// <summary> /// 定义单击添加按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btadd_Click(object sender, EventArgs e) { int fsid = 0; int rowAff = 0; XYECOM.Model.FriendLinkSortInfo fs = new XYECOM.Model.FriendLinkSortInfo(); XYECOM.Business.FriendLinkSort flk = new XYECOM.Business.FriendLinkSort(); fs.FS_Name = this.tbfltypename.Text; fs.FS_Alt = this.tbfltypealt.Text; if (Request.QueryString["Type"] != null) { if (int.Parse(Request.QueryString["Type"]) == 0) { fs.FS_PID = 0; rowAff = flk.Insert(fs, out fsid); if (rowAff >= 0) { Alert("添加友情链接分类成功!", "FriendLinkList.aspx?FS_PID=" + fs.FS_PID, true); } else if (rowAff == -2) { Alert("添加友情链接分类添加失败!", "FriendLinkList.aspx?FS_PID=" + fs.FS_PID, true); } else if (rowAff == -1) { Alert("该友情链接分类名称已经存在,请重新输入!"); } } else { fs.FS_ID = int.Parse(Request.QueryString["FS_ID"].ToString()); fs.FS_PID = 0; rowAff = flk.Update(fs); if (rowAff >= 0) { Alert("修改友情链接分类成功!", "FriendLinkList.aspx?FS_PID=0", true); } else { Alert("修改友情链接分类失败,可选择重新操作!", "FriendLinkList.aspx", true); } } } else { fs.FS_PID = 0; rowAff = flk.Insert(fs, out fsid); if (rowAff >= 0) { Alert("添加友情链分类成功!","FriendLinkList.aspx",true); } else if (rowAff == -2) { Alert("添加友情链接分类失败!", "FriendLinkList.aspx", true); } else if (rowAff == -1) { Alert("该友情链接分类名称已经存在,请重新输入!"); } } }
/// <summary> /// 判断加载类别方法 /// </summary> private void PostType() { XYECOM.Business.FriendLinkSort flk = new XYECOM.Business.FriendLinkSort(); if (XYECOM.Core.XYRequest.GetQueryString("FS_ID") != "") { BindData(int.Parse(XYECOM.Core.XYRequest.GetQueryString("FS_ID"))); } }
/// <summary> /// 定义删除事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lnkDel_Click(object sender, EventArgs e) { string ids = ""; XYECOM.Business.FriendLinkSort fs = new XYECOM.Business.FriendLinkSort(); foreach (GridViewRow row in this.gvlist.Rows) { if (((CheckBox)(row.FindControl("chkExport"))).Checked == true) ids += "," + this.gvlist.DataKeys[row.DataItemIndex].Value.ToString(); } if (ids.IndexOf(",") == 0) ids = ids.Substring(1); int SonNum = fs.GetSonType(ids); if (SonNum <= 0) { int rowAff = fs.Delete(ids); if (rowAff >= 0) { Response.Redirect("FriendLinkList.aspx"); } else { Alert("删除成功!","FriendLinkList.aspx"); } } else { Alert("该类别下面还有子类别,请先删除子类别!"); } }
private void BindData(int flid) { string strWhere = "where FL_ID=" + flid; XYECOM.Business.FriendLink fl = new XYECOM.Business.FriendLink(); XYECOM.Business.FriendLinkSort fls = new XYECOM.Business.FriendLinkSort(); DataTable dt = fl.GetDataTable(strWhere, ""); if (dt.Rows.Count > 0) { if (Convert.ToBoolean(dt.Rows[0]["FL_Type"]) == false) { this.rbtext.Checked = true; this.tblinkfont.Text = dt.Rows[0]["FL_Font"].ToString(); } else { this.rbpic.Checked = true; if (dt.Rows[0]["Fl_Font"].ToString() != "Image") { this.rbpicurl.Checked = true; this.tbpicaddress.Text = dt.Rows[0]["FL_Font"].ToString(); } else { this.rbpicupload.Checked = true; } } this.tblinkrul.Text = dt.Rows[0]["FL_URL"].ToString(); this.tblinkalt.Text = dt.Rows[0]["FL_Alt"].ToString(); this.flsortid.Text = dt.Rows[0]["FS_ID"].ToString(); } }