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;
}