public static ArrayList GetUpdate(Test test)
{
MYsql my = new MYsql();
//Console.WriteLine("GetUpdate 진입성공");
string sql = string.Format("update Notice set nTitle = '{1}', nContents = '{2}' where nNo = {0};", test.nNo, test.nTitle, test.nContents);
if (my.NonQuery(sql))
{
return(GetSelect());
}
else
{
return(new ArrayList());
}
}
public static ArrayList GetDelete(Test test)
{
//Console.WriteLine("GetDelete 진입성공 test.nNo : " + test.nNo);
MYsql my = new MYsql();
string sql = string.Format("update Notice set delYn = 'Y' where nNo = {0};", test.nNo);
if (my.NonQuery(sql))
{
return(GetSelect());
}
else
{
return(new ArrayList());
}
}
public static ArrayList GetInsert(Test test)
{
int mNo = Member_GetSelect(test);
//Console.WriteLine("성공1 : " + mNo);
MYsql my = new MYsql();
string sql = string.Format("insert into Notice (mNo, nTitle, nContents) values ('{0}','{1}','{2}');", mNo, test.nTitle, test.nContents);
if (my.NonQuery(sql))
{
return(GetSelect());
}
else
{
return(new ArrayList());
}
}
