protected void grdBookingDetail_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView grdBookingDetail = (ASPxGridView)sender;
CriteriaOperator filter = new BinaryOperator("PurchaseInvoiceInventoryTransactionId", Guid.Parse(Session["InventoryTransactionId"].ToString()), BinaryOperatorType.Equal);
XPCollection <PurchaseInvoiceInventoryAccountingTransaction> purchaseInvoiceTransaction = new XPCollection <PurchaseInvoiceInventoryAccountingTransaction>(session, filter);
if (purchaseInvoiceTransaction.Count > 0)
{
foreach (PurchaseInvoiceInventoryAccountingTransaction item in purchaseInvoiceTransaction)
{
if (item.RowStatus == ROW_NOT_DELETE)
{
grdBookingDetail.CancelEdit();
return;
}
}
}
ASPxSpinEdit c = (ASPxSpinEdit)grdBookingDetail.FindEditRowCellTemplateControl((GridViewDataColumn)grdBookingDetail.Columns["Credit"], "colBookingDetailCredit");
e.NewValues["Credit"] = c.Value.ToString();
c = (ASPxSpinEdit)grdBookingDetail.FindEditRowCellTemplateControl((GridViewDataColumn)grdBookingDetail.Columns["Debit"], "colBookingDetailDebit");
e.NewValues["Debit"] = c.Value.ToString();
}
private void OnLoad()
{
string salesman = SafeValue.SafeString(Request.QueryString["Salesman"].ToString());
int start = 0;
int end = 5000;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox id = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "txt_Id") as ASPxTextBox;
ASPxLabel product = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Product"], "lbl_ProductCode") as ASPxLabel;
ASPxLabel lotNo = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["LotNo"], "lbl_LotNo") as ASPxLabel;
ASPxSpinEdit qty = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty"], "spin_Qty") as ASPxSpinEdit;
ASPxSpinEdit price = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Price"], "spin_Price") as ASPxSpinEdit;
//ASPxComboBox location = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn)this.ASPxGridView1.Columns["Location"], "cmb_Location") as ASPxComboBox;
ASPxLabel des1 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Des1"], "lbl_Description") as ASPxLabel;
ASPxComboBox cmb_SalesId = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Salesman"], "cmb_SalesId") as ASPxComboBox;
ASPxSpinEdit hanQty = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["HanQty"], "spin_HandQty") as ASPxSpinEdit;
if (id != null && isPay != null && isPay.Checked && product != null)
{
list.Add(new Record("", product.Text, lotNo.Text, SafeValue.SafeInt(qty.Text, 0), SafeValue.SafeDecimal(price.Text, 0), "", des1.Text, "", SafeValue.SafeInt(hanQty, 0)));
}
else if (id == null)
{
break;
}
;
}
}
private void OnLoad()
{
int start = 0;
int end = 10000;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox skuId = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "txt_Id") as ASPxTextBox;
ASPxSpinEdit price = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Price"], "spin_Price") as ASPxSpinEdit;
ASPxSpinEdit qty1 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty1"], "spin_Qty1") as ASPxSpinEdit;
//ASPxSpinEdit qty2 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn)this.ASPxGridView1.Columns["Qty2"], "spin_Qty2") as ASPxSpinEdit;
//ASPxSpinEdit qty3 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn)this.ASPxGridView1.Columns["Qty3"], "spin_Qty3") as ASPxSpinEdit;
if (skuId != null && isPay != null && isPay.Checked)
{
list.Add(new Record(skuId.Text, SafeValue.SafeInt(qty1.Value, 0), 0, 0, SafeValue.SafeDecimal(price.Value, 0), ""
));
}
else if (skuId == null)
{
break;
}
;
}
}
private void OnLoad()
{
int start = 0;
int end = 5000;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox sku = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["ProductCode"], "txt_Product") as ASPxTextBox;
ASPxTextBox lotNo = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["LotNo"], "txt_LotNo") as ASPxTextBox;
ASPxSpinEdit qty = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty1"], "spin_Qty1") as ASPxSpinEdit;
ASPxLabel location = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Location"], "lbl_Location") as ASPxLabel;
ASPxLabel des = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Description"], "txt_Description") as ASPxLabel;
ASPxLabel wh = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["WareHouse"], "txt_WareHouse") as ASPxLabel;
ASPxLabel doNo = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["DoNo"], "txt_DoNo") as ASPxLabel;
ASPxComboBox fromWh = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["ToWarehouseId"], "cmb_WareHouse") as ASPxComboBox;
ASPxComboBox toLoc = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["ToLocId"], "cmb_Location") as ASPxComboBox;
if (sku != null && isPay != null && isPay.Checked)
{
list.Add(new Record(sku.Text, lotNo.Text, SafeValue.SafeInt(qty.Value, 0), location.Text, wh.Text, des.Text, doNo.Text
, fromWh.Text, toLoc.Text));
}
else if (sku == null)
{
break;
}
;
}
}
private void OnLoad()
{
int start = 0;
int count = this.grid.VisibleRowCount;
int end = count;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Product"], "ack_IsPay") as ASPxCheckBox;
ASPxLabel sku = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Product"], "txt_Product") as ASPxLabel;
ASPxLabel lotNo = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["LotNo"], "txt_LotNo") as ASPxLabel;
ASPxTextBox txt_Id = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Product"], "txt_Id") as ASPxTextBox;
ASPxSpinEdit spin_NewQty = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["NewQty"], "spin_NewQty") as ASPxSpinEdit;
if (spin_NewQty != null)
{
int qty = SafeValue.SafeInt(spin_NewQty.Value, 0);
if (qty > 0)
{
isPay.Checked = true;
if (txt_Id != null && isPay != null && isPay.Checked && qty > 0)
{
list.Add(new Record(txt_Id.Text, qty, sku.Text, lotNo.Text));
}
}
else if (txt_Id == null)
{
break;
}
;
}
}
}
protected void grdBookingDetail_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grdBookingDetail = (ASPxGridView)sender;
CriteriaOperator filter = new BinaryOperator("SalesInvoiceId", Guid.Parse(Session["SaleBillId"].ToString()), BinaryOperatorType.Equal);
XPCollection <SaleInvoiceTransaction> saleInvoiceTransaction = new XPCollection <SaleInvoiceTransaction>(session, filter);
if (saleInvoiceTransaction.Count > 0)
{
foreach (SaleInvoiceTransaction item in saleInvoiceTransaction)
{
if (item.RowStatus == ROW_NOT_DELETE)
{
grdBookingDetail.CancelEdit();
return;
}
}
}
e.NewValues["TransactionId!Key"] = ((ASPxGridView)sender).GetMasterRowKeyValue();
e.NewValues["GeneralJournalId"] = Guid.NewGuid();
ASPxSpinEdit c = (ASPxSpinEdit)grdBookingDetail.FindEditRowCellTemplateControl((GridViewDataColumn)grdBookingDetail.Columns["Credit"], "colBookingDetailCredit");
e.NewValues["Credit"] = c.Value.ToString();
c = (ASPxSpinEdit)grdBookingDetail.FindEditRowCellTemplateControl((GridViewDataColumn)grdBookingDetail.Columns["Debit"], "colBookingDetailDebit");
e.NewValues["Debit"] = c.Value.ToString();
}
protected void gvStudents_CellEditorInitialize(object sender, DevExpress.Web.ASPxGridViewEditorEventArgs e)
{
if (e.Column.Name == "examsMarks")
{
ASPxSpinEdit ts = (ASPxSpinEdit)e.Editor; ts.MaxValue = int.Parse(new InstanceConfigServices().GetConfig("examshigerscore"));
}
}
private void OnLoad()
{
int start = 0;
int end = 10000;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox id = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "txt_Id") as ASPxTextBox;
ASPxTextBox sku = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Code"], "txt_Product") as ASPxTextBox;
ASPxTextBox lotNo = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["LotNo"], "txt_LotNo") as ASPxTextBox;
ASPxSpinEdit qty1 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty1"], "spin_Qty") as ASPxSpinEdit;
//ASPxSpinEdit qty2 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn)this.ASPxGridView1.Columns["Qty2"], "spin_Qty2") as ASPxSpinEdit;
//ASPxSpinEdit qty3 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn)this.ASPxGridView1.Columns["Qty3"], "spin_Qty3") as ASPxSpinEdit;
if (sku != null && isPay != null && isPay.Checked)
{
list.Add(new Record(id.Text, sku.Text, lotNo.Text, SafeValue.SafeInt(qty1.Value, 0)
));
}
else if (sku == null)
{
break;
}
;
}
}
private void OnLoad()
{
int start = 0;
int end = count;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox id = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "txt_Id") as ASPxTextBox;
ASPxLabel txt_ContNo = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContNo"], "lbl_ContNo") as ASPxLabel;
ASPxLabel lbl_JobNo = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["JobNo"], "lbl_JobNo") as ASPxLabel;
ASPxLabel lbl_ContType = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContType"], "lbl_ContType") as ASPxLabel;
ASPxSpinEdit spin_Price = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Price"], "spin_Price") as ASPxSpinEdit;
ASPxSpinEdit spin_Qty = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Qty"], "spin_Qty") as ASPxSpinEdit;
ASPxTextBox txt_Unit = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Unit"], "txt_Unit") as ASPxTextBox;
ASPxTextBox txt_GroupBy = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["GroupBy"], "txt_GroupBy") as ASPxTextBox;
if (id != null && isPay != null && isPay.Checked)
{
list.Add(new Record(SafeValue.SafeInt(id.Text, 0), lbl_JobNo.Text, "", "", SafeValue.SafeDecimal(spin_Price.Value), SafeValue.SafeDecimal(spin_Qty.Value), txt_Unit.Text, txt_GroupBy.Text));
}
else if (id == null)
{
break;
}
}
}
private void OnLoad()
{
int start = 0;
int end = 10000;
for (int i = start; i < end; i++)
{
ASPxTextBox Id = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "txt_Id") as ASPxTextBox;
ASPxCheckBox isPay = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxLabel sku = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Code"], "txt_Product") as ASPxLabel;
ASPxSpinEdit price = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Price"], "spin_Price") as ASPxSpinEdit;
ASPxTextBox lotNo = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["LotNo"], "txt_LotNo") as ASPxTextBox;
ASPxSpinEdit qty1 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty1"], "spin_Qty1") as ASPxSpinEdit;
ASPxSpinEdit qty2 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty2"], "spin_Qty2") as ASPxSpinEdit;
ASPxSpinEdit qty3 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty3"], "spin_Qty3") as ASPxSpinEdit;
ASPxLabel location = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Location"], "lbl_Location") as ASPxLabel;
ASPxLabel des = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Des1"], "lbl_Description") as ASPxLabel;
ASPxLabel palletNo = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["PalletNo"], "lbl_PalletNo") as ASPxLabel;
ASPxLabel remark = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Remark"], "lbl_Remark") as ASPxLabel;
ASPxLabel handQty = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["HandQty"], "txt_HandQty") as ASPxLabel;
if (sku != null && isPay != null && isPay.Checked)
{
list.Add(new Record(SafeValue.SafeInt(Id.Text, 0), sku.Text, lotNo.Text, SafeValue.SafeInt(qty1.Value, 0), 0
, location.Text, SafeValue.SafeString(des.Text), SafeValue.SafeString(palletNo.Text), SafeValue.SafeString(remark.Text), SafeValue.SafeInt(handQty.Text, 0)));
}
else if (sku == null)
{
break;
}
;
}
}
private void OnLoad()
{
int start = 0;
int end = 200;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox partyId = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["PartyId"], "txt_PartyId") as ASPxTextBox;
ASPxTextBox sku = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Product"], "txt_Product") as ASPxTextBox;
ASPxTextBox des = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Description"], "txt_Description") as ASPxTextBox;
ASPxSpinEdit price1 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Price1"], "spin_Price1") as ASPxSpinEdit;
ASPxDateEdit fromDate = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["FromDate"], "txt_FromDate") as ASPxDateEdit;
if (partyId != null && sku != null && des != null && price1 != null && fromDate != null && isPay != null && isPay.Checked)
{
list.Add(new Record(partyId.Text, sku.Text, des.Text, SafeValue.SafeDecimal(price1.Value, 0), fromDate.Date
));
}
else if (sku == null)
{
break;
}
;
}
}
/// <summary>
/// cập nhật số lượng hay giá tiền
/// </summary>
private void BatchUpdate()
{
txtKhachThanhToan.Text = "0";
int MaHoaDon = tabControlSoHoaDon.ActiveTabIndex;
string IDKho = Session["IDKho"].ToString();
for (int i = 0; i < gridChiTietHoaDon.VisibleRowCount; i++)
{
int STT = Convert.ToInt32(gridChiTietHoaDon.GetRowValues(i, "STT"));
var exitHang = DanhSachHoaDon[MaHoaDon].ListChiTietHoaDon.FirstOrDefault(item => item.STT == STT);
int IDHangHoa = exitHang.IDHangHoa;
object SoLuong = gridChiTietHoaDon.GetRowValues(i, "SoLuong");
object DonGiaCu = gridChiTietHoaDon.GetRowValues(i, "DonGia");
object DoDayCu = dtHangHoa.LayDoDayHienTai(IDHangHoa);//gridChiTietHoaDon.GetRowValues(i, "DoDay");
ASPxSpinEdit spineditSoLuong = gridChiTietHoaDon.FindRowCellTemplateControl(i, (GridViewDataColumn)gridChiTietHoaDon.Columns["SoLuong"], "txtSoLuongChange") as ASPxSpinEdit;
ASPxSpinEdit spineditDonGia, spineditDoDay;
object GiaMoi = 0, DoDayMoi = 0;
object SoLuongMoi = spineditSoLuong.Value;
if (Session["IDNhom"].ToString() == "1")
{
spineditDonGia = gridChiTietHoaDon.FindRowCellTemplateControl(i, (GridViewDataColumn)gridChiTietHoaDon.Columns["DonGia"], "txtDonGia") as ASPxSpinEdit;
GiaMoi = spineditDonGia.Value;
spineditDoDay = gridChiTietHoaDon.FindRowCellTemplateControl(i, (GridViewDataColumn)gridChiTietHoaDon.Columns["DoDay"], "txtDoDay") as ASPxSpinEdit;
DoDayMoi = spineditDoDay.Value;
}
else
{
GiaMoi = DonGiaCu;
DoDayMoi = DoDayCu;
}
if (SoLuong != SoLuongMoi || DonGiaCu != GiaMoi || double.Parse(DoDayCu.ToString()) != double.Parse(DoDayMoi.ToString()))
{
if (double.Parse(DoDayCu.ToString()) != double.Parse(DoDayMoi.ToString()))
{
// tính lại thành tiền = doday * SL * DonGia
double ThanhTienOld = exitHang.ThanhTien;
exitHang.SoLuong = double.Parse(SoLuongMoi.ToString());
exitHang.DonGia = double.Parse(GiaMoi.ToString());
exitHang.DoDay = double.Parse(DoDayMoi.ToString());
exitHang.ThanhTien = (exitHang.DoDay * exitHang.SoLuong) * exitHang.DonGia;
DanhSachHoaDon[MaHoaDon].TongTien += exitHang.ThanhTien - ThanhTienOld;
DanhSachHoaDon[MaHoaDon].KhachCanTra = DanhSachHoaDon[MaHoaDon].TongTien; // -DanhSachHoaDon[MaHoaDon].GiamGia;
DanhSachHoaDon[MaHoaDon].KhachThanhToan = DanhSachHoaDon[MaHoaDon].TongTien; // -DanhSachHoaDon[MaHoaDon].GiamGia;
}
else
{
double ThanhTienOld = exitHang.ThanhTien;
exitHang.SoLuong = double.Parse(SoLuongMoi.ToString());
exitHang.DonGia = double.Parse(GiaMoi.ToString());
exitHang.DoDay = double.Parse(DoDayMoi.ToString());
exitHang.ThanhTien = double.Parse(SoLuongMoi.ToString()) * exitHang.DonGia;
DanhSachHoaDon[MaHoaDon].TongTien += exitHang.ThanhTien - ThanhTienOld;
DanhSachHoaDon[MaHoaDon].KhachCanTra = DanhSachHoaDon[MaHoaDon].TongTien; // -DanhSachHoaDon[MaHoaDon].GiamGia;
DanhSachHoaDon[MaHoaDon].KhachThanhToan = DanhSachHoaDon[MaHoaDon].TongTien; // -DanhSachHoaDon[MaHoaDon].GiamGia;
}
}
}
}
private void OnLoad()
{
int start = 0; // this.ASPxGridView1.PageIndex * ASPxGridView1.SettingsPager.PageSize;
int end = 1000; // (ASPxGridView1.PageIndex + 1) * ASPxGridView1.SettingsPager.PageSize;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxLabel Id = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "lbl_Id") as ASPxLabel;
ASPxDateEdit date_ShipDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ShipDate"], "date_ShipDate") as ASPxDateEdit;
ASPxTextBox txt_ShipIndex = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ShipIndex"], "txt_ShipIndex") as ASPxTextBox;
ASPxTextBox txt_ShipPortCode = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ShipPortCode"], "txt_ShipPortCode") as ASPxTextBox;
ASPxComboBox cbb_ContIndex = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContIndex"], "cbb_ContIndex") as ASPxComboBox;
ASPxSpinEdit spin_Qty = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["QtyOrig"], "spin_Qty") as ASPxSpinEdit;
ASPxSpinEdit spin_Weight = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["WeightOrig"], "spin_Weight") as ASPxSpinEdit;
ASPxSpinEdit spin_Volume = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["VolumeOrig"], "spin_Volume") as ASPxSpinEdit;
if (Id != null && isPay != null && isPay.Checked)
{
list.Add(new Record(SafeValue.SafeInt(Id.Text, 0), SafeValue.SafeInt(txt_ShipIndex.Value, 0), date_ShipDate.Date, txt_ShipPortCode.Text, SafeValue.SafeString(cbb_ContIndex.Value), SafeValue.SafeDecimal(spin_Qty.Value), SafeValue.SafeDecimal(spin_Weight.Value), SafeValue.SafeDecimal(spin_Volume.Value)));
}
else
{
if (Id == null)
{
break;
}
}
}
}
private void OnLoad()
{
int start = 0;
int end = count;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox id = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "txt_Id") as ASPxTextBox;
ASPxTextBox txt_ContNo = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContNo"], "txt_ContNo") as ASPxTextBox;
ASPxComboBox cbbContType = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContType"], "cbbContType") as ASPxComboBox;
ASPxSpinEdit spin_Price = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Price"], "spin_Price") as ASPxSpinEdit;
ASPxTextBox txt_Unit = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Unit"], "txt_Unit") as ASPxTextBox;
ASPxSpinEdit spin_Qty = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Qty"], "spin_Qty") as ASPxSpinEdit;
ASPxSpinEdit spin_LineIndex = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["LineIndex"], "spin_LineIndex") as ASPxSpinEdit;
ASPxComboBox cbb_ChgCode = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ChgCode"], "cbb_ChgCode") as ASPxComboBox;
ASPxTextBox txt_ChgCodeDe = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ChgCodeDe"], "txt_ChgCodeDe") as ASPxTextBox;
ASPxTextBox txt_Remark = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Remark"], "txt_Remark") as ASPxTextBox;
ASPxTextBox txt_GroupBy = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["GroupBy"], "txt_GroupBy") as ASPxTextBox;
if (id != null && isPay != null && isPay.Checked)
{
list.Add(new Record(SafeValue.SafeInt(id.Text, 0), txt_ContNo.Text, SafeValue.SafeString(cbbContType.Value), SafeValue.SafeDecimal(spin_Price.Value), SafeValue.SafeDecimal(spin_Qty.Value),
SafeValue.SafeString(cbb_ChgCode.Value), txt_ChgCodeDe.Text, txt_Unit.Text, SafeValue.SafeInt(spin_LineIndex.Value, 0), txt_Remark.Text, txt_GroupBy.Text));
}
else if (id == null)
{
break;
}
}
}
private void OnLoad()
{
int start = 0;
int end = 5000;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Code"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox code = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Code"], "txt_Id") as ASPxTextBox;
ASPxLabel lbl_Description = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Description"], "lbl_Description") as ASPxLabel;
ASPxLabel lbl_Att4 = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Att4"], "lbl_Att4") as ASPxLabel;
ASPxLabel lbl_Att5 = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Att5"], "lbl_Att5") as ASPxLabel;
ASPxLabel lbl_Att6 = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Att6"], "lbl_Att6") as ASPxLabel;
ASPxLabel lbl_Att7 = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Att7"], "lbl_Att7") as ASPxLabel;
ASPxLabel lbl_Att8 = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Att8"], "lbl_Att8") as ASPxLabel;
ASPxLabel lbl_Att9 = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Att9"], "lbl_Att9") as ASPxLabel;
ASPxLabel lbl_Uom1 = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Uom1"], "lbl_Uom1") as ASPxLabel;
ASPxLabel lbl_PartyId = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["PartyName"], "lbl_PartyId") as ASPxLabel;
ASPxSpinEdit spin_Qty = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Qty"], "spin_Qty") as ASPxSpinEdit;
ASPxSpinEdit spin_Price = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Price"], "spin_Price") as ASPxSpinEdit;
if (isPay != null && isPay.Checked)
{
list.Add(new Record(code.Text, SafeValue.SafeInt(spin_Qty.Text, 0), SafeValue.SafeDecimal(spin_Price.Text), lbl_Description.Text, lbl_Att4.Text, lbl_Att5.Text, lbl_Att6.Text,
lbl_Att7.Text, lbl_Att8.Text, lbl_Att9.Text, lbl_Uom1.Text));
}
else if (code == null)
{
break;
}
;
}
}
protected void spinItemTax_Load(object sender, EventArgs e)
{
ASPxSpinEdit spin = sender as ASPxSpinEdit;
ASPxCallbackPanel panel = spin.NamingContainer as ASPxCallbackPanel;
//Set data when in edit mode
if (gridviewBillItem.IsEditing && !gridviewBillItem.IsNewRowEditing && !panel.IsCallback)
{
var billItemId = (panel.NamingContainer
as DevExpress.Web.ASPxGridView.GridViewDataItemTemplateContainer).KeyValue;
object itemId = gridviewBillItem.GetRowValuesByKeyValue(billItemId, "ItemId!Key");
if (itemId == DBNull.Value)
{
return;
}
ItemBO itemBO = new ItemBO();
ItemTax itemTax = itemBO.GetCurrentVATOfItem(session, (Guid)itemId);
if (itemTax != null)
{
spin.Number = (decimal)itemTax.TaxId.Percentage;
}
else
{
spin.Number = 0;
}
}
}
protected void grid_bkg_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
if (grd.EditingRowVisibleIndex > -1)
{
string houseId = SafeValue.SafeString(grd.GetRowValues(grd.EditingRowVisibleIndex, new string[] { "SequenceId" }));
string sql = string.Format("select top(1) mkg.Sequenceid,Mkg.Qty,Mkg.PackageType,Mkg.Weight,mkg.Volume,mkg.Marking,mkg.Description from seaexportmkg mkg inner join seaexport job on mkg.RefNo=job.RefNo and mkg.JobNo=job.JobNo where job.SequenceId='{0}'", houseId);
DataTable tab = ConnectSql.GetTab(sql);
if (tab.Rows.Count == 1)
{
ASPxTextBox mkgId = grd.FindEditFormTemplateControl("txtMkgId") as ASPxTextBox;
ASPxSpinEdit wt = grd.FindEditFormTemplateControl("spin_wt2") as ASPxSpinEdit;
ASPxSpinEdit m3 = grd.FindEditFormTemplateControl("spin_m4") as ASPxSpinEdit;
ASPxSpinEdit qty = grd.FindEditFormTemplateControl("spin_pkg2") as ASPxSpinEdit;
ASPxButtonEdit pkgType = grd.FindEditFormTemplateControl("txt_pkgType2") as ASPxButtonEdit;
ASPxMemo mkg = grd.FindEditFormTemplateControl("txt_mkg2") as ASPxMemo;
ASPxMemo des = grd.FindEditFormTemplateControl("txt_des2") as ASPxMemo;
mkgId.Text = SafeValue.SafeString(tab.Rows[0]["SequenceId"]);
wt.Value = SafeValue.SafeDecimal(tab.Rows[0]["Weight"], 0);
m3.Value = SafeValue.SafeDecimal(tab.Rows[0]["Volume"], 0);
qty.Value = SafeValue.SafeInt(tab.Rows[0]["Qty"], 0);
pkgType.Text = SafeValue.SafeString(tab.Rows[0]["PackageType"]);
mkg.Text = SafeValue.SafeString(tab.Rows[0]["Marking"]);
des.Text = SafeValue.SafeString(tab.Rows[0]["Description"]);
}
}
}
private void OnLoad()
{
int start = 0;
int end = 10000;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox doDetId = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Product"], "txt_DoDetId") as ASPxTextBox;
ASPxSpinEdit qty1 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty1"], "spin_Qty1") as ASPxSpinEdit;
ASPxSpinEdit qty2 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty2"], "spin_Qty2") as ASPxSpinEdit;
ASPxSpinEdit qty3 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty3"], "spin_Qty3") as ASPxSpinEdit;
ASPxButtonEdit toLoc = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["ToLoc"], "txt_ToLoc") as ASPxButtonEdit;
if (doDetId != null && isPay != null && isPay.Checked)
{
list.Add(new Record(doDetId.Text, SafeValue.SafeInt(qty1.Value, 0), SafeValue.SafeInt(qty2.Value, 0), SafeValue.SafeInt(qty3.Value, 0), toLoc.Text
));
}
else if (doDetId == null)
{
break;
}
;
}
}
protected void ASPxButton1_Click(object sender, EventArgs e)
{
Dictionary <object, int> lowerBoundStorage = Session["lowerBoundStorage"] as Dictionary <object, int>;
if (lowerBoundStorage == null)
{
lowerBoundStorage = new Dictionary <object, int>();
}
int startIndex = ASPxGridView1.PageIndex * ASPxGridView1.SettingsPager.PageSize;
int endIndex = Math.Min(ASPxGridView1.VisibleRowCount, startIndex + ASPxGridView1.SettingsPager.PageSize);
for (int i = startIndex; i < endIndex; i++)
{
ASPxSpinEdit txtLowerBound = (ASPxSpinEdit)ASPxGridView1.FindRowCellTemplateControl(i, (GridViewDataColumn)ASPxGridView1.Columns["LowerBound"], "txtLB");
if (txtLowerBound.Text == "")
{
return;
}
int lowerBound = int.Parse(txtLowerBound.Text.Trim());
object key = ASPxGridView1.GetRowValues(i, "CategoryID");
if (!lowerBoundStorage.ContainsKey(key))
{
lowerBoundStorage.Add(key, lowerBound);
}
else
{
lowerBoundStorage[key] = lowerBound;
}
}
Session["lowerBoundStorage"] = lowerBoundStorage;
}
private void Unitchange(string para)
{
int IDProduct = Convert.ToInt32(para);
//sL
ASPxSpinEdit SpinEdit = gridImportPro.FindRowCellTemplateControlByKey(IDProduct, (GridViewDataColumn)gridImportPro.Columns["Số lượng"], "spUnitReturn") as ASPxSpinEdit;
int UnitProductNew = Convert.ToInt32(SpinEdit.Number);
//Giá vốn
ASPxSpinEdit SpinEdit_GiaVon = gridImportPro.FindRowCellTemplateControlByKey(IDProduct, (GridViewDataColumn)gridImportPro.Columns["Giá vốn"], "spGiaVonReturn") as ASPxSpinEdit;
double PriceProduct_GiaVon = Convert.ToDouble(SpinEdit_GiaVon.Number);
//Giá bán
ASPxSpinEdit SpinEdit_GiaBan = gridImportPro.FindRowCellTemplateControlByKey(IDProduct, (GridViewDataColumn)gridImportPro.Columns["Giá bán"], "spGiaBanReturn") as ASPxSpinEdit;
double PriceProduct_GiaBan = Convert.ToDouble(SpinEdit_GiaBan.Number);
// cập nhật
var sourceRow = listReceiptProducts.Where(x => x.STT == IDProduct).SingleOrDefault();
sourceRow.SoLuong = UnitProductNew;
sourceRow.GiaBanMoi = PriceProduct_GiaBan;
sourceRow.GiaVon = PriceProduct_GiaVon;
sourceRow.ThanhTien = UnitProductNew * PriceProduct_GiaVon;
//BindGrid();
}
private void OnLoad()
{
int start = 0;
int end = 1000;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.grid_wh.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_wh.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox id = this.grid_wh.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_wh.Columns["Id"], "txt_Id") as ASPxTextBox;
ASPxSpinEdit spin_Qty = this.grid_wh.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_wh.Columns["Qty"], "spin_Qty") as ASPxSpinEdit;
ASPxSpinEdit spin_WholeQty = this.grid_wh.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_wh.Columns["Qty"], "spin_WholeQty") as ASPxSpinEdit;
ASPxSpinEdit spin_Weight = this.grid_wh.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_wh.Columns["Qty"], "spin_Weight") as ASPxSpinEdit;
ASPxSpinEdit spin_Volume = this.grid_wh.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_wh.Columns["Qty"], "spin_Volume") as ASPxSpinEdit;
ASPxSpinEdit spin_LengthPack = this.grid_wh.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_wh.Columns["Qty"], "spin_LengthPack") as ASPxSpinEdit;
ASPxSpinEdit spin_WidthPack = this.grid_wh.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_wh.Columns["Qty"], "spin_WidthPack") as ASPxSpinEdit;
ASPxSpinEdit spin_HeightPack = this.grid_wh.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_wh.Columns["Qty"], "spin_HeightPack") as ASPxSpinEdit;
if (id != null && isPay != null && isPay.Checked)
{
list.Add(new Record(SafeValue.SafeInt(id.Text, 0), SafeValue.SafeDecimal(spin_Qty.Value), SafeValue.SafeDecimal(spin_WholeQty.Value),
SafeValue.SafeDecimal(spin_Weight.Value), SafeValue.SafeDecimal(spin_Volume.Value), SafeValue.SafeDecimal(spin_LengthPack.Value),
SafeValue.SafeDecimal(spin_WidthPack.Value), SafeValue.SafeDecimal(spin_HeightPack.Value)));
}
else if (id == null)
{
break;
}
}
}
private void Unitchange_GiamGia(string para)
{
int IDProduct = Convert.ToInt32(para);
ASPxSpinEdit SpinEdit_GiamGia = gridImportPro.FindRowCellTemplateControlByKey(IDProduct, (GridViewDataColumn)gridImportPro.Columns["Giảm giá"], "spGiamGiaReturn") as ASPxSpinEdit;
double GiamGia = Convert.ToDouble(SpinEdit_GiamGia.Number);
var sourceRow = listReceiptProducts.Where(x => x.STT == IDProduct).SingleOrDefault();
double DonGiaHienTai = sourceRow.GiaBanCu;
if (GiamGia >= 0 && GiamGia <= 100)
{
//giảm %
double GiamGiaTien = (DonGiaHienTai * (double)(GiamGia / 100));
if (GiamGia == 0)
{
sourceRow.GiaBan = DonGiaHienTai;
}
else
{
sourceRow.GiaBan = DonGiaHienTai - GiamGiaTien;
}
}
else
{
//giảm tiền
sourceRow.GiaBan = DonGiaHienTai - GiamGia;
}
sourceRow.GiamGia = GiamGia;
sourceRow.ThanhTien = sourceRow.SoLuong * sourceRow.GiaBan;
}
protected void spGiaVonReturn_Init(object sender, EventArgs e)
{
ASPxSpinEdit SpinEdit = sender as ASPxSpinEdit;
GridViewDataRowTemplateContainer container = SpinEdit.NamingContainer as GridViewDataRowTemplateContainer;
SpinEdit.ClientSideEvents.NumberChanged = String.Format("function(s, e) {{ onUnitReturnChanged({0}); }}", container.KeyValue);
}
private void OnLoad()
{
int start = 0;
int end = 1000;
for (int i = start; i < end; i++)
{
ASPxCheckBox isOk = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["SequenceId"], "ack_IsOk") as ASPxCheckBox;
ASPxTextBox id = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["SequenceId"], "txt_Id") as ASPxTextBox;
ASPxLabel lbl_ChgcodeId = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ChgcodeId"], "lbl_ChgcodeId") as ASPxLabel;
ASPxLabel lbl_ChgcodeDes = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ChgcodeDes"], "lbl_ChgcodeDes") as ASPxLabel;
ASPxSpinEdit spin_Price = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Price"], "spin_Price") as ASPxSpinEdit;
ASPxSpinEdit spin_Qty = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Qty"], "spin_Qty") as ASPxSpinEdit;
ASPxTextBox txt_Unit = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ChgUnit"], "txt_Unit") as ASPxTextBox;
if (id != null && isOk != null && isOk.Checked)
{
list.Add(new Record(lbl_ChgcodeId.Text, lbl_ChgcodeDes.Text, SafeValue.SafeDecimal(spin_Price.Value), SafeValue.SafeDecimal(spin_Qty.Value), txt_Unit.Text));
}
else if (id == null)
{
break;
}
}
}
private void OnLoad1()
{
int start = 0;
int end = 5000;
string doNo = SafeValue.SafeString(Request.QueryString["Sn"].ToString());
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox id = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "txt_Id") as ASPxTextBox;
ASPxTextBox sku = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["ProductCode"], "txt_Product") as ASPxTextBox;
ASPxTextBox lotNo = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["LotNo"], "txt_LotNo") as ASPxTextBox;
ASPxSpinEdit spin_Qty = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty"], "spin_Qty") as ASPxSpinEdit;
ASPxLabel spin_Picked = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Qty5"], "spin_Picked") as ASPxLabel;
ASPxLabel balQty = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["AvaibleQty"], "spin_AvaibleQty") as ASPxLabel;
ASPxLabel location = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Location"], "lbl_Location") as ASPxLabel;
ASPxLabel price = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Price"], "spin_Price") as ASPxLabel;
ASPxLabel spin_PengingPickQty = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["PengingPickQty"], "spin_PengingPickQty") as ASPxLabel;
ASPxLabel txt_Remark = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Remark"], "txt_Remark") as ASPxLabel;
ASPxLabel txt_PalletNo = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["PalletNo"], "txt_PalletNo") as ASPxLabel;
if (sku != null && isPay != null && isPay.Checked)
{
list.Add(new Record(SafeValue.SafeInt(id.Text, 0), sku.Text, lotNo.Text, SafeValue.SafeDecimal(spin_Qty.Value, 0), SafeValue.SafeDecimal(balQty.Text, 0), location.Text, SafeValue.SafeDecimal(price.Text, 0)
, SafeValue.SafeInt(spin_PengingPickQty.Text, 0), txt_Remark.Text, txt_PalletNo.Text));
}
else if (sku == null)
{
break;
}
;
}
}
public List<WebControl> RenderControl(System.Xml.XmlNode xmlControl)
{
base.Initialize(xmlControl);
ASPxSpinEdit aspxSpinEdit = new ASPxSpinEdit
{
ID = _PropertyMapper.GetID(),
NullText = "Entre " + _PropertyMapper.GetMinValue() + " y " + _PropertyMapper.GetMaxValue(),
ReadOnly = _PropertyMapper.ReadOnly(),
MinValue = _PropertyMapper.GetMinValue(),
MaxValue = _PropertyMapper.GetMaxValue(),
NumberType = SpinEditNumberType.Float,
DecimalPlaces = 2,
};
aspxSpinEdit.SpinButtons.ShowIncrementButtons = false;
aspxSpinEdit.ValidationSettings.SetFocusOnError = true;
aspxSpinEdit.ValidationSettings.RequiredField.IsRequired = _PropertyMapper.Required();
aspxSpinEdit.ValidationSettings.RequiredField.ErrorText = "Campo Requerido";
aspxSpinEdit.ValidationSettings.ValidationGroup = "InputValidation";
_Controls.Add(aspxSpinEdit);
return _Controls;
}
public MoneyControl()
{
spnAmount = new ASPxSpinEdit()
{
ID = POST_AMOUNT_KEY,
Number = 0,
};
cboCurrency = new ASPxComboBox()
{
ID = POST_CURRENCY_KEY,
ValueType = typeof(int),
EnableAnimation = false,
IncrementalFilteringMode = IncrementalFilteringMode.StartsWith,
DropDownStyle = DropDownStyle.DropDown,
AutoResizeWithContainer = true,
Width = Unit.Pixel(60),
};
layoutTable = new Table()
{
CellPadding = 0,
CellSpacing = 0,
};
//HtmlTableRow row = new HtmlTableRow();
//HtmlTableCell cell = new HtmlTableCell();
}
protected void grdBalanceLine_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
GridViewDataColumn col = ((ASPxGridView)sender).Columns["TransactionId.Code"] as GridViewDataColumn;
if (e.NewValues["TransactionId.Code"] == null)
{
e.Errors.Add(col, "");
e.RowError = "Chưa nhập mã bút toán";
return;
}
ASPxSpinEdit c1 = (ASPxSpinEdit)grdBalanceLine.FindEditRowCellTemplateControl((GridViewDataColumn)grdBalanceLine.Columns["Debit"], "colBalanceInitDebit");
ASPxSpinEdit c2 = (ASPxSpinEdit)grdBalanceLine.FindEditRowCellTemplateControl((GridViewDataColumn)grdBalanceLine.Columns["Credit"], "colBalanceInitCredit");
if (c1.Value == null && c2.Value == null)
{
e.Errors.Add(col, "");
e.RowError = "Số dư Nợ(Có) phải lớn hơn 0 ";
return;
}
else
{
if (c1.Value != null && c2.Value != null)
{
if (double.Parse(c1.Value.ToString()) > 0 && double.Parse(c2.Value.ToString()) > 0)
{
e.Errors.Add(col, "");
e.RowError = "Số dư Nợ(Có) phải bằng 0 ";
return;
}
}
}
}
protected void grdBalanceLine_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e)
{
if (e.Column.FieldName == "Debit")
{
ASPxSpinEdit c1 = (ASPxSpinEdit)grdBalanceLine.FindEditRowCellTemplateControl((GridViewDataColumn)grdBalanceLine.Columns["Debit"], "colBalanceInitDebit");
}
}
private void OnLoad()
{
int start = 0;
int end = 5000;
for (int i = start; i < end; i++)
{
ASPxCheckBox isPay = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Product"], "ack_IsPay") as ASPxCheckBox;
ASPxTextBox txt_Id = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Product"], "txt_Id") as ASPxTextBox;
ASPxLabel lbl_DoNo = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["DoNo"], "lbl_DoNo") as ASPxLabel;
ASPxLabel lbl_Description = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Description"], "lbl_Description") as ASPxLabel;
ASPxLabel lbl_PartyId = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["PartyName"], "lbl_PartyId") as ASPxLabel;
ASPxLabel lbl_LotNo = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["LotNo"], "lbl_LotNo") as ASPxLabel;
ASPxLabel lbl_Qty = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Qty"], "lbl_Qty") as ASPxLabel;
ASPxLabel lbl_ChargeCode = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ChargeCode"], "lbl_ChargeCode") as ASPxLabel;
ASPxSpinEdit spin_Price = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Price"], "spin_Price") as ASPxSpinEdit;
ASPxSpinEdit spin_Surcharge = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Surcharge"], "spin_Surcharge") as ASPxSpinEdit;
ASPxLabel lbl_Days = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Days"], "lbl_Days") as ASPxLabel;
if (isPay != null && isPay.Checked)
{
list.Add(new Record(txt_Id.Text, lbl_DoNo.Text, lbl_Description.Text, lbl_PartyId.Text, lbl_LotNo.Text, SafeValue.SafeDecimal(lbl_Qty.Text, 0), SafeValue.SafeDecimal(spin_Price.Text), lbl_ChargeCode.Text, SafeValue.SafeInt(lbl_Days.Text, 0), SafeValue.SafeDecimal(spin_Surcharge.Text)));
}
else if (txt_Id == null)
{
break;
}
;
}
}
protected void grdBookingDetail_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e)
{
if (e.Column.FieldName == "RowStatus")
{
e.Editor.Value = 1;
GridViewDataColumn col1 = ((ASPxGridView)sender).Columns["Credit"] as GridViewDataColumn;
ASPxSpinEdit spin1 = ((ASPxGridView)sender).FindEditRowCellTemplateControl(col1, "colBookingDetailCredit") as ASPxSpinEdit;
spin1.Value = 0;
GridViewDataColumn col2 = ((ASPxGridView)sender).Columns["Debit"] as GridViewDataColumn;
ASPxSpinEdit spin2 = ((ASPxGridView)sender).FindEditRowCellTemplateControl(col2, "colBookingDetailDebit") as ASPxSpinEdit;
spin1.Value = 0;
}
if (e.Column.FieldName == "AccountId!Key")
{
ASPxComboBox combo = (ASPxComboBox)e.Editor;
//combo.ItemsRequestedByFilterCondition += new ListEditItemsRequestedByFilterConditionEventHandler(AccountItemsRequestedByFilterCondition);
//combo.ItemRequestedByValue += new ListEditItemRequestedByValueEventHandler(AccountItemRequestedByValue);
ASPxComboBox accountCombobox = e.Editor as ASPxComboBox;
accountCombobox.TextField = "Code";
accountCombobox.DataSource = AccountingBO.getNotParentAccountList(session);
accountCombobox.DataBind();
e.Editor.Focus();
}
}
public virtual void InstantiateIn(Control container) {
var c = (PivotGridCellTemplateContainer) container;
var asPxSpinEdit = new ASPxSpinEdit {Text = c.Text, Width = Unit.Percentage(100)};
int columnIndex = ((PivotGridCellTemplateItem) (c.DataItem)).ColumnIndex;
int rowIndex = ((PivotGridCellTemplateItem) (c.DataItem)).RowIndex;
asPxSpinEdit.ID = string.Format("Ec{0}r{1}", columnIndex, rowIndex);
asPxSpinEdit.SpinButtons.ShowIncrementButtons = false;
asPxSpinEdit.EnableClientSideAPI = true;
asPxSpinEdit.ClientSideEvents.ValueChanged = "function (s,e){var editorText=s.GetText();" +
_clientInstanceName + ".PerformCallback('" + columnIndex + "|" +
rowIndex + "|'+editorText)}";
asPxSpinEdit.ClientSideEvents.GotFocus = "function(s,e){window.editorToFocus = s.name;ASPxClientControl.GetControlCollection().Get(window.editorToFocus).SelectAll()}";
c.Controls.Add(asPxSpinEdit);
}
protected void BindExisting(ASPxSpinEdit txtSerialLevel, ASPxTextBox txtNameLevel, ASPxTextBox txtAbbrLevel, string ORG_SERIAL, ASPxRadioButton rdActive, ASPxRadioButton rdCancel)
{
string SQL = "select ORG_SERIAL,ORG_NAME,ORG_ABBR,ORG_TYPE,ORG_STATUS from CTLT_ORGANIZE where ORG_SERIAL='" + ORG_SERIAL + "'";
SqlDataAdapter DA = new SqlDataAdapter(SQL, OPM_BL.DefaultConnectionString);
DataTable DT = new DataTable();
DA.Fill(DT);
if (DT.Rows.Count > 0)
{
txtSerialLevel.Text = DT.Rows[0]["ORG_SERIAL"].ToString();
txtSerialLevel.ReadOnly = true;
txtSerialLevel.BackColor = System.Drawing.Color.Gray;
txtNameLevel.Text = DT.Rows[0]["ORG_NAME"].ToString();
txtAbbrLevel.Text = DT.Rows[0]["ORG_ABBR"].ToString();
if ( DT.Rows[0]["ORG_STATUS"].ToString() == "A"){
rdActive .Checked =true ;
rdCancel.Checked =false ;
}else{
rdActive .Checked =false ;
rdCancel.Checked =true ;
}
}
else
{
txtSerialLevel.Text = "";
txtSerialLevel.ReadOnly = false;
txtSerialLevel.BackColor = System.Drawing.Color.White;
txtNameLevel.Text = "";
txtAbbrLevel.Text = "";
rdActive.Checked = true;
rdCancel.Checked = false;
}
}
public static void SetSpinValue(ASPxSpinEdit spin, object objects)
{
try
{
if (objects != null)
{
spin.Value = objects;
}
}
catch (Exception ex)
{
SiAuto.Main.LogString("Lỗi SetSpinValue :", ex.ToString());
}
}
public static string GetSpinValue(ASPxSpinEdit spin, int soluongthapphan)
{
string result = "";
try
{
result = double.Parse(spin.Value.ToString()).ToString("N" + soluongthapphan.ToString(), CultureInfo.GetCultureInfo("en-US"));
}
catch (Exception ex)
{
SiAuto.Main.LogString("Lỗi GetSpinValue :", ex.ToString());
}
return result;
}
public static string GetSpinValue(ASPxSpinEdit spin)
{
string result = "";
try
{
result = String.Format(CultureInfo.GetCultureInfo("en-US"), "{0:0.####}", spin.Value);
}
catch (Exception ex)
{
SiAuto.Main.LogString("Lỗi GetSpinValue :", ex.ToString());
}
return result;
}
private WebControl CreateSpinEdit(Control container)
{
ASPxSpinEdit spinedit = new ASPxSpinEdit();
templateContainer = (GridViewDataItemTemplateContainer)container;
spinedit.ID = string.Format("{0}_{1}", (templateContainer.Column).FieldName, templateContainer.VisibleIndex);
spinedit.ClientInstanceName = string.Format("{0}_{1}", (templateContainer.Column).FieldName, templateContainer.VisibleIndex);
spinedit.Value = templateContainer.Grid.GetRowValues(templateContainer.VisibleIndex, (templateContainer.Column).FieldName).ToString();
object clientevent = SqlHelper.ExecuteScalar( DataServices.ConnectString, "SY_modulefields_getClientevent", _moduleID, _tableName, (templateContainer.Column).FieldName);
if (clientevent != null)
{
Dictionary<string, string> valueclientevent = JsonConvert.DeserializeObject<Dictionary<string, string>>(clientevent.ToString());
if (valueclientevent != null)
{
spinedit.ClientSideEvents.ButtonClick = valueclientevent["buttonclick"];
spinedit.ClientSideEvents.GotFocus = valueclientevent["gotfocus"];
spinedit.ClientSideEvents.Init = valueclientevent["init"];
spinedit.ClientSideEvents.KeyDown = valueclientevent["keydown"];
spinedit.ClientSideEvents.KeyPress = valueclientevent["keypress"];
spinedit.ClientSideEvents.KeyUp = valueclientevent["keyup"];
spinedit.ClientSideEvents.LostFocus = valueclientevent["lostfocus"];
spinedit.ClientSideEvents.NumberChanged = valueclientevent["numberchanged"];
spinedit.ClientSideEvents.Validation = valueclientevent["validation"];
spinedit.ClientSideEvents.ValueChanged = valueclientevent["valuechanged"];
//{"buttonclick":"","gotfocus":"","init":"","keydown":"","keypress":"","keyup":"","lostfocus":"","numberchanged":"","validation":"","valuechanged":""}
}
}
return spinedit;
}
public List<HtmlTableCell> BuildNumberSpin(string caption, string id, string helptext, string skinID, int length, bool isReadOnly, string controlValue)
{
List<HtmlTableCell> c = new List<HtmlTableCell>();
try
{
HtmlTableCell cell = new HtmlTableCell();
cell.Attributes.Add("class", "tblFormViewtdLabel");
cell.Style.Add("Width", "20%");
ASPxLabel lb = new ASPxLabel();
lb.Text = caption;
cell.Controls.Add(lb);
HtmlTableCell celledit = new HtmlTableCell();
celledit.Attributes.Add("class", "tblFormViewtdValue");
celledit.Style.Add("Width", "30%");
ASPxSpinEdit se = new ASPxSpinEdit();
se.SkinID = skinID;
se.ID = id;
se.NullText = helptext;
se.MaxLength = length;
//se.Enabled = alowEdit;
se.Width = Unit.Percentage(99);
se.Theme = "DevEx";
se.AutoPostBack = false;
se.ReadOnly = isReadOnly;
se.Value = controlValue;
celledit.Controls.Add(se);
c.Add(cell);
c.Add(celledit);
cot += 2;
}
catch (Exception)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(),
"<script> alert('buildNumberSpin fieldname" + id + "'); </script>",
false);
}
return c;
}
