private void BindOrderDetailData() { DataTable myTable = orderDetailBLL.GetData("orderNumber ='" + orderNumber + "'"); StringBuilder sb = new StringBuilder(); foreach (DataRow dr in myTable.Rows) { sb.Append("<tr>"); ClassLibrary.Model.Routes route = routeBLL.GetModel(Convert.ToInt32(dr["routeID"])); string tmpClassPy = routeClassBll.GetModel(Convert.ToInt32(route.LocationID)).ClassNamePY; sb.AppendFormat("<td><a href='{3}/{2}/{0}.html' target='_blank'>{1}</a></td>", dr["routeID"].ToString(), dr["RouteName"].ToString(), tmpClassPy, SysConfig.webSite); string[] temp = dr["Number"].ToString().Split(','); sb.AppendFormat("<td>{0}</td>", temp[0] + "大" + temp[1] + "小"); sb.AppendFormat("<td>{0}</td>", (Convert.ToInt32(dr["RoutePrice"]) == 0 ? "价格电讯" : "¥" + 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 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(); }