private D05F2140 LoadD05F2140()
{
D05F2140 frmTable = new D05F2140();
string TableID = GridTable.GetFocusedRowCellValue("TableID").ToString();
frmTable.Status = Convert.ToInt32(GridTable.GetFocusedRowCellValue("Status"));
frmTable.TableID = TableID;
frmTable.AmountPayment = 0;
frmTable.lbTableName.Content = "Tên bàn: " + GridTable.GetFocusedRowCellValue("TableName").ToString();
if (frmTable.Status == 0)
{
frmTable.VoucherID = "";
}
else
{
DataTable dt = BLTable.LoadD05F2140(TableID, frmTable.Status);
if (dt.Rows.Count > 0)
{
frmTable.VoucherID = dt.Rows[dt.Rows.Count - 1]["VoucherID"].ToString();
}
else
{
frmTable.VoucherID = "";
}
}
return(frmTable);
}
private void DoSaveSQL()
{
if (AmountPayment > 0)
{
Status = 2;
}
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine(BLTable.SQLDeleteD91T2141(VoucherID));
sSQL.AppendLine(BLTable.SQLDeleteD91T2140(VoucherID));
sSQL.AppendLine(BLTable.SQLInsertD91T2140(VoucherID, TableID, sePeople.EditValue, sePeople.NumberFormat, seTotalMoney.EditValue, seTotalMoney.NumberFormat, Status, AmountPayment));
sSQL.AppendLine(BLTable.SQLInsertD91T2141s(dtGrid, VoucherID));
sSQL.AppendLine(BLTable.SQLUpdateStockD91T1040s(dtGrid));
if (L3SQLServer.ExecuteSQL(sSQL.ToString()))
{
if (Status == 1)
{
BLTable.UpdateStatus1(L3SQLClient.SQLMoney(seTotalMoney.EditValue, seTotalMoney.NumberFormat), L3SQLClient.SQLMoney(sePeople.EditValue, sePeople.NumberFormat), TableID);
}
else if (Status == 2)
{
BLTable.UpdateStatus2(L3SQLClient.SQLMoney(seTotalMoney.EditValue, seTotalMoney.NumberFormat), L3SQLClient.SQLMoney(sePeople.EditValue, sePeople.NumberFormat), TableID);
}
Lemon3.Messages.L3Msg.SaveOK();
Saved = true;
}
else
{
Lemon3.Messages.L3Msg.SaveNotOK();
btnSave.IsEnabled = true;
}
}
private void mnsNew_Click(object sender, RoutedEventArgs e)
{
BLTable.InitialTable(GridTable.GetFocusedRowCellValue("TableID").ToString());
LoadSimple();
mnsNew.IsEnabled = false;
mnsPay.IsEnabled = true;
mnsAdd.IsEnabled = true;
}
private void LoadEdit()
{
DataTable dt = BLTable.GetTable(TableID);
if (dt.Rows.Count > 0)
{
txtTableID.Text = dt.Rows[0]["TableID"].ToString();
txtTableName.Text = dt.Rows[0]["TableName"].ToString();
txtPosition.Text = dt.Rows[0]["Position"].ToString();
}
}
private void tsbDelete_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
try
{
string TableID = GridTable.GetFocusedRowCellValue("TableID").ToString();
BLTable.DeleteTable(TableID);
LoadSimple();
GridTable.FocusRowHandle(GridTable.ReturnVisibleRowCount - 1);
}
catch (NullReferenceException)
{
System.Windows.MessageBox.Show("Lỗi không thể xóa được bảng trống");
}
}
private void lbeSuggestion_EditValueChanged(object sender, DevExpress.Xpf.Editors.EditValueChangedEventArgs e)
{
string sInventoryID = lbeSuggestion.EditValue.ToString();
DataTable dt = BLTable.SelectInventoryID(sInventoryID);
string sInventoryName = "";
if (dt.Rows.Count > 0 && Convert.ToDecimal(dt.Rows[0]["InStock"]) > 0)
{
btnPay.IsEnabled = true;
sInventoryName = L3ConvertType.L3String(dt.Rows[0]["InventoryName"]);
int irow = GridVoucherInventory.FindRowByValue("InventoryID", sInventoryID);
if (irow >= 0)
{
int value_Old = L3ConvertType.L3Int(GridVoucherInventory.GetCellValue(irow, COL_Quantity));
int stock_Old = L3ConvertType.L3Int(GridVoucherInventory.GetCellValue(irow, COL_InStock));
if (stock_Old > 0)
{
GridVoucherInventory.SetCellValue(irow, "Quantity", value_Old + 1);
GridVoucherInventory.SetCellValue(irow, "InStock", stock_Old - 1);
}
CalAmountGrid(irow);
}
else
{
DataRow dr = dtGrid.NewRow();
dr["InventoryID"] = sInventoryID;
dr["InventoryName"] = dt.Rows[0]["InventoryName"];
dr["UnitID"] = dt.Rows[0]["UnitID"];
dr["InStock"] = Convert.ToDecimal(dt.Rows[0]["InStock"]) - 1;
dr["Quantity"] = 1;
dr["Price"] = dt.Rows[0]["Price"];
dr["VAT"] = dt.Rows[0]["VAT"];
dr["Amount"] = L3ConvertType.Number(dr["Quantity"]) * L3ConvertType.Number(dr["Price"]) * (1 - L3ConvertType.Number(dr["VAT"]));
dtGrid.Rows.Add(dr);
}
btnSave.IsEnabled = true;
btnDeleteQuatity.IsEnabled = true;
btnAddQuatity.IsEnabled = true;
btnAdd10Quatity.IsEnabled = true;
}
else
{
MessageBox.Show("Đã hết hàng!");
}
CalAmount();
txtItem.Text = "";
lbeSuggestion.Visibility = Visibility.Collapsed;
lbeSuggestion.EditValue = null;
}
private void LoadTDBGrid()
{
dtGrid = BLTable.LoadVoucherDataGrid(L3SQLClient.SQLString(VoucherID));
L3DataSource.LoadDataSource(GridVoucherInventory, dtGrid, true);
if (dtGrid.Rows.Count == 0)
{
btnPay.IsEnabled = false;
btnDeleteQuatity.IsEnabled = false;
}
else
{
btnPay.IsEnabled = true;
btnDeleteQuatity.IsEnabled = true;
}
}
private void LoadMaster()
{
lbVoucherID.Content = "Phiếu đặt: " + VoucherID;
DataTable dtMaster = BLTable.LoadMaster(L3SQLClient.SQLString(VoucherID));
if (dtMaster.Rows.Count > 0)
{
lbUserID.Content = "Thu ngân: " + dtMaster.Rows[0]["UserID"];
seTotalMoney.EditValue = dtMaster.Rows[0]["Amount"];
sePeople.EditValue = dtMaster.Rows[0]["CountPerson"];
}
else
{
lbUserID.Content = "Thu ngân: " + L3.UserID;
seTotalMoney.EditValue = 0;
sePeople.EditValue = 0;
Status = 1;
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
btnSave.Focus();
if (!btnSave.IsFocused)
{
return;
}
if (!AllowSave())
{
return;
}
Models.Table table = new Models.Table();
table.TableID = txtTableID.Text;
table.TableName = txtTableName.Text;
table.Position = txtPosition.Text;
bool bRet = false;
btnSave.IsEnabled = false;
if (_fromState == EnumFormState.FormAdd)
{
bRet = BLTable.AddTable(table);
}
else
{
bRet = BLTable.UpdateTable(table);
}
if (bRet)
{
Lemon3.Messages.L3Msg.SaveOK();
TableID = txtTableID.Text;
Close();
btnSave.IsEnabled = true;
}
else
{
Lemon3.Messages.L3Msg.SaveNotOK();
btnSave.IsEnabled = true;
}
}
private void mnsPay_Click(object sender, RoutedEventArgs e)
{
string VoucherID = "";
DataTable dt = BLTable.SelectPayment(GridTable.GetFocusedRowCellValue("TableID").ToString(), GridTable.GetFocusedRowCellValue("Status").ToString());
if (dt.Rows.Count > 0)
{
VoucherID = dt.Rows[dt.Rows.Count - 1]["VoucherID"].ToString();
}
D05F2141 frmPayment = new D05F2141();
frmPayment.TotalMoney = Convert.ToDecimal(dt.Rows[dt.Rows.Count - 1]["Amount"]);
frmPayment.WindowStartupLocation = WindowStartupLocation.CenterScreen;
frmPayment.ShowDialog();
if (!frmPayment.bClicked)
{
return;
}
decimal AmountPayment = frmPayment.TotalMoney;
BLTable.UpdateMoney(L3SQLClient.SQLMoney(GridTable.GetFocusedRowCellValue("TotalMoney"), "n0"), L3SQLClient.SQLMoney(GridTable.GetFocusedRowCellValue("People"), "n0"), GridTable.GetFocusedRowCellValue("TableID"));
BLTable.UpdateVoucherD91T2140(L3SQLClient.SQLMoney(AmountPayment, "n0"), VoucherID);
LoadSimple();
}
void txtItem_TextChanged(object sender, TextChangedEventArgs e)
{
DataTable DtSuggest = BLTable.LoadSuggest();
string typedString = txtItem.Text;
DataTable AutoTable = DtSuggest.Clone();
AutoTable.Clear();
foreach (DataRow item in DtSuggest.Rows)
{
if (!string.IsNullOrEmpty(txtItem.Text))
{
if (item["InventoryID"].ToString().Contains(typedString) || item["InventoryName"].ToString().Contains(typedString) || item["BarCode"].ToString().Contains(typedString))
{
AutoTable.ImportRow(item);
}
}
}
if (AutoTable.Rows.Count > 0)
{
lbeSuggestion.DisplayMember = "InventoryName";
lbeSuggestion.ValueMember = "InventoryID";
lbeSuggestion.ItemsSource = AutoTable;
lbeSuggestion.Visibility = Visibility.Visible;
}
else if (txtItem.Text.Equals(""))
{
lbeSuggestion.Visibility = Visibility.Collapsed;
lbeSuggestion.ItemsSource = null;
}
else
{
lbeSuggestion.Visibility = Visibility.Collapsed;
lbeSuggestion.ItemsSource = null;
}
}
public void LoadSimple()
{
GridTable.ItemsSource = BLTable.LoadTable();
lkesStatus.ItemsSource = BLTable.LoadStatusName();
}
