protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { PrizeSysConfig conf = (from a in db.PrizeSysConfigs select a).FirstOrDefault(); string s = ""; if (conf != null && conf.SystemDate.HasValue) { currentTime = conf.SystemDate.Value; } else { currentTime = DateTime.Now; } s = currentTime.ToString("yyyy-MM-dd"); txtDate.Text = s; } } lblError.Text = ""; } }
static public DateTime GetSystemDate() { DateTime dt = DateTime.Now; bool bTest = true; if (!bTest) { return(dt); } using (DIYPTEntities db = new DIYPTEntities()) { PrizeSysConfig conf = (from c in db.PrizeSysConfigs select c).FirstOrDefault(); if (conf != null && conf.SystemDate.HasValue) { dt = conf.SystemDate.Value; } } return(dt); }