protected void Show_Send_Back(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Order_Number.Text)) { try { int order_id = int.Parse(Order_Number.Text); string sqlstr = " select o.order_id,format(o.create_time,'yyyy-MM-dd HH:mm:ss') create_time,sum((p.price * od.qty)) total from order_form o "; sqlstr += " join order_detail od on o.order_id = od.order_id "; sqlstr += " join product p on p.prod_id = od.prod_id "; sqlstr += " where o.status != 6 and o.order_id = " + order_id; sqlstr += " group by o.order_id,o.create_time "; orderTable = myDatabase.GetDataTable(sqlstr); Send_Back_Grid.DataSource = orderTable; Send_Back_Grid.DataBind(); orderTable.Rows.Clear(); Order_Item_Detail_Grid.DataSource = orderTable; Order_Item_Detail_Grid.DataBind(); if (orderTable.Rows.Count == 0) { //showResMessage("查詢失敗,單號已退單或不存在,請重新查詢。"); } } catch (Exception) { showResMessage("單號內容有誤,請重新輸入"); } } else { showResMessage("請輸入單號"); } }
protected void Complete_Order(object sender, EventArgs e) { Button completeButton = (Button)sender; String order_id = (string)completeButton.CommandArgument; string sqlStr = " update order_form set status = 19 , complete_time = getDate() where order_form.order_id = " + order_id; myDatabase.execSQL(sqlStr); Order_View(sender, e); orderTable = null; Order_Item_Detail_Grid.DataSource = orderTable; Order_Item_Detail_Grid.DataBind(); }
protected void Sumbit_Order(object sender, EventArgs e) { if (DialogClass.MessageChickSimple("確定此筆訂單已完成?", MessageBoxButton.OKCancel)) { Button sumbitButton = (Button)sender; String order_id = (string)sumbitButton.CommandArgument; string sqlStr = " update order_form set status = 4 , end_time = getDate() where order_form.order_id = " + order_id; myDatabase.execSQL(sqlStr); orderTable.Rows.Clear(); Order_Item_Detail_Grid.DataSource = orderTable; Order_Item_Detail_Grid.DataBind(); Order_View(sender, e); } }
protected void Order_Detail_View(object sender, EventArgs e) { Button viewButton = (Button)sender; String order_id = (string)viewButton.CommandArgument; string sqlStr = " select product.prod_ch_name, " + " product.size, " + " dbo.getOptionNameById(" + Constant.OPTION_TYPE_SUGER + ",sugur_type) as sugur, " + " dbo.getOptionNameById(" + Constant.OPTION_TYPE_ICE + ",ice_type)as ice,qty from order_detail " + " join product on product.prod_id = order_detail.prod_id " + " where order_detail.order_id = " + order_id; orderTable = myDatabase.GetDataTable(sqlStr); Order_Item_Detail_Grid.DataSource = orderTable; Order_Item_Detail_Grid.DataBind(); }
protected void Send_Back(object sender, EventArgs e) { Button button = (Button)sender; int order_id = int.Parse((string)button.CommandArgument); try { string sqlstr = " update order_form set status = 6 , end_time = getdate()"; sqlstr += " where order_id = " + order_id; myDatabase.execSQL(sqlstr); showResMessage("設定成功"); Show_Send_Back(sender, e); orderTable.Rows.Clear(); Order_Item_Detail_Grid.DataSource = orderTable; Order_Item_Detail_Grid.DataBind(); } catch (Exception) { showResMessage("單號內容有誤,請重新輸入"); } }