// private void NameChanged(object Sender, XEventArgs e)
// {
// }
// protected void Page_Load(object sender, EventArgs e)
// {
// }
// private void checkActive(object Sender, XEventArgs e)
// {
// }
//public override void AfterPost()
//{
// itemForm.syncOnSave();
//}
public override void Initialize()
{
ItemTable = XModule.GetTable("MTRL");
itemForm = new ItemForm();
itemForm.TopLevel = false;
itemForm.MTRL = ItemTable;
itemForm.Visible = true;
XModule.InsertControl(itemForm, "+PAGE(PG8,Web)");
CallCount++;
}
public override void Initialize()
{
CustTable = XModule.GetTable("TRDR");
customerForm = new CustomerForm();
customerForm.TopLevel = false;
customerForm.Visible = true;
customerForm.TRDR = CustTable;
XModule.InsertControl(customerForm, "+PAGE(PG8,Web)");
CallCount++;
}
public override void Initialize()
{
CustTable = XModule.GetTable("PRCCATEGORY");
// XModule.SetEvent("ON_TRDR_NAME", NameChanged);
// XModule.SetEvent("ON_TRDR_POST", NameChanged);
form1 = new panel1();
pRCCategoryForm = new PRCCategoryForm();
p2 = new panel2();
pRCCategoryForm.TopLevel = false;
pRCCategoryForm.Visible = true;
pRCCategoryForm.PRCCategory = CustTable;
// XModule.InsertControl(itemForm, "+PANEL(Panel1,Web)");
//XModule.InsertControl(itemForm, "+PANEL(NULL, 0,Web)");
//XModule.SetEvent("ON_TRDR", checkActive);
XModule.InsertControl(pRCCategoryForm, "+PAGE(Pl1,Web)");
CallCount++;
}
public override void Initialize()
{
CustTable = XModule.GetTable("TRDR");
// MessageBox.Show((String)CustTable.Current["EMAIL"]);
XModule.SetEvent("ON_TRDR_NAME", NameChanged);
XModule.SetEvent("ON_TRDR_POST", NameChanged);
form1 = new panel1();
customerForm = new CustomerForm();
p2 = new panel2();
customerForm.TopLevel = false;
customerForm.Visible = true;
customerForm.TRDR = CustTable;
XModule.InsertControl(customerForm, "+PAGE(PG2,Web)");
XModule.SetEvent("ON_TRDR", checkActive);
CallCount++;
}
public override void Initialize()
{
CustTable = XModule.GetTable("MTRL");
CustTableExtra = XModule.GetTable("MTREXTRA");
// XModule.SetEvent("ON_MTRL_POST", NameChanged);
// XModule.SetEvent("ON_TRDR_POST", Page_Load);
form1 = new panel1();
itemForm = new ItemForm();
p2 = new panel2();
itemForm.TopLevel = false;
itemForm.MTRL = CustTable;
itemForm.MTREXTRA = CustTableExtra;
itemForm.CompanyId = this.XSupport.ConnectionInfo.CompanyId;
//itemForm.XSupport = this.XSupport;
// MessageBox.Show("SELECT A.COMPANY,A.PRCCATEGORY,A.CODE,A.NAME,A.ACNMSK,A.ISACTIVE,A.PRICEZONE " +
// "FROM [DEMO].[dbo].[PRCCATEGORY] A WHERE A.COMPANY=" + this.XSupport.ConnectionInfo.CompanyId + " ORDER BY A.PRCCATEGORY");
XTable pRCCategories = this.XSupport.GetSQLDataSet(
"SELECT A.COMPANY,A.PRCCATEGORY,A.CODE,A.NAME,A.ACNMSK,A.ISACTIVE,A.PRICEZONE " +
"FROM PRCCATEGORY A WHERE A.COMPANY=" + this.XSupport.ConnectionInfo.CompanyId + " ORDER BY A.PRCCATEGORY"
);
itemForm.pRCCategories = pRCCategories;
// PRCCategories[1, 1].ToString();
// itemForm.dataGridView1.VirtualMode = true;
// itemForm.dataGridView1.RowCount = table1.Count;
itemForm.Visible = true;
XModule.InsertControl(itemForm, "+PAGE(PG8,Web)");
//XModule.SetEvent("ON_TRDR", checkActive);
CallCount++;
}
private void btnCreateCustomer_Click(object sender, EventArgs e)
{
Customer = Prg.CreateModule("CUSTOMER");
CustTbl = Customer.GetTable("TRDR");
}
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 override void Initialize()
{
curSupport = XSupport;
CCCCONNECTIONBRICK = XModule.GetTable("CCCCONNECTIONBRICK");
CCCSQLCOMMANDCOLUMN = XModule.GetTable("CCCSQLCOMMANDCOLUMN");
}
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);
}
}
