📄 remote.cs
字号:
}
for(int j=1;j<pages+1;j++)
{
strHtml.AppendFormat("<a href=\" ?page={0}{1}\"> {2} </a>",j,param,j);
}
if(page<pages)
{
strHtml.AppendFormat("<a href=\" ?page={0}{1}\"> 下一页 </a>",page+1,param);
}
strHtml.AppendFormat("<a href=\" ?page={0}{1}\"> 尾页 </a>",pages,param);
strHtml.Append("</DIV></FORM></TD></TR>");
return strHtml.ToString();
}
public static string getField(int id)
{
string cFieldName="";
if(id==1)
{
cFieldName="cEditor";
}
else if(id==2)
{
cFieldName="cPublisher";
}
else if(id==3)
{
cFieldName="cBookType";
}
else if(id==4||id==5||id==6)
{
cFieldName="cStatus";
}
else if(id==7)
{
cFieldName="cISBN";
}
else if(id==8)
{
cFieldName="cBookName";
}
return cFieldName;
}
/// <summary>
/// 在后台书本列表获得书本列表
/// </summary>
/// <param name="count">每页显示和行数</param>
/// <param name="page">当前的页数</param>
/// <returns></returns>
public static string getBookList(int count,int page)
{
Data.BLL.BookData bll=new BookData();
Data.Model.BookData model=new Data.Model.BookData();
ArrayList list=new ArrayList();
list=bll.getPrimaryKeyList();
int acount=list.Count;//记录数
int pages=(acount-1)/count+1;//页数
StringBuilder strHtml=new StringBuilder();
strHtml.Append("<TR><TD width=\"593\"><DIV align=center><TABLE height=130 cellSpacing=0 cellPadding=0 width=768 border=0><TBODY>");
strHtml.Append("<tr bgcolor=\"#CCCCCC\"><td align=center colspan=4><a href=\"AddBook.aspx\" height=36> 点击添加新图书 </a></td></tr>");
for(int i=(page-1)*count;i<page*count&&i<acount;i++)
{
model=bll.getModel(list[i].ToString());
string Description=model.cDescription.ToString().Trim();
if(Description.Length>80)
{
Description=Description.Substring(0,80)+"...";
}
string Editor="";
string BookName="";
string Publisher="";
string Status="";
Editor=model.cEditor.ToString().Trim();
BookName=model.cBookName.ToString().Trim();
Publisher=model.cPublisher.ToString().Trim();
Status=model.cStatus.ToString().Trim();
if(Editor.Length>6)
{
Editor=Editor.Substring(0,6)+"...";
}
if(BookName.Length>6)
{
BookName=BookName.Substring(0,6)+"...";
}
if(Publisher.Length>6)
{
Publisher=Publisher.Substring(0,6)+"...";
}
if(Status=="N")
{
Status="新书上市";
}
else if(Status=="T")
{
Status="精品推荐";
}
else if(Status=="F")
{
Status="销售排行";
}
strHtml.Append("<TR>");
strHtml.Append("<TD class=xuxian width=111 rowSpan=5><DIV align=center>");
strHtml.Append("<TABLE height=125 width=\"100%\" background=\"\" border=0>");
strHtml.Append("<TBODY>");
strHtml.Append("<TR>");
strHtml.Append("<TD><DIV align=center>");
strHtml.AppendFormat("<IMG src=\"{0}\" alt=\"{1}\" width=84 height=113 border=0 align=top></DIV></TD>",model.cImagePath,model.cBookName);
strHtml.Append("</TR>");
strHtml.Append("</TBODY>");
strHtml.Append("</TABLE>");
strHtml.Append("</DIV></TD>");
strHtml.AppendFormat("<TD width=138 height=20><DIV align=left><FONT color=#6699cc size=2 title=\"{0}\">书名：",model.cBookName);
strHtml.AppendFormat("{0}</FONT></DIV></TD>",BookName);
strHtml.Append("<TD width=138 height=20><DIV align=left><FONT color=#6699cc size=2>ISBN：");
strHtml.AppendFormat("{0}</FONT></DIV></TD>",model.cISBN);
strHtml.AppendFormat("<TD class=xuxian vAlign=top width=271 rowSpan=5><DIV align=left><p><FONT title=\"{0}\"color=#6699cc size=2>简介：{1}</FONT></p>",model.cDescription,Description);
strHtml.Append("<table width=\"251\" border=\"0\">");
strHtml.Append("<tr>");
strHtml.Append("<td width=\"245\" height=\"33\"><FONT color=#6699cc size=2>");
strHtml.AppendFormat("<a href=\"UpdateBook.aspx?name={0}\"><IMG src=\"Images/update1.gif\" alt=\"shopcart\" width=37 height=17 border=0> </a>",System.Web.HttpUtility.UrlEncode(model.cBookName));
strHtml.AppendFormat("<a href=\"?cid=D&page={0}&id={1}\"><IMG src=\"Images/gwc_bt_delete.gif\" alt=\"shopcart\" width=37 height=17 border=0> </a>",page,System.Web.HttpUtility.UrlEncode(model.cBookName));
strHtml.Append("</FONT></td>");
strHtml.Append("</tr>");
strHtml.Append("</table>");
strHtml.Append("</DIV></TD>");
strHtml.Append("</TR>");
strHtml.Append("<TR>");
strHtml.AppendFormat("<TD width=138 height=20><DIV align=left><FONT color=#6699cc size=2>定价：{0} </FONT></DIV></TD>",model.mPrice);
strHtml.AppendFormat("<TD width=138 height=20><DIV align=left><FONT color=#6699cc size=2>类型：{0} </FONT></DIV></TD>",model.cBookType);
strHtml.Append("</TR>");
strHtml.Append("<TR>");
strHtml.AppendFormat("<TD width=138 height=20><DIV align=left><FONT color=#6699cc size=2>折扣价格：{0} </FONT></DIV></TD>",model.mCheapPrice);
strHtml.AppendFormat("<TD width=138 height=20><DIV align=left><FONT color=#6699cc size=2>库存量：{0} </FONT></DIV></TD>",model.iQuantity);
strHtml.Append("</TR>");
strHtml.Append("<TR>");
strHtml.AppendFormat("<TD width=138 height=20><DIV align=left><FONT title=\"{0}\" color=#6699cc size=2>作者：{1} </FONT></DIV></TD>",model.cEditor,Editor);
strHtml.AppendFormat("<TD width=138 height=20><DIV align=left><FONT color=#6699cc size=2>销售量：{0} </FONT></DIV></TD>",model.iSaleQty);
strHtml.Append("</TR>");
strHtml.Append("<TR>");
strHtml.AppendFormat("<TD class=\"xuxian\" width=138 height=20><DIV align=left><FONT title=\"{0}\" color=#6699cc size=2>出版：{1} </FONT></DIV></TD>",model.cPublisher,Publisher);
strHtml.AppendFormat("<TD class=\"xuxian\" width=138 height=20><DIV align=left><FONT color=#6699cc size=2>状态：{0} </FONT></DIV></TD>",Status);
strHtml.Append("</TR>");
}
strHtml.Append("</TBODY></TABLE></DIV></TD></TR>");
strHtml.Append("<TR><TD height=\"48\"><FORM action=nlist.asp method=get><DIV align=center>");
strHtml.AppendFormat(" 第 {0} 页 ",page);
strHtml.AppendFormat(" 共 {0} 页 ",pages);
strHtml.AppendFormat("<a href=\" ?page=1\"> 首页 </a>");
if(page>1)
{
strHtml.AppendFormat("<a href=\" ?page={0}\"> 上一页 </a>",page-1);
}
for(int j=1;j<pages+1;j++)
{
strHtml.AppendFormat("<a href=\" ?page={0}\"> {1} </a>",j,j);
}
if(page<pages)
{
strHtml.AppendFormat("<a href=\" ?page={0}\"> 下一页 </a>",page+1);
}
strHtml.AppendFormat("<a href=\" ?page={0}\"> 尾页 </a>",pages);
strHtml.Append("</DIV></FORM></TD></TR>");
return strHtml.ToString();
}
#endregion
#region 书本详细信息
public static string getBookDetails(string BookName)
{
StringBuilder strHtml=new StringBuilder();
Data.BLL.BookData bll=new BookData();
Data.Model.BookData model=new Data.Model.BookData();
model=bll.getModel(BookName.ToString().Trim());
strHtml.Append("<table width=\"579\" height=\"454\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"tline\">");
strHtml.Append("<tr class=\"hang\">");
strHtml.Append("<td width=\"266\" height=\"263\" class=\"lie\"><div align=\"center\">");
strHtml.AppendFormat("<img src=\"{0}\" width=\"193\" height=\"223\">",model.cImagePath);
strHtml.Append("</div></td>");
strHtml.Append("<td width=\"314\">");
strHtml.Append("<table width=\"310\" height=\"264\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
strHtml.Append("<tr class=\"hang\">");
strHtml.AppendFormat("<td class=\"hang\">作者：{0}</td>",model.cEditor);
strHtml.Append("</tr>");
strHtml.Append("<tr class=\"hang\">");
strHtml.AppendFormat("<td class=\"hang\">价格：{0}</td>",model.mPrice);
strHtml.Append("</tr>");
strHtml.Append("<tr class=\"hang\">");
strHtml.AppendFormat("<td class=\"hang\">库存量：{0}</td>",model.iQuantity);
strHtml.Append("</tr>");
strHtml.Append("<tr class=\"hang\">");
strHtml.AppendFormat("<td class=\"hang\">ISBN：{0}</td>",model.cISBN);
strHtml.Append("</tr>");
strHtml.Append("<tr class=\"hang\">");
strHtml.AppendFormat("<td class=\"hang\">出版社：{0}</td>",model.cPublisher);
strHtml.Append("</tr>");
strHtml.Append("<tr class=\"hang\">");
strHtml.AppendFormat("<td class=\"hang\">销售量：{0}</td>",model.iSaleQty);
strHtml.Append("</tr>");
strHtml.Append("</table></td></tr>");
strHtml.Append("<tr><td height=\"177\" colspan=\"2\"><table width=\"577\" height=\"225\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
strHtml.Append("<tr>");
strHtml.AppendFormat("<td class=\"lie\">{0}</td>",model.cDescription);
strHtml.Append("</tr>");
strHtml.Append("</table></td></tr></table>");
return strHtml.ToString();
}
#endregion
#region 后台管理员列表
public static string getManagerList(string ManagerName)
{
StringBuilder strHtml=new StringBuilder();
Data.BLL.Manager bll=new Manager();
Data.Model.Manager model=new Data.Model.Manager();
ArrayList list=new ArrayList();
strHtml.Append("<tr bgcolor=\"#CCCCCC\">");
strHtml.Append("<td>管理员ID</td>");
strHtml.Append("<td>真实姓名</td>");
strHtml.Append("<td>电话号码</td>");
strHtml.Append("<td>Email</td>");
strHtml.Append("<td>Zip</td>");
strHtml.Append("<td>操作</td>");
strHtml.Append("</tr>");
string bgcolor="";
if(ManagerName.Equals("Admin"))
{
list=bll.getPrimaryKeyList();
bgcolor="bgcolor=#99ff00";
for(int i=0;i<list.Count;i++)
{//在列表中删除超级管理员
if(list[i].ToString().Trim().Equals("Admin"))
{
list.RemoveAt(i);
}
}
for(int i=0;i<list.Count;i++)
{
model=bll.getModel(list[i].ToString());
strHtml.Append("<tr bgcolor=\"#CCFFFF\">");
strHtml.AppendFormat("<td>{0}</td>",model.cManagerID);
strHtml.AppendFormat("<td>{0}</td>",model.cManagerName);
strHtml.AppendFormat("<td>{0}</td>",model.cPhone);
strHtml.AppendFormat("<td>{0}</td>",model.cEmail);
strHtml.AppendFormat("<td>{0}</td>",model.cZip);
strHtml.AppendFormat("<td><a href=\" ?cid=D&name={0}\">删除管理员</a></td>",System.Web.HttpUtility.UrlEncode(model.cManagerID));
strHtml.Append("</tr>");
}
}
model=bll.getModel(ManagerName);
strHtml.AppendFormat("<tr {0} bgcolor=\"#CCFFFF\">",bgcolor);
strHtml.AppendFormat("<td>{0}</td>",model.cManagerID);
strHtml.AppendFormat("<td>{0}</td>",model.cManagerName);
strHtml.AppendFormat("<td>{0}</td>",model.cPhone);
strHtml.AppendFormat("<td>{0}</td>",model.cEmail);
strHtml.AppendFormat("<td>{0}</td>",model.cZip);
strHtml.Append("<td><a href=\"UpdateManager.aspx\">更新</a></td>");
strHtml.Append("</tr>");
if(ManagerName.Equals("Admin"))
{
strHtml.Append("<tr bgcolor=\"#99CCFF\"><td colspan=5></td><td><a href=\"AddManager.aspx\">添加管理员</a></td></tr>");
}
return strHtml.ToString();
}
#endregion
#region 后台反馈消息列表
public static string getFeedBackList(int count,int page,string cStatus)
{
StringBuilder strHtml=new StringBuilder();
Data.BLL.Feedback bll=new Feedback();
Data.Model.Feedback model=new Data.Model.Feedback();
ArrayList list=new ArrayList();
list=bll.getPrimaryKeyList(cStatus);
int pages=(list.Count-1)/count+1;//页数
if(cStatus=="未处理")
{
strHtml.Append("<tr bgcolor=\"#CCCCCC\"><td colspan=5 align=\"center\"><a href=\" ?id=Y&page=1\">点击显示己处理反馈</a></td></tr>");
}
else
{
strHtml.Append("<tr bgcolor=\"#CCCCCC\"><td colspan=5 align=\"center\"><a href=\" ?id=N&page=1\">点击显示未处理反馈</a></td></tr>");
}
for(int i=(page-1)*count;i<page*count&&i<list.Count;i++)
{
model=bll.getModel(list[i].ToString());
strHtml.Append("<tr bgcolor=\"#CCFFFF\">");
strHtml.Append("<td width=\"72\">反馈号</td>");
strHtml.AppendFormat("<td width=\"96\">{0}</td>",model.cID.ToString().Trim());
strHtml.Append("<td width=\"72\" rowspan=\"4\">反馈消息</td>");
strHtml.AppendFormat("<td width=\"256\"rowspan=\"4\">{0}</td>",model.cMessage.ToString().Trim());
strHtml.Append("<td width=\"72\"> </td>");
strHtml.Append("</tr>");
strHtml.Append("<tr bgcolor=\"#CCFFFF\">");
strHtml.Append("<td>用户ID</td>");
strHtml.AppendFormat("<td>{0}</td>",model.cUserID.ToString().Trim());
strHtml.AppendFormat("<td><a href=\" ?cid=D&name={0}\">删除反馈</a></td>",model.cID);
strHtml.Append("</tr>");
strHtml.Append("<tr bgcolor=\"#CCFFFF\">");
strHtml.Append("<td>反馈时间</td>");
strHtml.AppendFormat("<td>{0}</td>",model.dDateTime.ToString("yyyy-MM-dd"));
if(cStatus=="未处理")
{
strHtml.AppendFormat("<td><a href=\" ?cid=U&name={0}\">修改状态</a></td>",model.cID);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -