public int GetNextTicketNumber(bool sureliMi)
{
//süreli mi true ise, verilemeyen biletlerden ilki gelmeli.
int NextTicketNumber = 0;
string strWhereSQL =
string.Format(
"Where GRPID={0} AND (SIS_TAR BETWEEN '{1}' AND '{2}') AND (OZEL_MUSTERI='False') AND (TRANSFER='False') ",
this.GrupID,
BiletTarih.ToString("yyyy.MM.dd 00:00:00"),
BiletTarih.ToString("yyyy.MM.dd 23:59:59")
);
DataTable dtTicketNumber = (DataTable)DBProcess.SimpleQuery("BILETLER",
strWhereSQL,
"ORDER BY BID DESC limit 1",
"BILET_NO")["DataTable"];
if (dtTicketNumber != null)
{
if (dtTicketNumber.Rows.Count > 0)
{
NextTicketNumber = int.Parse(dtTicketNumber.Rows[0][0].ToString()) + 1;
}
else
{
NextTicketNumber = grup.BaslangicNo;
}
}
else
{
NextTicketNumber = 0;
}
return(NextTicketNumber);
}
public int GetNextTicketNumber()
{
int NextTicketNumber = 0;
string strWhereSQL = string.Format("Where GRPID={0} AND (SIS_TAR BETWEEN '{1}' AND '{2}')",
newBilet.GrupID,
BiletTarih.ToString("MM.dd.yyyy 00:00:00"),
BiletTarih.ToString("MM.dd.yyyy 23:59:59")
);
DataTable dtTicketNumber = (DataTable)DBProcess.SimpleQuery("BILETLER",
strWhereSQL,
"ORDER BY BID DESC",
"TOP (1) BILET_NO")["DataTable"];
if (dtTicketNumber != null)
{
if (dtTicketNumber.Rows.Count > 0)
{
NextTicketNumber = int.Parse(dtTicketNumber.Rows[0][0].ToString()) + 1;
}
else
{
NextTicketNumber = grup.BaslangicNo;
}
}
else
{
NextTicketNumber = 0;
}
return(NextTicketNumber);
}
