//select cash information by id from ST_EXP_DETAIL table
public DataSet.DsPSMS.ST_EXP_DETAILDataTable selectExpDetDataById(int expId)
{
DsPSMS.ST_EXP_DETAILDataTable expDetDt = new DsPSMS.ST_EXP_DETAILDataTable();
Open();
query = "SELECT* FROM ST_EXP_DETAIL WHERE EXP_ID = " + expId + " AND DEL_FLG = " + 0;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(expDetDt);
Close();
return(expDetDt);
}
// delete the cash information from ST_EXP_DETAIL tabel
public void deleteExpDet(DataSet.DsPSMS.ST_EXP_DETAILRow dr)
{
DsPSMS.ST_EXP_DETAILDataTable expDetDt = new DsPSMS.ST_EXP_DETAILDataTable();
Open();
string query = "";
query = "UPDATE ST_EXP_DETAIL SET DEL_FLG =" + 1 + " WHERE EXP_ID = " + dr.EXP_ID + " AND CRT_DT_TM='" + dr.CRT_DT_TM + "'";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
Close();
}
protected void showExpHedGv()
{
DsPSMS.ST_EXP_DETAILDataTable expDetDt = new DsPSMS.ST_EXP_DETAILDataTable();
int expId = Convert.ToInt32(LblExpIdVal.Text);
expDetDt = expService.getExpDetDataById(expId, out msg);
if (expDetDt != null)
{
//expDetDt.Columns.Remove(expDetDt.Columns[0]);
expDetDt.Columns.Remove(expDetDt.Columns[4]);
expDetDt.Columns.Remove(expDetDt.Columns[4]);
expDetDt.Columns.Remove(expDetDt.Columns[4]);
expDetDt.Columns.Remove(expDetDt.Columns[4]);
expDetList.DataSource = expDetDt;
expDetList.DataBind();
}
}
public DataSet.DsPSMS.ST_EXP_DETAILDataTable getExpDetDataById(int expId, out string msg)
{
DsPSMS.ST_EXP_DETAILDataTable expDetDt = new DsPSMS.ST_EXP_DETAILDataTable();
try
{
Open();
expDetDt = expDb.selectExpDetDataById(expId);
int ttt = expDetDt.Rows.Count;
msg = "Have data";
}
catch
{
msg = "error occurs when selecting the Expanse data";
return(null);
}
finally
{
Close();
}
return(expDetDt);
}
