1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| namespace HotelPms.Data.Master
| {
| public partial class Output
| {
| public string MaxIDSql()
| {
| return $@"SELECT ISNULL(MAX(ID),0) FROM M_Output WHERE MachineName = N'{MachineName}' AND UserName = N'{UserName}' AND ReportID = {ReportID};";
| }
|
| public string ClearDetailSql()
| {
| return $@"DELETE FROM M_OutputItem WHERE MachineName = N'{MachineName}' AND UserName = N'{UserName}' AND ReportID = {ReportID} AND OutputID = {ID};";
| }
| }
| }
|
|
