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 ImplAdapterTableExt(IEnvironment pEnv, IPagedSource pSource, string[] pCol, String pSqlNewIdTable, ISqlBuilderPreparer[] preps)
{
environment = pEnv;
source = pSource;
columns = pCol;
newIdTable = pSqlNewIdTable;
//
if (preps != null)
{
for (int i = 0; i < preps.Length; ++i)
{
source.getBuilder().addPereparer(preps[i]);
}
}
//
//adapter = new SqliteDataAdapter();
//adapter.AcceptChangesDuringUpdate = false;
//source.getBuilder().reset();
//source.getBuilder().setCountMin();
//for (int i = 0; i < columns.Length; ++i)
// source.getBuilder().addParameterValue(columns[i], DBNull.Value);
//adapter.SelectCommand = source.getBuilder().get();
//builder = new SqliteCommandBuilder(adapter);
// builder.ConflictOption = ConflictOption.CompareAllSearchableValues;
// builder.SetAllValues = true;
//
// adapter.RowUpdating += new SqliteRowUpdatingEventHandler(adapter_RowUpdating);
}
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]]);
}
}
}
}
}
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);
}
}
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_);
}
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);
}
}
}
}
protected override void setSource(IPagedSource pSource)
{
base.setSource(pSource);
pSource.getBuilder().addPereparer(new SqlBuilderPreparerFixedCondition(TableINVOICE.GRPCODE, ConstDocGroupCode.sales));
pSource.getBuilder().addPereparer(new SqlBuilderPreparerFixedCondition(TableINVOICE.TRCODE, ConstDocTypeMaterial.wholeSaleReturn));
}
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();
}
}
}
protected override void setSource(IPagedSource pSource)
{
base.setSource(pSource);
pSource.getBuilder().addPereparer(new SqlBuilderPreparerFixedCondition(TableINVOICE.GRPCODE, ConstDocGroupCode.materialManagement));
pSource.getBuilder().addPereparer(new SqlBuilderPreparerFixedCondition(TableINVOICE.TRCODE, ConstDocTypeMaterial.marerialDefinedInput15));
}
protected override void setSource(IPagedSource pSource)
{
base.setSource(pSource);
pSource.getBuilder().addPereparer(new SqlBuilderPreparerFixedCondition(TableKSLINES.TRCODE, ConstCashDocType.clientToCash));
}
void init(DataTable pTable, IPagedSource pSource, string[] pBindChildCol, string[] pBindParentCol, string[] pChildCol, string[] pParentCol, UpdateTypeFlags pFlags, IRowValidator pValidator, string[] pTriggerCols)
{
flags.flagEnable(pFlags);
source = pSource;
for (int i = pChildCol.Length; i < pParentCol.Length; ++i)
{
pChildCol = ToolArray.resize <string>(pChildCol, pChildCol.Length + 1);
pChildCol[pChildCol.Length - 1] = string.Empty;
}
for (int i = 0; i < pParentCol.Length; ++i)
{
if ((pChildCol[i] == string.Empty) || (pChildCol[i] == null))
{
pChildCol[i] = ToolColumn.getColumnFullName(source.getBuilder().getName(), pParentCol[i]);
}
}
triggerCols = pTriggerCols;
bindChildCol = pBindChildCol;
bindParentCol = pBindParentCol;
childCol = pChildCol;
parentCol = pParentCol;
allChildCol = new string[bindChildCol.Length + childCol.Length];
bindChildCol.CopyTo(allChildCol, 0);
childCol.CopyTo(allChildCol, bindChildCol.Length);
allParentCol = new string[bindParentCol.Length + parentCol.Length];
bindParentCol.CopyTo(allParentCol, 0);
parentCol.CopyTo(allParentCol, bindParentCol.Length);
//
for (int i = 0; i < bindChildCol.Length; ++i)
{
addColForMap(bindChildCol[i], bindParentCol[i]);
}
for (int i = 0; i < childCol.Length; ++i)
{
addColForMap(childCol[i], parentCol[i]);
}
//
if (flags.isFlagEnabled(UpdateTypeFlags.activeOnRelColumn))
{
columns = bindChildCol;
}
else
{
int len = allChildCol.Length;
if (flags.isFlagEnabled(UpdateTypeFlags.activateIgnorLast1DrivedChilCols))
{
len -= 1;
}
else
if (flags.isFlagEnabled(UpdateTypeFlags.activateIgnorLast2DrivedChilCols))
{
len -= 2;
}
else
if (flags.isFlagEnabled(UpdateTypeFlags.activateIgnorLast3DrivedChilCols))
{
len -= 3;
}
columns = new string[len];
Array.Copy(allChildCol, columns, len);
}
columns = ToolArray.merge <string>(columns, triggerCols);
//
if (flags.isFlagEnabled(UpdateTypeFlags.updateIgnoreRelColumn))
{
updateChildCol = childCol;
}
else
{
updateChildCol = allChildCol;
}
//!!!!!!!!!!!!!!!!!!!!!!!!!!!
//
for (int i = 0; i < allChildCol.Length; ++i)
{
if (!tableSource.Columns.Contains(allChildCol[i]))
{
tableSource.Columns.Add(allChildCol[i], ToolTypeSet.helper.tObject);//check// source.getBuilder().getColumnType(allParentCol[i]));
}
}
//
try
{
flags.flagEnable(UpdateTypeFlags.__spe__updateIfDrived);
for (int i = 0; i < tableSource.Rows.Count; ++i)
{
refresh(tableSource.Rows[i]);
}
}
finally
{
flags.flagDisable(UpdateTypeFlags.__spe__updateIfDrived);
}
//
tableSource.ColumnChanged += new DataColumnChangeEventHandler(table_ColumnChanged);
}
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));
}
}
}
}
}
}
protected override void setSource(IPagedSource pSource)
{
base.setSource(pSource);
pSource.getBuilder().addPereparer(new SqlBuilderPreparerFixedCondition(TableINVOICE.GRPCODE, ConstDocGroupCode.purchasing));
pSource.getBuilder().addPereparer(new SqlBuilderPreparerFixedCondition(TableINVOICE.TRCODE, ConstDocTypeMaterial.materialPurchase));
}
public virtual string getName()
{
return(source.getBuilder().getName());
}
protected override void setSource(IPagedSource pSource)
{
base.setSource(pSource);
pSource.getBuilder().addPereparer(new SqlBuilderPreparerFixedCondition(TableSTFICHE.GRPCODE, ConstDocGroupCode.materialManagement));
}