/// <summary> /// Saves information that is common for all rows on a AidId /// /// </summary> private void saveCommonOrderRow(OrderRowDefinitions.OrderRow or, ref GarpGenericDB data) { data.find(or.OrderNo); data.next(); while (data.getValue("ONR").Equals(or.OrderNo) && !data.EOF) { if ((getFormatedAidId(data.getValue("NX1")) == or.AidNr) && (!isEgenAvgift(data.getValue("ANR")))) { fillCommonOrderRowFields(or, data); } data.next(); } }
private void btnCopDoc2_Click(object sender, EventArgs e) { Config.CopDoc cd = Config.getCopDoc[1]; GarpGenericDB garp; Process copdoc = new Process(); if (cd.Table.Equals("OGA")) { garp = new GarpGenericDB(cd.Table); // If we found the post searched for if (garp.find(txtONR.Text)) { cd.Arguments = cd.Arguments.Replace("{" + cd.Table + ";", ""); cd.Arguments = cd.Arguments.Replace(cd.Field + "}", "\"" + garp.getValue(cd.Field) + "\""); copdoc.StartInfo.FileName = cd.Path; copdoc.StartInfo.Arguments = cd.Arguments; try { Log4Net.Logger.loggInfo("CopDoc started with following string: " + copdoc.StartInfo.FileName + " " + copdoc.StartInfo.Arguments, Config.User, "frmMain.btnCopDoc1_Click()"); copdoc.Start(); } catch (Exception ex) { Log4Net.Logger.loggError(ex, "Error when starting CopDoc Path:" + cd.Path + " Arguments:" + cd.Arguments, Config.User, "frmMain.btnCopDoc1_Click"); MessageBox.Show(this, "Det gick inte att starta CopDoc", "CopDoc", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show(this, "Hittade inte den eftersökta patienten i Garp", "Patient hittades ej", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (cd.Table.Equals("KA")) { garp = new GarpGenericDB(cd.Table); // If we found the post searched for if (garp.find(txtKNR.Text)) { cd.Arguments = cd.Arguments.Replace("{" + cd.Table + ";", ""); cd.Arguments = cd.Arguments.Replace(cd.Field + "}", garp.getValue(cd.Field)); copdoc.StartInfo.FileName = cd.Path; copdoc.StartInfo.Arguments = cd.Arguments; try { copdoc.Start(); } catch (Exception ex) { Log4Net.Logger.loggError(ex, "Error when starting CopDoc Path:" + cd.Path + " Arguments:" + cd.Arguments, Config.User, "frmMain.btnCopDoc1_Click"); MessageBox.Show(this, "Det gick inte att starta CopDoc", "CopDoc", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show(this, "Hittade inte den eftersökta patienten i Garp", "Patient hittades ej", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private OrderRowDefinitions.OrderRow fillOrderRow(ref GarpGenericDB data) { mOGR2.find(data.getValue("ONR").PadRight(6) + data.getValue("RDC").PadLeft(3)); OrderRowDefinitions.OrderRow or = new OrderRowDefinitions.OrderRow(); fillFieldsFromOtherTables(data.getValue("ONR"), data.getValue("RDC")); or.OrderNo = data.getValue("ONR"); or.Rad = data.getValue("RDC"); or.AidNr = getFormatedAidId(data.getValue("NX1")); or.Artikel = data.getValue("ANR"); or.ProductName = oProduct.getNameById(data.getValue("ANR")); or.Antal = data.getValue("ORA"); if (isInternalProduct(or.Artikel)) or.APris = mOGR.getValue("LVP"); else or.APris = mOGR.getValue("PRI"); or.LevTid = data.getValue("LDT"); or.InkStat = data.getValue("INK"); or.Enhet = data.getValue("ENH"); or.AidDate = getFormatedAidDate(data.getValue("DIM")); or.Prodstatus = oProdStat.getTable(data.getValue("RES")).TX1; or.SelectedHandler = data.getValue("BNX"); or.Levstatus = data.getValue("LVF"); //or.DeliverMode = getDeliverMode(or.OrderNo); or.Text = orText.getTexts(or.OrderNo, or.Rad); or.AidsText = orText.getAidsText(or.OrderNo, or.Rad); or.ViewInList = mOGR.getValue("X1F").Equals("x") ? true : false; or.Warrenty = mOGR.getValue("RBK").Equals("G") ? true : false; or.Beloppsrad = mOGR.getValue("BRA").Equals("*") ? true : false; or.DeliverDate = GCF.noNULL(mDeliverDate); or.InvoiceNo = GCF.noNULL(mInvoiceNo);; or.InvoiceDate = GCF.noNULL(mInvoiceDate);; or.Thord_NeedStep = mOGR2.getValue("C2A"); or.AidPriority = mOGR2.getValue("C2B"); try { or.AidOid = 0; int.TryParse(mOGR2.getValue("NU5"), out or.AidOid); } catch(Exception e) { or.AidOid = 0; } try { or.PartOid = 0; int.TryParse(mOGR2.getValue("NU6"), out or.PartOid); } catch (Exception e) { or.PartOid = 0; } or.CreatedInThord = data.getValue("X2F").Equals("1") ? true : false; or.FirstTimePatient = mOGR2.getValue("C1A").Equals("1") ? true : false; or.EA_ProductGroup = mOGR.getValue("EXT"); or.ProductionTitle = mOGR2.getValue("C20") + mOGR2.getValue("C10"); or.Urgent = mOGR2.getValue("C1B").Equals("1") ? true : false; or.Priority = mOGR2.getValue("C1C"); string[] s = { "yyMMdd", "yyyyMMdd", "yyyy-MM-dd" }; try { DateTime dt; DateTime.TryParseExact(mOGR2.getValue("C06"), s, new CultureInfo("sv-SE"), DateTimeStyles.AssumeLocal, out dt); if (dt.AddYears(50) < DateTime.Now) or.PromisedDeliverDate = null; else or.PromisedDeliverDate = dt; } catch { or.PromisedDeliverDate = null; } try { DateTime dt; DateTime.TryParseExact(mOGR2.getValue("C07").Trim(), s, new CultureInfo("sv-SE"), DateTimeStyles.AssumeLocal, out dt); if (dt.AddYears(50) < DateTime.Now) or.ConditionDate = null; else or.ConditionDate = dt; } catch { or.ConditionDate = null; } or.Holder = mOGR2.getValue("C05") == "" ? null : mOGR2.getValue("C05"); return or; }
public PurchaseDefenitions[] getAllPurchaseOrders(string cust_onr) { GarpGenericDB IGA = new GarpGenericDB("IGA"); GarpGenericDB IGF = new GarpGenericDB("IGF"); GarpGenericDB LA = new GarpGenericDB("LA"); PurchaseDefenitions purchase; ArrayList alPurchase = new ArrayList(); IGF.first(); while (!IGF.EOF) { if (GCF.noNULL(IGF.getValue("TX3")).StartsWith(cust_onr.Trim())) { purchase = new PurchaseDefenitions(); purchase.IO_No = IGF.getValue("ONR").Trim(); purchase.CustomerOrderNo = IGF.getValue("TX3"); if (IGA.find(IGF.getValue("ONR"))) { purchase.IO_Status = IGA.getValue("LEF"); purchase.SupplierNo = IGA.getValue("LNR"); if (LA.find(IGA.getValue("LNR"))) purchase.SupplierName = LA.getValue("NAM"); } alPurchase.Add(purchase); } IGF.next(); } return (PurchaseDefenitions[])alPurchase.ToArray(typeof(PurchaseDefenitions)); }