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;
}
