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);
}
}