/// <summary> /// 修改友情链接 /// </summary> /// <param name="LinkInfo">Model</param> /// <returns></returns> public bool ModfiyLink(Tz888.Model.Link.LinkInfoTab LinkInfo) { string sql = "update LinkInfoTab set ChannelId=@ChannelId,LinkId=@LinkId,LinkInfoName=@LinkInfoName,LinkUrl=@LinkUrl,Sort=@Sort,Logo=@Logo,Remarks=@Remarks where LinkInfoId=@LinkInfoId"; SqlParameter[] Paras = new SqlParameter[] { new SqlParameter("@ChannelId", SqlDbType.Int, 4), new SqlParameter("@LinkId", SqlDbType.Int, 4), new SqlParameter("@LinkInfoName", SqlDbType.NVarChar, 100), new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 200), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Logo", SqlDbType.NVarChar, 200), new SqlParameter("@Remarks", SqlDbType.NVarChar, 200), new SqlParameter("@LinkInfoId", SqlDbType.Int, 4) }; Paras[0].Value = LinkInfo.ChannelId; Paras[1].Value = LinkInfo.LinkId; Paras[2].Value = LinkInfo.LinkInfoName; Paras[3].Value = LinkInfo.LinkUrl; Paras[4].Value = LinkInfo.Sort; Paras[5].Value = LinkInfo.Logo; Paras[6].Value = LinkInfo.Remarks; Paras[7].Value = LinkInfo.LinkInfoId; int row = crm.ExecuteSql(sql, Paras); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加友情链接 /// </summary> /// <param name="LinkInfoTab">LinkInfoTab</param> /// <returns></returns> public bool AddLink(Tz888.Model.Link.LinkInfoTab Type) { string sql = "insert into LinkInfoTab(ChannelId,LinkId,LinkInfoName,LinkUrl,Sort,Logo,Remarks) " + "values(@ChannelId,@LinkId,@LinkInfoName,@LinkUrl,@Sort,@Logo,@Remarks)"; SqlParameter[] Paras = new SqlParameter[] { new SqlParameter("@ChannelId", SqlDbType.Int, 4), new SqlParameter("@LinkId", SqlDbType.Int, 4), new SqlParameter("@LinkInfoName", SqlDbType.NVarChar, 100), new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 200), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Logo", SqlDbType.NVarChar, 200), new SqlParameter("@Remarks", SqlDbType.NVarChar, 200) }; Paras[0].Value = Type.ChannelId; Paras[1].Value = Type.LinkId; Paras[2].Value = Type.LinkInfoName; Paras[3].Value = Type.LinkUrl; Paras[4].Value = Type.Sort; Paras[5].Value = Type.Logo; Paras[6].Value = Type.Remarks; int row = crm.ExecuteSql(sql, Paras); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改链接 /// </summary> /// <param name="LinkInfo">Model</param> /// <returns></returns> public bool ModfiyLink(Tz888.Model.Link.LinkInfoTab LinkInfo) { return(dal.ModfiyLink(LinkInfo)); }
/// <summary> /// 添加友情链接 /// </summary> /// <param name="LinkInfoTab">LinkInfoTab</param> /// <returns></returns> public bool AddLink(Tz888.Model.Link.LinkInfoTab LinkInfo) { return(dal.AddLink(LinkInfo)); }