/// <summary> /// 取得一個新訂單編號 /// </summary> /// <returns></returns> public string GetNewOrderID(string Track) { string NewID; StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OrderID from Sales_Order"); strSql.Append(" where OrderID like @OrderID "); strSql.Append(" order by OrderID Desc "); SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.Char,11)}; parameters[0].Value = Track+"%"; RedGlovePermission.Model.Sales_Order model = new RedGlovePermission.Model.Sales_Order(); DataSet ds=SqlServerHelper.Query(strSql.ToString(),parameters); if (ds.Tables[0].Rows.Count > 0) { NewID = (int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString().Substring(10, 3)) + 1001).ToString(); NewID = Track + NewID.Substring(NewID.Length - 3); } else { NewID = Track + "001"; } return NewID; }
/// <summary> /// 取得訂單細項編號 /// </summary> /// <param name="OID">訂單編號</param> /// <returns></returns> public string GetNewOrderSeq(string OID) { string NewSEQ; StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Seq from Sales_Order_DTL"); strSql.Append(" where OrderID = @OrderID "); strSql.Append(" order by Seq Desc "); SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.Char,13)}; parameters[0].Value = OID; RedGlovePermission.Model.Sales_Order model = new RedGlovePermission.Model.Sales_Order(); DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { NewSEQ = (int.Parse(ds.Tables[0].Rows[0]["SEQ"].ToString()) + 1).ToString(); } else { NewSEQ = "1"; } return NewSEQ; }
/// <summary> /// 得到一筆訂單資料 /// </summary> /// <param name="OrderID">訂單編號</param> /// <returns></returns> public RedGlovePermission.Model.Sales_Order GetOrderModel(string OrderID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from Sales_Order "); strSql.Append(" where OrderID=@OrderID "); SqlParameter[] parameters = { new SqlParameter("@OrderID", SqlDbType.Char,13)}; parameters[0].Value = OrderID; RedGlovePermission.Model.Sales_Order model = new RedGlovePermission.Model.Sales_Order(); DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { //if (ds.Tables[0].Rows[0]["MA001"].ToString() != "") //{ model.OrderID = ds.Tables[0].Rows[0]["OrderID"].ToString(); //} model.Order_Date = ds.Tables[0].Rows[0]["Order_Date"].ToString(); model.Company = ds.Tables[0].Rows[0]["Company"].ToString(); model.MA001 = ds.Tables[0].Rows[0]["MA001"].ToString(); model.CaseNo = ds.Tables[0].Rows[0]["CaseNo"].ToString(); model.Department = ds.Tables[0].Rows[0]["Department"].ToString(); model.TaxRate = float.Parse(ds.Tables[0].Rows[0]["TaxRate"].ToString()); model.Amount = float.Parse(ds.Tables[0].Rows[0]["Total"].ToString()); model.Tax = float.Parse(ds.Tables[0].Rows[0]["Tax"].ToString()); return model; } else { return null; } }
protected void gvChild_RowCommand(object sender, GridViewCommandEventArgs e) { GridViewRow gvr = (GridViewRow)((GridView)sender).NamingContainer; HiddenField _hfChildSearch = (HiddenField)gvr.FindControl("_hfChildSearch"); SqlDataSource dsChild = (SqlDataSource)gvr.FindControl("dsChild"); if (e.CommandName == "InsertNew") { //TextBox tbSeq = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbSeq"); TextBox tbMB001 = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbMB001"); TextBox tbFreeQty = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbFreeQty"); TextBox tbQty = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbQty"); TextBox tbUnitPrice = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbUnitPrice"); TextBox tbDiscount = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbDiscount"); //if (tbSeq != null) // dsChild.InsertParameters["Seq"].DefaultValue = tbSeq.Text; RedGlovePermission.Model.Basic_Companies model = new RedGlovePermission.Model.Basic_Companies(); model = bll.GetCCompanyModel(CompanyList.SelectedItem.ToString()); dsChild.InsertParameters["Seq"].DefaultValue = bllOrder.GetNewOrderSeq(gvr.Cells[5].Text); if (tbMB001 != null) dsChild.InsertParameters["MB001"].DefaultValue = tbMB001.Text; if (tbFreeQty != null) dsChild.InsertParameters["FreeQty"].DefaultValue = tbFreeQty.Text; if (tbQty != null) dsChild.InsertParameters["Qty"].DefaultValue = tbQty.Text; if (tbUnitPrice != null) dsChild.InsertParameters["unitPrice"].DefaultValue = tbUnitPrice.Text; if (tbDiscount != null) dsChild.InsertParameters["Discount"].DefaultValue = tbDiscount.Text; else dsChild.InsertParameters["Discount"].DefaultValue = "1"; dsChild.InsertParameters["OrderId"].DefaultValue = gvr.Cells[5].Text; UserSession user = SessionBox.GetUserSession(); dsChild.InsertParameters["CREATOR"].DefaultValue = user.LoginName.ToString(); dsChild.InsertParameters["CREATE_DATE"].DefaultValue = DateTime.Now.ToString("yyyyMMdd"); dsChild.Insert(); //處理單頭合計及稅額 if (bllOrder.OrderTotal(gvr.Cells[5].Text) == 0) ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_total_false") + "');", true); else { RedGlovePermission.Model.Sales_Order ordermodel = new RedGlovePermission.Model.Sales_Order(); ordermodel = bllOrder.GetOrderModel(gvr.Cells[5].Text); gvr.Cells[13].Text = ordermodel.Amount.ToString(); gvr.Cells[14].Text = ordermodel.Tax.ToString(); } ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_update_true") + "');", true); _hfChildSearch.Value = ""; BindChildData((GridView)sender); } if (e.CommandName == "InsertCancel") { _hfChildSearch.Value = ""; BindChildData((GridView)sender); } }
protected void gvChild_RowUpdated(object sender, GridViewUpdatedEventArgs e) { GridViewRow gvr = (GridViewRow)((GridView)sender).NamingContainer; //處理單頭合計及稅額 if (bllOrder.OrderTotal(gvr.Cells[5].Text) == 0) ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_total_false") + "');", true); else { RedGlovePermission.Model.Sales_Order ordermodel = new RedGlovePermission.Model.Sales_Order(); ordermodel = bllOrder.GetOrderModel(gvr.Cells[5].Text); gvr.Cells[13].Text = ordermodel.Amount.ToString(); gvr.Cells[14].Text = ordermodel.Tax.ToString(); } ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_update_true") + "');", true); }
protected void gvChild_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow gvr = (GridViewRow)((GridView)sender).NamingContainer; SqlDataSource dsChild = (SqlDataSource)gvr.FindControl("dsChild"); dsChild.DeleteParameters["OrderID"].DefaultValue = gvr.Cells[5].Text; dsChild.DeleteParameters["SEQM"].DefaultValue = ((GridView)sender).Rows[e.RowIndex].Cells[1].Text; dsChild.Delete(); //處理單頭合計及稅額 if (bllOrder.OrderTotal(gvr.Cells[5].Text) == 0) ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_total_false") + "');", true); else { RedGlovePermission.Model.Sales_Order ordermodel = new RedGlovePermission.Model.Sales_Order(); ordermodel = bllOrder.GetOrderModel(gvr.Cells[5].Text); gvr.Cells[13].Text = ordermodel.Amount.ToString(); gvr.Cells[14].Text = ordermodel.Tax.ToString(); } ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_delete_true") + "');", true); }