public string GetView() { ChangeHope.WebPage.DataView dv = new ChangeHope.WebPage.DataView(); dv.Sql = "[select] * [from] MemberRank [where] 1=1 [order by] Priority asc"; dv.RowHead = "序号/5%,徽标/5%,等级名称/30%,打折率/10%,积分上限/10%,积分下限/10%,升级金额/10%,操作/30%"; dv.RowText = "{0}$@allnum,<img src='/{0}'/>$LogoPic,Name,{0}%$Discount,{0}点积分$MinScore,{0}点积分$MaxScore,{0}元人民币$UpgradeMoney,<a href='?id={0}' onclick='return confirm(\"是否真的要删除?\\n删除后将不能恢复该数据\")'>删除</a> <a href='member_rank_edit.aspx?id={0}'>编辑</a>$Id"; string view = dv.GetView(); dv = null; return(view); }
public string GetList() { ChangeHope.WebPage.DataView dataview = new ChangeHope.WebPage.DataView(); dataview.Sql = "[select] *,(select top 1 loginintime from yxs_adminloginlog where adminname=yxs_administrators.name order by id desc)as logintime,(select top 1 loginip from yxs_adminloginlog where adminname=yxs_administrators.name order by id desc)as loginip [from] yxs_administrators [where] 1=1 [order by] state,adminid asc"; dataview.RowHead = "序号/5%,管理员帐号/10%,最后登陆时间/15%,最后登陆IP/10%,是否冻结/10%,开始管理时间/15%,管理过期时间/15%,操作/20%"; dataview.RowText = "{0}$@allnum,name,logintime,loginip,<script>GetStat('{0}');</script>$state,managebegintime,manageendtime,<a href='admin_edit.aspx?adminid={0}'>编辑</a> <a href='?action=del&adminid={0}' onclick=\"return confirm('是否删除该数据')\">删除</a><script>OtherAction('{0}—{1}—{2}—{3}—{4}—{5}')</script>$adminid|OfficePhone|HomePhone|MobilePhone|LoginAuthenticationOfficePhone|QQ"; string view = dataview.GetView(); dataview = null; return(view); }
/// <summary> /// 暂时屏蔽删除 /// <a href='javascript:void(0)' onclick='Del({0})'>删除</a> /// </summary> /// <returns></returns> public string GetList() { string chanelid = ChangeHope.WebPage.PageRequest.GetString("q_chanelid"); ChangeHope.WebPage.DataView dataview = new ChangeHope.WebPage.DataView(); dataview.RowHead = "序号/5%,频道名称/10%,描述/45%,是否系统频道/15%,操作/25%"; dataview.Sql = "[select] * [from] yxs_ArticleChannel [where] Id like '" + chanelid + "%' and LEN(Id) =" + (chanelid.Length + 3) + " [order by] Id asc"; dataview.RowText = "{0}$@allnum,<a href=?q_chanelid={1}>{0}</a>$Name|Id,Description,Shop,<a href='articlechannel_edit.aspx?id={0}'>编辑</a> <a href='javascript:void(0)' onclick='Del({0})'>删除</a> $Id"; string view = dataview.GetView(); dataview = null; return view; }
public string GetView() { ChangeHope.WebPage.DataView dv = new ChangeHope.WebPage.DataView(); dv.Sql = "[select] * [from] yxs_MemberRank [where] 1=1 [order by] Priority asc"; dv.RowHead = "序号/5%,徽标/5%,等级名称/30%,打折率/10%,积分上限/10%,积分下限/10%,升级金额/10%,操作/30%"; dv.RowText = "{0}$@allnum,<img src='/{0}'/>$LogoPic,Name,{0}%$Discount,{0}点积分$MinScore,{0}点积分$MaxScore,{0}元人民币$UpgradeMoney,<a href='?id={0}' onclick='return confirm(\"是否真的要删除?\\n删除后将不能恢复该数据\")'>删除</a> <a href='member_rank_edit.aspx?id={0}'>编辑</a>$Id"; string view = dv.GetView(); dv = null; return view; }
public string GetListForTable() { ChangeHope.WebPage.DataView dataview = new ChangeHope.WebPage.DataView(); dataview.RowHead = "序号/5%,标题/40%,发布人/10%,更新时间/15%,状态/5%,所属频道/10%,操作/20%"; dataview.RowText = "{0}$@allnum,<a href='article_read.aspx?id={0}'>{1}</a>$id|@sub#Title#30,Users,UpdateTime,<img src='../images/{0}.gif' />$State,ChannelContent,<a href=article_edit.aspx?id={0}>编辑</a> <a href='javascript:void(0)' onclick='Del({0})'>删除</a>$id"; string view = dataview.GetView(dal.GetList("")); dataview = null; return view; }
public string GetList() { ChangeHope.WebPage.DataView dataview = new ChangeHope.WebPage.DataView(); dataview.Sql = "[select] *,(select top 1 LogininTime from Adminloginlog where AdminName=Administrators.Name order by ID desc)as LoginTime,(select top 1 LoginIP from Adminloginlog where AdminName=Administrators.Name order by ID desc)as LoginIP [from] Administrators [where] 1=1 [order by] AdminID asc"; dataview.RowHead = "序号/5%,管理员帐号/10%,最后登陆时间/15%,最后登陆IP/10%,是否冻结/10%,开始管理时间/15%,管理过期时间/15%,操作/20%"; dataview.RowText = "{0}$@AllNum,Name,LoginTime,LoginIP,<script>GetStat('{0}');</script>$State,ManageBeginTime,ManageEndTime,<a href='admin_edit.aspx?adminid={0}'>编辑</a> <a href='?action=del&adminid={0}' onclick=\"return confirm('是否删除该数据')\">删除</a>$AdminID"; string view= dataview.GetView(); dataview = null; return view; }