public Posversionmodifylog GetLasterPosversionmodifylogByPosid(string pos_id) { const string sqlTxt = @"SELECT top 1 [id] ,[posid] ,[versionNo] ,[updatefileurl] ,[updatetype] ,[updatetime] FROM [EtownDB].[dbo].[posversionmodifylog] where posid=@posid order by id desc"; var cmd = sqlHelper.PrepareTextSqlCommand(sqlTxt); cmd.AddParam("@posid", pos_id); using (var reader = cmd.ExecuteReader()) { Posversionmodifylog u = null; while (reader.Read()) { u = new Posversionmodifylog { Id = reader.GetValue <int>("id"), Posid = reader.GetValue <int>("posid"), VersionNo = reader.GetValue <decimal>("versionNo"), Updatefileurl = reader.GetValue <string>("updatefileurl"), Updatetime = reader.GetValue <DateTime>("updatetime"), Updatetype = reader.GetValue <int>("updatetype"), }; } return(u); } }
public Posversionmodifylog GetLatestVersion(string pos_id) { using (var sql = new SqlHelper()) { try { var internalData = new InternalPosversionmodifylog(sql); Posversionmodifylog result = internalData.GetLasterPosversionmodifylogByPosid(pos_id); return(result); } catch { throw; } } }