public string GetNewActCode() { var result = string.Empty; var now = DateTime.Now; var sql = @" SELECT COUNT(1) FROM Fct_ActivityBase AND REC_CreateTime >= @REC_CreateTime1 AND REC_CreateTime > @REC_CreateTime2" ; var num = BaseConnection.Count(string.Format(sql, now.ToString("yyyy-M-d 00:00:00"), now.ToString("yyyy-M-d 23:59:59"))); result = now.ToString("yyyyMMdd") + num; return(result); }
public PageResult <Model_Fct_ActivityBase> GetBasePage(int pageSize, int index) { var page = new PageResult <Model_Fct_ActivityBase>(); index = index < 0 ? 0 : index; var start = index * pageSize; var end = (index + 1) * pageSize; var sql = @" WITH LIST as ( SELECT ROW_NUMBER() OVER(ORDER BY Fct_ActivityBase.Rec_CreateTime DESC) AS ROWNUM, Fct_ActivityBase.* FROM dbo.Fct_ActivityBase WHERE Fct_ActivityBase.Disabled = 0 ) SELECT * FROM LIST WHERE ROWNUM BETWEEN {0} AND {1}"; var sqlcount = @" SELECT COUNT(1) FROM dbo.Fct_ActivityBase WHERE Fct_ActivityBase.Disabled = 0"; page.Count = BaseConnection.Count(sqlcount); page.List = BaseConnection.Query <Model_Fct_ActivityBase>(string.Format(sql, start, end)); return(page); }
public Model_Fct_ActivityBase GetBase(string id) { var sql = "SELECT Fct_ActivityBase. FROM dbo.Fct_ActivityBase WHERE Disabled = 0 AND ActivityId = " + id; return(BaseConnection.Query <Model_Fct_ActivityBase>(sql).FirstOrDefault()); }
public Model_Fct_ActivityBase GetBase(Model_Fct_ActivityBase m) { return(BaseConnection.Query <Model_Fct_ActivityBase>("SELECT Fct_ActivityBase.* FROM dbo.Fct_ActivityBase WHERE Disabled = 0 AND ActivityId = @ActivityId", m).FirstOrDefault()); }