private void MTRGROUPSyncButton_Click(object sender, EventArgs e)
{
Io.HttpWeb.ItemHttp ITEMHttp = new Io.HttpWeb.ItemHttp();
XTable MTRGROUP = Model.S1Init.myXSupport.GetSQLDataSet(
" SELECT COMPANY " +
" ,SODTYPE " +
" ,UTBL05 " +
" ,CODE " +
" ,NAME " +
" ,ISACTIVE " +
" FROM UTBL05 " +
// " WHERE SODTYPE = 51 " +
" WHERE ISACTIVE = 1 " +
" AND COMPANY = " + Model.S1Init.myXSupport.ConnectionInfo.CompanyId.ToString());
this.LoadingProgressBar.Maximum = MTRGROUP.Count;
this.LoadingProgressBar.Step = 1;
for (int i = 0; i < MTRGROUP.Count; i++)
{
ITEMHttp.syncMTRGROUP(MTRGROUP[i, "UTBL05"].ToString(),
MTRGROUP[i, "NAME"].ToString());
this.LoadingProgressBar.PerformStep();
}
this.LoadingProgressBar.Value = 0;
MessageBox.Show("Διαδικασία ολοκληρώθηκε.");
}
private void MtrlSyncButton_Click(object sender, EventArgs e)
{
Io.HttpWeb.ItemHttp itemHttp = new Io.HttpWeb.ItemHttp();
string[,] PRICERPRC = new string[12, 2];
String CODE = "", NAME = "", ITEM_PRICE = "";
String CATEG_NAME = "-1", CATEG_ID = "-1";
Settings settings = Settings.getInstance();
String FILTER_CHECKBOX = "";
XTable pRCCategories = Model.S1Init.myXSupport.GetSQLDataSet(
"SELECT A.COMPANY,A.PRCCATEGORY,A.CODE,A.NAME,A.ACNMSK,A.ISACTIVE,A.PRICEZONE " +
"FROM PRCCATEGORY A WHERE A.COMPANY=" + Model.S1Init.myXSupport.ConnectionInfo.CompanyId + " ORDER BY A.PRCCATEGORY"
);
if (!settings.ITEM_ON_WEB.Equals(""))
{
FILTER_CHECKBOX = " AND ME." + settings.ITEM_ON_WEB + " = 1";
}
XTable MTRLS = Model.S1Init.myXSupport.GetSQLDataSet(
" SELECT " +
" M.CODE , " +
" M.NAME , " +
" M." + settings.ITEM_PRICE + ", " +
" M." + settings.ITEM_PRICE + "01, " +
" M." + settings.ITEM_PRICE + "02, " +
" M." + settings.ITEM_PRICE + "03, " +
" M." + settings.ITEM_PRICE + "04, " +
" M." + settings.ITEM_PRICE + "05, " +
" M." + settings.ITEM_PRICE + "06, " +
" M." + settings.ITEM_PRICE + "07, " +
" M." + settings.ITEM_PRICE + "08, " +
" M." + settings.ITEM_PRICE + "09, " +
" M." + settings.ITEM_PRICE + "10, " +
" M." + settings.ITEM_PRICE + "11, " +
" M." + settings.ITEM_PRICE + "12, " +
" G.CODE , " +
" G.NAME " +
" FROM ( MTRL M LEFT OUTER JOIN MTRGROUP G ON M.MTRGROUP = G.MTRGROUP " +
" AND G.SODTYPE = 51 " +
" AND G.COMPANY = " + Model.S1Init.myXSupport.ConnectionInfo.CompanyId + " ) " +
" LEFT OUTER JOIN MTREXTRA ME ON M.MTRL = ME.MTRL " +
" WHERE M.SODTYPE = 51 " +
" AND M.COMPANY = " + Model.S1Init.myXSupport.ConnectionInfo.CompanyId +
FILTER_CHECKBOX
);
this.LoadingProgressBar.Maximum = MTRLS.Count;
this.LoadingProgressBar.Step = 1;
int zone;
for (int j = 0; j < pRCCategories.Count; j++)
{
zone = int.Parse(pRCCategories[j, 7].ToString());
PRICERPRC[zone - 1, 0] = pRCCategories[j, 2].ToString();
}
for (int i = 0; i < MTRLS.Count; i++)
{
int j = 0;
CATEG_NAME = "-1";
CATEG_ID = "-1";
if (!DBNull.Value.Equals(MTRLS[i, "CODE"]))
{
CODE = (String)MTRLS[i, "CODE"];
}
if (!DBNull.Value.Equals(MTRLS[i, "NAME"]))
{
NAME = (String)MTRLS[i, "NAME"];
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE]))
{
ITEM_PRICE = (String)MTRLS[i, settings.ITEM_PRICE].ToString();
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "01"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "01"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "02"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "02"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[j, settings.ITEM_PRICE + "03"]))
{
PRICERPRC[i, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "03"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[j, settings.ITEM_PRICE + "04"]))
{
PRICERPRC[i, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "04"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "05"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "05"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "06"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "06"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "07"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "07"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "08"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "08"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "09"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "09"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "10"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "10"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "11"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "11"].ToString();
j++;
}
if (!DBNull.Value.Equals(MTRLS[i, settings.ITEM_PRICE + "12"]))
{
PRICERPRC[j, 1] = (String)MTRLS[i, settings.ITEM_PRICE + "12"].ToString();
j++;
}
itemHttp.syncMTRL(CODE, NAME, ITEM_PRICE, PRICERPRC, j, CATEG_NAME, CATEG_ID);
this.LoadingProgressBar.PerformStep();
}
this.LoadingProgressBar.Value = 0;
MessageBox.Show("Διαδικασία ολοκληρώθηκε.");
}
