ASP.Net MVC3连接SAP实践

gir

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using SAP.Middleware.Connector;
using System.Data;
namespace SAPMVC.Controllers
{
public class HomeController : Controller
{
string MATNR = string.Empty;
public ActionResult Index()
{
ViewBag.Message = "Welcome to ASP.NET MVC!";
nco();
//nco2();
return View();
}
public void nco2()
{
RfcConfigParameters rfcPar = new RfcConfigParameters();
//rfcPar.Add(RfcConfigParameters.Name, "CON");
//rfcPar.Add(RfcConfigParameters.AppServerHost, "192.168.1.3");
//rfcPar.Add(RfcConfigParameters.Client, "800");
//rfcPar.Add(RfcConfigParameters.User, "UserID");
//rfcPar.Add(RfcConfigParameters.Password, "Password");
//rfcPar.Add(RfcConfigParameters.SystemNumber, "02");
//rfcPar.Add(RfcConfigParameters.Language, "EN");
rfcPar.Add(RfcConfigParameters.Name, "CON");
rfcPar.Add(RfcConfigParameters.AppServerHost, "192.168.1.3");   //SAP主机IP
rfcPar.Add(RfcConfigParameters.SystemNumber, "00");  //SAP实例
rfcPar.Add(RfcConfigParameters.User, "MENGXIN");  //用户名
rfcPar.Add(RfcConfigParameters.Password, "5239898");  //密码
rfcPar.Add(RfcConfigParameters.Client, "888");  // Client
//rfcPar.Add(RfcConfigParameters.Language, "ZH");  //登陆语言
//rfcPar.Add(RfcConfigParameters.PoolSize, "5");
//rfcPar.Add(RfcConfigParameters.MaxPoolSize, "10");
//rfcPar.Add(RfcConfigParameters.IdleTimeout, "60");
RfcDestination dest = RfcDestinationManager.GetDestination(rfcPar);
RfcRepository rfcrep = dest.Repository;
IRfcFunction myfun = null;
myfun = rfcrep.CreateFunction("SAP里面的函数名称");
myfun.SetValue("VTYPE", "0");//SAP里面的传入参数
myfun.Invoke(dest);
IRfcTable IrfTable = myfun.GetTable("IT_ZMYTB2");
//提前实例化一个空的表结构出来
DataTable dt = new DataTable();
dt.Columns.Add("USERID");
dt.Columns.Add("USERPWD");
dt.Columns.Add("USERADDRESS");
//循环把IRfcTable里面的数据放入Table里面，因为类型不同，不可直接使用。
for (int i = 0; i < IrfTable.Count; i++)
{
IrfTable.CurrentIndex = i;
DataRow dr = dt.NewRow();
dr["USERID"] = IrfTable.GetString("USERID");
dr["USERPWD"] = IrfTable.GetString("USERPWD");
dr["USERADDRESS"] = IrfTable.GetString("USERADDRESS");
dt.Rows.Add(dr);
}
}
public void nco()
{
IDestinationConfiguration ID = new MyBackendConfig();
RfcDestinationManager.RegisterDestinationConfiguration(ID);
RfcDestination prd = RfcDestinationManager.GetDestination("PRD_000");
RfcDestinationManager.UnregisterDestinationConfiguration(ID);
nco(prd);
}
public void nco(RfcDestination prd)
{
RfcRepository repo = prd.Repository;
IRfcFunction companyBapi = repo.CreateFunction("ZRFC_MARA_INFO");   //调用函数名
companyBapi.SetValue("MATNR", MATNR);   //设置Import的参数
companyBapi.Invoke(prd);   //执行函数
IRfcTable table = companyBapi.GetTable("IT_MARA");  //获取相应的品号内表
string MAKTX = companyBapi.GetValue("MAKTX").ToString();  //获取品名
DataTable dt = new DataTable();  //新建表格
dt.Columns.Add("品号");  //表格添加一列
for (int i = 0; i < table.RowCount; i++)
{
table.CurrentIndex = i;  //当前内表的索引行
DataRow dr = dt.NewRow();
dr[0] = table.GetString("MATNR");  //获取表格的某行某列的值
dt.Rows.Add(dr);  //填充该表格的值
}
if (MATNR == "")
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//this.comboBox1.Items.Add(dt.Rows[0].ToString());   //填充下拉框
}
}
//this.label1.Text = MAKTX;   //显示品名
prd = null;
repo = null;
}
public ActionResult About()
{
return View();
}
//登陆SAP前的准备工作
public class MyBackendConfig : IDestinationConfiguration
{
public RfcConfigParameters GetParameters(String destinationName)
{
if ("PRD_000".Equals(destinationName))
{
RfcConfigParameters parms = new RfcConfigParameters();
//parms.Add(RfcConfigParameters.Name, "PRD_000");
parms.Add(RfcConfigParameters.AppServerHost, "192.168.1.3");   //SAP主机IP
parms.Add(RfcConfigParameters.SystemNumber, "00");  //SAP实例
parms.Add(RfcConfigParameters.User, "MENGXIN");  //用户名
parms.Add(RfcConfigParameters.Password, "5239898");  //密码
parms.Add(RfcConfigParameters.Client, "888");  // Client
parms.Add(RfcConfigParameters.Language, "ZH");  //登陆语言
parms.Add(RfcConfigParameters.PoolSize, "5");
parms.Add(RfcConfigParameters.MaxPoolSize, "10");
parms.Add(RfcConfigParameters.IdleTimeout, "60");
return parms;
}
else return null;
}
public bool ChangeEventsSupported()
{
return false;
}
public event RfcDestinationManager.ConfigurationChangeHandler ConfigurationChanged;
}
}
}