protected void dsCurComment_Selecting(object sender, Microsoft.AspNet.EntityDataSource.EntityDataSourceSelectingEventArgs e) { if (Assignment != null) { e.DataSource.Where = String.Format("it.WFAssignId = {0}", Assignment.WFAssignId); } }
protected void dsLoc_Selecting(object sender, Microsoft.AspNet.EntityDataSource.EntityDataSourceSelectingEventArgs e) { eCAR3Entities pContext = new eCAR3Entities(); // We need constants for these! List <String> pLocs = LocTreeCache.GetCreateLocsForUser(User.UserId, 0x0002); if (pLocs == null) { return; } StringBuilder sb = new StringBuilder(); int i = 0; // This works to get all of them foreach (string pLoc in pLocs) { if (i > 0) { sb.Append(","); } sb.Append("'" + pLoc + "'"); i++; } e.DataSource.Where = string.Format("it.RowKey in {{{0}}}", sb.ToString()); }
protected void GridDetailDataSource_Selecting(object sender, Microsoft.AspNet.EntityDataSource.EntityDataSourceSelectingEventArgs e) { GridDataItem parentItem = ((GridNestedViewItem)e.DataSource.NamingContainer).ParentItem; int hierarchyIndex = parentItem != null ? parentItem.ItemIndex : -1; if (hierarchyIndex == -1) { e.Cancel = true; return; } MetaTable masterMetaTable = GridDataSource.GetTable(); MetaTable detailMetaTable = e.DataSource.GetTable(); StringBuilder sb = new StringBuilder(); sb.Append(Helpers.PersianSearchDataSourceHelpers.GetValidUniCodeQuery(e.DataSource.Where)); if (masterMetaTable.ForeignKeyColumnsNames != string.Empty) { //Many to One relation foreach (MetaColumn column in detailMetaTable.PrimaryKeyColumns) { foreach (string name in masterMetaTable.ForeignKeyColumnsNames.Split(',')) { string columnName = ((MetaForeignKeyColumn)masterMetaTable.GetColumn(name)).ForeignKeyNames.Where(n => n == name + "." + column.Name).FirstOrDefault(); GridTableView ownerTableView = ((GridNestedViewItem)e.DataSource.NamingContainer).OwnerTableView; if (!ownerTableView.DataKeyNames.Contains(columnName)) { continue; } if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat("it.{0} = '{1}'", column.Name, ownerTableView.DataKeyValues[hierarchyIndex][columnName]); //break; } } } //else //{ //One to Many relation foreach (MetaColumn col in detailMetaTable.Columns) { if (col is MetaForeignKeyColumn) { MetaForeignKeyColumn column = (MetaForeignKeyColumn)col; if (column.ParentTable.Name == masterMetaTable.Name) { int primarykeyindex = 0; // in relations witch has mor than one foreign key column foreach (string name in column.ForeignKeyNames) //maybe { GridTableView ownerTableView = ((GridNestedViewItem)e.DataSource.NamingContainer).OwnerTableView; string columnName = name;//.Split('.')[1]; //if (!ownerTableView.DataKeyNames.Contains(columnName)) //maybe spel of foreignkey in child table does not equla to primary key in parrent table // continue; switch (masterMetaTable.PrimaryKeyColumns[primarykeyindex].ColumnType.Name) { case "Int16": case "Int32": case "Int64": if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat("it.{0} = {1}", name, ownerTableView.DataKeyValues[hierarchyIndex][masterMetaTable.PrimaryKeyColumns[primarykeyindex].Name]); //its depond on our chance witch is the orders of foeign key and parimary in master table should be equal break; default: if (sb.Length > 0) { sb.Append(" AND "); } sb.AppendFormat("it.{0} = '{1}'", name, ownerTableView.DataKeyValues[hierarchyIndex][masterMetaTable.PrimaryKeyColumns[primarykeyindex].Name]); //its depond on our chance witch is the orders of foeign key and parimary in master table should be equal break; } primarykeyindex++; //break; } break; } } } //} e.DataSource.Where = sb.ToString(); }
protected void GridDataSource_Selecting(object sender, Microsoft.AspNet.EntityDataSource.EntityDataSourceSelectingEventArgs e) { e.DataSource.Where = Helpers.PersianSearchDataSourceHelpers.GetValidUniCodeQuery(e.DataSource.Where); }
protected void paymankarDatasource_Selecting(object sender, Microsoft.AspNet.EntityDataSource.EntityDataSourceSelectingEventArgs e) { }