34 lines
961 B
C#
34 lines
961 B
C#
namespace Common.UI.Models
|
|
{
|
|
using LaaPackages.SqlClient;
|
|
|
|
internal class P2000_Shared
|
|
{
|
|
public int Id { get; set; }
|
|
|
|
public int PsNo { get; set; }
|
|
|
|
public string Action { get; set; }
|
|
|
|
public bool Completed { get; set; }
|
|
|
|
public string Logs { get; set; }
|
|
}
|
|
|
|
internal static class P2000_Shared_Extensions
|
|
{
|
|
public static int FindSharedId(this SqlConnection connection, int psno, string action)
|
|
=> connection
|
|
.CreateCommand($@"
|
|
SELECT TOP 1 Id
|
|
FROM P2000_Shared
|
|
WHERE Psno = @{nameof(psno)}
|
|
AND Action = @{nameof(action)}
|
|
AND Completed = 0
|
|
ORDER BY Id DESC")
|
|
.SetParameter(nameof(psno), psno)
|
|
.SetParameter(nameof(action), action)
|
|
.FirstOrDefault(x => x.GetValue<int>(0));
|
|
}
|
|
}
|