public DataTable TableGetAccountByNo(string accountNo)
{
AccessDB accessDB = new AccessDB();
DataTable dt = accessDB.Get(SQL_SELECT_EX, GenerateParameters(accountNo));
if (String.IsNullOrEmpty(accountNo))
{
object obj = accessDB.GetExcuteScalar("Select Max(AccountNo) From Account");
DataRow dr = dt.NewRow();
int no = Convert.ToInt32(obj);
no++;
dr["AccountNo"] = no.ToString();
dt.Rows.Add(dr);
}
return(dt);
}