public void MakePriceOffer(ScenaryOrder scenaryOrder)
{
int lotid = Execute("select id, number from lots where number like '%" + scenaryOrder.LotNumber + "%'").Tables[0].Rows[0].Field <int>("id");
if (Execute("select lotid from priceoffers where lotid='" + lotid + "'").Tables[0].Rows.Count != 0)
{
ModifyRecord("update priceoffers set price='" + scenaryOrder.PriceTo + "' where lotid='" + lotid + "'");
}
else
{
int procuratoryid = Execute("select * from procuratories where lotid='" + lotid +
"' and supplierid=(select supplierid from suppliersjournal where code like '%" + scenaryOrder.ClientCode + "%')").Tables[0].Rows[0].Field <int>("id");
ModifyRecord("insert into priceoffers (procuratoryid, lotid, price)values('" + procuratoryid + "','" + lotid + "','" + scenaryOrder.PriceTo + "')");
}
}
public void AppendList(ScenaryOrder scnenaryOrder)
{
scnearyOrderLst.Add(scnenaryOrder);
}
public void MakeTestOffer(ScenaryOrder scenaryOrder)
{
ModifyRecord("insert into etsresults (brokername, clientcode, lotnumber, sum, date, userserial)values('" +
scenaryOrder.SelectedBroker.name + "','" + scenaryOrder.ClientCode + "','" + scenaryOrder.LotNumber + "','" + scenaryOrder.PriceTo + "','" +
DateTime.Now.ToString("yyyy-MM-dd") + "','" + App.hddSerialNumber + "')");
}