internal static void smazStarouDavku(Session sesna, int extApp, string perioda, out bool dataSmazana, ref PLATCI_RESP resp)
{
dataSmazana = false;
try
{
DBVal dbval = new DBVal(sesna);
sesna.ExecuteNonQuery("delete from P_ODPADY_EULEVY where ZPRAC = 'A' and EA = " + extApp.ToString() +
" and ENTRYDATE < " + dbval.dbv.getCurrentDateTimeText + "-750");
sesna.ExecuteNonQuery("delete from P_ODPADY_EULEVY where EA = " + extApp.ToString() + " and ZPRAC = 'E'" +
" and PER = '" + perioda + "'");
dataSmazana = true;
}
catch (Exception e)
{
resp.result = Result.ERROR;
resp.status = Status.ERROR;
resp.ERRORMESS = string.Format("Odmazání starých dat neproběhlo. \n {0}", e.Message);
}
}
public int LIZNI_SEQ(string sequence)
{
DBVal dbv = new DBVal(sesna);
IDBValFactory idbv = dbv.CreateDBV();
int ID = 0;
if (idbv.Database == typeof(MSSQL))
{
if (sequence == "PRPL_ID")
{
sequence = "P_SEQUENCE_PRPL";
}
if (sequence == "PLATBA_ID")
{
sequence = "P_SEQUENCE_PLATBA";
}
DevExpress.Xpo.DB.SelectedData selData = sesna.ExecuteSproc("LIZNI_SEQ", new OperandValue(sequence));
ID = Convert.ToInt32(selData.ResultSet[0].Rows[0].Values[0]);
}
if (idbv.GetType() == typeof(ORACLE))
{
if (sequence == "PRPL_ID")
{
sequence = "P_SEQ_PRPL_ID";
}
if (sequence == "PLATBA_ID")
{
sequence = "P_SEQ_PLATBA_ID";
}
object obj = sesna.ExecuteScalar("select " + sequence + ".Nextval ID from dual");
ID = Convert.ToInt32(obj);
}
if (ID == 0)
{
throw new Exception(String.Format("chyba při čtení hodnoty sequence {0}", sequence));
}
return(ID);
}
