public DataSet getIconChild()
{
string query = "SELECT DuongDanAnh, MaDonVi FROM dbo.DonVi";
DataSet dataSet = new DataSet();
connect = new connection();
dataSet = connect.FillDataSet(query, CommandType.Text);
return(dataSet);
}
public DataSet getDataParentNode()
{
string query = "SELECT * FROM dbo.BinhChung";
DataSet dataSet = new DataSet();
connect = new connection();
dataSet = connect.FillDataSet(query, CommandType.Text);
return(dataSet);
}
public void getDataTSDV(DataGridView dataGridView, SearchLookUpEdit searchLookUpEdit)
{
string query = "LayThongTinThamSoDauVao";
DataSet dataSet = new DataSet();
connect = new connection();
dataSet = connect.FillDataSet(query, CommandType.StoredProcedure);
dataGridView.DataSource = dataSet.Tables[0];
searchLookUpEdit.Properties.DataSource = dataSet.Tables[0];
}
public void SelectSuCoWithKeHoach(DataGridView dataGridView, SearchLookUpEdit searchLookUpEdit, int maKeHoach)
{
connection connect;
string query = "SelectSuCoWithIDKeHoach ";
DataSet dataSet = new DataSet();
connect = new connection();
dataSet = connect.FillDataSet(query, CommandType.StoredProcedure, new [] { "maKeHoach" }, new object[] { maKeHoach });
dataGridView.DataSource = dataSet.Tables[0];
searchLookUpEdit.Properties.DataSource = dataSet.Tables[0];
}
public void SelectAllSuCo(DataGridView dataGridView, SearchLookUpEdit searchLookUpEdit)
{
connection connect;
string query = "SelectAllSuCo";
DataSet dataSet = new DataSet();
connect = new connection();
dataSet = connect.FillDataSet(query, CommandType.StoredProcedure);
dataGridView.DataSource = dataSet.Tables[0];
searchLookUpEdit.Properties.DataSource = dataSet.Tables[0];
}
public DataSet getDataChildNode(string mabinhchung)
{
string query = "LayTTDonViTheoBinhChung";
string[] para = { "@mabinhchung" };
string[] value = { mabinhchung };
DataSet dataSet = new DataSet();
connection connect = new connection();
dataSet = connect.FillDataSet(query, CommandType.StoredProcedure, para, value);
return(dataSet);
}
public List <Dem> SelectAllFileDem()
{
connection connect;
string query = "SelectAllFile";
DataSet dataSet = new DataSet();
connect = new connection();
dataSet = connect.FillDataSet(query, CommandType.StoredProcedure);
List <Dem> list = new List <Dem>();
foreach (DataRow row in dataSet.Tables[0].Rows)
{
list.Add(new Dem()
{
MaFile = row.Field <int>((int)FileDemField.MaFile),
TenFile = row.Field <string>((int)FileDemField.TenFile),
DuongDan = row.Field <string>((int)FileDemField.DuongDan)
});
}
return(list);
}