public ClientMasterInfo GetRecord_Next(int currentRecordID)
{
LocalLayer.LocalDefine localDefine = new DAL.SqlDAL.LocalLayer.LocalDefine();
string sqlString = string.Empty;
DataBaseCommandKeyInfo dataBaseCommandKeyInfo = new DataBaseCommandKeyInfo();
List <DataBaseCommandKeyInfo> keyList = new List <DataBaseCommandKeyInfo>();
dataBaseCommandKeyInfo.Key = "clm_iRecID";
dataBaseCommandKeyInfo.KeyValue = currentRecordID.ToString();
dataBaseCommandKeyInfo.KeyValueType = TypeCode.Int32;
keyList.Add(dataBaseCommandKeyInfo);
sqlString = localDefine.GetCommandSQL_Next(keyList, "ClientMaster_clm");
ClientMasterInfo clientMaster = null;
try
{
clientMaster = GetRecordForSql(sqlString);
}
catch (Exception Ex)
{
throw Ex;
}
return(clientMaster);
}
public ClientMasterInfo GetRecord_Previous(int currentRecordID)
{
LocalLayer.LocalDefine localDefine = new DAL.SqlDAL.LocalLayer.LocalDefine();
string sqlString = string.Empty;
DataBaseCommandKeyInfo dataBaseCommandKeyInfo = new DataBaseCommandKeyInfo();
List<DataBaseCommandKeyInfo> keyList = new List<DataBaseCommandKeyInfo>();
dataBaseCommandKeyInfo.Key = "clm_iRecID";
dataBaseCommandKeyInfo.KeyValue = currentRecordID.ToString();
dataBaseCommandKeyInfo.KeyValueType = TypeCode.Int32;
keyList.Add(dataBaseCommandKeyInfo);
sqlString = localDefine.GetCommandSQL_Previous(keyList,"ClientMaster_clm");
ClientMasterInfo clientMaster = null;
try
{
clientMaster = GetRecordForSql(sqlString);
}
catch (Exception Ex)
{
throw Ex;
}
return clientMaster;
}
