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("Διαδικασία ολοκληρώθηκε."); }