public int SPage(DateTime sdate) { var sql = @"select isnull(max(当前页),0) 当前页 from " + tableName + " where 年=" + sdate.Year + " and 月=" + sdate.Month + " and 日=" + sdate.Day; var page = int.Parse(FITTHelper.GetSingleVal(sql).ToString()); return(page == 0 ? page : page + 1); }
public int SPage() { var sql = @"select isnull(max(当前页),0) 当前页 from 影院专资表"; var page = int.Parse(FITTHelper.GetSingleVal(sql).ToString()); return(page == 0 ? page : page + 1); }
public DateTime SDate() { var sdate = int.Parse(ConfigurationOperator.GetValue("syear")); var sql = @"select isnull(max(日期),'1900-01-01')日期 from " + tableName + " where 年=" + sdate; var riqi = FITTHelper.GetSingleVal(sql).ToString(); if (DateTime.Parse(riqi) == DateTime.Parse("1900-01-01")) { return(new DateTime(sdate, 1, 1)); } else { return(DateTime.Parse((riqi))); } }