protected string GetBillNo(string tableName)
{
int BillNo = 0;
DateTime CurrentDate = DateTime.Now.Date;
String sBillNo = DateTime.Now.ToString("yyyyMMdd");
Norecordor Norecordor = Session.Get <Norecordor>(tableName);
if (Norecordor == null)
{
Norecordor = new Norecordor {
TableNam = tableName, LastBillDate = DateTime.Now.Date, BillNo = "0"
};
}
BillNo = Convert.ToInt32(Norecordor.BillNo);
if (CurrentDate > Norecordor.LastBillDate)
{
Norecordor.BillNo = "0";
Norecordor.LastBillDate = CurrentDate;
BillNo = 0;
}
if (CurrentDate == Norecordor.LastBillDate)
{
BillNo = Convert.ToInt32(Norecordor.BillNo) + 1;
Norecordor.BillNo = BillNo + "";
}
if ((BillNo > 0) && (BillNo < 10))
{
sBillNo += "000" + BillNo;
}
if ((BillNo >= 10) && (BillNo < 100))
{
sBillNo += "00" + BillNo;
}
if ((BillNo >= 100) && (BillNo < 1000))
{
sBillNo += "0" + BillNo;
}
//if ((BillNo >= 1000) && (BillNo < 10000)) sBillNo += "0" + BillNo;
//if ((BillNo >= 10000) && (BillNo < 100000)) sBillNo += "0" + BillNo;
//Norecordor.BillNo = BillNo + "";
Session.Save(Norecordor);
Session.Flush();
CloseSession();
return(sBillNo);
}
protected Int32 GetLineID(string tableName)
{
string Result = String.Empty;
Norecordor Norecordor = Session.Get <Norecordor>(tableName);
if (Norecordor == null)
{
Norecordor = new Norecordor {
TableNam = tableName, LastIdDate = DateTime.Now, LineId = 0
};
}
Norecordor.LineId += 1;
Session.Save(Norecordor);
Session.Flush();
CloseSession();
return(Norecordor.LineId);
/*using (IDbCommand Command = Session.Connection.CreateCommand()) {
* Command.CommandText = "call ProcGetLineID(?)";
* //Command.CommandType = CommandType.StoredProcedure;
* IDbDataParameter parameter = Command.CreateParameter();
* parameter.ParameterName = "aTable_nam";
* parameter.DbType = DbType.String;
* parameter.Value = tableName;
* parameter.Direction = ParameterDirection.Input;
* Command.Parameters.Add(parameter);
* IDataReader Reader = Command.ExecuteReader();
* try {
* if (Reader.Read()) {
* Result = Reader.GetString(0);
* }
* }
* finally {
* Reader.Dispose();
* }
* }
* return Convert.ToInt32(Result);*/
}
