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