public ImplPagedGridExtender(MobDataGrid pGrid, IPagedSource pSource, string pGlobalId) { globalId = pGlobalId; // grid = pGrid; source = pSource; // source.getBuilder().reset(); int indx = -1; try { indx = source.getBuilder().addPereparer(new SqlBuilderPreparerFixedCondition(TableDUMMY.ID, ToolLRef.dummyLRef)); DataTable tab_ = source.getAll(); initTable(tab_); grid.DataSource = tab_; tab_.DefaultView.ListChanged += DefaultView_ListChanged; } finally { if (indx > 0) { source.getBuilder().deletePreparer(indx); } } //grid.KeyPress += new KeyPressEventHandler(grid_KeyPress_Search); //grid.KeyDown += new KeyEventHandler(grid_KeyDown_Search); }
public void refreshSource() { if (_sourceDs != null) { _data = _sourceDs; } else if (_sourcePs != null) { _sourcePs.getBuilder().reset(); DataTable table = _sourcePs.getAll(); ToolTable.fillNull(table); _data = new DataSet(); _data.Tables.Add(table); } }
void distribute(DataRow row, string[] cols) { if (needUpdate(row, cols)) { //getData source.getBuilder().reset(); for (int i = 0; i < cols.Length; ++i) { string col = ToolColumn.extractColumnName(getColMapBind(cols[i])); string tab = ToolColumn.extractTableName(getColMapBind(cols[i])); object val = row[cols[i]]; if ((tab != string.Empty) && (col != string.Empty)) { source.getBuilder().addParameterValueTable(tab, col, val); } else if (col != string.Empty) { source.getBuilder().addParameterValue(col, val); } else if (col == string.Empty) { source.getBuilder().addFreeParameterValue(val); } } emptyDest(); DataTable tabData = source.getAll(); // if (tabData != null) { //Has data foreach (DataRow rowData in tabData.Rows) { DataRow nRow = tableDest.NewRow(); ToolRow.initTableNewRow(nRow); tableDest.Rows.Add(nRow); for (int i = 0; i < updateChildCol.Length; ++i) { ToolCell.set(nRow, getColMapData(updateChildCol[i]), rowData[updateChildCol[i]]); } } } } }
protected override void returnData(DataRow pRow) { reset(); if (pRow != null) { string barcode = pRow[TableDUMMY.VALUE].ToString().Trim(); if (barcode != string.Empty) { var p = new PARSER(barcode, CurrentVersion.ENV.getEnvString("WEIGHTBARCODE", "")); barcode = p.CODE1; IPagedSource ps = reference.getPagedSource(); ps.getBuilder().reset(); ps.getBuilder().beginWhereGroup(); ps.getBuilder().addParameterValue(TableITEMS.BARCODE1, barcode, SqlTypeRelations.equal, SqlTypeRelations.boolOr); if (CurrentVersion.ENV.getEnvBool("BARCODEMULTI", false)) { ps.getBuilder().addParameterValue(TableITEMS.BARCODE2, barcode, SqlTypeRelations.equal, SqlTypeRelations.boolOr); ps.getBuilder().addParameterValue(TableITEMS.BARCODE3, barcode, SqlTypeRelations.equal, SqlTypeRelations.boolOr); } ps.getBuilder().endWhereGroup(); DataTable matTab = ps.getAll(); if (matTab != null && matTab.Rows.Count > 0) { DataRow matRow = matTab.Rows[0]; DataRow matRowExt = selectUnit(matRow, barcode, p.WEIGHT); base.returnData(matRowExt); } else { ToolMobile.playAlarmAndVibrate(); ToolMsg.show(this, MessageCollection.T_MSG_INVALID_BARCODE, null); } } } }
public DataTable refresh() { if (getTable() == null) { return(null); } source.getBuilder().reset(); if (startigDataLoad != null) { startigDataLoad.Invoke(this, EventArgs.Empty); } DataTable tab_ = source.getAll(); ToolTable.fillNull(tab_); loadData(tab_); return(tab_); }
void doneAsync() { lock (environment) { bool ok = false; try { // log.set(MessageCollection.T_MSG_OPERATION_STARTING); // makeDbReadonly(); // string fileWorkDir = ToolMobile.getFullPath("data"); ToolMobile.createDir(fileWorkDir); string fileOutputZip = Path.Combine(fileWorkDir, "toava.zip"); string fileOutputXml = Path.Combine(fileWorkDir, "toava.xml"); // bool res = false; //Source //if (environment.getAppSettings().getBool(AvaExt.Settings.SettingsAvaAgent.MOB_USE_LOCAL_EXPIMP_B)) //{ // //SaveFileDialog sfd = new SaveFileDialog(); // //if (sfd.ShowDialog() == DialogResult.OK) // // fileOutputXml = sfd.FileName; // //else // // throw new Exception(string.Empty); //} // log.set(MessageCollection.T_MSG_DATA_READING); // XmlDocument doc = new XmlDocument(); string docID = "LOGICALREF"; AdapterUserDocument[] adapters = new AdapterUserDocument[] { new AdapterUserWholesaleSlip(environment, new ImplAdapterDataSetStub(environment, new AdapterDataSetWholesaleSlip(environment))), new AdapterUserWholesaleOrder(environment, new ImplAdapterDataSetStub(environment, new AdapterDataSetWholesaleOrder(environment))), new AdapterUserCashClient(environment, new ImplAdapterDataSetStub(environment, new AdapterDataSetCashClient(environment))) }; IPagedSource[] sources = new IPagedSource[] { new PagedSourceSlip(environment), new PagedSourceOrder(environment), new PagedSourceCashTrans(environment) }; string[] arrDesc = new string[] { environment.translate(WordCollection.T_DOC_STOCK_TRANS), environment.translate(WordCollection.T_DOC_STOCK_ORDERS), environment.translate(WordCollection.T_DOC_FINANCE) }; bool hasData = false; for (int i = 0; i < sources.Length; ++i) { IPagedSource source = sources[i]; source.getBuilder().addParameterValue(TableDUMMY.CANCELLED, ConstBool.not); AdapterUserDocument adapter = adapters[i]; log.set(MessageCollection.T_MSG_DATA_READING, new object[] { arrDesc[i] }); DataTable table = source.getAll(); log.set(MessageCollection.T_MSG_DATA_EXPORT, new object[] { arrDesc[i] }); foreach (DataRow row in table.Rows) { hasData = true; adapter.edit(row[docID]); adapter.export(doc); } } if (!hasData) { throw new Exception(MessageCollection.T_MSG_ERROR_NO_DATA); } // string[] expSettings = environment.getSysSettings().getAllSettings(); foreach (string settingsName in expSettings) { if (settingsName.StartsWith("MOB_SYS_")) { XmlAttribute attr = doc.CreateAttribute(settingsName); attr.Value = environment.getSysSettings().getString(settingsName); doc.DocumentElement.Attributes.Append(attr); } } // log.set(MessageCollection.T_MSG_DATA_WRITING); // doc.Save(fileOutputXml); ToolZip.compress(fileOutputZip, fileOutputXml); // if (!environment.getAppSettings().getBool(AvaExt.Settings.SettingsAvaAgent.MOB_USE_LOCAL_EXPIMP_B)) // { if (ToolMobile.existsFile(fileOutputZip)) { // log.set(MessageCollection.T_MSG_DATA_SENDING); // AgentData ad = new AgentData(environment); ad.chackOperationResult(ad.sendData(ToolMobile.readFileData(fileOutputZip))); } // } ok = true; } catch (Exception exc) { log.error(ToolException.unwrap(exc)); environment.getExceptionHandler().setException(exc); } finally { log.set(MessageCollection.T_MSG_OPERATION_FINISHING); Thread.Sleep(1000); log.hide(); } } }
void distribute(DataRow row, string[] cols) { if (validator.check(row)) { if (needUpdate(row, cols)) { bool drivedUpdateMode = flags.isFlagEnabled(UpdateTypeFlags.__spe__updateIfDrived); if (drivedUpdateMode) { bool hasFull = false; for (int i = 0; i < allChildCol.Length; ++i) { if (ToolColumn.isColumnFullName(allChildCol[i])) { hasFull = true; } } if (!hasFull) { return; } } //getData source.getBuilder().reset(); for (int i = 0; i < cols.Length; ++i) { string col = ToolColumn.extractColumnName(getColMap(cols[i])); string tab = ToolColumn.extractTableName(getColMap(cols[i])); object val = row[cols[i]]; if ((tab != string.Empty) && (col != string.Empty)) { source.getBuilder().addParameterValueTable(tab, col, val); } else if (col != string.Empty) { source.getBuilder().addParameterValue(col, val); } else if (col == string.Empty) { source.getBuilder().addFreeParameterValue(val); } } IDictionary dicData = ToolRow.convertFirstToDictionary(source.getAll()); // if (dicData != null) { //Has data string[] tmpChildCol = (drivedUpdateMode ? ToolColumn.selectFullNameCols(updateChildCol) : updateChildCol); for (int i = 0; i < tmpChildCol.Length; ++i) { ToolCell.set(row, tmpChildCol[i], dicData[getColMap(tmpChildCol[i])]); } } else { //No data if (!flags.isFlagEnabled(UpdateTypeFlags.disableEditCancel)) { row.CancelEdit(); } else { if (flags.isFlagEnabled(UpdateTypeFlags.setTypeDefaultToDrivedChild)) { ToolRow.initTableNewRow(row, (drivedUpdateMode ? ToolColumn.selectFullNameCols(childCol) : childCol)); } if (flags.isFlagEnabled(UpdateTypeFlags.setTypeDefaultToRelChild)) { ToolRow.initTableNewRow(row, (drivedUpdateMode ? ToolColumn.selectFullNameCols(bindChildCol) : bindChildCol)); } } } } } }