public void FillExpense(string filter)
{
expenseTableAdapter daEx = new expenseTableAdapter();
if (filter != "")
{
DS.expense.Clear();
daEx.Adapter.SelectCommand = new MySqlCommand("select * from expense where " + filter, daEx.Connection);
daEx.Adapter.Fill(DS.expense);
}
else
{
daEx.Fill(DS.expense);
}
//DS.expense
}
public void Debt(string comment)
{
expenseTableAdapter expDa = new expenseTableAdapter();
expDa.Adapter.SelectCommand = new MySql.Data.MySqlClient.MySqlCommand("select * from expense order by expenseId desc limit 1", expDa.Connection);
DataSetTpos.expenseDataTable expTable = new DataSetTpos.expenseDataTable();
DataSetTpos.expenseRow expRow = expTable.NewexpenseRow();
double sum = 0;
expRow.expenseDate = DateTime.Now;
expRow.debt = 0;
expRow.status = 0;
expRow.comment = comment;
expRow.expType = 3;
expRow.expSum = (int)Math.Round(sum);
expRow.terminal = 0;
expTable.Rows.Add(expRow);
int expId;
expDa.Update(expTable);
expDa.FillLast(expTable);
ordersTableAdapter prDa = new ordersTableAdapter();
DataSetTpos.ordersRow[] orRows = (DataSetTpos.ordersRow[])DBclass.DS.orders.Select("expenseId = -1");
foreach (DataSetTpos.ordersRow oneRow in orRows)
{
oneRow.expenseId = (expTable.Rows[0] as DataSetTpos.expenseRow).expenseId;
}
expId = Convert.ToInt32((expTable.Rows[0] as DataSetTpos.expenseRow).expenseId);
prDa.Update(DBclass.DS.orders);
triggerExecute("ExpenseTrigger", expId);
productviewTableAdapter prVda = new productviewTableAdapter();
prVda.Fill(DBclass.DS.productview);
isNewExpense = true;
}
public Kassa(int expId)
{
InitializeComponent();
db = new DBclass();
expenseTableAdapter prVda = new expenseTableAdapter();
prVda.Fill(DBclass.DS.expense);
table = DBclass.DS.expense;
DataTable chTable = DBclass.DS.changesel;
chs.Fill(DBclass.DS.changesel);
DataRow[] temp = DBclass.DS.changesel.Select("");
DataView dataView = new DataView(chTable);
dataView.RowFilter = "userId = " + UserValues.CurrentUserID;
dataView.Sort = "changSelId DESC";
chTable = dataView.ToTable();
DBclass.DS.changesel.DefaultView.Sort = "changSelId desc";
dt = DBclass.DS.expense.Select("userId = " + UserValues.CurrentUserID);
expenseId = Convert.ToInt32(chTable.Rows[1]["expenseId"].ToString());
Smena.Text = chTable.Rows[0]["startTime"].ToString();
DataSetTpos.expenseRow row = (DataSetTpos.expenseRow)dt[0];
if (chTable.Rows[1]["expenseId"].ToString() == "")
{
expenseId = row.expenseId;
}
sumTerm = table.Compute("Sum(terminal)", "userId = " + UserValues.CurrentUserID + " and expenseId > " + expenseId + " and debt = 0 and expType = 0");
sumExp = table.Compute("Sum(expSum)", "userId = " + UserValues.CurrentUserID + " and expenseId > " + expenseId + " and debt = 0 and expType = 0");
sumBack = table.Compute("Sum(expSum)", "userId = " + UserValues.CurrentUserID + " and expenseId > " + expenseId + " and debt = 0 and expType = 1");
sumDebt = table.Compute("Sum(expSum)", "userId = " + UserValues.CurrentUserID + " and expenseId > " + expenseId + " and debt = 1 and expType = 0");
int sumE;
int sumT;
int sumB;
int sumD;
if (sumExp.ToString() == String.Empty)
{
sumE = 0;
}
else
{
sumE = Convert.ToInt32(sumExp);
}
if (sumTerm.ToString() == String.Empty)
{
sumT = 0;
}
else
{
sumT = Convert.ToInt32(sumTerm);
}
if (sumBack.ToString() == String.Empty)
{
sumB = 0;
}
else
{
sumB = Convert.ToInt32(sumBack);
}
if (sumDebt.ToString() == String.Empty)
{
sumD = 0;
}
else
{
sumD = Convert.ToInt32(sumDebt);
}
nal.Text = (sumE - sumT).ToString();
terminal.Text = sumT.ToString();
debt.Text = sumD.ToString();
back.Text = sumB.ToString();
all.Text = Convert.ToInt32(sumE).ToString();
expenseId = expId;
}
