protected Boolean LoadData(int OrderID)
{
try
{
// Load Data For Page.
DAOrders daOrders = new DAOrders();
daOrders.USP_Orders_GetFullAllByID(OrderID);
//
fBillCustomer.InnerText = daOrders.fBillCustomer.ToString();
fBillPhone.InnerText = daOrders.fBillPhone.ToString();
fBillAddress.InnerText = daOrders.fBillAddress.ToString();
fShipCustomer.InnerText = daOrders.fShipCustomer.ToString();
fShipPhone.InnerText = daOrders.fShipPhone.ToString();
fShipAddress.InnerText = daOrders.fShipAddress.ToString();
lblBillCity.InnerText = daOrders.fBillDistrict.ToString() + ", " + daOrders.fBillProvince.ToString();
lblShipCity.InnerText = daOrders.fShipDistrict.ToString() + ", " + daOrders.fShipProvince.ToString();
fShippingName.InnerText = daOrders.fShippingName;
fPaymentName.InnerText = daOrders.fPaymentName;
fCustomer.InnerText = daOrders.fCustomerName;
fOrdersID.InnerText = daOrders.fID.ToString();
fSysDate.InnerText = daOrders.fSysDate.ToShortDateString();
fTotalPrice.InnerText = MyString.CurrencyFomat(daOrders.fTotalPrice);
fDiscount.InnerText = MyString.CurrencyFomat(daOrders.fDiscount);
fShippingPrice.InnerText = MyString.CurrencyFomat(daOrders.fShippingPrice);
fTotalNeedPay.InnerText = MyString.CurrencyFomat(daOrders.fTotalNeedPay);
}
catch
{
return(false);
}
return(true);
}
override protected int ExecInsert()
{
try
{
if (CreateOrUpdateCustomer())
{
DAOrders DAOrders = CreateObjectFromPage();
if (this.mode == ActParam.New)
{
DAOrders.fID = DAOrders.USP_GetKey();
this.KeyID = DAOrders.fID; // --> Update new SessionID for continue edit.
btPrintBill.Visible = true;
btPrintPacking.Visible = true;
btPrintBill.HRef = "~/Pages/Order/InvoiceTemplate/Bill.aspx?OrderID=" + this.KeyID.ToString();
btPrintPacking.HRef = "~/Pages/Order/InvoiceTemplate/Packing.aspx?OrderID=" + this.KeyID.ToString();
}
else
{
DAOrders.fID = 0;
}
// Tạo khách hàng trước ---> Nếu thành công mới tạo đơn hàng
DAOrders.USP_Orders_Insert();
return(1);
}
else
{
return(-1);
}
}
catch { return(0); }
}
override protected Boolean LoadData()
{
try
{
// Load Data For Page.
DAOrders daOrders = new DAOrders();
daOrders.USP_Orders_GetFullID(this.KeyID);
//
fOrderStatusID.Value = daOrders.fOrderStatusID.ToString();
fPaymentID.Value = daOrders.fPaymentID.ToString();
fShippingID.Value = daOrders.fShippingID.ToString();
fBillCustomer.Value = daOrders.fBillCustomer.ToString();
fBillPhone.Value = daOrders.fBillPhone.ToString();
fBillAddress.Value = daOrders.fBillAddress.ToString();
fBillProvinceID.SelectedValue = daOrders.fBillProvinceID.ToString();
fBillDistrictID.Value = daOrders.fBillDistrictID.ToString();
fShipCustomer.Value = daOrders.fShipCustomer.ToString();
fShipPhone.Value = daOrders.fShipPhone.ToString();
fShipAddress.Value = daOrders.fShipAddress.ToString();
fShipProvinceID.SelectedValue = daOrders.fShipProvinceID.ToString();
fShipDistrictID.Value = daOrders.fShipDistrictID.ToString();
fShipAddressNote.Value = daOrders.fShipAddressNote.ToString();
fNoteSaler.Value = daOrders.fNoteSaler.ToString();
fNoteCustomer.Value = daOrders.fNoteCustomer.ToString();
fCustomerID.SelectedValue = daOrders.fCustomerID.ToString();
fIPAddress.InnerText = daOrders.fIPAddress.ToString();
fTotalPrice.Value = daOrders.fTotalPrice;
fDiscount.Value = daOrders.fDiscount;
fShippingPrice.Value = daOrders.fShippingPrice;
fTotalNeedPay.Value = daOrders.fTotalNeedPay;
//
// Khi cần enabled cột nào
if (this.KeyID == 0)
{
fIPAddress.InnerText = "LocalHost";
btPrintBill.Visible = false;
btPrintPacking.Visible = false;
}
else
{
titleTotalPrice.InnerText = MyString.CurrencyFomat(daOrders.fTotalNeedPay) + " vnđ";
// Load OrderDetailt
LoadDataOrderDetailt();
LoadCustomerInfo(int.Parse(fCustomerID.SelectedValue));
btPrintBill.Visible = true;
btPrintPacking.Visible = false;
btPrintBill.HRef = "~/Pages/Order/InvoiceTemplate/Bill.aspx?OrderID=" + this.KeyID.ToString();
btPrintPacking.HRef = "~/Pages/Order/InvoiceTemplate/Packing.aspx?OrderID=" + this.KeyID.ToString();
}
}
catch (Exception e)
{
ShowErrorMes("Lỗi hệ thống: " + e.ToString());
return(false);
}
return(true);
}
override protected Boolean LoadData()
{
try
{
// Load Data For Page.
DAOrders daOrders = new DAOrders();
//daOrders.USP_Orders_GetFullAllByID(this.KeyID);
SqlDataReader mDataReader = daOrders.USP_Orders_GetByID_Reader(this.KeyID);
if (mDataReader.Read())
{
// Thong tin co ban
fID.InnerText = "#" + mDataReader["ID"].ToString();
fSysDate.InnerText = mDataReader["SysDate"].ToString();
fOrderStatus.InnerText = mDataReader["OrderStatus"].ToString();
// Thong tin khách hàng
fCustomer.InnerText = mDataReader["CustomerName"].ToString();
fEmail.InnerText = mDataReader["Email"].ToString();
fCustomerGroup.InnerText = mDataReader["CustomerGroup"].ToString();
fIPAddress.InnerText = mDataReader["IPAddress"].ToString();
fPayment.InnerText = mDataReader["Payment"].ToString();
fShipping.InnerText = mDataReader["Shipping"].ToString();
fBillCustomer.InnerText = mDataReader["BillCustomer"].ToString();
fBillPhone.InnerText = mDataReader["BillPhone"].ToString();
fBillAddress.InnerText = mDataReader["BillAddress"].ToString();
fBillProvince.InnerText = mDataReader["BillProvince"].ToString();
fBillDistrict.InnerText = mDataReader["BillDistrict"].ToString();
fShipCustomer.InnerText = mDataReader["ShipCustomer"].ToString();
fShipPhone.InnerText = mDataReader["ShipPhone"].ToString();
fShipAddress.InnerText = mDataReader["ShipAddress"].ToString();
fShipProvince.InnerText = mDataReader["ShipProvince"].ToString();
fShipDistrict.InnerText = mDataReader["ShipDistrict"].ToString();
fShipAddressNote.InnerText = mDataReader["ShipAddressNote"].ToString();
fNoteSaler.InnerText = mDataReader["NoteSaler"].ToString();
fNoteCustomer.InnerText = mDataReader["NoteCustomer"].ToString();
//fTotalPrice.InnerText = mDataReader["TotalPrice"].ToString();
//fDiscount.InnerText = mDataReader["Discount"].ToString();
//fShippingPrice.InnerText = mDataReader["ShippingPrice"].ToString();
//fTotalNeedPay.InnerText = mDataReader["TotalNeedPay"].ToString();
mDataReader.Close();
return(true);
}
else
{
mDataReader.Close();
}
//return false;
//
//fOrderStatusID.Value = daOrders.fOrderStatusID.ToString();
//fPaymentID.Value = daOrders.fPaymentID.ToString();
//fShippingID.Value = daOrders.fShippingID.ToString();
//fBillCustomer.InnerText = daOrders.fBillCustomer.ToString();
//fBillPhone.InnerText = daOrders.fBillPhone.ToString();
//fBillAddress.InnerText = daOrders.fBillAddress.ToString();
//fBillProvinceID.InnerText = daOrders.fBillProvinceID.ToString();
//fBillDistrictID.InnerText = daOrders.fBillDistrictID.ToString();
//fShipCustomer.InnerText = daOrders.fShipCustomer.ToString();
//fShipPhone.InnerText = daOrders.fShipPhone.ToString();
//fShipAddress.InnerText = daOrders.fShipAddress.ToString();
//fShipProvinceID.InnerText = daOrders.fShipProvinceID.ToString();
//fShipDistrictID.InnerText = daOrders.fShipDistrictID.ToString();
//fShipAddressNote.InnerText = daOrders.fShipAddressNote.ToString();
//fNoteSaler.InnerText = daOrders.fNoteSaler.ToString();
//fNoteCustomer.InnerText = daOrders.fNoteCustomer.ToString();
//fCustomer.InnerText = daOrders.fCustomerID.ToString();
//fIPAddress.InnerText = daOrders.fIPAddress.ToString();
//fTotalPrice.Value = daOrders.fTotalPrice.ToString();
//fDiscount.Value = daOrders.fDiscount.ToString();
//fShippingPrice.Value = daOrders.fShippingPrice.ToString();
//fTotalNeedPay.Value = daOrders.fTotalNeedPay.ToString();
//fSysDate.SelectedDate = daOrders.fSysDate;
//
// Khi cần enabled cột nào
//if (this.KeyID > 0)
//{
// if (mode != Act.Clone)
// fUserName.Enabled = false;
// else
// fUserName.Text = "";
//}
}
catch (Exception e)
{
ShowErrorMes("Lỗi hệ thống: " + e.ToString());
return(false);
}
return(true);
}
