public bool chkLogin(string id, string pass)
{
ClsDb db = new ClsDb();
DataTable tb;
try
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT * FROM users");
sql.AppendLine("WHERE user_id = " + id);
sql.AppendLine("AND password = "******"localhost", "master", "sa", "", -1);
tb = db.ExecuteSql(sql.ToString(), -1);
if (tb.Rows.Count == 0)
{
return(false);
}
}
catch (Exception e)
{
}
finally
{
db.Disconnect();
}
return(true);
}
internal List <ARTICLE> GetArticles()
{
List <ARTICLE> articles = new List <ARTICLE>();
ClsDb db = new ClsDb();
DataTable tb;
try
{
db.Connect("localhost", "master", "sa", "", -1);
tb = db.ExecuteSql("select * from article_title order by create_date desc", -1);
foreach (DataRow dr in tb.Rows)
{
ARTICLE article = new ARTICLE();
article.kanri_no = utils.NullChkToInt(dr["kanri_no"]);
article.title_no = utils.NullChkToInt(dr["title_no"]);
article.title_name = utils.NullChkString(dr["title_name"]);
article.title_msg = utils.NullChkString(dr["title_msg"]);
article.create_user = utils.NullChkToInt(dr["create_user"]);
}
}catch (Exception e)
{
}finally
{
db.Disconnect();
}
return(articles);
}