public List<OnlineModelShow> Convert(List<Online> item) { List<OnlineModelShow> result = new List<OnlineModelShow>(); foreach (var i in item) { if (i.EndTime != null) { var Sales = new OnlineModelShow { Id = i.Id, Type = i.Type, Name = i.Name, Content = HttpUtility.HtmlDecode(i.Content), Banner_PC = i.Banner_PC, Banner_Mobile = i.Banner_Mobile, Url = i.Url, Display = i.Display, StartTime = i.StartTime.AddHours(8), EndTime = i.EndTime.Value.AddHours(8), UpdateTime = i.UpdateTime.AddHours(8), }; result.Add(Sales); } else { var Sales = new OnlineModelShow { Id = i.Id, Type = i.Type, Name = i.Name, Content = HttpUtility.HtmlDecode(i.Content), Banner_PC = i.Banner_PC, Banner_Mobile = i.Banner_Mobile, Url = i.Url, Display = i.Display, StartTime = i.StartTime.AddHours(8), UpdateTime = i.UpdateTime.AddHours(8), }; result.Add(Sales); } } return result; }
public List<Category> Get_Type() { s26webDataContext db = new s26webDataContext(); OnlineModelShow data = new OnlineModelShow(); data.type_list = db.Category.Where(w => w.Fun_Id == 10).ToList(); db.Connection.Close(); return data.type_list; }
public int Insert(OnlineModelShow item) { s26webDataContext db = new s26webDataContext(); try { //有輸入下線時間 if (item.EndTime != DateTime.Parse("0001/1/1 上午 12:00:00")) { Online new_item = new Online { Type = item.Type, Name = item.Name, Content = item.Content, Banner_PC = item.Banner_PC, Banner_Mobile = item.Banner_Mobile, Url = item.Url, Display = item.Display, StartTime = item.StartTime.AddHours(-8), EndTime = item.EndTime.AddHours(-8), UpdateTime = DateTime.UtcNow }; db.Online.InsertOnSubmit(new_item); db.SubmitChanges(); db.Connection.Close(); return new_item.Id; } else { Online new_item = new Online { Type = item.Type, Name = item.Name, Content = item.Content, Banner_PC = item.Banner_PC, Banner_Mobile = item.Banner_Mobile, Url = item.Url, Display = item.Display, StartTime = item.StartTime.AddHours(-8), UpdateTime = DateTime.UtcNow }; db.Online.InsertOnSubmit(new_item); db.SubmitChanges(); db.Connection.Close(); return new_item.Id; } } catch { return -1; } }
public int Update(OnlineModelShow item) { try { s26webDataContext db = new s26webDataContext(); var data = db.Online.FirstOrDefault(f => f.Id == item.Id); if (data != null) { data.Type = item.Type; data.Name = item.Name; data.Content = item.Content; if (item.Banner_PC != null) { data.Banner_PC = item.Banner_PC; } if (item.Banner_Mobile != null) { data.Banner_Mobile = item.Banner_Mobile; } data.Url = item.Url; data.Display = item.Display; data.StartTime = item.StartTime.AddHours(-8); if (item.EndTime != DateTime.Parse("0001/1/1 上午 12:00:00")) { data.EndTime = item.EndTime.AddHours(-8); } else { data.EndTime = null; } data.UpdateTime = DateTime.UtcNow; db.SubmitChanges(); db.Connection.Close(); return data.Id; } db.Connection.Close(); return -1; } catch { return -1; } }
public OnlineModelShow Get_One_Front(int id) { s26webDataContext db = new s26webDataContext(); OnlineModelShow data = new OnlineModelShow(); var item = db.Online.FirstOrDefault(f => f.Id == id); data.Type = item.Type; data.Name = item.Name; data.Content = HttpUtility.HtmlDecode(item.Content); data.Banner_PC = item.Banner_PC; data.Banner_Mobile = item.Banner_Mobile; data.Url = item.Url; data.Display = item.Display; data.StartTime = item.StartTime.AddHours(8); if (item.EndTime != null) { data.EndTime = item.EndTime.Value.AddHours(8); } data.UpdateTime = item.UpdateTime.AddHours(8); db.Connection.Close(); return data; }