private void LoadData() { OrderManager orderManager = new OrderManager(); OrderDetailManager orderDetailManager = new OrderDetailManager(); AccountManager accountManager = new AccountManager(); DataTable dtOrder = new DataTable(); DataTable dtOrderDetail = new DataTable(); try { if (Request.QueryString["id"] != null) { int orderId = int.Parse(Request.QueryString["id"].ToString()); dtOrder = orderManager.Order_GetList(orderId); if (dtOrder != null && dtOrder.Rows.Count > 0) { DataRow drOrder = dtOrder.Rows[0]; lblOrderType.Text = accountManager.OrderType_GetName(int.Parse(drOrder["AccountTypeId"].ToString())); lblAccountType.Text = accountManager.AccountType_GetName(int.Parse(drOrder["AccountTypeId"].ToString())); lblAccountName.Text = accountManager.Account_GetName(int.Parse(drOrder["AccountId"].ToString())); lblOrderCode.Text = drOrder["OrderCode"].ToString(); lblTransportFee.Text = decimal.Parse(drOrder["TransportFee"].ToString()).ToString("#,##0"); lblNote.Text = drOrder["Note"].ToString(); dtOrderDetail = orderDetailManager.OrderDetail_GetList_OrderId(orderId); if (dtOrderDetail != null && dtOrderDetail.Rows.Count > 0) { //add row SUM DataRow sumRow; sumRow = dtOrderDetail.NewRow(); sumRow["OrderId"] = -1; sumRow["OrderDetailId"] = -1; sumRow["ProductId"] = -1; sumRow["Price"] = -1; sumRow["Quantity"] = dtOrderDetail.Compute("SUM(Quantity)", null); sumRow["Amount"] = dtOrderDetail.Compute("SUM(Amount)", null); sumRow["UnitTypeId"] = -1; sumRow["UnitValue"] = -1; sumRow["UnitId"] = -1; dtOrderDetail.Rows.Add(sumRow); gvData.DataSource = dtOrderDetail; gvData.DataBind(); gvData.Visible = true; ErrorBox.Message = string.Empty; } else { gvData.Visible = false; ErrorBox.Message = "Không có dữ liệu"; } } else { ErrorBox.Message = "Không có dữ liệu"; } } else { ErrorBox.Message = "Không lấy được dữ liệu"; } } catch (Exception ex) { SaveErrorLog(ex); ErrorBox.Message = "Lỗi chức năng"; } }
private void LoadData() { OrderManager orderManager = new OrderManager(); OrderDetailManager orderDetailManager = new OrderDetailManager(); AccountManager accountManager = new AccountManager(); DataTable dtOrder = new DataTable(); DataTable dtOrderDetail = new DataTable(); DataTable dtAccount = new DataTable(); decimal totalAmount = 0, totalQuanTity = 0; if (Request.QueryString["id"] != null) { int orderId = int.Parse(Request.QueryString["id"].ToString()); dtOrder = orderManager.Order_GetList(orderId); if (dtOrder != null && dtOrder.Rows.Count > 0) { DataRow drOrder = dtOrder.Rows[0]; int accountId = int.Parse(drOrder["AccountId"].ToString()); lblAccountName.Text = accountManager.Account_GetName(accountId); lblNote.Text = drOrder["Note"].ToString(); dtAccount = accountManager.Account_GetList(accountId); if (dtAccount != null && dtAccount.Rows.Count > 0) { lblAddress.Text = dtAccount.Rows[0]["Address"].ToString(); } dtOrderDetail = orderDetailManager.OrderDetail_GetList_OrderId(orderId); if (dtOrderDetail != null && dtOrderDetail.Rows.Count > 0) { foreach (DataRow row in dtOrderDetail.Rows) { totalQuanTity += decimal.Parse(row["Quantity"].ToString()); totalAmount += decimal.Parse(row["Amount"].ToString()); } //add row SUM DataRow sumRow; sumRow = dtOrderDetail.NewRow(); sumRow["OrderId"] = -1; sumRow["OrderDetailId"] = -1; sumRow["ProductId"] = -1; sumRow["Price"] = -1; sumRow["Quantity"] = totalQuanTity; sumRow["Amount"] = totalAmount; sumRow["UnitTypeId"] = -1; sumRow["UnitValue"] = -1; sumRow["UnitId"] = -1; dtOrderDetail.Rows.Add(sumRow); gvData.DataSource = dtOrderDetail; gvData.DataBind(); lblNumberWord.Text = MoneyToString(totalAmount); gvData.Visible = true; gvData.CssClass = gvData.CssClass.Replace("Label", ""); gvData.CssClass = gvData.CssClass.Replace("colunmHeader", ""); gvData.CssClass = gvData.CssClass.Replace("HlightRow", ""); gvData.CssClass = gvData.CssClass.Replace("Label", ""); } else { gvData.Visible = false; } } } }
private void LoadData() { OrderManager orderManager = new OrderManager(); OrderDetailManager orderDetailManager = new OrderDetailManager(); DataTable dtOrder = new DataTable("dtOrder"); DataTable dtOrderDetail = new DataTable("dtOrderDetail"); DataTable dt = new DataTable("dt"); try { if (Request.QueryString["id"] != null) { int orderId = int.Parse(Request.QueryString["id"].ToString()); dtOrder = orderManager.Order_GetList(orderId); if (dtOrder != null && dtOrder.Rows.Count > 0) { DataRow drOrder = dtOrder.Rows[0]; ddlAccountType.SelectedValue = drOrder["AccountTypeId"].ToString(); LoadAccount(int.Parse(ddlAccountType.SelectedValue)); txtOrderCode.Text = drOrder["OrderCode"].ToString(); ddlAccount.SelectedValue = drOrder["AccountId"].ToString(); txtTransportFee.Text = decimal.Parse(drOrder["TransportFee"].ToString()).ToString("#,##0"); txtNote.Text = drOrder["Note"].ToString(); dtOrderDetail = orderDetailManager.OrderDetail_GetList_OrderId(orderId); if (dtOrderDetail != null && dtOrderDetail.Rows.Count > 0) { dt = (DataTable)ViewState["dtOrderDetail"]; DataRow row; foreach (DataRow item in dtOrderDetail.Rows) { row = dt.NewRow(); row["ProductID"] = item["ProductID"]; row["Price"] = item["Price"]; row["Quantity"] = item["Quantity"]; row["Amount"] = item["Amount"]; row["UnitTypeId"] = item["UnitTypeId"]; row["UnitValue"] = item["UnitValue"]; row["UnitId"] = item["UnitId"]; dt.Rows.Add(row); } gvData.DataSource = dtOrderDetail; gvData.DataBind(); gvData.Visible = true; ErrorBox.Message = string.Empty; NotifyBox.Message = string.Empty; } else { gvData.Visible = false; ErrorBox.Message = "Không có dữ liệu"; NotifyBox.Message = string.Empty; } } else { ErrorBox.Message = "Không có dữ liệu"; NotifyBox.Message = string.Empty; } } else { ErrorBox.Message = "Không lấy được dữ liệu"; NotifyBox.Message = string.Empty; } } catch (Exception ex) { ErrorBox.Message = "Lỗi chức năng"; NotifyBox.Message = string.Empty; SaveErrorLog(ex); } }