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