public override void init()
{
try
{
BU = ConfigGet("BU");
Plant = ConfigGet("PLANT");
DB = ConfigGet("DB");
CUST = ConfigGet("CUST");
COUNT = ConfigGet("COUNT");
arrayConvertWO = ConfigGet("CONVERTWO").Split(',');
_downloadWO = ConfigGet("DOWNLOADWO");
List <System.Net.IPAddress> temp = HWDNNSFCBase.HostInfo.IP.Where(ipv4 => ipv4.AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork).ToList();
ip = temp[0].ToString();
Output.UI = new DownloadWO_UI(this);
SFCDB = new OleExec(DB, false);
synLock = new T_R_SYNC_LOCK(SFCDB, DB_TYPE_ENUM.Oracle);
C_TAB_COLUMN_MAP = new T_C_TAB_COLUMN_MAP(SFCDB, DB_TYPE_ENUM.Oracle);
C_SKU = new T_C_SKU(SFCDB, DB_TYPE_ENUM.Oracle);
R_WO_HEADER = new T_R_WO_HEADER(SFCDB, DB_TYPE_ENUM.Oracle);
R_WO_ITEM = new T_R_WO_ITEM(SFCDB, DB_TYPE_ENUM.Oracle);
R_WO_TEXT = new T_R_WO_TEXT(SFCDB, DB_TYPE_ENUM.Oracle);
RouteDetail = new T_C_ROUTE_DETAIL(SFCDB, DB_TYPE_ENUM.Oracle);
WOType = new T_R_WO_TYPE(SFCDB, DB_TYPE_ENUM.Oracle);
Keypart = new T_C_KEYPART(SFCDB, DB_TYPE_ENUM.Oracle);
C_ROUTE = new T_C_ROUTE(SFCDB, DB_TYPE_ENUM.Oracle);
R_WO_BASE = new T_R_WO_BASE(SFCDB, DB_TYPE_ENUM.Oracle);
T_Series = new T_C_SERIES(SFCDB, DB_TYPE_ENUM.Oracle);
t_c_kp_list = new T_C_KP_LIST(SFCDB, DB_TYPE_ENUM.Oracle);
ZRFC_GET_PRO_HEADER8 = new ZRFC_GET_PRO_HEADER8(BU);
}
catch (Exception e)
{
throw new Exception("Init DownLoadWO Fail" + e.Message);
}
Output.Tables.Add(ZRFC_GET_PRO_HEADER8.GetTableValue("PO"));
// Output.Tables.Add(ZRFC_GET_PRO_HEADER8.GetTableValue("POD"));
}
public void Download(string StrWo, string Plant)
{
OleExec sfcdb;
DataTable RFC_Table = new DataTable();
T_R_WO_HEADER_TJ R_WO_HEADER;
Dictionary <string, string> DicPara = new Dictionary <string, string>();
sfcdb = this.DBPools["SFCDB"].Borrow();
ZRFC_GET_PRO_HEADER8 zrfc_GET_PRO_HEADER8 = new ZRFC_GET_PRO_HEADER8();
zrfc_GET_PRO_HEADER8.SetValues(StrWo, Plant);//NHGZ,WDN1//WDN1,WSL3
zrfc_GET_PRO_HEADER8.CallRFC();
DataTable woheader = zrfc_GET_PRO_HEADER8.GetTableValue("PO");
R_WO_HEADER = new T_R_WO_HEADER_TJ(sfcdb, DB_TYPE_ENUM.Oracle);
Row_R_WO_HEADER_TJ rowRWOHeader = (Row_R_WO_HEADER_TJ)R_WO_HEADER.NewRow();
if (woheader.Rows.Count > 0)
{
rowRWOHeader.ID = R_WO_HEADER.GetNewID(BU, sfcdb);
rowRWOHeader.AUFNR = woheader.Rows[0]["AUFNR"].ToString();
rowRWOHeader.WERKS = woheader.Rows[0]["WERKS"].ToString();
rowRWOHeader.AUART = woheader.Rows[0]["AUART"].ToString();
rowRWOHeader.MATNR = woheader.Rows[0]["MATNR"].ToString();
rowRWOHeader.REVLV = woheader.Rows[0]["REVLV"].ToString();
rowRWOHeader.KDAUF = woheader.Rows[0]["KDAUF"].ToString();
rowRWOHeader.GSTRS = woheader.Rows[0]["GSTRS"].ToString();
rowRWOHeader.DISPO = woheader.Rows[0]["DISPO"].ToString();
rowRWOHeader.GAMNG = woheader.Rows[0]["GAMNG"].ToString();
rowRWOHeader.VERID = woheader.Rows[0]["VERID"].ToString();
rowRWOHeader.ARBPL = woheader.Rows[0]["ARBPL"].ToString();
rowRWOHeader.KUNNR = woheader.Rows[0]["KUNNR"].ToString();
rowRWOHeader.KDMAT = woheader.Rows[0]["KDMAT"].ToString();
rowRWOHeader.AEDAT = woheader.Rows[0]["AEDAT"].ToString();
rowRWOHeader.AENAM = woheader.Rows[0]["AENAM"].ToString();
rowRWOHeader.MATKL = woheader.Rows[0]["MATKL"].ToString();
rowRWOHeader.MAKTX = woheader.Rows[0]["MAKTX"].ToString();
rowRWOHeader.GMEIN = woheader.Rows[0]["GMEIN"].ToString();
rowRWOHeader.STATUS = woheader.Rows[0]["STATUS"].ToString();
rowRWOHeader.ERDAT = woheader.Rows[0]["ERDAT"].ToString();
rowRWOHeader.ERFZEIT = woheader.Rows[0]["ERFZEIT"].ToString();
rowRWOHeader.AEZEIT = woheader.Rows[0]["AEZEIT"].ToString();
rowRWOHeader.GSUZS = woheader.Rows[0]["GSUZS"].ToString();
rowRWOHeader.RSNUM = woheader.Rows[0]["RSNUM"].ToString();
rowRWOHeader.KBEASOLL = woheader.Rows[0]["KBEASOLL"].ToString();
rowRWOHeader.TASKGROUP = woheader.Rows[0]["TASKGROUP"].ToString();
rowRWOHeader.CY_SEQNR = woheader.Rows[0]["CY_SEQNR"].ToString();
rowRWOHeader.ZAPLFL = woheader.Rows[0]["ZAPLFL"].ToString();
rowRWOHeader.ZVORNR = woheader.Rows[0]["ZVORNR"].ToString();
rowRWOHeader.ZTDLINE = woheader.Rows[0]["ZTDLINE"].ToString();
rowRWOHeader.KDPOS = woheader.Rows[0]["KDPOS"].ToString();
rowRWOHeader.BSTKD = woheader.Rows[0]["BSTKD"].ToString();
rowRWOHeader.POSEX_E = woheader.Rows[0]["POSEX_E"].ToString();
rowRWOHeader.TKNUM = woheader.Rows[0]["TKNUM"].ToString();
rowRWOHeader.APRIO = woheader.Rows[0]["APRIO"].ToString();
rowRWOHeader.MAUFNR = woheader.Rows[0]["MAUFNR"].ToString();
rowRWOHeader.OBJNR = woheader.Rows[0]["OBJNR"].ToString();
rowRWOHeader.FEVOR = woheader.Rows[0]["FEVOR"].ToString();
rowRWOHeader.WEMNG = woheader.Rows[0]["WEMNG"].ToString();
rowRWOHeader.ERNAM = woheader.Rows[0]["ERNAM"].ToString();
rowRWOHeader.IDAT2 = woheader.Rows[0]["IDAT2"].ToString();
rowRWOHeader.PHAS2 = woheader.Rows[0]["PHAS2"].ToString();
rowRWOHeader.STLAL = woheader.Rows[0]["STLAL"].ToString();
rowRWOHeader.STLAN = woheader.Rows[0]["STLAN"].ToString();
rowRWOHeader.VDATU = woheader.Rows[0]["VDATU"].ToString();
rowRWOHeader.VGW03 = woheader.Rows[0]["VGW03"].ToString();
String WO = rowRWOHeader.AUFNR;
string sql = $@"DELETE FROM R_WO_HEADER_TJ WHERE AUFNR = '{WO}'";
sfcdb.ExecSQL(sql);
sql = rowRWOHeader.GetInsertString(DB_TYPE_ENUM.Oracle);
sfcdb.ExecSQL(sql);
}
}
