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