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;
}
private void btnPay_Click(object sender, EventArgs e)
{
string str = "";
if (!string.IsNullOrEmpty(txbPay.Text))
{
if (rbtnCash.Checked ||
rbtnTerminal.Checked ||
rbtnTransfer.Checked)
{
DataSetTpos.transferRow trRow = Classes.DB.DBclass.DS.transfer.NewtransferRow();
trRow.summ = Convert.ToInt32(txbPay.Text);
switch ((selectedRbt).Name)
{
case "rbtnCash":
trRow.transferType = 1;
break;
case "rbtnTerminal":
trRow.transferType = 2;
break;
case "rbtnTransfer":
trRow.transferType = 3;
break;
}
trRow.contragentId = contragId;
//trRow.comment = "Оплата за товары";
int sum = Convert.ToInt32(txbPay.Text) + lastPverflow;
trRow.dataTransfer = DateTime.Now.Date;
Classes.DB.DBclass.DS.transfer.AddtransferRow(trRow);
DataSetTposTableAdapters.transferTableAdapter trTA = new DataSetTposTableAdapters.transferTableAdapter();
trTA.Update(Classes.DB.DBclass.DS.transfer);
trTA.Fill(Classes.DB.DBclass.DS.transfer);
DataSetTposTableAdapters.expenseTableAdapter expenseDa = new DataSetTposTableAdapters.expenseTableAdapter();
expenseDa.FillByContragent(DBclass.DS.expense, contragId);
DataSetTposTableAdapters.transferexpenseTableAdapter trexDa = new DataSetTposTableAdapters.transferexpenseTableAdapter();
int lastIndexTransfer = (int)trTA.GetLast();
foreach (DataRow row in dataTable.Select("expType = 1"))
{
sum += Convert.ToInt32(row["expSum"]);
}
foreach (DataRow row in dataTable.Rows)
{
DataSetTpos.expenseRow expRow = DBclass.DS.expense.FindByexpenseId(Convert.ToInt32(row["expenseId"]));
if (expRow.expType != 1)
{
int debt = Convert.ToInt32(row["debt"]);
int payedSum = 0;
if (sum > 0 && expRow != null)
{
if (debt <= sum)
{
sum = sum - debt;
payedSum = debt;
debt = 0;
expRow.status = 0;
}
else if (debt > sum)
{
debt = debt - sum;
payedSum = sum;
sum = 0;
}
DataSetTpos.transferexpenseRow trexpRow = DBclass.DS.transferexpense.NewtransferexpenseRow();
trexpRow.expenseId = expRow.expenseId;
trexpRow.transferId = lastIndexTransfer;
DBclass.DS.transferexpense.AddtransferexpenseRow(trexpRow);
}
switch ((selectedRbt).Name)
{
case "rbtnCash":
expRow.inCash += payedSum;
break;
case "rbtnTerminal":
expRow.terminal += payedSum;
break;
case "rbtnTransfer":
expRow.transfer += payedSum;
break;
}
expRow.debt = debt;
}
else
{
//sum = sum + expRow.expSum;
expRow.status = 0;
}
expenseDa.Update(expRow);
}
trexDa.Update(DBclass.DS.transferexpense);
DataSetTpos.transferRow trRow1 = Classes.DB.DBclass.DS.transfer.Last <DataSetTpos.transferRow>();
if (sum > 0)
{
trRow1.overflow = sum;
}
else
{
trRow1.overflow = 0;
}
trTA.Update(trRow1);
}
else
{
lblError.Text = "Выберите вид оплаты!";
lblError.Visible = true;
}
}
else
{
lblError.Text = "Введите сумму оплаты!";
lblError.Visible = 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;
}
