public List <DailyNews> GetDailyNews(string Conn)
{
using (MySql.Data.MySqlClient.MySqlConnection sqlConnection = new MySql.Data.MySqlClient.MySqlConnection(Conn)){
SQLs.AppendLine("SELECT * ");
SQLs.AppendLine("FROM CoreMVCBackend.DailyNews ");
SQLs.AppendLine("WHERE Status!=3 ");
SQLs.AppendLine("ORDER BY NewsDate DESC");
List <DailyNews> news = sqlConnection.Query <DailyNews>(SQLs.ToString()).AsList();
return(news);
}
}
public IEnumerable <NavBarItemModel> QueryNavBarItem(string conn)
{
using (MySqlConnection sConn = new MySqlConnection(conn)){
SQLs.Clear();
SQLs.AppendLine("SELECT * ");
SQLs.AppendLine("FROM CoreMVCBackend.NavBarItems ");
SQLs.AppendLine("WHERE ItemStatus!=3 ");
var items = sConn.Query <NavBarItemModel>(SQLs.ToString());
return(items);
}
}
public List <NavBarItem> GetAllItems(string Conn)
{
using (MySql.Data.MySqlClient.MySqlConnection sConn = new MySql.Data.MySqlClient.MySqlConnection(Conn)){
SQLs.Clear();
SQLs.AppendLine("SELECT * ");
SQLs.AppendLine("FROM CoreMVCBackend.NavBarItems ");
SQLs.AppendLine("WHERE ItemStatus!=3 ");
List <NavBarItem> items = sConn.Query <NavBarItem>(SQLs.ToString()).AsList();
return(items);
}
}
public bool DeleteNavBarItem(int id, string conn)
{
using (MySqlConnection sConn = new MySqlConnection(conn)){
bool Result = false;
SQLs.Clear();
SQLs.AppendLine("UPDATE CoreMVCBackend.NavBarItems ");
SQLs.AppendLine("SET ItemStatus=3 ");
SQLs.AppendLine("WHERE ID=@ID ");
object param = new{
ID = id
};
Result = sConn.Execute(SQLs.ToString(), param) == 0?false:true;
return(Result);
}
}
public bool CreateNavBarItem(NavBarItemModel model, string conn)
{
using (MySqlConnection sConn = new MySqlConnection(conn)){
bool result = false;
SQLs.Clear();
SQLs.AppendLine("INSERT INTO CoreMVCBackend.NavBarItems ");
SQLs.AppendLine("(ItemName,ItemController,ItemAction,ItemStatus) ");
SQLs.AppendLine("Values ");
SQLs.AppendLine("(@ItemName,'NavBar',@ItemAction,@ItemStatus) ");
object param = new{
ItemName = model.ItemName,
ItemAction = model.ItemAction,
ItemStatus = model.ItemStatus
};
result = sConn.Execute(SQLs.ToString(), param) == 0?false:true;
return(result);
}
}
public bool CreateDailyNews(CoreMVCBackend.Model.DailyNews.DailyNews DailyNews, string Conn)
{
using (MySqlConnection sqlConnection = new MySqlConnection(Conn)){
bool result = false;
SQLs.Clear();
SQLs.AppendLine("INSERT into CoreMVCBackend.DailyNews ");
SQLs.AppendLine("(NewsDate,Subject,Context,Status) ");
SQLs.AppendLine("VALUES ");
SQLs.AppendLine("(@NewsDate,@Subject,@Context,@Status) ");
object param = new{
NewsDate = DailyNews.NewsDate,
Subject = DailyNews.Subject,
Context = DailyNews.Context,
Status = DailyNews.Status
};
result = sqlConnection.Execute(SQLs.ToString(), param) == 0?false:true;
return(result);
}
}
public AccountModel Create(string Acc, string Pass, string Conn)
{
AccountModel result = new AccountModel();
using (MySqlConnection conn = new MySqlConnection(Conn)){
SQLs.Clear();
SQLs.AppendLine("SELECT * ");
SQLs.AppendLine("FROM CoreMVCBackend.Account ");
SQLs.AppendLine("WHERE Account_Account=@Account_Account ");
List <AccountModel> query = conn.Query <AccountModel>(SQLs.ToString(), new { Account_Account = Acc })
.AsList();
if (query.Count == 0)
{
throw new LogInException("202", "查無該帳號");
}
if (query.Count > 1)
{
throw new LogInException("202", "帳號異常,重複註冊");
}
#region 重複嘗試失敗
#endregion 重複嘗試失敗
var User = query[0];
if (!EncodeHelper.Encode(EncodeEnum.SHA1, Pass).Equals(User.Account_Password))
{
throw new LogInException("202", "密碼錯誤");
}
result = User;
}
return(result);
}
public bool ModifyNavBarItem(NavBarItemModel model, string conn)
{
using (MySqlConnection sConn = new MySqlConnection(conn)){
bool result = false;
SQLs.Clear();
SQLs.AppendLine("UPDATE CoreMVCBackend.NavBarItems ");
SQLs.AppendLine("SET ItemName=@ItemName,ItemController=@ItemController, ");
SQLs.AppendLine("ItemAction=@ItemAction,ItemStatus=@ItemStatus ");
SQLs.AppendLine("WHERE ");
SQLs.AppendLine("ID=@ID ");
object param = new{
ID = model.ID,
ItemName = model.ItemName,
ItemController = model.ItemController,
ItemAction = model.ItemAction,
ItemStatus = model.ItemStatus
};
result = sConn.Execute(SQLs.ToString(), param) == 0?false:true;
return(result);
}
}
