private void exeCmdGroup(StringBuilder pBuilder, XmlNode pNode, DataSet pDataSet) { string tabName = pNode.Attributes[_constAttrTable].Value; string filter = ToolXml.getAttribValue(pNode, _constAttrFilter, string.Empty); DataTable table = pDataSet.Tables[tabName]; table.DefaultView.RowFilter = filter; string[] colsArr = ToolString.explodeList(pNode.Attributes[_constAttrList].Value); DataTable[] grpTabs = ToolTable.explodeForGroups(table, colsArr); foreach (DataTable curTab in grpTabs) { if (curTab.DefaultView.Count > 0) { pDataSet.Tables.Remove(tabName); pDataSet.Tables.Add(curTab); setVars(curTab.DefaultView[0].Row); eval(pNode, pDataSet, pBuilder); } } pDataSet.Tables.Remove(tabName); pDataSet.Tables.Add(table); }
protected void LinkButton1_Click(object sender, EventArgs e) { ToolTable TT = new ToolTable(); TT.Cat = Convert.ToInt32(DropDownList1.SelectedValue); TT.ToolName = TextBox2.Text; TT.ThumbPic = "~/Dashboard/ThumbnailPic/" + FileUpload1.FileName; FileUpload1.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload1.FileName)); FileUpload2.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload2.FileName)); FileUpload3.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload3.FileName)); FileUpload4.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload4.FileName)); FileUpload5.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload5.FileName)); FileUpload6.SaveAs(Server.MapPath("~/Dashboard/ThumbnailPic/" + FileUpload5.FileName)); TT.Content1 = TextBox2.Text; TT.Pic1 = "/Dashboard/ThumbnailPic/" + FileUpload2.FileName; TT.Content2 = TextBox3.Text; TT.Pic2 = "/Dashboard/ThumbnailPic/" + FileUpload3.FileName; TT.Content3 = TextBox4.Text; TT.Pic3 = "/Dashboard/ThumbnailPic/" + FileUpload4.FileName; TT.Content4 = TextBox5.Text; TT.Pic4 = "/Dashboard/ThumbnailPic/" + FileUpload5.FileName; TT.MianContent = TextBox1.Text; TT.SourceCode = "/Dashboard/SourceCode/" + FileUpload6.FileName; dl.da.ToolTables.InsertOnSubmit(TT); dl.da.SubmitChanges(); Response.Write("<script>alert('Success')</script>"); TextBox1.Text = TextBox2.Text = TextBox3.Text = TextBox4.Text = TextBox5.Text = ""; }
public KeyInputByField(Object pSource, String pFileName) { view = ToolTable.dataTableFromSource(pSource).DefaultView; field = pFileName; filterItem = new List <FilterItem>(); filterItem.Add(new FilterItem(field)); }
public virtual DataTable getLast() { reverseSort(); DataTable table = getFirst(); reverseSort(); setBorder(ToolRow.getFirstRealRow(table)); return(ToolTable.createReversed(table)); }
void initTable(DataTable pTable) { ToolTable.fillNull(pTable); string sort_ = ToolMobile.getEnvironment().getStateRuntime(stateNameSort) as string; if (sort_ != null && pTable.DefaultView.Sort != sort_) { pTable.DefaultView.Sort = sort_; } }
static DataTable getData(IEnvironment env, int lref) { IPagedSource source = new PagedSourceDocNum(env); source.getBuilder().addParameterValue(TableDOCNUM.LOGICALREF, lref); DataTable tabNum = source.getAll(); if (ToolTable.isEmpty(tabNum)) { throw new MyException.MyExceptionError(MessageCollection.T_MSG_ERROR_NUMERATION); } return(tabNum); }
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); } }
static DataTable getData(IEnvironment env, DateTime date, short mod, short docType, short firm, short div, short factory, short wh, short group, short role, short user) { IPagedSource source = new PagedSourceDocNum(env); source.getBuilder().addParameterValue(TableDOCNUM.APPMODULE, mod); source.getBuilder().addParameterValue(TableDOCNUM.DOCIDEN, docType); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.FIRMID, firm); source.getBuilder().addParameterValue(TableDOCNUM.FIRMID, 0, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.EFFSDATE, date, SqlTypeRelations.lessEqual); source.getBuilder().addParameterValue(TableDOCNUM.EFFEDATE, date, SqlTypeRelations.greaterEqual); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.DIVISID, div); source.getBuilder().addParameterValue(TableDOCNUM.DIVISID, -1, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.WHID, wh); source.getBuilder().addParameterValue(TableDOCNUM.WHID, -1, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.FACTID, factory); source.getBuilder().addParameterValue(TableDOCNUM.FACTID, -1, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.GROUPID, group); source.getBuilder().addParameterValue(TableDOCNUM.GROUPID, 0, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.ROLEID, role); source.getBuilder().addParameterValue(TableDOCNUM.ROLEID, 0, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); source.getBuilder().beginWhereGroup(); source.getBuilder().addParameterValue(TableDOCNUM.USERID, user); source.getBuilder().addParameterValue(TableDOCNUM.USERID, 0, SqlTypeRelations.equal, SqlTypeRelations.boolOr); source.getBuilder().endWhereGroup(); DataTable tabNum = source.getAll(); if (ToolTable.isEmpty(tabNum)) { throw new MyException.MyExceptionError(MessageCollection.T_MSG_ERROR_NUMERATION); } return(tabNum); }
public void addParameterValueTable(string table, string col, object value, SqlTypeRelations relMath, SqlTypeRelations relBool) { try { if ((table != null) && (col != null) && (value != null)) { // Type typeWate = getColumnType(table, col); if (true //isColumnExists(table, col) && //(value.GetType() == DBNull.Value.GetType() || // (value = Convert.ChangeType(value, typeWate, null)) != null //) ) { object[] arr = new object[] { tableWhereRecodrType.common, table, col, value, relMath, relBool, getPatternWhere() }; int indx = tableWhere.Rows.Count - 1; for (; indx >= 0; --indx) { DataRow lastRow = tableWhere.Rows[indx]; if (isLineCommon(lastRow) && (getLinePatern(lastRow) == getPatternWhere())) { string targetCol = ToolColumn.getColumnFullName(table, col); string curCol = ToolColumn.getColumnFullName((string)lastRow[TableDUMMY.PARENTNAME], (string)lastRow[TableDUMMY.CHILDNAME]); if (string.Compare(targetCol, curCol) < 0) { continue; } } ++indx; break; } ToolTable.insertRowAt(tableWhere, indx, arr); return; } } } catch (Exception exc) { throw exc; } throw new MyException.MyExceptionInner(MessageCollection.T_MSG_ERROR_INNER); }
public ToolTableEdit() { InitializeComponent(); MinimumSize = new Size(600, 200); Dock = System.Windows.Forms.DockStyle.Fill; Name = "ToolTableEdit"; Size = new System.Drawing.Size(600, 300); TabIndex = 0; localTable = new ToolTable(); frmSelTool = new FormSelectToolNum(); changedGridStyle = new DataGridViewCellStyle(); changedGridStyle.BackColor = Color.Yellow; changedGridStyle.ForeColor = Color.Black; stdGridStyle = dataGridTools.DefaultCellStyle; errorGridStyle = new DataGridViewCellStyle(); errorGridStyle.BackColor = Color.LightPink; UpdateColors(); }
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_); }
public DataSet get() { // _result.Clear(); for (int i = 0; i < _sqlQueryes.Length; ++i) { IPagedSource source = new ImplPagedSource( _environment, new ImplSqlBuilder(_environment, _sqlQueryes[i], (_aliases.Length > i ? _aliases[i] : string.Empty))); foreach (IFilter filter in _filters) { filter.applyToBuilder(source.getBuilder()); } _result.Tables.Add(source.getAll()); } foreach (DataTable tab in _result.Tables) { ToolTable.fillNull(tab); } return(_result.Copy()); }
partial void InsertToolTable(ToolTable instance);
public virtual void loadFilterStruct() { try { getGrid().beginDataLoad(); if (!HasFilter) { getFilterTreePanel().Visible = false; getFilterGridPanel().Visible = false; } else { getFilterTreePanel().Visible = false; List <MobDataGrid> list = new List <MobDataGrid>(); { if (FilterCols.Length > 0) { list.Add(getFilterGrid1()); } if (FilterCols.Length > 1) { list.Add(getFilterGrid2()); } else { getFilterGrid2().Visible = false; } } filterWrap = new ImplFilterWrapGrid(list.ToArray()); //filterWrap = new ImplFilterWrapTree(getFilterTree()); filterWrap.FilterChanged += filterWrap_FilterChanged; //getFilter().NodeClick += MobDataReferenceGridFormBase_NodeClick; string stateNameFilterTree = globalStoreName() + "/filtertree"; object[][] tree_ = environment.getStateData(stateNameFilterTree) as object[][]; if (tree_ == null) { string name_ = getDsName(); ITableDescriptor td_ = environment.getDbDescriptor().getTable(name_); if (td_ == null) { throw new MyExceptionError("Cant find table [" + name_ + "] descriptor"); } string tabFullName_ = td_.getNameFull(); string sql_ = string.Format("SELECT DISTINCT {0} FROM {1}", ToolString.joinList(FilterCols), tabFullName_); DataTable tab_ = SqlExecute.execute(environment, sql_, null); tree_ = ToolTable.getGroups(tab_, FilterCols); } filterWrap.fill(tree_); // getFilter().fillTree(tree_); environment.setStateData(stateNameFilterTree, tree_); } } catch (Exception exc) { ToolMobile.setException(exc); } finally { getGrid().endDataLoad(); } }
partial void DeleteToolTable(ToolTable instance);
partial void UpdateToolTable(ToolTable instance);
public void Setup() { _toolTable = new ToolTable(); }
private void detach_ToolTables(ToolTable entity) { this.SendPropertyChanging(); entity.CategoryTable = null; }