📄 remote.cs
字号:
strHtml.Append("<br>温馨提示：<br> 你的订单己生成，信息如下：");
strHtml.Append("</td></tr>");
strHtml.Append("</TABLE>");
strHtml.Append("<br>");
strHtml.Append("<TABLE width=\"600\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#0099cc\" id=\"tMyShoppingCart\">");
strHtml.Append("<TBODY>");
strHtml.Append("<TR class=shoppingcart-head align=center>");
strHtml.Append("<TD width=\"100\">定单号</TD>");
strHtml.Append("<TD width=\"200\">商品名称</TD>");
strHtml.Append("<TD width=\"100\">原价</TD>");
strHtml.Append("<TD width=\"100\">数量</TD>");
strHtml.Append("<TD width=\"100\">银卡小计</TD>");
strHtml.Append("</TR>");
return strHtml.ToString();
}
public static string getOrderEnd(ArrayList list,ArrayList num)
{
double count=0;
Data.BLL.BookData bll=new BookData();
Data.Model.BookData model=new Data.Model.BookData();
for(int i=0;i<list.Count;i++)
{
model=bll.getModel(list[i].ToString());
double price=model.mCheapPrice;
int number=int.Parse(num[i].ToString());
count=count+price*number;
}
StringBuilder strHtml=new StringBuilder();
strHtml.Append("<TR>");
strHtml.Append("<TD class=shoppingcart-subtotal-title colSpan=4> 购物总计:</TD>");
strHtml.AppendFormat("<TD align=center class=shoppingcart-subtotal>{0} 元</TD>",count);
strHtml.Append("</TR>");
strHtml.Append("</TBODY></TABLE>");
strHtml.Append("<TABLE width=\"600\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#0099cc\" id=\"tMyShoppingCart\">");
strHtml.Append("<tr><td align=right><br>");
strHtml.Append("注意：一个星期以内若货物没有收到，请及时与本书店联系，否则当己收到货处理。<br>");
strHtml.Append("</td></tr>");
strHtml.Append("<tr><td align=center><br>");
strHtml.Append("<a href=\"\" onclick=\"window.close();\">关闭</a>");
strHtml.Append("</td></tr>");
strHtml.Append("</TABLE>");
return strHtml.ToString();
}
#endregion
#region 生成定单
/// <summary>
/// 生成定单
/// </summary>
/// <param name="list">书本数据集</param>
/// <param name="num">数量数据集</param>
/// <param name="user">订购用户</param>
/// <returns></returns>
public static string CreateOrder(ArrayList list,ArrayList num,string user)
{
Data.BLL.Orders bll=new Orders();
Data.Model.Orders model=new Data.Model.Orders();
Data.BLL.BookData Book=new BookData();
Data.Model.BookData DataData=new Data.Model.BookData();
int OrderID=bll.getMaxOrderID()+1;
string cOrderID=Data.BLL.Remote.getOrderID(OrderID);
model.cOrderID=cOrderID;
model.cUserID=user;
model.dOrderDate=System.DateTime.Now;
for(int i=0;i<list.Count;i++)
{
model.cBookName=list[i].ToString();
model.iQuantity=int.Parse(num[i].ToString());
DataData=Book.getModel(list[i].ToString());
model.mPrice=DataData.mPrice;
model.mAllPrice=DataData.mPrice*int.Parse(num[i].ToString());
bll.add(model);
}
return cOrderID;
}
/// <summary>
/// 生成订单ID号
/// </summary>
/// <param name="OrderID"></param>
/// <returns></returns>
public static string getOrderID(int OrderID)
{
string cOrderID="000001";
if(OrderID<10)
{
cOrderID="00000"+OrderID.ToString();
}
else if(OrderID>=10&&OrderID<100)
{
cOrderID="0000"+OrderID.ToString();
}
else if(OrderID>=100&&OrderID<1000)
{
cOrderID="000"+OrderID.ToString();
}
else if(OrderID>=1000&&OrderID<10000)
{
cOrderID="00"+OrderID.ToString();
}
else if(OrderID>=10000&&OrderID<100000)
{
cOrderID="0"+OrderID.ToString();
}
else
{
cOrderID=OrderID.ToString();
}
return cOrderID;
}
#endregion
#region 订购成功,数据统一
public static bool ExecUpdate(ArrayList list,ArrayList num)
{
Data.BLL.BookData bll=new BookData();
Data.Model.BookData model=new Data.Model.BookData();
bool b=false;
for(int i=0;i<list.Count;i++)
{
model=bll.getModel(list[i].ToString());
model.iQuantity=model.iQuantity-int.Parse(num[i].ToString());
model.iSaleQty=model.iSaleQty+int.Parse(num[i].ToString());
if(bll.update(model))
{
b=true;
continue;
}
else
{
b=false;
break;
}
}
return b;
}
#endregion
#region 后台订单列表（显示在页面上）
/// <summary>
/// 后台订单列表
/// </summary>
/// <param name="count">每页显示的行数</param>
/// <param name="page">当前页数</param>
/// <returns>strHtml</returns>
public static string getOrderList(int count,int page)
{
Data.BLL.Orders bll=new Orders();
Data.Model.Orders model=new Data.Model.Orders();
ArrayList list=new ArrayList();
list=bll.getPrimaryKeyList();
ArrayList OrderIDlist=new ArrayList();
ArrayList BookNamelist=new ArrayList();
for(int i=0;i<list.Count;i++)
{
OrderIDlist.Add(list[i].ToString());
i++;
BookNamelist.Add(list[i].ToString());
}
int acount=list.Count/2;
int pages=(acount-1)/count+1;
StringBuilder strHtml=new StringBuilder();
strHtml.Append("<table width=\"778\" height=\"59\" border=\"0\" align=\"center\" bordercolor=\"#C0C0C0\" ID=\"Table2\">");
strHtml.Append("<tr bgcolor=\"#CCCCCC\">");
strHtml.Append("<td>订单号</td>");
strHtml.Append("<td>书名</td>");
strHtml.Append("<td>价格</td>");
strHtml.Append("<td>数量</td>");
strHtml.Append("<td>总价</td>");
strHtml.Append("<td>订购日期</td>");
strHtml.Append("<td>删除订单</td>");
strHtml.Append("</tr>");
for(int i=(page-1)*count;i<page*count&&i<acount;i++)
{
model=bll.getModel(OrderIDlist[i].ToString(),BookNamelist[i].ToString());
strHtml.Append("<tr bgcolor=\"#CCFFFF\">");
strHtml.AppendFormat("<td>{0}",model.cOrderID);
strHtml.Append("</td>");
strHtml.AppendFormat("<td>{0}",model.cBookName);
strHtml.Append("</td>");
strHtml.AppendFormat("<td>{0}",model.mPrice);
strHtml.Append("</td>");
strHtml.AppendFormat("<td>{0}",model.iQuantity);
strHtml.Append("</td>");
strHtml.AppendFormat("<td>{0}",model.mAllPrice);
strHtml.Append("</td>");
strHtml.AppendFormat("<td>{0}",model.dOrderDate.ToString("yyyy-MM-dd"));
strHtml.Append("</td>");
strHtml.Append("<td>");
strHtml.AppendFormat("<a href=\" ?cOrderID={0}&cBookName={1}\">删除</a>",model.cOrderID,System.Web.HttpUtility.UrlEncode(model.cBookName));
strHtml.Append("</td>");
strHtml.Append("</tr>");
}
strHtml.Append("<tr bgcolor=\"#99CCFF\"><td align=\"center\" colspan=7>");
strHtml.AppendFormat(" 第 {0} 页 ",page);
strHtml.AppendFormat(" 共 {0} 页 ",pages);
strHtml.AppendFormat("<a href=\" ?page=1\" style=\"text-decoration:none\"> 首页 </a>");
if(page>1)
{
strHtml.AppendFormat("<a href=\" ?page={0}\" style=\"text-decoration:none\"> 上一页 </a>",page-1);
}
for(int j=1;j<pages+1;j++)
{
strHtml.AppendFormat("<a href=\" ?page={0}\" style=\"text-decoration:none\"> {1} </a>",j,j);
}
if(page<pages)
{
strHtml.AppendFormat("<a href=\" ?page={0}\" style=\"text-decoration:none\"> 下一页 </a>",page+1);
}
strHtml.AppendFormat("<a href=\" ?page={0}\" style=\"text-decoration:none\"> 尾页 </a>",pages);
strHtml.Append("</td></tr>");
strHtml.Append("</table>");
return strHtml.ToString();
}
#endregion
#region 得到用户表列表
/// <summary>
/// 获得书本列表
/// </summary>
/// <param name="count">每页显示记录数</param>
/// <param name="page">显示页码</param>
/// <returns></returns>
public static string getUserList(int count,int page)
{
Data.BLL.Register bll=new Data.BLL.Register();
Data.Model.Register model=new Data.Model.Register();
ArrayList list=new ArrayList();
list=bll.getPrimaryKeyList();
int acount=list.Count;//总记录数
int pages=(acount-1)/count+1;//总页数
StringBuilder strHtml=new StringBuilder();
strHtml.Append("<table width=\"778\" height=\"78\" border=\"1\" align=\"center\" bordercolor=\"#c0c0c0\" ID=\"Table1\">");
for(int i=(page-1)*count;i<page*count&&i<acount;i++)
{
model=bll.getModel(list[i].ToString());
strHtml.Append("<tr bgcolor=\"#CCCCCC\">");
strHtml.Append("<td width=\"96\">用户名</td>");
strHtml.Append("<td width=\"96\">密码</td>");
strHtml.Append("<td width=\"36\" align=center>性别</td>");
strHtml.Append("<td>Eamil地址</td>");
strHtml.Append("<td>电话号码</td>");
strHtml.Append("<td>真实姓名</td>");
strHtml.Append("<td width=\"36\" align=center>年龄</td>");
strHtml.Append("<td>身份证号码</td>");
strHtml.AppendFormat("<td rowspan=3><a href=\"?id={0}\" align=center>删除用户</a></td>",model.cUserID);
// strHtml.Append("<td width=\"48\" rowspan=3><a href=\"AddUser.aspx\">添加</a></td>");
strHtml.Append("</tr>");
strHtml.AppendFormat("<tr bgcolor=\"#CCFFFF\"><td width=\"96\">{0}</td>",model.cUserID);
strHtml.AppendFormat("<td width=\"96\">{0}</td>",model.cPassword);
strHtml.AppendFormat("<td width=\"36\" align=center>{0}</td>",model.cSex);
strHtml.AppendFormat("<td>{0}</td>",model.cEmail);
strHtml.AppendFormat("<td>{0}</td>",model.cPhone);
strHtml.AppendFormat("<td>{0}</td>",model.cUserName);
strHtml.AppendFormat("<td width=\"36\" align=center>{0}</td>",model.iAge);
strHtml.AppendFormat("<td>{0}</td>",model.cDegreeNo);
// strHtml.Append("<td> </td>");
strHtml.Append("</tr><tr bgcolor=\"#CCFFFF\"><td>地址</td>");
strHtml.AppendFormat("<td colspan=7>{0}</td>",model.cAddress);
strHtml.Append("</tr>");
}
strHtml.Append("<tr bgcolor=\"#CCFFEE\">");
strHtml.Append("<td colspan=8> </td>");
strHtml.Append("<td align=center><a href=\"AddUser.aspx\">添加用户</a></td>");
strHtml.Append("</tr>");
strHtml.Append("</table>");
strHtml.Append("<TR bgcolor=\"#99CCFF\"><TD height=\"48\"><FORM action=# 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
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -