/// <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));
}
