private void BindOrderDetailData()
{
DataTable myTable = orderDetailBLL.GetData(" orderNumber ='" + orderNumber + "'");
myTable = pg.pagination(myTable, 20, "");
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
ClassLibrary.Model.Routes route = routeBLL.GetModel(Convert.ToInt32(dr["routeID"]));
string tmpClassPy = routeClassBll.GetModel(Convert.ToInt32(route.LocationID)).ClassNamePY;
sb.AppendFormat("<td><a href='/{2}/{1}.html' target='_blank'>{0}</a></td>", dr["RouteName"].ToString(), dr["routeID"].ToString(), tmpClassPy);
string[] temp = dr["Number"].ToString().Split(',');
sb.AppendFormat("<td>{0}</td>", temp[0] + "大" + temp[1] + "小");
//sb.AppendFormat("<td><input id='price_{0}' type='text' size='10' value='{1}' /><input type='button' class='button' value='修改' onclick='UpdateOrderDetailPrice({0},{2})' /></td>", dr["ID"].ToString(), Convert.ToInt32(dr["RoutePrice"]), dr["ordernumber"].ToString());
sb.AppendFormat("<td>¥{0}元</td>", Convert.ToInt32(dr["RoutePrice"]));
sb.AppendFormat("<td>{0}</td>", dr["RouteTime"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["StartTime"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["CreatedTime"].ToString());
sb.Append("</tr>");
}
dataOrderDetailList = sb.ToString();
}
private void BindData(string sql)
{
DataTable myTable = routeCommentBLL.GetData(sql);
myTable = pg.pagination(myTable, 20, "");
pageInfo = pg.pageNumList;
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.AppendFormat("<tr id='tr_{0}'>", dr["ID"].ToString());
ClassLibrary.Model.Routes rmodel = routeBLL.GetModel(Convert.ToInt32(dr["routeId"]));
string tmpClassPy = rcList.Find(delegate(ClassLibrary.Model.RouteClass rcm) { return(rcm.ID == rmodel.LocationID); }).ClassNamePY;
sb.AppendFormat("<td><a href='/{2}/{1}.html' target='_blank'>{0}</a></td>", Function.Clip(GetRoute(Convert.ToInt32(dr["routeID"])), 10, true), Convert.ToInt32(dr["routeID"]), tmpClassPy);
sb.AppendFormat("<td>{0}</td>", Convert.ToInt16(dr["Grade"].ToString()));
sb.AppendFormat("<td>{0}</td>", dr["UserName"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["Nickname"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["Email"].ToString());
sb.AppendFormat("<td>{0}</td>", Convert.ToBoolean(dr["Checked"]) ? "<span class='green'>是</span>" : "<span class='red'>否</span>");
sb.AppendFormat("<td>{0}</td>", dr["CreatedTime"].ToString());
sb.Append("<td>");
if (!Convert.ToBoolean(dr["Checked"]))
{
sb.AppendFormat("<a href='RouteCommentList.aspx?ID={0}'>审核</a> ", dr["ID"].ToString());
}
else
{
sb.Append(" ");
}
sb.AppendFormat("<a href='RouteCommentDetail.aspx?id={0}'>查看</a> ", dr["ID"].ToString());
sb.AppendFormat("<a href='javascript:void(0)' onclick='routeCommentDelete({0})'>删除</a>", dr["ID"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
dataRouteCommentList = sb.ToString();
}
private void BindData()
{
DataTable myTable = ordersBLL.GetData("");
myTable = pg.pagination(myTable, 20, "");
pageInfo = pg.pageNumList;
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in myTable.Rows)
{
sb.AppendFormat("<tr id='tr_{0}'>", dr["OrderNumber"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["OrderNumber"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["UserName"].ToString());
string[] temp = dr["proQuantity"].ToString().Split(',');
sb.AppendFormat("<td>{0}</td>", temp[0] + "大" + temp[1] + "小");
sb.AppendFormat("<td>¥{0}元</td>", Convert.ToInt32(dr["proTotalPrice"]));
sb.AppendFormat("<td>{0}</td>", dr["Linkman"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["ContractType"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["Payment"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["Status"].ToString());
sb.AppendFormat("<td>{0}</td>", dr["CreatedTime"].ToString());
sb.Append("<td>");
sb.AppendFormat("<a href='OrdersDetail.aspx?id={0}'>查看</a> ", dr["OrderNumber"].ToString());
if (dr["Status"].ToString() == "未处理")
{
sb.AppendFormat("<a href='javascript:void(0)' onclick='ordersDelete({0})'>删除</a>", dr["OrderNumber"].ToString());
}
sb.Append("</td>");
sb.Append("</tr>");
}
dataOrdersList = sb.ToString();
}