public void KomisyonBedeliniGetir(string musteriNumarasi, DateTime?baslangicTarihi, DateTime?bitisTarihi
, out DataTable dtITAB, out DataTable dtZRETURN)
{
SAPDestinationConfiguration sapDestinationConfiguration = new SAPDestinationConfiguration();
IRfcFunction rfcFunction = null;
try
{
// ishak.kulekci 24.06.2013
// Destination configuration already initialized hatasını engelleme, bunun için önce TryGetDestination kullanılır
RfcDestination rfcDestination = RfcDestinationManager.TryGetDestination("SAPSYSTEM");
if (rfcDestination == null)
{
try
{
RfcDestinationManager.RegisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
rfcDestination = RfcDestinationManager.GetDestination("SAPSYSTEM");
}
//RfcDestination rfcDestination = RfcDestinationManager.GetDestination("SAPSYSTEM");
rfcFunction = rfcDestination.Repository.CreateFunction("Z_RFC_YK_BEKPRIM_TO_INTERNET");
//rfcFunction.SetValue("KUNNR", "100092"); // aygaz
rfcFunction.SetValue("KUNNR", musteriNumarasi);
//rfcFunction.SetValue("DATAB", "20130601");
rfcFunction.SetValue("DATAB", baslangicTarihi.Value.ToString("yyyyMMdd", CultureInfo.GetCultureInfo("tr-tr")));
//rfcFunction.SetValue("DATBI", "20130605");
rfcFunction.SetValue("DATBI", bitisTarihi.Value.ToString("yyyyMMdd", CultureInfo.GetCultureInfo("tr-tr")));
rfcFunction.Invoke(rfcDestination);
}
catch (Exception exception)
{
throw exception;
}
finally
{
try
{
RfcDestinationManager.UnregisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
}
dtITAB = RFCHelper.RfcTableToDataTable(rfcFunction.GetTable("ITAB"), "ITAB");
dtZRETURN = RFCHelper.RfcTableToDataTable(rfcFunction.GetTable("ZRETURN"), "ZRETURN");
}
private void btnRFCExecute_Click(object sender, EventArgs e)
{
try
{
string rfcName = txtRFCName.Text;
SAPDestinationConfiguration sapDestinationConfiguration = new SAPDestinationConfiguration();
IRfcFunction rfcFunction = null;
try
{
// ishak.kulekci 24.06.2013
// Destination configuration already initialized hatasını engelleme, bunun için önce TryGetDestination kullanılır
RfcDestination rfcDestination = RfcDestinationManager.TryGetDestination("SAPSYSTEM");
if (rfcDestination == null)
{
try
{
RfcDestinationManager.RegisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
rfcDestination = RfcDestinationManager.GetDestination("SAPSYSTEM");
}
//RfcDestination rfcDestination = RfcDestinationManager.GetDestination("SAPSYSTEM");
//rfcFunction = rfcDestination.Repository.CreateFunction("Z_RFC_YK_BEKPRIM_TO_INTERNET");
////rfcFunction.SetValue("KUNNR", "100092"); // aygaz
//rfcFunction.SetValue("KUNNR", musteriNumarasi);
////rfcFunction.SetValue("DATAB", "20130601");
//rfcFunction.SetValue("DATAB", baslangicTarihi.Value.ToString("yyyyMMdd", CultureInfo.GetCultureInfo("tr-tr")));
////rfcFunction.SetValue("DATBI", "20130605");
//rfcFunction.SetValue("DATBI", bitisTarihi.Value.ToString("yyyyMMdd", CultureInfo.GetCultureInfo("tr-tr")));
//rfcFunction.Invoke(rfcDestination);
rfcFunction = rfcDestination.Repository.CreateFunction(rfcName);
//rfcFunction.Metadata
// ishak.kulekci 26.11.2015 09.00 import parametreleri set edilir, rfc invoke edilir
// rfc sonucunda gelen export ve table parametreleri elde edilir ve gösterilir
foreach (DataGridViewRow row in gvImportParams.Rows)
{
string prmName = row.Cells["cName"].Value == null ? "" : row.Cells["cName"].Value.ToString(); // cName -> Name verisi
string prmNewValue = row.Cells["cNewValue"].Value == null ? "" : row.Cells["cNewValue"].Value.ToString(); // cNewValue -> NewValue verisi
rfcFunction.SetValue(prmName, prmNewValue);
}
// rfc invoke edilir
rfcFunction.Invoke(rfcDestination);
//RfcParameterMetadata describing an importing/exporting/tables parameter of a function module
List <RfcParameterMetadata_ForUI> listRfcParameterMetadataWhichDirectionExport = new List <RfcParameterMetadata_ForUI>();
List <RFCTableWhichHasDataTableAndFieldInfo> listRFCTable = new List <RFCTableWhichHasDataTableAndFieldInfo>();
int parameterCount = rfcFunction.Metadata.ParameterCount;
for (int i = 0; i < parameterCount; i++)
{
RfcParameterMetadata rfcParameterMetadata = rfcFunction.Metadata[i];
//rfcParameterMetadata.DefaultValue
//rfcParameterMetadata.Direction
//RfcDirection.CHANGING
//RfcDirection.EXPORT
//RfcDirection.IMPORT
//RfcDirection.TABLES
//rfcParameterMetadata.Optional
//rfcParameterMetadata.Name
if (rfcParameterMetadata.Direction == RfcDirection.EXPORT)
{
listRfcParameterMetadataWhichDirectionExport.Add(Convert_To_RfcParameterMetadata_ForUI(rfcParameterMetadata));
}
else if (rfcParameterMetadata.Direction == RfcDirection.TABLES)
{
RfcTableMetadata rfcTableMetadata = rfcParameterMetadata.ValueMetadataAsTableMetadata;
int fieldCount = rfcTableMetadata.LineType.FieldCount;
// field adeti kadar Datatable nesnesi oluşturup kolon eklemesi yapılacak
DataTable dt = new DataTable(rfcTableMetadata.Name);
List <RfcFieldMetadata_ForUI> listRfcFieldMetadata = new List <RfcFieldMetadata_ForUI>();
for (int j = 0; j < fieldCount; j++)
{
RfcFieldMetadata rfcFieldMetadata = rfcTableMetadata[j];
DataColumn dc = new DataColumn(rfcFieldMetadata.Name);
dt.Columns.Add(dc);
listRfcFieldMetadata.Add(Convert_To_RfcFieldMetadata_ForUI(rfcFieldMetadata));
}
RFCTableWhichHasDataTableAndFieldInfo rfcTable = new RFCTableWhichHasDataTableAndFieldInfo();
rfcTable.TableParameterMetadata = Convert_To_RfcParameterMetadata_ForUI(rfcParameterMetadata);
rfcTable.DataTableForItems = RFCHelper.RfcTableToDataTable(rfcFunction.GetTable(rfcParameterMetadata.Name), rfcParameterMetadata.Name); //dt;
rfcTable.ListForFieldMetadata = listRfcFieldMetadata;
listRFCTable.Add(rfcTable);
}
}
gvExportParams.AutoGenerateColumns = false;
gvExportParams.DataSource = listRfcParameterMetadataWhichDirectionExport;
// tablolar elde edilip, tabcontrol içine tabpage olarak eklenir
// her tabpage içinde datagridview eklenir, kolon değerlerini alma sağlanır
foreach (RFCTableWhichHasDataTableAndFieldInfo itemTable in listRFCTable)
{
TabPage page = new TabPage();
page.Text = itemTable.TableParameterMetadata.Name;
page.Name = "tp" + itemTable.TableParameterMetadata.Name;
page.Width = 550;
page.Height = 300;
DataGridView gv = new DataGridView();
gv.Name = "gv" + itemTable.TableParameterMetadata.Name;
// grid kaynağı bağlanmalı
gv.DataSource = itemTable.DataTableForItems;
gv.Anchor = AnchorStyles.Left | AnchorStyles.Right;
gv.Location = new Point(5, 35);
gv.Margin = new Padding(3);
gv.Width = 540;
gv.Height = 200;
gv.AllowUserToAddRows = false;
gv.AllowUserToDeleteRows = false;
gv.ReadOnly = true;
//gv.Visible = false;
Label lblRowCount = new Label();
lblRowCount.Name = "lblRowCount" + itemTable.TableParameterMetadata.Name;
lblRowCount.Text = "Veri Adeti: " + itemTable.DataTableForItems.Rows.Count.ToString();
lblRowCount.Location = new Point(gv.Location.X, gv.Location.Y + gv.Height - 20);
page.Controls.Add(gv);
page.Controls.Add(lblRowCount);
tcTablesToExport.TabPages.Add(page);
}
}
catch (Exception exception)
{
throw exception;
}
finally
{
try
{
RfcDestinationManager.UnregisterDestinationConfiguration(sapDestinationConfiguration);
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}