public static decimal getItemValueAsDecimal(Domino.NotesDocumentClass Document, String Field) { if (Document == null) { return(0); } try { String r = (String)((Object[])Document.GetItemValue(Field))[0]; if (r == "") { return(0); } return(Decimal.Parse(r)); } catch { } try { Double d = (Double)((Object[])Document.GetItemValue(Field))[0]; return(Decimal.Parse(d.ToString())); } catch { } return((decimal)((Object[])Document.GetItemValue(Field))[0]); }
public static String getItemValue(Domino.NotesDocumentClass Document, String Field) { /*if (Document == null) return ""; * return (String)((Object[])Document.GetItemValue(Field))[0].ToString();*/ return(getItemValue(Document, Field, 0)); }
public static String getItemValue(Domino.NotesDocumentClass Document, String Field, int Maxlength) { if (Document == null) { return(""); } String ret = (String)((Object[])Document.GetItemValue(Field))[0].ToString(); return(Maxlength == 0 || (Maxlength != 0 && ret.Length <= Maxlength) ? ret : ret.Substring(0, Maxlength)); }
public static String[] getItemValues(Domino.NotesDocumentClass Document, String Field) { Object[] ar = ((Object[])Document.GetItemValue(Field)); String[] ret = new String[ar.Length]; for (int n = 0; n < ar.Length; n++) { ret[n] = ar[n].ToString(); } return(ret); }
private void getLotusUser(String Pernr, out String Lname, out String Cname) { Lname = null; Cname = null; Domino.NotesDatabaseClass database = (Domino.NotesDatabaseClass)session.GetDatabase("", DB_USER, false); Domino.NotesDocumentCollectionClass docs = (Domino.NotesDocumentCollectionClass)database.Search("txttetechid = '" + Sap.shiftLeft(Pernr, "0") + "'", null, 99999); for (int n = 0; n < docs.Count; n++) { Domino.NotesDocumentClass doc = (Domino.NotesDocumentClass)docs.GetNthDocument(n); Lname = getItemValue(doc, "benutzer"); Cname = getItemValue(doc, "benutzerInterface"); } }
private Domino.NotesDocumentClass getParentDispatch(String Aufnr, Domino.NotesDatabaseClass Database) { String aufnr = Aufnr; Domino.NotesDocumentCollectionClass docs = (Domino.NotesDocumentCollectionClass)Database.Search("numeanr = '" + Sap.shiftLeft(aufnr, "0") + "'", null, 99999); for (int n = 0; n < docs.Count; n++) { Domino.NotesDocumentClass doc = (Domino.NotesDocumentClass)docs.GetNthDocument(n); if (getItemValue(doc, "FORM") == DISPATCH_PARENT_FORM) { return(doc); } } return(null); }
public String getLotusPernr(String Lname) { Domino.NotesDatabaseClass database = (Domino.NotesDatabaseClass)session.GetDatabase("", DB_USER, false); Domino.NotesDocumentCollectionClass docs = (Domino.NotesDocumentCollectionClass)database.Search("benutzerInterface = '" + Lname + "'", null, 99999); for (int n = 1; n <= docs.Count; n++) { Domino.NotesDocumentClass doc = (Domino.NotesDocumentClass)docs.GetNthDocument(n); String ret = getItemValue(doc, "txttetechid"); if (ret != null && ret.Trim().Length > 0) { return(ret); } } return(""); }
public String getMaterialPmsId(String Matnr) { Domino.NotesDocumentClass material = getMaterial(Matnr); return(material != null?Lotus.getItemValue(material, "txtartpkid") : ""); }
private void replaceDispatchFields(ref Domino.NotesDocumentClass doc, SAPWS.ZFSS_S_DISPATCH E, SAPWS.ZFSS_S_DISPATCH_TEXT[] T, SAPWS.ZFSS_S_DISPATCH_Z7[] Z7, SAPWS.ZFSS_S_DISPATCH_EQUIPMENT[] DE, DISPATCH_TYPE DispatchType) { String text; // Child? if (DispatchType == DISPATCH_TYPE.CHILD) { // Genel bilgiler doc.ReplaceItemValue("FORM", "frm_gzea"); doc.ReplaceItemValue("SAPtxtNo", Sap.shiftLeft(buildChildAufnr(E.AUFNR), "0")); // Ekipmana özel bilgiler for (int n = 0; n < DE.Length; n++) { if (DE[n].AUFNR == E.AUFNR) { doc.ReplaceItemValue("txtartpkid", getMaterialPmsId(Sap.shiftLeft(DE[n].MATNR, "0"))); doc.ReplaceItemValue("numeqnr", Sap.shiftLeft(DE[n].EQUNR, "0")); doc.ReplaceItemValue("txtfabriknr", Sap.shiftLeft(DE[n].SERNR, "0")); doc.ReplaceItemValue("txteqsoftwareversion", DE[n].ZZSWVER); doc.ReplaceItemValue("txteqstandort", DE[n].ZZLOCAT); doc.ReplaceItemValue("dateqletztewartung", parseSapDate(DE[n].ZZLASTDATE)); doc.ReplaceItemValue("txtartsachnr", Sap.shiftLeft(DE[n].MATNR, "0")); } } } else { doc.ReplaceItemValue("FORM", "frm_ea"); doc.ReplaceItemValue("numeaicon", 25); } doc.ReplaceItemValue("numeanr", Sap.shiftLeft(E.AUFNR, "0")); doc.ReplaceItemValue("anzeige1", E.NAME1); doc.ReplaceItemValue("txtartbenenn", E.NAME1); doc.ReplaceItemValue("txtTSR", E.ZFSE_VORNA + " " + E.ZFSE_NACHN); doc.ReplaceItemValue("SAPTSRID", Sap.shiftLeft(E.ZFSE, "0")); doc.ReplaceItemValue("txtpriority", E.ZJOBTYPE); doc.ReplaceItemValue("dateabestelltam", parseSapDate(E.AUFK_ERDAT)); doc.ReplaceItemValue("dateeadue", parseSapDate(E.GSTRP)); doc.ReplaceItemValue("txteabesteller", E.ZCONTACT_NAME1); doc.ReplaceItemValue("txtcontacttel", E.TEL_NUMBER); text = ""; for (int x = 0; x < T.Length; x++) { if (T[x].AUFNR == E.AUFNR && T[x].DTTYP == "R") { text += (text.Length > 0 ? "\r\n" + T[x].TLINE : T[x].TLINE); } } doc.ReplaceItemValue("txteakrztxt", text); text = ""; for (int x = 0; x < T.Length; x++) { if (T[x].AUFNR == E.AUFNR && T[x].DTTYP == "I") { text += (text.Length > 0 ? "\r\n" + T[x].TLINE : T[x].TLINE); } } doc.ReplaceItemValue("txtinfoIntern", text); text = ""; for (int x = 0; x < T.Length; x++) { if (T[x].AUFNR == E.AUFNR && T[x].DTTYP == "W") { text += (text.Length > 0 ? "\r\n" + T[x].TLINE : T[x].TLINE); } } doc.ReplaceItemValue("WorkPerformed", text); doc.ReplaceItemValue("txteanrUS", Sap.shiftLeft(E.AUFNR, "0")); doc.ReplaceItemValue("CreatedBy", E.ERNAM_NAME_FIRST + " " + E.ERNAM_NAME_LAST); doc.ReplaceItemValue("txteajobtype", E.VAPLZ + " - " + E.VAPLZ_KTEXT); //doc.ReplaceItemValue("txteastatus", "0"); --> Bunu yapmıyoruz, trafik lambasıyla Update sırasında oynamasak daha iyi doc.ReplaceItemValue("Invoice", E.ZINVOICE == "X" ? "1" : "0"); doc.ReplaceItemValue("numeaestvalue", Sap.shiftLeft(E.QMNUM, "0")); doc.ReplaceItemValue("txtkdkrzbez", E.NAME1); doc.ReplaceItemValue("txtkdnr", Sap.shiftLeft(E.KUNNR, "0")); doc.ReplaceItemValue("txtCustomerAddress", E.STRAS + " " + E.PSTLZ + " " + E.ORT01); //doc.ReplaceItemValue("ReadAll", READ_ALL); //doc.ReplaceItemValue("TeamReader", TEAM_READER); // Additional Readers doc.RemoveItem("AdditionalReaders"); doc.RemoveItem("AdditionalReadersCN"); for (int n = 0; n < Z7.Length; n++) { if (Z7[n].AUFNR == E.AUFNR) { String lname = ""; String cname = ""; getLotusUser(Z7[n].PARNR, out lname, out cname); if (lname != null) { doc.AppendItemValue("AdditionalReaders", lname); doc.AppendItemValue("AdditionalReadersCN", cname); } } } }
public void setDispatchs(Domino.NotesViewClass view) { ArrayList txtr, txti, txtw; int dispcount = 0; int disppos = -1; if (view == null) { return; } // Verileri çek SAPWS.ZFSS_SET_DISPATCH eq = new sapFIN.SAPWS.ZFSS_SET_DISPATCH(); // Toplamda kaç Dispatch ile karşı karşıyayız tespit et ve Dispatch değişkenlerini yarat for (int n = 1; n <= view.AllEntries.Count; n++) { String form = Lotus.getItemValue((Domino.NotesDocumentClass)view.GetNthDocument(n), "FORM"); if (form == "frm_ea") { for (int m = 1; m <= view.GetNthDocument(n).Responses.Count; m++) { Domino.NotesDocumentClass sd = (Domino.NotesDocumentClass)view.GetNthDocument(n).Responses.GetNthDocument(m); String subform = Lotus.getItemValue(sd, "FORM"); if (subform == "frm_gzea") { dispcount++; } } } } if (dispcount <= 0) { return; } eq.I_DISPATCH = new sapFIN.SAPWS.ZFSS_S_DISPATCH_FLD[dispcount]; eq.I_TEXT = new sapFIN.SAPWS.ZFSS_S_DISPATCH_TEXT[0]; // Verileri aktar for (int n = 1; n <= view.AllEntries.Count; n++) { Domino.NotesDocumentClass di = (Domino.NotesDocumentClass)view.GetNthDocument(n); String form = Lotus.getItemValue(di, "FORM"); //if (form == "frm_ea" || form == "frm_gzea") if (form == "frm_ea") { for (int m = 1; m <= view.GetNthDocument(n).Responses.Count; m++) { Domino.NotesDocumentClass sd = (Domino.NotesDocumentClass)view.GetNthDocument(n).Responses.GetNthDocument(m); String subform = Lotus.getItemValue(sd, "FORM"); if (subform == "frm_gzea") { disppos++; eq.I_DISPATCH[disppos] = new sapFIN.SAPWS.ZFSS_S_DISPATCH_FLD(); eq.I_DISPATCH[disppos].AUFNR = Lotus.getItemValue(sd, "SAPtxtNo").Replace("U", ""); eq.I_DISPATCH[disppos].NAME1 = Lotus.getItemValue(sd, "anzeige1", 30); eq.I_DISPATCH[disppos].ZFSE = Lotus.getItemValue(sd, "SAPTSRID", 12); eq.I_DISPATCH[disppos].ZJOBTYPE = Lotus.getItemValue(di, "txtpriority", 4); eq.I_DISPATCH[disppos].AUFK_ERDAT = parseLotusDate(Lotus.getItemValue(di, "dateabestelltam")); eq.I_DISPATCH[disppos].GSTRP = parseLotusDate(Lotus.getItemValue(di, "dateeadue")); eq.I_DISPATCH[disppos].ZCONTACT_NAME1 = Lotus.getItemValue(di, "txteabesteller", 35); eq.I_DISPATCH[disppos].TEL_NUMBER = Lotus.getItemValue(di, "txtcontacttel", 30); txtr = splitText(Lotus.getItemValue(di, "txteakrztxt"), 132); for (int t = 0; t < txtr.Count; t++) { eq.I_TEXT = expandDispatchTextTable(eq.I_TEXT); eq.I_TEXT[eq.I_TEXT.Length - 1].AUFNR = eq.I_DISPATCH[disppos].AUFNR.Replace("U", ""); eq.I_TEXT[eq.I_TEXT.Length - 1].DTTYP = "R"; eq.I_TEXT[eq.I_TEXT.Length - 1].TLINE = (String)txtr[t]; } txti = splitText(Lotus.getItemValue(di, "rtxtinfoIntern"), 132); for (int t = 0; t < txti.Count; t++) { eq.I_TEXT = expandDispatchTextTable(eq.I_TEXT); eq.I_TEXT[eq.I_TEXT.Length - 1].AUFNR = eq.I_DISPATCH[disppos].AUFNR.Replace("U", ""); eq.I_TEXT[eq.I_TEXT.Length - 1].DTTYP = "I"; eq.I_TEXT[eq.I_TEXT.Length - 1].TLINE = (String)txti[t]; } txtw = splitText(Lotus.getItemValue(sd, "rtxtpruefbericht"), 132); for (int t = 0; t < txtw.Count; t++) { eq.I_TEXT = expandDispatchTextTable(eq.I_TEXT); eq.I_TEXT[eq.I_TEXT.Length - 1].AUFNR = eq.I_DISPATCH[disppos].AUFNR.Replace("U", ""); eq.I_TEXT[eq.I_TEXT.Length - 1].DTTYP = "W"; eq.I_TEXT[eq.I_TEXT.Length - 1].TLINE = (String)txtw[t]; } //eq.I_DISPATCH[disppos].AUFNR = Lotus.getItemValue(sd, "txteanrUS"); --> GEREK YOK ZATEN ÜSTTE YAZDIK String tmp = Lotus.getItemValue(di, "txteajobtype"); eq.I_DISPATCH[disppos].VAPLZ = tmp.Trim().Length <= 0 || tmp.IndexOf("-") <= 0 ? "" : tmp.Substring(0, tmp.IndexOf("-")); if (eq.I_DISPATCH[disppos].VAPLZ.Length > 8) { eq.I_DISPATCH[disppos].VAPLZ = eq.I_DISPATCH[disppos].VAPLZ.Substring(0, 8); } eq.I_DISPATCH[disppos].ZINVOICE = Lotus.getItemValue(di, "Invoice") == "1" ? "X" : ""; eq.I_DISPATCH[disppos].QMNUM = Lotus.getItemValue(sd, "numkdkostenstelle"); eq.I_DISPATCH[disppos].ZFSE = Lotus.getItemValue(di, "SAPTSRID"); eq.I_DISPATCH[disppos].KUNNR = Lotus.getItemValue(sd, "txtkdnr"); eq.I_DISPATCH[disppos].EQUNR = Lotus.getItemValue(sd, "numeqnr"); eq.I_DISPATCH[disppos].AUSVN = parseLotusDate(Lotus.getItemValue(di, "dateabestelltam")); if (Lotus.getItemValue(sd, "TXTEQSTATUS") == "2") // yeşil ışık { eq.I_DISPATCH[disppos].AUSBS = parseToday(); } eq.I_DISPATCH[disppos].ZFSSUST = Lotus.getItemValue(di, "numeanr"); // Additional readers String[] ar = Lotus.getItemValues(sd, "AdditionalReaders"); eq.I_Z7 = new sapFIN.SAPWS.ZFSS_S_DISPATCH_Z7[ar.Length]; for (int a = 0; a < ar.Length; a++) { eq.I_Z7[a] = new sapFIN.SAPWS.ZFSS_S_DISPATCH_Z7(); eq.I_Z7[a].AUFNR = eq.I_DISPATCH[disppos].AUFNR.Replace("U", ""); eq.I_Z7[a].PARNR = Program.lotus.getLotusPernr(ar[a]); } } // frm_gzea } // loop at subdocs } // IF FORM } // FOR SAPWS.ZFSS_SET_DISPATCHResponse res = sapService.ZFSS_SET_DISPATCH(eq); }
public void setComponents(Domino.NotesViewClass view) { int dispcount = 0; int disppos = -1; if (view == null) { return; } // Toplamda kaç Dispatch ile karşı karşıyayız tespit et ve Dispatch değişkenlerini yarat for (int n = 1; n <= view.AllEntries.Count; n++) { Domino.NotesDocumentClass di = (Domino.NotesDocumentClass)view.GetNthDocument(n); String form = Lotus.getItemValue(di, "FORM"); if (form == "frm_ea") { for (int m = 1; m <= di.Responses.Count; m++) { Domino.NotesDocumentClass sd = (Domino.NotesDocumentClass)di.Responses.GetNthDocument(m); String subform = Lotus.getItemValue(sd, "FORM"); if (subform == "frm_gzea") { for (int x = 1; x <= sd.Responses.Count; x++) { Domino.NotesDocumentClass co = (Domino.NotesDocumentClass)sd.Responses.GetNthDocument(x); String subform2 = Lotus.getItemValue(co, "FORM"); if (subform2 == "frm_lum") { dispcount++; } } } } } } if (dispcount <= 0) { return; } SAPWS.ZFSS_SET_COMPONENT eq = new sapFIN.SAPWS.ZFSS_SET_COMPONENT(); eq.I_COMPONENT = new sapFIN.SAPWS.ZFSS_S_COMPONENT[dispcount]; // Devam for (int n = 1; n <= view.AllEntries.Count; n++) { Domino.NotesDocumentClass di = (Domino.NotesDocumentClass)view.GetNthDocument(n); String form = Lotus.getItemValue(di, "FORM"); if (form == "frm_ea") { for (int m = 1; m <= di.Responses.Count; m++) { Domino.NotesDocumentClass sd = (Domino.NotesDocumentClass)di.Responses.GetNthDocument(m); String subform = Lotus.getItemValue(sd, "FORM"); if (subform == "frm_gzea") { for (int x = 1; x <= sd.Responses.Count; x++) { Domino.NotesDocumentClass co = (Domino.NotesDocumentClass)sd.Responses.GetNthDocument(x); String subform2 = Lotus.getItemValue(co, "FORM"); if (subform2 == "frm_lum") { disppos++; eq.I_COMPONENT[disppos] = new sapFIN.SAPWS.ZFSS_S_COMPONENT(); eq.I_COMPONENT[disppos].MATNR = Lotus.getItemValue(co, "txtartsachnr", 18); eq.I_COMPONENT[disppos].BDMNG = Lotus.getItemValueAsDecimal(co, "numlumverbrauch"); eq.I_COMPONENT[disppos].MEINS = Lotus.getItemValue(co, "numartme"); eq.I_COMPONENT[disppos].ZZACCNT = Lotus.getItemValue(co, "txtaccindcodeLUM"); eq.I_COMPONENT[disppos].ZZSERNE = Lotus.getItemValue(co, "txtfabriknr"); eq.I_COMPONENT[disppos].ZZSEROL = Lotus.getItemValue(co, "txtfabriknrout"); eq.I_COMPONENT[disppos].POTX1 = Lotus.getItemValue(co, "txtbemerk"); eq.I_COMPONENT[disppos].ZZVANLO = Lotus.getItemValue(co, "txtlumlagerort"); eq.I_COMPONENT[disppos].LUNID = co.UniversalID; eq.I_COMPONENT[disppos].AUFNR = Lotus.getItemValue(co, "SAPtxtNo", 40).Replace("U", ""); } } } } } } SAPWS.ZFSS_SET_COMPONENTResponse res = sapService.ZFSS_SET_COMPONENT(eq); }
public void setConfirmations(Domino.NotesViewClass view) { int dispcount = 0; int disppos = -1; if (view == null) { return; } // Toplamda kaç Dispatch ile karşı karşıyayız tespit et ve Dispatch değişkenlerini yarat for (int n = 1; n <= view.AllEntries.Count; n++) { Domino.NotesDocumentClass di = (Domino.NotesDocumentClass)view.GetNthDocument(n); String form = Lotus.getItemValue(di, "FORM"); if (form == "frm_ea") { for (int m = 1; m <= di.Responses.Count; m++) { Domino.NotesDocumentClass sd = (Domino.NotesDocumentClass)di.Responses.GetNthDocument(m); String subform = Lotus.getItemValue(sd, "FORM"); if (subform == "frm_gzea") { for (int x = 1; x <= sd.Responses.Count; x++) { Domino.NotesDocumentClass co = (Domino.NotesDocumentClass)sd.Responses.GetNthDocument(x); String subform2 = Lotus.getItemValue(co, "FORM"); if (subform2 == "frm_arbleist") { dispcount++; } } } } } } if (dispcount <= 0) { return; } SAPWS.ZFSS_SET_CONFIRMATION eq = new sapFIN.SAPWS.ZFSS_SET_CONFIRMATION(); eq.I_CONFIRMATION = new sapFIN.SAPWS.ZFSS_S_CONFIRMATION[dispcount]; // Devam for (int n = 1; n <= view.AllEntries.Count; n++) { Domino.NotesDocumentClass di = (Domino.NotesDocumentClass)view.GetNthDocument(n); String form = Lotus.getItemValue(di, "FORM"); if (form == "frm_ea") { for (int m = 1; m <= di.Responses.Count; m++) { Domino.NotesDocumentClass sd = (Domino.NotesDocumentClass)di.Responses.GetNthDocument(m); String subform = Lotus.getItemValue(sd, "FORM"); if (subform == "frm_gzea") { for (int x = 1; x <= sd.Responses.Count; x++) { Domino.NotesDocumentClass co = (Domino.NotesDocumentClass)sd.Responses.GetNthDocument(x); String subform2 = Lotus.getItemValue(co, "FORM"); if (subform2 == "frm_arbleist") { disppos++; eq.I_CONFIRMATION[disppos] = new sapFIN.SAPWS.ZFSS_S_CONFIRMATION(); eq.I_CONFIRMATION[disppos].ARBPL = Lotus.getItemValue(co, "numleiststdacttext", 6); eq.I_CONFIRMATION[disppos].BUDAT = parseLotusDate(Lotus.getItemValue(co, "dattatwork")); eq.I_CONFIRMATION[disppos].IEDZ_WAIT = parseLotusTime(Lotus.getItemValue(co, "numwaittimeende")); eq.I_CONFIRMATION[disppos].IEDZ_WORK = parseLotusTime(Lotus.getItemValue(co, "numleiststdende")); eq.I_CONFIRMATION[disppos].ISDZ_WAIT = parseLotusTime(Lotus.getItemValue(co, "numwaittimebeginn")); eq.I_CONFIRMATION[disppos].ISDZ_WORK = parseLotusTime(Lotus.getItemValue(co, "numleiststdbeginn")); eq.I_CONFIRMATION[disppos].ISMNE_TRAV = "H"; eq.I_CONFIRMATION[disppos].ISMNE_WAIT = "H"; eq.I_CONFIRMATION[disppos].ISMNE_WORK = "H"; eq.I_CONFIRMATION[disppos].ISMNW_TRAV = Lotus.getItemValueAsDecimal(co, "numtraveltime"); eq.I_CONFIRMATION[disppos].ISMNW_TRAV = Decimal.Parse(String.Format("{0:00.0}", eq.I_CONFIRMATION[disppos].ISMNW_TRAV)); //eq.I_CONFIRMATION[disppos].ISMNW_WAIT = Lotus.getItemValueAsDecimal(co, "numwaittimeacttextprint"); //eq.I_CONFIRMATION[disppos].ISMNW_WORK = Lotus.getItemValueAsDecimal(co, "numleiststd"); eq.I_CONFIRMATION[disppos].LUNID = co.UniversalID; eq.I_CONFIRMATION[disppos].LTXA1 = Lotus.getItemValue(co, "txtbemerk", 40); eq.I_CONFIRMATION[disppos].AUFNR = Lotus.getItemValue(co, "SAPtxtNo", 40).Replace("U", ""); } } } } } } SAPWS.ZFSS_SET_CONFIRMATIONResponse res = sapService.ZFSS_SET_CONFIRMATION(eq); }