1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| namespace HotelPms.Data.Common.Util
| {
| public class SyncConfig
| {
| /// <summary>
| /// 32,767
| /// </summary>
| /// <param name="type"></param>
| /// <returns></returns>
| public static string GetLockSql(ESyncType type)
| {
| return $"UPDATE S_SyncConfig SET Seq = CASE WHEN Seq = 32767 THEN 1 ELSE Seq + 1 END,UpdateDate = GETDATE() WHERE ID = {(int)type};";
| }
| }
| }
|
|