Esempio n. 1
0
        public byte[] Byte_INTERFACE(string Interface, string Json)
        {
            Byte[] _StrErr = null;
            IDictionary <string, object> dic = MapListConverter.JsonToDictionary(Json);

            switch (Interface)
            {
            case "GetUserInfo":
                string UserId   = null;
                string username = null;
                string PWD      = null;
                if (dic.ContainsKey("USERID"))
                {
                    UserId = dic["USERID"].ToString();
                }
                if (dic.ContainsKey("USERNAME"))
                {
                    UserId = dic["USERNAME"].ToString();
                }
                if (dic.ContainsKey("PWD"))
                {
                    UserId = dic["PWD"].ToString();
                }
                _StrErr = mlc.GetDataSetSurrogateZipBytes(mUserInfo.GetUserInfo(UserId, username, PWD));
                break;

            case "GetWoInfo":
                _StrErr = mlc.GetDataSetSurrogateZipBytes(woinfo.GetWoInfo(dic["WOID"].ToString(), dic["PARTNUMBER"].ToString(), null));
                break;

            default:
                _StrErr = null;
                break;
            }
            return(_StrErr);
        }
Esempio n. 2
0
        public byte[] Get_Z_RFC_ZMM011(string woid)
        {
            this._strError = string.Empty;
            try
            {
                System.Data.DataSet   ds   = new System.Data.DataSet();
                System.Data.DataTable mDt1 = new System.Data.DataTable("Z_RFC_ZMM011_TB1");
                System.Data.DataTable mDt2 = new System.Data.DataTable("Z_RFC_ZMM011_TB2");

                mDt1.Columns.Add("AUFNR", typeof(string));
                mDt1.Columns.Add("MATNR1", typeof(string));
                mDt1.Columns.Add("MATNR2", typeof(string));
                mDt1.Columns.Add("MAKTX2", typeof(string));
                mDt1.Columns.Add("BDMNG", typeof(Int32));

                mDt2.Columns.Add("VORNR", typeof(string));
                mDt2.Columns.Add("LTXA1", typeof(string));


                RfcDestination _desination = RfcDestinationManager.GetDestination(this.GetCfgParameters());
                IRfcFunction   rfcFunction = _desination.Repository.CreateFunction("Z_RFC_ZMM011");

                rfcFunction.SetValue("IMPORT1", woid);
                rfcFunction.Invoke(_desination);
                string[] arrTB = new string[] { "OUTPUT1", "OUTPUT2" };

                IRfcTable table = rfcFunction.GetTable(arrTB[0]);

                for (int i = 0; i < table.RowCount; i++)
                {
                    if (table[i].GetInt("BDMNG") < 1)
                    {
                        continue;
                    }
                    mDt1.Rows.Add(table[i].GetString("AUFNR").TrimStart('0'), table[i].GetString("MATNR1").TrimStart('0'),
                                  table[i].GetString("MATNR2").TrimStart('0'), table[i].GetString("MAKTX2").TrimStart('0'),
                                  table[i].GetInt("BDMNG"));
                }
                ds.Tables.Add(mDt1);

                table = rfcFunction.GetTable(arrTB[1]);
                for (int i = 0; i < table.RowCount; i++)
                {
                    mDt2.Rows.Add(table[i].GetString("VORNR").TrimStart('0'), table[i].GetString("LTXA1").TrimStart('0'));
                }
                ds.Tables.Add(mDt2);

                return(mlc.GetDataSetSurrogateZipBytes(ds));
            }
            catch
            {
                return(null);
            }
        }
Esempio n. 3
0
 public byte[] GetReworkInfo(string ReworkNo)
 {
     return(mlc.GetDataSetSurrogateZipBytes(ReworkDetail.GetReworkInfo(ReworkNo)));
 }
Esempio n. 4
0
 public byte[] QuerytSmtKpNormallog(string dicstring, bool ShowTotal)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mSmtkpnormallog.QuerytSmtKpNormallog(dicstring, ShowTotal)));
 }
Esempio n. 5
0
        public byte[] Get_UserInfo(string JsonUser, string FieldList)
        {
            IDictionary <string, object> mst = MapListConverter.JsonToDictionary(JsonUser);

            return(mlc.GetDataSetSurrogateZipBytes(mUserInfo.GetUserInfo(mst, FieldList)));
        }
Esempio n. 6
0
 public byte[] GetSmtIO(string masterId, string woId)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mSmtio.GetSmtIO(masterId, woId)));
 }
Esempio n. 7
0
 public byte[] GetFixtureInfo()
 {
     return(mlc.GetDataSetSurrogateZipBytes(fixture.GetFixtureInfo(null)));
 }
Esempio n. 8
0
 public byte[] Get_DSInfo(DateTime rec_Sta, DateTime rec_End, out string status)
 {
     return(mlc.GetDataSetSurrogateZipBytes(Ds.Get_DSInfo(rec_Sta, rec_End, out status)));
 }
Esempio n. 9
0
 public byte[] GetRoleInfo()
 {
     return(mlc.GetDataSetSurrogateZipBytes(mRoleinfo.GetRoleInfo()));
 }
Esempio n. 10
0
 public byte[] Get_B_MAIL_T(string Mail_App)
 {
     return(mlc.GetDataSetSurrogateZipBytes(Mail.Get_B_MAIL_T(Mail_App)));
 }
Esempio n. 11
0
 public byte[] GetQueryWipAllInfo(string ColumnName, string Data)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mWiptracking.Get_WIP_TRACKING(ColumnName, Data)));
 }
Esempio n. 12
0
 public byte[] ReworkWipQuery(string Colnum, string Data)
 {
     return(mlc.GetDataSetSurrogateZipBytes(WipWh.ReworkWipQuery(Colnum, Data)));
 }
Esempio n. 13
0
 public byte[] GetGangInfoByTrsn(string trsn)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mPartstorehousehad.GetGangInfoByTrsn(trsn)));
 }
Esempio n. 14
0
 public byte[] GettCustomerAll()
 {
     return(mlc.GetDataSetSurrogateZipBytes(_tCustomer.GettCustomerAll()));
 }
Esempio n. 15
0
 public byte[] GetDeptInfo()
 {
     return(mlc.GetDataSetSurrogateZipBytes(mdeptinfo.GetDeptInfo()));
 }
Esempio n. 16
0
 public byte[] GetAllStationNoInfo()
 {
     return(mlc.GetDataSetSurrogateZipBytes(mStationNoinfo.GetAllStationNoInfo()));
     //string sql = "select stationno,lineId,machineId,des,stationspec from stationnoInfo";
     //return BLL.BllMsSqllib.Instance.ExecuteQuerySQL(sql);
 }
Esempio n. 17
0
 public byte[] Sel_QCNO_Date(DateTime Dt, string Line)
 {
     return(mlc.GetDataSetSurrogateZipBytes(fqc.Sel_QCNO_Date(Dt, Line)));
 }
Esempio n. 18
0
 public byte[] GetRouteInfoByWoId(string routgroupId)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mRouteinfo.GetRouteInfoByRoutgroupId(routgroupId)));// BLL.BllMsSqllib.Instance.MsSqlLib.GetRouteByWoId(woId);
 }
Esempio n. 19
0
 public byte[] GetErrorCode()
 {
     return(mlc.GetDataSetSurrogateZipBytes(mErrcode.GetErrorCode(null)));
 }
Esempio n. 20
0
 public byte[] GetSmtKpMaster(string MasterId)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mSmtkpmaster.GetSmtKpMaster(MasterId)));
 }
Esempio n. 21
0
 public byte[] GetWipKeyParts(string SNTYPE, string SNVAL)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mWipkeypart.GetWipKeyParts(SNTYPE, SNVAL)));
 }
Esempio n. 22
0
 public byte[] GetReasonCode()
 {
     return(mlc.GetDataSetSurrogateZipBytes(mReasoncode.GetReasonCode()));
 }
Esempio n. 23
0
 public byte[] QueryPartMaps(string kpnumber)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mPartmap.QueryPartMaps(kpnumber)));
 }
Esempio n. 24
0
 public byte[] GetKeyParts()
 {
     return(mlc.GetDataSetSurrogateZipBytes(mKeypart.GetKeyParts()));
 }
Esempio n. 25
0
 public byte[] GetFacInfo()
 {
     return(mlc.GetDataSetSurrogateZipBytes(mFacinfo.GetFacInfo()));
 }
Esempio n. 26
0
 public byte[] GetRepairSnInfo(string ESN)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mRepairinfo.GetRepairSnInfo(ESN)));
 }
Esempio n. 27
0
 public byte[] GetAllMachineInfo()
 {
     return(mlc.GetDataSetSurrogateZipBytes(mMachineid.GetMachineInfo(null)));
 }
Esempio n. 28
0
 public byte[] QueryVersionInfoByWo(string wo)
 {
     return(mlc.GetDataSetSurrogateZipBytes(VersionMark.QueryVersionInfoByWo(wo)));
 }
Esempio n. 29
0
 public byte[] Get_ProductRealSummary(string WORK_DATE, string Class)
 {
     return(mlc.GetDataSetSurrogateZipBytes(Prs.Get_Product_Real_Summary(WORK_DATE, Class)));
 }
Esempio n. 30
0
 public byte[] GetProductSnType(string partnumber)
 {
     return(mlc.GetDataSetSurrogateZipBytes(mProduct.GetProductSnType(partnumber)));
 }