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;
}
