public void SelectProdType(DataSet ds)
{
try
{
string query = @"SELECT * FROM PROD_T ORDER BY PROD_TYPE ASC";
db.ExecuteDsQuery(ds, query);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataSet LoadPayment(UserVO user)
{
DataSet ds = new DataSet();
try
{
string query = @"SELECT * FROM PAY_T WHERE US_EMAIL = '#US_EMAIL' ORDER BY PAY_TYPE_NO ASC ";
query = query.Replace("#US_EMAIL", user.Email);
db.ExecuteDsQuery(ds, query);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(ds);
}
return(ds);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(ds);
}
}