public IList<FriendLinkInfo> GetLinks(LinkItemType linkType) { SqlHelper objSqlHelper = new SqlHelper(); List<FriendLinkInfo> friendlinks = new List<FriendLinkInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@linkType", SqlDbType.Int, 4); objParams[0].Value = (int)linkType; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Link_GetLinks", objParams); ; objParams[0].Value = (int)linkType; while (reader.Read()) { FriendLinkInfo item = new FriendLinkInfo(); item.LinkID = reader.GetInt32(reader.GetOrdinal("linkID")); item.LinkName = reader.GetString(reader.GetOrdinal("linkName")); item.LinkURL = reader.GetString(reader.GetOrdinal("linkURL")); item.LinkLogo = reader.GetString(reader.GetOrdinal("linkLogo")); item.LinkOrder = reader.GetInt32(reader.GetOrdinal("linkOrder")); item.IsMain = reader.GetBoolean(reader.GetOrdinal("linkMain")); item.IsArrow = reader.GetBoolean(reader.GetOrdinal("linkArrow")); friendlinks.Add(item); } reader.Close(); return friendlinks; }
void dataBind() { string edit = Request.QueryString["edit"]; if (edit != null) { FriendLinkInfo f = new FriendLinkInfo(); f = FriendLink.GetLinkByID(int.Parse(edit)); LinkNameTxt.Text = f.LinkName; LinkIndexChk.Checked = f.IsMain; LinkUrlTxt.Text = f.LinkURL; LinkLogoTxt.Text = f.LinkLogo; LinkAddBtn.Text = "编辑"; } else { LinkAddBtn.Text = "新增"; } }
protected void LinkAddBtn_Click(object sender, EventArgs e) { string edit = Request.QueryString["edit"]; FriendLinkInfo f = new FriendLinkInfo(); f.LinkName = LinkNameTxt.Text; f.IsMain = LinkIndexChk.Checked; f.LinkURL = LinkUrlTxt.Text; f.LinkLogo = LinkLogoTxt.Text; if (edit != null) { f.LinkID = int.Parse(edit); FriendLink.UpdateLink(f); Response.Redirect("friendLink.aspx"); } else { FriendLink.InsertLink(InsertLinkType.Arrowed, f); Response.Redirect("friendLink.aspx"); } }
/// <summary> /// 获取特定链接 /// </summary> /// <returns></returns> public FriendLinkInfo GetLinkByID(int linkID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@LinkID", SqlDbType.Int, 4); objParams[0].Value = linkID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Link_GetLinkByID", objParams); FriendLinkInfo item = new FriendLinkInfo(); while (reader.Read()) { item.LinkID = reader.GetInt32(reader.GetOrdinal("linkID")); item.LinkName = reader.GetString(reader.GetOrdinal("linkName")); item.LinkURL = reader.GetString(reader.GetOrdinal("linkURL")); item.LinkLogo = reader.GetString(reader.GetOrdinal("linkLogo")); item.LinkOrder = reader.GetInt32(reader.GetOrdinal("linkOrder")); item.IsMain = reader.GetBoolean(reader.GetOrdinal("linkMain")); item.IsArrow = reader.GetBoolean(reader.GetOrdinal("linkArrow")); } reader.Close(); return item; }
/// <summary> /// 更新友情链接 /// </summary> /// <param name="link"></param> /// <returns></returns> public static int UpdateLink(FriendLinkInfo link) { return friendLink.UpdateLink(link); }
/// <summary> /// 添加友情链接 /// </summary> /// <param name="link"></param> public static void InsertLink(InsertLinkType linkType, FriendLinkInfo link) { friendLink.InsertLink(linkType, link); }
/// <summary> /// 添加友情链接 /// </summary> /// <param name="r"></param> public void InsertLink(InsertLinkType linkType, FriendLinkInfo f) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[6]; objParams[0] = new SqlParameter("@LinkName", f.LinkName); objParams[1] = new SqlParameter("@LinkURL", f.LinkURL); objParams[2] = new SqlParameter("@LinkLogo", StringHelper.convertStr(f.LinkLogo)); objParams[3] = new SqlParameter("@linkMain", f.IsMain); objParams[4] = new SqlParameter("@LinkAddDate", DateTime.Now); objParams[5] = new SqlParameter("@linkArrow", (int)linkType); ; objSqlHelper.ExecuteNonQuery("je_Link_InsertLink", objParams); }
/// <summary> /// 更新友情链接 /// </summary> /// <param name="item"></param> /// <returns></returns> public int UpdateLink(FriendLinkInfo f) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[5]; objParams[0] = new SqlParameter("@LinkName", f.LinkName); objParams[1] = new SqlParameter("@LinkURL", f.LinkURL); objParams[2] = new SqlParameter("@LinkLogo", StringHelper.convertStr(f.LinkLogo)); objParams[3] = new SqlParameter("@linkMain", f.IsMain); objParams[4] = new SqlParameter("@LinkID", f.LinkID); return objSqlHelper.ExecuteNonQuery("je_Link_UpdateLink", objParams); }