private void OrderGridView_MouseDoubleClick(object sender, MouseEventArgs e)
{
try{
if (MessageBox.Show("Are you sure to delete this order?", "Delete Order", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Connection c = new Connection();
dti = c.connect();
int index = OrderGridView.SelectedRows[0].Index;
string orderNumber = "SELECT orderID FROM orders WHERE orderID=\"" + OrderGridView[0, index].Value.ToString() + "\"";
int orderID = int.Parse(dti.getOneField(orderNumber));
string DeleteQuery = "DELETE FROM orders WHERE orderID=" + orderID;
string Deletequery = "DELETE FROM orderitems WHERE orderID="+orderID;
dti.executeDMQuery(DeleteQuery);
dti.close();
for (int i = 0; i < data.Rows.Count; i = i + 1)
{
DataRow row = data.Rows[i];
if (int.Parse(row["orderID"].ToString()) == orderID)
data.Rows.Remove(row);
}
OrderGridView.Rows.RemoveAt(index);
OrderGridView.Refresh();
}
}
catch(Exception ee)
{ }
}
} // 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 mtSend_Click(object sender, EventArgs e)
{
try{
if(OrderGridView.SelectedRows.Count>0){
if(MessageBox.Show("Are you sure to send out this order?", "Send Order", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Connection c = new Connection();
dti = c.connect();
int index = OrderGridView.SelectedRows[0].Index;
string orderNumber = "SELECT orderID FROM orders WHERE orderID=\"" + OrderGridView[0, index].Value.ToString() + "\"";
int orderID = int.Parse(dti.getOneField(orderNumber));
string sendQuery = "UPDATE orders SET shipped=1 WHERE orderID=\"" + OrderGridView[0, index].Value.ToString() + "\"";
dti.executeDMQuery(sendQuery);
for (int i = 0; i < data.Rows.Count; i = i + 1)
{
DataRow row = data.Rows[i];
if (int.Parse(row["orderID"].ToString()) == orderID)
data.Rows.Remove(row);
}
OrderGridView.DataSource = data;
OrderGridView.Refresh();
}
}
}
catch(Exception ee)
{ }
}
private void LoadProductionOrderColorAndSize()
{
DataTable dsProductionOrder = new DataTable();
dsProductionOrder.Columns.Add("COLSYSID", typeof(Int64));
dsProductionOrder.Columns.Add("COLNAME", typeof(string));
OrderGridView.Columns.Clear();
DataSet ds = ProjectFunctions.GetDataSet("sp_LoadProductionOrderColorAndSize '" + txtArtID.Text + "'");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
dsProductionOrder.Columns.Add(dr["SZDESC"].ToString().Trim());
}
int Count = 0;
OrderGridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn());
OrderGridView.Columns[Count].OptionsColumn.AllowEdit = false;
OrderGridView.Columns[Count].Visible = true;
OrderGridView.Columns[Count].Caption = "COLSYSID";
OrderGridView.Columns[Count].FieldName = "COLSYSID";
Count++;
OrderGridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn());
OrderGridView.Columns[Count].OptionsColumn.AllowEdit = false;
OrderGridView.Columns[Count].Visible = true;
OrderGridView.Columns[Count].Caption = "COLNAME";
OrderGridView.Columns[Count].FieldName = "COLNAME";
Count++;
foreach (DataRow dr in ds.Tables[0].Rows)
{
OrderGridView.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn());
OrderGridView.Columns[Count].OptionsColumn.AllowEdit = true;
OrderGridView.Columns[Count].Visible = true;
OrderGridView.Columns[Count].Caption = dr["SZDESC"].ToString();
OrderGridView.Columns[Count].FieldName = dr["SZSYSID"].ToString();
Count++;
}
if (dsProductionOrder.Rows.Count > 0)
{
OrderGrid.DataSource = dsProductionOrder;
OrderGridView.BestFitColumns();
}
else
{
OrderGrid.DataSource = null;
OrderGridView.BestFitColumns();
}
}
}
private void BindingOrderData()
{
try
{
List <DataAccessLayer.Modelo.Order> listOrder = logicData.GetOrderList();
OrderGridView.DataSource = listOrder;
OrderGridView.DataBind();
}
catch (Exception)
{
throw;
}
}
private void ArrangeGridViewColumns()
{
if (OrdersGridControl.DataSource != null)
{
OrderGridView.PopulateColumns();
// since the component has no idea of what is going to receive, we have to map and setup all by hand
// hide some columns
OrderGridView.Columns[nameof(CustomerOrder.FirstName)].Visible = false;
OrderGridView.Columns[nameof(CustomerOrder.LastName)].Visible = false;
OrderGridView.Columns[nameof(CustomerOrder.Id)].Visible = false;
OrderGridView.Columns[nameof(CustomerOrder.OrderId)].Visible = false;
// apply some formats
OrderGridView.Columns[nameof(CustomerOrder.OrderDate)].DisplayFormat.FormatType = FormatType.DateTime;
OrderGridView.Columns[nameof(CustomerOrder.OrderDate)].DisplayFormat.FormatString =
ConfigurationManager.AppSettings["DateFormat"];
OrderGridView.Columns[nameof(CustomerOrder.OrderValue)].DisplayFormat.FormatType = FormatType.Numeric;
OrderGridView.Columns[nameof(CustomerOrder.OrderValue)].DisplayFormat.FormatString =
ConfigurationManager.AppSettings["CurrencyFormat"];
// no edit on the columns
foreach (GridColumn gridColumn in OrderGridView.Columns)
{
if (TotalPages > 1)
{
gridColumn.SortMode = ColumnSortMode.Custom;
}
gridColumn.OptionsColumn.AllowEdit = false;
}
// add button
GridColumn unbColumn = OrderGridView.Columns.AddField("ShowCustomerDetail");
unbColumn.VisibleIndex = OrderGridView.Columns.Count;
unbColumn.OptionsFilter.AllowFilter = false;
unbColumn.OptionsColumn.ShowCaption = false;
unbColumn.OptionsColumn.AllowSort = DefaultBoolean.False;
unbColumn.UnboundType = UnboundColumnType.Decimal;
RepositoryItemButtonEdit edit = new RepositoryItemButtonEdit
{
TextEditStyle = TextEditStyles.HideTextEditor
};
edit.ButtonClick += ShowCustomerDetailClick;
edit.Buttons[0].Caption = "View Detail";
edit.Buttons[0].Kind = ButtonPredefines.Glyph;
OrderGridView.Columns["ShowCustomerDetail"].ColumnEdit = edit;
OrderGridView.Columns[_sortColumn].SortOrder = _sortDirection;
}
}
protected void ExportToExcel(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=orderreports.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
OrderGridView.AllowPaging = false;
this.BindGridView();
OrderGridView.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in OrderGridView.HeaderRow.Cells)
{
cell.BackColor = OrderGridView.HeaderStyle.BackColor;
}
foreach (GridViewRow row in OrderGridView.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = OrderGridView.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = OrderGridView.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
OrderGridView.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
public OrderForm()
{
InitializeComponent();
try{
c = new Connection();
dti = c.connect();
data = dti.getToDataTable("SELECT orders.orderID, orders.buyer, orders.orderDate FROM orders, orderitems, warehouse WHERE warehouse.itemNumber=orderitems.itemID AND orders.orderID=orderitems.orderID AND orders.shipped=0 GROUP BY orders.orderDate");
OrderGridView.DataSource = data;
OrderGridView.Columns["orderID"].Visible = false;
OrderGridView.Columns["orderDate"].Width = 270;
OrderGridView.Columns["orderDate"].HeaderText = "Order Date";
OrderGridView.Columns["buyer"].HeaderText = "Buyer Name";
OrderGridView.Refresh();
}
catch(Exception ee)
{ }
}
/// <summary>
/// Opens the popup for the customer edition
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void ShowCustomerDetailClick(object sender, ButtonPressedEventArgs e)
{
try
{
ShowLoadingPanel();
CustomerOrder obj = (CustomerOrder)OrderGridView.GetRow(OrderGridView.FocusedRowHandle);
// we call the editor cloning the object as we only want to update the record after we have updated the database (for heavy data sources)
// or in the end of the method, we could just reload the grid's data source
CustomerDetail dlg =
new CustomerDetail(obj.Clone())
{
StartPosition = FormStartPosition.CenterParent
};
// ok?
if (dlg.ShowDialog() == DialogResult.OK)
{
// invoke repository
PersistenceResult result = await _repository.SaveCustomerInfoAsync(dlg.CustomerOrder);
if (result.Success)
{
// In this case we have a simple situation, just replace
obj.FirstName = dlg.CustomerOrder.FirstName;
obj.LastName = dlg.CustomerOrder.LastName;
OrderGridView.UpdateCurrentRow();
MessageBox.Show("Record successfully saved!");
}
else
{
MessageBox.Show("An error has occurred when trying dto save the record");
}
}
dlg = null;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
HideLoadingPanel();
}
}
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>";
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
OrderGridView.AutoResizeColumns();
OrderDetailGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
private void mtRefresh_Click(object sender, EventArgs e)
{
data = dti.getToDataTable("SELECT orders.orderID, orders.buyer, orders.orderDate FROM orders, orderitems, warehouse WHERE warehouse.itemNumber=orderitems.itemID AND orders.orderID=orderitems.orderID AND orders.shipped=0 GROUP BY orders.orderDate");
OrderGridView.DataSource = data;
OrderGridView.Refresh();
}
