//select all cash information from ST_EXP_HED table
public DataSet.DsPSMS.ST_EXP_HEDDataTable selectExpHedAllData()
{
DsPSMS.ST_EXP_HEDDataTable expHedDt = new DsPSMS.ST_EXP_HEDDataTable();
Open();
query = "SELECT* FROM ST_EXP_HED WHERE DEL_FLG = " + 0;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(expHedDt);
Close();
return(expHedDt);
}
protected void showExpHedGv()
{
ExpHedDt = expService.getExpHedAllData(out msg);
if (ExpHedDt != null && ExpHedDt.Rows.Count != 0)
{
//ExpHedDt.Columns.Remove(ExpHedDt.Columns[0]);
ExpHedDt.Columns.Remove(ExpHedDt.Columns[6]);
ExpHedDt.Columns.Remove(ExpHedDt.Columns[6]);
ExpHedDt.Columns.Remove(ExpHedDt.Columns[6]);
ExpHedDt.Columns.Remove(ExpHedDt.Columns[6]);
expHedList.DataSource = ExpHedDt;
expHedList.DataBind();
}
}
public DataSet.DsPSMS.ST_EXP_HEDDataTable getExpHedAllData(out string msg)
{
DsPSMS.ST_EXP_HEDDataTable expHedDt = new DsPSMS.ST_EXP_HEDDataTable();
try
{
Open();
expHedDt = expDb.selectExpHedAllData();
msg = "Have data";
}
catch
{
msg = "error occurs when selecting the Expanse Head";
return(null);
}
finally
{
Close();
}
return(expHedDt);
}
