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; }