public List <SapDepartment> SapDepartmentGetByProductCode(string branchCode, string productCode)
{
RfcDestination sapRfcDestination = SapHelper.Destination;
RfcRepository sapRfcRepository = sapRfcDestination.Repository;
RfcRepository repo = sapRfcRepository;
string bapiName = "ZDD_EXPORT_TABLE_ZMATSELLER";
IRfcFunction exportBapi = repo.CreateFunction(bapiName);
exportBapi.SetValue("IN_MATNR", SapFormatProductCode(productCode));
exportBapi.Invoke(sapRfcDestination);
IRfcTable detail = exportBapi.GetTable("IN_ZMAT_SELLER");
var sapDepartment = new List <SapDepartment>();
foreach (var item in detail)
{
if (branchCode.Equals(item["WERKS"].GetString()))
{
sapDepartment.Add(new SapDepartment
{
DepartmentCode = detail.GetString("LOGGR"),
DepartmentName = detail.GetString("LTEXT")
});
}
}
return(sapDepartment);
}
public string getLP_Desc(string idioma, string lista) //Trae la descripción lista de precio consultada
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_007");//Módulo de función
//bapi.SetValue("SPRAS", ");
bapi.SetValue("PLTYP", lista);
bapi.Invoke(oDestino);
//IRfcTable tabla = bapi.GetTable("IT_KNVP");
string cadena = "";
IRfcTable tabla = bapi.GetTable("IT_T189T");
for (int i = 0; i < tabla.Count & i < 1; i++)
{
tabla.CurrentIndex = i;
cadena = tabla.GetString("PLTYP") + " " + tabla.GetString("PTEXT");
}
return(cadena);
}
else
{
return(null);
}
}
public string auto_clientes(string vk, string vt, string sp, string ku, string em, string tp) //Autocompleta de cliente
{
Conexion con = new Conexion("E-DESARROLL2", "Initial02");
string t = "";
//if (!tp.Trim().Equals("A"))
if (tp.Trim().Equals("V") | tp.Trim().Equals("C")) //ADD RSG 23.06.2017
{
t = em;
}
IRfcTable tabla = con.AutoKUNNR(vk, vt, sp, ku.ToUpper(), t);
string[] lista = new string[tabla.Count];
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
lista[i] = tabla.GetString("KUNNR");
lista[i] += " - " + tabla.GetString("NAME1");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista); //Convertir arreglo a string para JavaScript
return(list);
}
public List <SapDepartment> SapDepartmentGetByLocationCode(string branchCode, string warehouseCode, string locationCode)
{
RfcDestination sapRfcDestination = SapHelper.Destination;
RfcRepository sapRfcRepository = sapRfcDestination.Repository;
RfcRepository repo = sapRfcRepository;
string bapiName = "ZDD_EXPORT_SELLER_FROM_LOCATE";
IRfcFunction companyBapi = repo.CreateFunction(bapiName);
companyBapi.SetValue("I_BIN_CODE", locationCode);
companyBapi.SetValue("I_LGORT", warehouseCode);
companyBapi.SetValue("I_WERKS", branchCode);
companyBapi.Invoke(sapRfcDestination);
IRfcTable detail = companyBapi.GetTable("O_TLOGT");
var sapDepartment = new List <SapDepartment>();
foreach (var item in detail)
{
sapDepartment.Add(new SapDepartment
{
DepartmentCode = detail.GetString("LOGGR"),
DepartmentName = detail.GetString("LTEXT")
});
}
return(sapDepartment);
}
public List <meins> meinss() //Trae cadena de mail y teléfono
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_045");//Módulo de función
bapi.Invoke(oDestino);
IRfcTable tcurr = bapi.GetTable("IT_T006A");
List <meins> mm = new List <meins>();
for (int i = 0; i < tcurr.Count; i++)
{
tcurr.CurrentIndex = i;
meins m = new meins();
m.MSEHI = tcurr.GetString("MSEHI");
//m.MSEHI = tcurr.GetString("MSEH3");
m.MSEH3 = tcurr.GetString("MSEH3");
m.desc = tcurr.GetString("MSEHL");
mm.Add(m);
}
//List<string> ms = new List<string>();
//foreach(meins m in mm)
//{
// ms.Add("<option value='"+m.MSEHI+"'>"+ m.MSEH3+ " - " + "</option>");
//}
return(mm);
}
else
{
return(null);
}
}
public static List <ActivityType> getAllActivityTypes(RfcDestination destination, ControllingArea iControllingArea)
{
List <ActivityType> ret = new List <ActivityType>();
RfcRepository repo = destination.Repository;
IRfcFunction activityTypeList = repo.CreateFunction("BAPI_ACTIVITYTYPE_GETLIST");
activityTypeList.SetValue("CONTROLLINGAREA", iControllingArea.ControllingAreaCode);
activityTypeList.SetValue("DATE", DateTime.Now);
activityTypeList.Invoke(destination);
IRfcTable activityTypes = activityTypeList.GetTable("ACTIVITYTYPE_LIST");
for (int cuIndex = 0; cuIndex < activityTypes.RowCount; cuIndex++)
{
activityTypes.CurrentIndex = cuIndex;
ActivityType activityT = new ActivityType();
activityT.ActivityTypeCode = activityTypes.GetString("ACTTYPE");
activityT.ActivityTypeName = activityTypes.GetString("NAME");
activityT.ActivityDescription = activityTypes.GetString("DESCRIPT");
activityT.ControllingArea = iControllingArea;
ret.Add(activityT);
}
return(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
//Conexion c = new Conexion("E-DESARROLL2", "Initial02");
try
{
hidUsuario.Value = Session["Usuario"].ToString();
hidNumEmp.Value = Session["NumEmp"].ToString();
hidTipoEmp.Value = Session["TipoEmp"].ToString();
Conexion c = new Conexion();
if (c.conectar())
{
IRfcTable lista_vkorg = c.ListaVKORG("", "");
IRfcTable lista_vtweg = c.ListaVTWEG("", "", "");
IRfcTable lista_spart = c.ListaSPART("", hidNumEmp.Value, "", "", "01");
IRfcTable lista_pltyp;
if (lista_spart.Count > 0)
{
lista_spart.CurrentIndex = 0;
lista_pltyp = c.ListaPLTYP(hidNumEmp.Value, lista_spart.GetString("SPART"), "");
for (int i = 0; i < lista_pltyp.Count; i++)
{
lista_pltyp.CurrentIndex = i;
txtPLTYP_N.Items.Add(new ListItem(lista_pltyp.GetString("PLTYP") + " " + lista_pltyp.GetString("PTEXT"), lista_pltyp.GetString("PLTYP")));
}
}
fecha_limite = c.fechaLimite();
for (int i = 0; i < lista_vkorg.Count; i++)
{
lista_vkorg.CurrentIndex = i;
txtVKORG.Items.Add(new ListItem(lista_vkorg.GetString("VKORG") + " " + lista_vkorg.GetString("VTEXT"), lista_vkorg.GetString("VKORG")));
if (lista_vkorg.GetString("VKORG").Equals("1000"))
{
txtVKORG.SelectedIndex = i;
}
}
for (int i = 0; i < lista_vtweg.Count; i++)
{
lista_vtweg.CurrentIndex = i;
txtVTWEG.Items.Add(new ListItem(lista_vtweg.GetString("VTWEG") + " " + lista_vtweg.GetString("VTEXT"), lista_vtweg.GetString("VTWEG")));
if (lista_vtweg.GetString("VTWEG").Equals("10"))
{
txtVTWEG.SelectedIndex = i;
}
}
for (int i = 0; i < lista_spart.Count; i++)
{
lista_spart.CurrentIndex = i;
txtSPART.Items.Add(new ListItem(lista_spart.GetString("SPART") + " " + lista_spart.GetString("VTEXT"), lista_spart.GetString("SPART")));
}
}
}
catch (Exception ex)
{
Response.Redirect("https://www.terzaonline.com/nworkflow/login/");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
month = HttpUtil.GetReqStrValue("month");
werk = HttpUtil.GetReqStrValue("werk");
SAPCHARTPARAM param = new SAPCHARTPARAM();
param.I_WERKS = werk;
param.I_GJAHR = month.Substring(0, 4);
param.I_MONAT = month.Substring(5, 2);
monthStr = param.I_MONAT;
days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT));
//库存金额情况变动表
//ZTTPP_STOCK_MONEY val1 = new ZTTPP_STOCK_MONEY();
//val1.ZDATE = "";
//val1.ZKCJE = "";
//val1.ZKW = "";
//val1List = RFCUtil.GetTable<ZTTPP_STOCK_MONEY>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1);
// AttributeItem[] item1List = val1.af_GetAvailableAttributeItem();
for (int i = 1; i <= days; i++)
{
labels += "\"" + param.I_MONAT + "/" + (i < 10 ? "0" + i : "" + i) + "\",";
}
labels = labels.Substring(0, labels.Length - 1);
IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY");
for (int i = 0; i < IrfTable.Count; i++)
{
IrfTable.CurrentIndex = i;
string zdate = IrfTable.GetString("ZDATE");
string zkw = IrfTable.GetString("ZKW");
string zkcje = IrfTable.GetString("ZKCJE");
stockMap.Add("" + zdate + zkw, zkcje);
//zkwMap.Add(zkw, zkw);
if (!zkwMap.ContainsKey(zkw))
{
zkwMap.Add(zkw, zkw);
}
}
foreach (var zkw in zkwMap)
{
lineNames.Add(zkw.Key);
string data = "";
for (int i = 1; i <= days; i++)
{
data += stockMap.ContainsKey(month + "-" + (i < 10 ? "0" + i : "" + i) + zkw.Key) ? stockMap[month + "-" + (i < 10 ? "0" + i : "" + i) + zkw.Key] + "," : "0" + ",";
}
datas.Add(data);
}
//itemLists.Add(item1List);
}
else
{
}
}
private string getDescLP(string pltyp, IRfcTable p)
{
for (int i = 0; i < p.Count; i++)
{
p.CurrentIndex = i;
if (p.GetString("PLTYP").Equals(pltyp))
{
return(p.GetString("PLTYP") + " " + p.GetString("PTEXT"));
}
}
return("");
}
public void getSAPData()
{
try
{
RfcConfigParameters rfcPar = new RfcConfigParameters();
rfcPar.Add(RfcConfigParameters.Name, "DEV");
rfcPar.Add(RfcConfigParameters.AppServerHost, "10.1.10.6");
rfcPar.Add(RfcConfigParameters.Client, "560");
rfcPar.Add(RfcConfigParameters.User, "IT_XM01");
rfcPar.Add(RfcConfigParameters.Password, "/qaz456");
rfcPar.Add(RfcConfigParameters.SystemNumber, "01");
rfcPar.Add(RfcConfigParameters.Language, "ZF");
RfcDestination dest = RfcDestinationManager.GetDestination(rfcPar);
RfcRepository rfcrep = dest.Repository;
IRfcFunction myfun = null;
myfun = rfcrep.CreateFunction("ZPP_EXCEL_CO01"); //SAP里面的函数名称
myfun.SetValue("I_AUFNR_B", "11000086"); //SAP传入参数 Single
myfun.SetValue("WERKS", "1201"); //SAP传入参数 Single
//IRfcStructure rfcstructSN = null;
//IRfcStructure rfcstructX = null;
//rfcstructSN = myfun.GetStructure("GENERALDATA"); //SAP传入参数 Structure
//rfcstructSN.SetValue("SERIAL_NO", "TestValue"); //SAP传入参数 Structure
//myfun.SetValue("GENERALDATA", rfcstructSN);
myfun.Invoke(dest);
//IRfcStructure rfcReturn = myfun.GetStructure("RETURN"); //此处返回类型为Structure 如果是Single类型 则直接调用myfun.GetString("RETURN");
//string s = rfcReturn.GetString("TYPE");
IRfcTable irfcTable = myfun.GetTable("E_BOMCOMP");
//提前实例化一个空的表结构出来
DataTable dt = new DataTable();
dt.Columns.Add("GAMNG");
dt.Columns.Add("MATNR");
dt.Columns.Add("BDMNG");
//循环把IRfcTable里面的数据放入Table里面，因为类型不同，不可直接使用。
for (int i = 0; i < irfcTable.Count; i++)
{
irfcTable.CurrentIndex = i;
DataRow dr = dt.NewRow();
dr["GAMNG"] = irfcTable.GetString("AUFNR");
dr["MATNR"] = irfcTable.GetString("Z_SYTABIX");
dr["BDMNG"] = irfcTable.GetString("BDMNG");
dt.Rows.Add(dr);
}
dgSAPData.DataSource = dt;
}
catch (Exception e)
{
}
}
public EmployeeDetail getEmployeeDetailedInfo(string personalNr)
{
EmployeeDetail result = null;
RfcDestination destination = (RfcDestination)(TestConfigSAPDotNet.getConnectionObject());
if (!personalNr.Equals(string.Empty))
{
try
{
RfcRepository repo = destination.Repository;
IRfcFunction employeeList = repo.CreateFunction(Constants.BAPI_PERSDATA_GETDETAILEDLIST);
employeeList.SetValue(Constants.EMPLOYEENUMBER, personalNr);
employeeList.Invoke(destination);
IRfcTable employees = employeeList.GetTable(Constants.PERSONALDATA);
for (int cuIndex = 0; cuIndex < employees.RowCount; cuIndex++)
{
employees.CurrentIndex = cuIndex;
var NAMeOFFORMOFADD = employees.GetString(Constants.NAMeOFFORMOFADD);
var FIRSTNAME = employees.GetString(Constants.FIRSTNAME);
var LASTNAME = employees.GetString(Constants.LASTNAME);
var NAMEOFLANGUAGE = employees.GetString(Constants.NAMEOFLANGUAGE);
var NAMEOFNATIONALI = employees.GetString(Constants.NAMEOFNATIONALITY);
var DATEOFBIRTH = employees.GetString(Constants.DATEOFBIRTH);
var BIRTHPLACE = employees.GetString(Constants.BIRTHPLACE);
var NAMEOFGENDER = employees.GetString(Constants.NAMEOFGENDER);
var NAMEOFCOUNTRYOF = employees.GetString(Constants.NAMEOFCOUNTRYOF);
result = new EmployeeDetail()
{
Country = NAMEOFCOUNTRYOF,
DateOfBith = DATEOFBIRTH,
FirstName = FIRSTNAME,
Gender = NAMEOFGENDER,
Language = NAMEOFLANGUAGE,
LastName = LASTNAME,
NamePrefix = NAMeOFFORMOFADD,
Nationality = NAMEOFNATIONALI,
PlaceOfBith = BIRTHPLACE
};
}
}
catch (Exception ex)
{
_loggingManager.ThrowException(ex, DOTNETSAPErrorSeverity.High);
}
finally
{
}
}
return(result);
}
private void btnPO_Click(object sender, EventArgs e)
{
sapConnClass sc = new sapConnClass();
var rfcPara = sc.setParaToConn(connClient);
var rfcDest = RfcDestinationManager.GetDestination(rfcPara);
var rfcRepo = rfcDest.Repository;
IRfcFunction getPORFC = null;
// rfc 函數名稱
getPORFC = rfcRepo.CreateFunction(getPODetail);
//輸入參數：工單號碼
getPORFC.SetValue("P_AUFNR", txtAufnr.Text.ToString().Trim());
// Call function.
getPORFC.Invoke(rfcDest);
//回傳內表
IRfcTable ITAB = getPORFC.GetTable("ITAB");
DataTable dt = new DataTable();
dt.Columns.Add("作業號碼");
dt.Columns.Add("作業短文");
dt.Columns.Add("報工數量");
for (int i = 0; i <= ITAB.RowCount - 1; i++)
{
DataRow dr = dt.NewRow();
ITAB.CurrentIndex = i;
dr["作業號碼"] = ITAB.GetString("VORNR").ToString();
dr["作業短文"] = ITAB.GetString("LTXA1").ToString();
dr["報工數量"] = ITAB.GetString("GMNGA").ToString();
dt.Rows.Add(dr);
}
dataGridView1.DataSource = dt.DefaultView;
dataGridView1.ReadOnly = true;
// rfc 回傳參數
string KDAUF = getPORFC.GetValue("KDAUF").ToString().TrimStart('0');
string KDPOS = getPORFC.GetValue("KDPOS").ToString().TrimStart('0');
string PSMNG = getPORFC.GetValue("PSMNG").ToString().TrimEnd('0').TrimEnd('.');
string DGLTS = getPORFC.GetValue("DGLTS").ToString();
string USER_LINE = getPORFC.GetValue("USER_LINE").ToString();
lblQty.Text = "工單數量：" + PSMNG;
lblStatus.Text = "使用者自定狀態：" + USER_LINE;
lblSoitme.Text = "銷售訂單/項次：" + KDAUF + " / " + KDPOS;
lblEnddate.Text = "工單排程結束日期：" + DGLTS;
}
public List <string> monedas() //Trae cadena de mail y teléfono
{
if (conectar())
{
RfcRepository repo = oDestino.Repository;
IRfcFunction bapi = repo.CreateFunction("ZFWF_AP_021");//Módulo de función
bapi.Invoke(oDestino);
IRfcTable tcurr = bapi.GetTable("IT_TCURC");
List <string> m = new List <string>();
for (int i = 0; i < tcurr.Count; i++)
{
tcurr.CurrentIndex = i;
m.Add(tcurr.GetString("WAERS"));
}
return(m);
}
else
{
return(null);
}
}
public string getDescLP(string lp, string vk, string vt, string sp, string ku) //Obtiene descripción de la lista de precio
{
Conexion con = new Conexion("E-DESARROLL2", "Initial02");
IRfcTable tabla = con.getCliente(vk, vt, sp, ku.ToUpper());
string[] cl = new string[tabla.Count];
string desc = "";
if (tabla.Count > 0)
{
for (int i = 0; i < 1 & i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
cl[i] = tabla.GetString("NAME1");
}
if (cl[0] != null)
{
desc = cl[0];
}
}
else
{
desc = "";
}
if (!desc.Equals(""))
{
return(con.getLP_Desc("ES", lp));
}
else
{
return("");
}
}
public string getColumnaCliente(string vk, string vt, string sp, string kunnr, string column) //Obtener columna de cliente
{
Conexion con = new Conexion("E-DESARROLL2", "Initial02");
IRfcTable tabla = con.getCliente(vk, vt, sp, kunnr.ToUpper());
string[] lista = new string[tabla.Count];
if (tabla.Count > 0)
{
for (int i = 0; i < 1 & i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
lista[i] = tabla.GetString(column);
}
if (lista[0] != null)
{
return(lista[0]);
}
}
else
{
return("");
}
return("");
}
public string lista_asset(string asset)
{
Conexion con = new Conexion();
asset = asset.ToUpper();
IRfcTable grupos = con.get_asset(asset);
string[] lista = new string[grupos.Count];
for (int i = 0; i < grupos.Count; i++)
{
grupos.CurrentIndex = i;
lista[i] = grupos.GetString("ANLN1");
}
for (int i = 0; i < lista.Length; i++)
{
int cont = 0;
foreach (char c in lista[i])
{
if (c.Equals('0'))
{
cont++;
}
else
{
break;
}
}
lista[i] = lista[i].Substring(cont, lista[i].Length - cont);
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista);
return(list);
}
public string lista_cuentas(string saknr)
{
Conexion con = new Conexion();
IRfcTable cuentas = con.get_saknr(saknr);
string[] lista = new string[cuentas.Count];
for (int i = 0; i < cuentas.Count; i++)
{
cuentas.CurrentIndex = i;
lista[i] = cuentas.GetString("SAKNR");
lista[i] += " - " + cuentas.GetString("TXT50");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista);
return(list);
}
public string lista_costes(string kostl)
{
Conexion con = new Conexion();
IRfcTable costes = con.get_kostl(kostl);
string[] lista = new string[costes.Count];
for (int i = 0; i < costes.Count; i++)
{
costes.CurrentIndex = i;
lista[i] = costes.GetString("KOSTL");
lista[i] += " - " + costes.GetString("KTEXT");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista);
return(list);
}
private string desc_cuentas(string saknr)
{
Conexion con = new Conexion();
IRfcTable cuentas = con.get_saknr(saknr);
string lista = "";
for (int i = 0; i < cuentas.Count; i++)
{
cuentas.CurrentIndex = i;
lista = cuentas.GetString("SAKNR");
lista += " - " + cuentas.GetString("TXT50");
}
//JavaScriptSerializer js = new JavaScriptSerializer();
//string list = js.Serialize(lista);
return(lista);
}
private string desc_costes(string kostl)
{
Conexion con = new Conexion();
IRfcTable costes = con.get_kostl(kostl);
string lista = "";
for (int i = 0; i < costes.Count; i++)
{
costes.CurrentIndex = i;
lista = costes.GetString("KOSTL");
lista += " - " + costes.GetString("KTEXT");
}
//JavaScriptSerializer js = new JavaScriptSerializer();
//string list = js.Serialize(lista);
return(lista);
}
public string getLPSCliente(string sp, string kunnr, string em) //Obtiene la lista de precio del cliente
{
Conexion con = new Conexion("E-DESARROLL2", "Initial02");
IRfcTable tabla = con.ListaPLTYP(em, sp, kunnr);
string[] lista = new string[tabla.Count];
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
lista[i] = tabla.GetString("PLTYP") + " " + tabla.GetString("PTEXT");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista); //Convertir arreglo a string para JavaScript
return(list);
}
public List <T> IRcTabeltoList <T>(IRfcTable table) where T : new()
{
List <T> listt = new List <T>();
System.Reflection.PropertyInfo[] propertiesT = typeof(T).GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public);
for (int i = 0; i < table.Count; i++)
{
T t = new T();
table.CurrentIndex = i;
for (int j = 0; j < table.ElementCount; j++)
{
foreach (System.Reflection.PropertyInfo itemT in propertiesT)
{
if (itemT.Name.ToLower() == table.GetElementMetadata(j).Name.ToLower())
{
switch (itemT.PropertyType.Name.ToLower())
{
case "string":
itemT.SetValue(t, table.GetString(j), null);
break;
case "int":
itemT.SetValue(t, Convert.ToInt32(table.GetInt(j)), null);
break;
case "int32":
itemT.SetValue(t, Convert.ToInt32(table.GetInt(j)), null);
break;
case "datetime":
itemT.SetValue(t, Convert.ToDateTime(table.GetString(j)), null);
break;
}
}
}
}
listt.Add(t);
}
return(listt);
}
/// <summary>
/// 物料凭证查询
/// </summary>
/// <param name="I_BKTXT">凭证抬头文本(凭证号与抬头文本至少填一个)</param>
/// <param name="I_MBLNR">物料凭证(凭证号与抬头文本至少填一个)</param>
/// <param name="I_MJAHR">物料凭证年度(选填)</param>
/// <returns></returns>
public static Result ZWMS_MKPF(string I_BKTXT, string I_MBLNR = "", string I_MJAHR = "")
{
Result result = new Result {
Success = false
};
try
{
//RfcDestination rfcDest = RfcDestinationManager.GetDestination(GetSapServerString());
RfcDestination rfcDest = RfcDestinationManager.GetDestination(ConfigurationManager.AppSettings["sapServer"].ToString());
//选择要调用的BAPI的名称
RfcFunctionMetadata rfMD = rfcDest.Repository.GetFunctionMetadata("ZWMS_MKPF");
//新建调用该BAPI的一个“实例”
IRfcFunction irF = rfMD.CreateFunction();
//******************************
//输入参数设置
//******************************
irF.SetValue("I_MBLNR", I_MBLNR); //物料凭证
irF.SetValue("I_MJAHR", I_MJAHR); //物料凭证年度
irF.SetValue("I_BKTXT", I_BKTXT); //凭证抬头文本
IRfcTable irt = irF.GetTable("O_MKPF");
RfcSessionManager.BeginContext(rfcDest);
irF.Invoke(rfcDest);
//irfCommit.Invoke(rfcDest);
RfcSessionManager.EndContext(rfcDest);
result.Success = irF.GetString("RTYPE").ToUpper() == "S";
result.Message = irF.GetValue("RTMSG").ToString();
if (result.Success && irt.RowCount > 0)
{
var MBLNR = "";
for (int i = 0; i < irt.RowCount; i++)
{
irt.CurrentIndex = i;
if (MBLNR.IsNotEmpty())
{
MBLNR += "/";
}
MBLNR += irt.GetString("MBLNR");
}
result.Message = MBLNR;
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public string auto_matkl(string mk, string sp) //Autocompleta de material
{
Conexion con = new Conexion("E-DESARROLL2", "Initial02");
IRfcTable tabla = con.AutoMATKL(mk.ToUpper(), sp);
string[] lista = new string[tabla.Count];
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
lista[i] = tabla.GetString("MATKL");
lista[i] += " " + tabla.GetString("WGBEZ");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista); //Convertir arreglo a string para JavaScript
return(list);
}
public string llenaPltyp(string pr, string sp) //Autocompleta de material
{
Conexion con = new Conexion("E-DESARROLL2", "Initial02");
IRfcTable tabla = con.ListaPLTYP(pr, sp, "");
string[] lista = new string[tabla.Count];
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
lista[i] = tabla.GetString("PLTYP");
lista[i] += " " + tabla.GetString("PTEXT");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista); //Convertir arreglo a string para JavaScript
return(list);
}
public string llenaSpart(string pr, string vk, string vt) //Autocompleta de material
{
Conexion con = new Conexion("E-DESARROLL2", "Initial02");
IRfcTable tabla = con.ListaSPART("", pr, vk, vt, "02");
string[] lista = new string[tabla.Count];
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
lista[i] = tabla.GetString("SPART");
lista[i] += " " + tabla.GetString("VTEXT");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista); //Convertir arreglo a string para JavaScript
return(list);
}
public string auto_pernr(string pr) //Autocompleta de cliente
{
Conexion con = new Conexion("E-DESARROLL2", "Initial02");
IRfcTable tabla = con.AutoPERNR(pr);
string[] lista = new string[tabla.Count];
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
lista[i] = tabla.GetString("ZUEMP");
lista[i] += " - " + tabla.GetString("SNAME");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista); //Convertir arreglo a string para JavaScript
return(list);
}
public string auto_clientesB(string vk, string vt, string sp, string ku) //Autocompleta de cliente
{
Conexion con = new Conexion("E-DESARROLL2", "Initial02");
IRfcTable tabla = con.AutoKUNNR(vk, vt, sp, ku.ToUpper(), "");
string[] lista = new string[tabla.Count];
for (int i = 0; i < tabla.Count; i++)
{
tabla.CurrentIndex = i;
lista[i] = tabla.GetString("KUNNR");
lista[i] += " - " + tabla.GetString("NAME1");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista); //Convertir arreglo a string para JavaScript
return(list);
}
public string lista_imputa(string texto)
{
Conexion con = new Conexion(); //Conexión a SAP
IRfcTable materiales = con.get_servicios(texto, "M"); //Llama módulo de función
string[] lista = new string[materiales.Count];
for (int i = 0; i < materiales.Count; i++)
{
//Llenado de lista
materiales.CurrentIndex = i;
lista[i] = materiales.GetString("NUM");
lista[i] += " - " + materiales.GetString("DESCR");
}
JavaScriptSerializer js = new JavaScriptSerializer();
string list = js.Serialize(lista); //Convertir arreglo a string para JavaScript
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
month = HttpUtil.GetReqStrValue("month");
werk = HttpUtil.GetReqStrValue("werk");
SAPCHARTPARAM param = new SAPCHARTPARAM();
param.I_WERKS = werk;
param.I_GJAHR = month.Substring(0, 4);
param.I_MONAT = month.Substring(5, 2);
monthStr = param.I_MONAT;
days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT));
//库存金额情况变动表
//ZTTPP_STOCK_MONEY val1 = new ZTTPP_STOCK_MONEY();
//val1.ZDATE = "";
//val1.ZKCJE = "";
//val1.ZKW = "";
//val1List = RFCUtil.GetTable<ZTTPP_STOCK_MONEY>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1);
// AttributeItem[] item1List = val1.af_GetAvailableAttributeItem();
IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY");
for (int i = 0; i < IrfTable.Count; i++)
{
IrfTable.CurrentIndex = i;
string zdate = IrfTable.GetString("ZDATE");
string zkw = IrfTable.GetString("ZKW");
string zkcje = IrfTable.GetString("ZKCJE");
stockMap.Add("" + zdate + zkw, zkcje);
//zkwMap.Add(zkw, zkw);
if (!zkwMap.ContainsKey(zkw))
{
zkwMap.Add(zkw, zkw);
}
}
//itemLists.Add(item1List);
}
else
{
}
}
private static void WriteRowProperties(IRfcTable table, JsonWriter writer)
{
for (int columnNumber = 0; columnNumber < table.ElementCount; columnNumber++)
{
var name = table.GetElementMetadata(columnNumber).Name;
var value = table.GetString(columnNumber);
writer.WritePropertyName(name);
writer.WriteValue(value);
}
}