} // BindMenuGridView
#endregion
// order history
#region Bind Order GridView
private void BindOrderGridView()
{
DataTable dt = new DataTable();
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["OrderistaConnectionString"].ConnectionString);
try
{
connection.Open();
SqlCommand cmd = new SqlCommand("SELECT Orders.OrderID, Min(Order_Items.RestaurantName) AS RestaurantName, MIN(CreationTime) AS CreationTime, "
+ "MIN(Semitotal) AS Subtotal, Min(Taxes) AS Tax, MIN(ServiceCharge) AS ServiceFee, MIN(Total) AS Total, MIN(Orders.Status) AS Status "
+ "FROM Orders, Order_Items WHERE Orders.CentennialEmail = @username "
+ "AND Orders.OrderID = Order_Items.OrderID GROUP BY Orders.OrderID");
cmd.Parameters.AddWithValue("@username", Session["username"]);
cmd.Connection = connection;
SqlDataAdapter sqlData = new SqlDataAdapter(cmd);
sqlData.Fill(dt);
if (dt.Rows.Count > 0)
{
OrderGridView.DataSource = dt;
OrderGridView.DataBind();
}
}
catch (SqlException ex)
{
string msg = "Fetch Error: ";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
connection.Close();
}
}
private void BindingOrderData()
{
try
{
List <DataAccessLayer.Modelo.Order> listOrder = logicData.GetOrderList();
OrderGridView.DataSource = listOrder;
OrderGridView.DataBind();
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["MemberID"] != null && Request.IsAuthenticated)
{
string MemberID = Session["MemberID"].ToString(); // 获取当前用户 ID
MemberInfoFormViewSqlDataSource.SelectCommand = string.Format("Select * from VIP_INFO where VipID='{0}'", MemberID);
string sqlSelectVipStr = string.Format("Select * from VIP_INFO where VipID='{0}'", MemberID);
SqlDataReader sqlSelectVipStrDataReader = DataBase.GetDataReader(sqlSelectVipStr);
if (sqlSelectVipStrDataReader.Read())
{
if (sqlSelectVipStrDataReader["Province"] == "" || sqlSelectVipStrDataReader["City"] == "" || sqlSelectVipStrDataReader["Postcode"] == "" || sqlSelectVipStrDataReader["Address"] == "" || sqlSelectVipStrDataReader["Telephone"] == "")
{
MsgLabel.Text = "请输入您的收货信息。";
OrderButton.Visible = false;
}
else
{
OrderButton.Visible = true;
}
}
DataTable mydt = new DataTable();
if (Session[CartTableName] != null)
{
mydt = (DataTable)Session[CartTableName];
OrderGridView.DataSource = mydt;
OrderGridView.DataBind();
}
else
{
Response.Redirect("../Product/ProductList.aspx");
}
}
else
{
Response.Redirect("../Member/Login.aspx");
}
for (int i = 0; i < OrderGridView.Rows.Count; i++)
{
AllTotal += Convert.ToDecimal(OrderGridView.Rows[i].Cells[1].Text) * Int32.Parse(OrderGridView.Rows[i].Cells[2].Text);
}
OrderGridView.FooterRow.Cells[0].Text = "商品总价：" + AllTotal.ToString();
}
private void OrderGridViewDataBind()
{
if (selectedTable.Rows.Count == 0)
{
supplierlist.Enabled = true;
clearbutton.Visible = false;
createOrderButton.Enabled = false;
}
else
{
supplierlist.Enabled = false;
clearbutton.Visible = true;
createOrderButton.Enabled = true;
}
OrderGridView.DataSource = selectedTable;
OrderGridView.DataBind();
}
protected void Open_Click(object sender, EventArgs e)
{
var controller = new ReceivingController();
controller.ClearUnOrderedItems();
UnorderedListView.DataSourceID = "UnorderedODS";
if (OrderListDropDown.SelectedIndex > 0)
{
var vendorinfo = controller.GetVendorContact(int.Parse(OrderListDropDown.SelectedValue));
CompanyName.Text = vendorinfo.Name;
CompanyAddress.Text = vendorinfo.Address;
CompanyContact.Text = vendorinfo.Contact;
CompanyPhone.Text = vendorinfo.Phone;
var iteminfo = controller.GetOrderDetails(int.Parse(OrderListDropDown.SelectedValue));
OrderGridView.DataSource = iteminfo;
OrderGridView.DataBind();
ReceiveShimpment.Visible = true;
UnorderedLabel.Visible = true;
UnorderedListView.Visible = true;
ForceClose.Visible = true;
Comments.Visible = true;
}
else
{
CompanyName.Text = null;
CompanyAddress.Text = null;
CompanyContact.Text = null;
CompanyPhone.Text = null;
OrderGridView.DataSource = null;
OrderGridView.DataBind();
ReceiveShimpment.Visible = false;
UnorderedLabel.Visible = false;
UnorderedListView.Visible = false;
ForceClose.Visible = false;
Comments.Visible = false;
}
}
private void BindGridView()
{
SqlConnection con = new SqlConnection(_ConnStr);
con.Open();
SqlCommand cmd = new SqlCommand("select ORD_Number,ORD_Date,ORD_SQ_RFQ_Number,ORD_SQ_RFQ_Company,ORD_SQ_RFQ_OriginCountry,ORD_SQ_RFQ_DestinationCountry,ORD_SQ_RFQ_OriginAirport,ORD_SQ_RFQ_DestinationAirport,ORD_SQ_RFQ_NumberofPackages,ORD_SQ_RFQ_TotalChwt,ORD_SQ_RFQ_Commodity,ORD_SQ_BuyerCurrency,ORD_SellerCurrency from Orders where ORD_Date between @fromdate and @todate and ORD_SQ_RFQ_Company = @company", con);
cmd.Parameters.AddWithValue("@company", dropdowncustomer.SelectedItem.Text);
cmd.Parameters.AddWithValue("@fromdate", Convert.ToDateTime(txtfromorderdate.Text));
cmd.Parameters.AddWithValue("@todate", Convert.ToDateTime(txttoorderdate.Text));
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
OrderGridView.DataSource = ds;
OrderGridView.DataBind();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
OrderGridView.DataSource = orderBll.GetOrderList();
OrderGridView.DataBind();
/*
* List<ClassInfo> clsList = clsBll.GetClassList();
* StringBuilder sbOpts = new StringBuilder();
* foreach (ClassInfo cls in clsList)
* {
* //这个班级作为默认选项
* if (stu.ClassId == cls.Id)
* {
* sbOpts.Append("<option value='" + cls.Id + "'selected='selected'>" + cls.Name + "</option>");
* }
* else
* {
* sbOpts.Append("<option value='" + cls.Id + "'>" + cls.Name + "</option>");
* }
*
* }
* html = html.Replace("{@stuClass}", sbOpts.ToString());
*/
List <ProductInfo> proInfo = proBll.GetProductList();
StringBuilder sbOpts = new StringBuilder();
foreach (ProductInfo cls in proInfo)
{
if (ops.Length == 0)
{
ops = "<option selected='selected'>请选择你要的商品</option>";
}
else
{
ops += "<option value='" + cls.cName + "'>" + cls.cName + "</option>";
}
}
}
