public void InsSalDocToS1(int FinDocID, int CustID, ArrayList items, double shippingPrice, int EXPN) { XModule ModuleSALDOC = Model.S1Init.myXSupport.CreateModule("SALDOC"); XTable FinDoc = ModuleSALDOC.GetTable("FINDOC"); XTable IteLines = ModuleSALDOC.GetTable("ITELINES"); XTable MtrDoc = ModuleSALDOC.GetTable("MTRDOC"); XTable EXPANAL = ModuleSALDOC.GetTable("EXPANAL"); try { ModuleSALDOC.InsertData(); FinDoc.Current["SERIES"] = FinDocID; FinDoc.Current["FPRMS"] = FinDocID; FinDoc.Current["TFPRMS"] = 202; FinDoc.Current["SOSOURCE"] = 1351; FinDoc.Current["TRNDATE"] = DateTime.Today; FinDoc.Current["TRDR"] = CustID; FinDoc.Current["VATSTS"] = 1; FinDoc.Current["FISCPRD"] = 2015; FinDoc.Current["BRANCH"] = 1000; // FinDoc.Current["VAT"] = 1; //FinDoc.Current.Post(); //MtrDoc.Current.Insert(); MtrDoc.Current["WHOUSE"] = 1000; //MtrDoc.Current.Post(); int linenum = 1; foreach (ArrayList item in items) { IteLines.Current.Insert(); IteLines.Current["LINENUM"] = linenum; IteLines.Current["SODTYPE"] = 51; // IteLines.Current["SOSOURCE"] = 1351; IteLines.Current["MTRL"] = (int)item[5]; IteLines.Current["MTRUNIT"] = 1; //Your code IteLines.Current["QTY1"] = Convert.ToDouble(item[2].ToString().Replace(".", ",")); // IteLines.Current["QTY1"] = 1.00; // IteLines.Current["VAT"] = 1310; //Your Code IteLines.Current["LINEVAL"] = Convert.ToDouble(item[4].ToString().Replace(".", ",")); IteLines.Current["PRICE"] = Convert.ToDouble(item[3].ToString().Replace(".", ",")); IteLines.Current["DISC1PRC"] = 0.00; IteLines.Current.Post(); linenum++; } if (shippingPrice > 0) { EXPANAL.Current.Insert(); EXPANAL.Current["EXPN"] = EXPN; EXPANAL.Current["EXPVAL"] = shippingPrice; //EXPANAL.Current[""] = //EXPANAL.Current[""] = EXPANAL.Current.Post(); } FinDoc.Current.Post(); ModuleSALDOC.PostData(); } catch (Exception ex) { throw ex; // MessageBox.Show(e.Message); } }
public void InsSalDocToS1(DateTime orderDate, int FinDocID, String WebCode, int CustID, ArrayList items, double shippingPrice, int EXPN) { Settings settings = Settings.getInstance(); XModule ModuleSALDOC = Model.S1Init.myXSupport.CreateModule("SALDOC"); XTable FinDoc = ModuleSALDOC.GetTable("FINDOC"); XTable IteLines = ModuleSALDOC.GetTable("ITELINES"); XTable MtrDoc = ModuleSALDOC.GetTable("MTRDOC"); XTable EXPANAL = ModuleSALDOC.GetTable("EXPANAL"); try { ModuleSALDOC.InsertData(); FinDoc.Current["SERIES"] = FinDocID; FinDoc.Current["FPRMS"] = FinDocID; FinDoc.Current["TFPRMS"] = 202; FinDoc.Current["SOSOURCE"] = 1351; FinDoc.Current["TRNDATE"] = orderDate; FinDoc.Current["TRDR"] = CustID; FinDoc.Current["VATSTS"] = 1; FinDoc.Current["FISCPRD"] = S1Init.myXSupport.ConnectionInfo.YearId; //2015 FinDoc.Current["BRANCH"] = S1Init.myXSupport.ConnectionInfo.BranchId; //1000; if (!settings.OrderWebRel.Equals("")) { FinDoc.Current[settings.OrderWebRel] = WebCode; //1000; } // FinDoc.Current["VAT"] = 1; //FinDoc.Current.Post(); //MtrDoc.Current.Insert(); MtrDoc.Current["WHOUSE"] = int.Parse(settings.WHouse); // 1000; //MtrDoc.Current.Post(); int linenum = 1; foreach (ArrayList item in items) { IteLines.Current.Insert(); IteLines.Current["LINENUM"] = linenum; IteLines.Current["SODTYPE"] = 51; // IteLines.Current["SOSOURCE"] = 1351; IteLines.Current["MTRL"] = (int)item[5]; IteLines.Current["MTRUNIT"] = 1; //Your code double a = Convert.ToDouble(item[2].ToString().Replace(".", ",")); IteLines.Current["QTY1"] = Convert.ToDouble(item[2].ToString().Replace(".", ",")); // IteLines.Current["QTY1"] = 1.00; // IteLines.Current["VAT"] = 1310; //Your Code IteLines.Current["LINEVAL"] = Convert.ToDouble(item[4].ToString().Replace(".", ",")); IteLines.Current["PRICE"] = Convert.ToDouble(item[3].ToString().Replace(".", ",")); IteLines.Current["DISC1PRC"] = 0.00; IteLines.Current.Post(); linenum++; } if (shippingPrice > 0) { EXPANAL.Current.Insert(); EXPANAL.Current["EXPN"] = EXPN; EXPANAL.Current["EXPVAL"] = shippingPrice; //EXPANAL.Current[""] = //EXPANAL.Current[""] = EXPANAL.Current.Post(); } FinDoc.Current.Post(); ModuleSALDOC.PostData(); } catch (Exception ex) { throw ex; // MessageBox.Show(e.Message); } }