private void STLINE(string BR_SELECT_ROW_FATURA_NO, string ID)
{
if (BR_SELECT_ROW_FATURA_NO != "" && ID != "")
{
_ERP_CLASS sql = new _ERP_CLASS();
string LINE_TABLE_SQL = string.Format(sql.LINE_TABLE_SQL, _GLOBAL_PARAMETERS._DBONAME, _GLOBAL_PARAMETERS._SIRKET_NO.ToString(), "01");
using (SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_ERP.ToString()))
{
SqlDataAdapter da = new SqlDataAdapter(LINE_TABLE_SQL + " AND (ln.INVOICEREF=" + ID + ")", myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "dbo_MecraList");
DataViewManager dvManager = new DataViewManager(ds);
DataView dv = dvManager.CreateDataView(ds.Tables[0]);
gridCntrl_LINE.DataSource = dv;
myConnection.Close();
}
}
}
private void DATA_LOAD()
{
using (SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_ERP.ToString()))
{
_ERP_CLASS sql = new _ERP_CLASS();
string INVOICE_TABLE_SQL = string.Format(sql.INVOICE_TABLE_SQL_PRINT, _GLOBAL_PARAMETERS._DBONAME, _GLOBAL_PARAMETERS._SIRKET_NO.ToString(), "01");
SqlCommand cmd = myConnection.CreateCommand();
cmd.CommandText = INVOICE_TABLE_SQL + " AND (fat.TRCODE IN (" + _FATURA_TYPE + ")) ";
SqlDataAdapter deMaster = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
deMaster.Fill(ds, "Header");
ds.Relations.Clear();
//ds.Relations.Add("Rapor", ds.Tables["Header"].Columns["LOGICALREF"], ds.Tables["Detail"].Columns["INVOICEREF"], false);
//gridCntrl_LIST.LevelTree.Nodes.Add(ds.Relations["Rapor"].RelationName, gridView_DETAYLAR);
gridCntrl_LIST.DataSource = ds.Tables["Header"];
gridCntrl_LIST.Refresh();
gridCntrl_LIST.RefreshDataSource();
myConnection.Close();
}
}