protected void grdPlaneacionIncrementos_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
grdPlaneacionIncrementos.DataSource = vObtienePlaneacionIncrementos;
decimal sumSueldoOriginal = vObtienePlaneacionIncrementos.Sum(s => s.MN_SUELDO_ORIGINAL) ?? 0;
txtNominaActual.Text = String.Format("{0:C}", sumSueldoOriginal);
decimal sumNominaPlaneada = vObtienePlaneacionIncrementos.Sum(s => s.MN_SUELDO_NUEVO) ?? 0;
txtNominaPlaneada.Text = String.Format("{0:C}", sumNominaPlaneada);
decimal vDiferencia = (sumNominaPlaneada - sumSueldoOriginal);
txtDiferencia.Text = String.Format("{0:C}", vDiferencia);
if (txtDiferencia != null && sumSueldoOriginal != 0)
{
txtDiferenciaPr.Text = String.Format("{0:N2}", (vDiferencia / sumSueldoOriginal) * 100);
}
//DataTable PlaneacionIncrementos = CrearDataTable(vObtienePlaneacionIncrementos, grdPlaneacionIncrementos);
//grdPlaneacionIncrementos.DataSource = PlaneacionIncrementos;
GridGroupByField field = new GridGroupByField();
field.FieldName = "NO_NIVEL";
field.HeaderText = "Nivel";
field.HeaderText = "<strong>Nivel</strong>";
field.FormatString = "<strong>{0}</strong>";
GridGroupByExpression ex = new GridGroupByExpression();
ex.GroupByFields.Add(field);
ex.SelectFields.Add(field);
grdPlaneacionIncrementos.MasterTableView.GroupByExpressions.Add(ex);
}
protected void grdMercadoSalarial_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
TabuladoresNegocio nTabuladores = new TabuladoresNegocio();
vObtieneTabuladorPuesto = nTabuladores.ObtienePuestosTabulador(ID_TABULADOR: vIdTabulador).Select(s => new E_TABULADOR_PUESTO
{
NO_RENGLON = (int)s.NO_RENGLON,
ID_TABULADOR_PUESTO = s.ID_TABULADOR_PUESTO,
ID_PUESTO = s.ID_PUESTO,
MN_MINIMO = s.MN_MINIMO,
MN_MAXIMO = s.MN_MAXIMO,
NB_DEPARTAMENTO = s.NB_DEPARTAMENTO,
NB_PUESTO = s.NB_PUESTO,
NO_NIVEL = s.NO_NIVEL,
CL_ORIGEN = s.CL_ORIGEN
}).ToList();
grdMercadoSalarial.DataSource = vObtieneTabuladorPuesto;
GridGroupByField field = new GridGroupByField();
field.FieldName = "NO_NIVEL";
field.HeaderText = "Nivel";
field.HeaderText = "<strong>Nivel</strong>";
field.FormatString = "<strong>{0}</strong>";
GridGroupByExpression ex = new GridGroupByExpression();
ex.GroupByFields.Add(field);
ex.SelectFields.Add(field);
grdMercadoSalarial.MasterTableView.GroupByExpressions.Add(ex);
}
private static GridGroupByExpression AddGroupByExpression(string headerText, string column, string formatString)
{
var expression = new GridGroupByExpression();
//
// Select Field
//
var gridSelectByField = new GridGroupByField
{
FieldName = column,
HeaderText = headerText,
FormatString = formatString
};
expression.SelectFields.Add(gridSelectByField);
//
// Group Field
//
var gridGroupByField = new GridGroupByField();
gridGroupByField.FieldName = column;
expression.GroupByFields.Add(gridGroupByField);
return(expression);
}
protected override string GetDisplayText(object value)
{
GridGroupByField field = (GridGroupByField)value;
string retVal = field.FieldName;
if (String.IsNullOrEmpty(retVal))
{
retVal = field.FieldName;
}
return(base.GetDisplayText(retVal));
}
protected void rgResultados_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
EventoCapacitacionNegocio neg = new EventoCapacitacionNegocio();
rgResultados.DataSource = neg.ObtieneEventoParticipanteCompetencia(ID_EVENTO: vIdEvento, ID_EMPRESA: vIdEmpresa, pID_ROL: vIdRol);
GridGroupByField field = new GridGroupByField();
field.FieldName = "ID_PARTICIPANTE";
//field.FieldName ="NB_PARTICIPANTE";
//field.HeaderText = "";
//field.FormatString = "{0}";
GridGroupByExpression ex = new GridGroupByExpression();
ex.GroupByFields.Add(field);
ex.SelectFields.Add(field);
rgResultados.MasterTableView.GroupByExpressions.Add(ex);
}
private void SetGroupByExpression()
{
if (!string.IsNullOrEmpty(GroupByExpressionField))
{
GridGroupByExpression expression = new GridGroupByExpression();
GridGroupByField gridGroupByField;
string[] split = GroupByExpressionField.Split(',');
foreach (string sp in split)
{
gridGroupByField = new GridGroupByField();
gridGroupByField.FieldName = sp;
expression.SelectFields.Add(gridGroupByField);
gridGroupByField = new GridGroupByField();
gridGroupByField.FieldName = sp;
expression.GroupByFields.Add(gridGroupByField);
}
grdZirProjeData.MasterTableView.GroupByExpressions.Add(expression);;
}
}
private static GridGroupByExpression AddGroupByExpression(string headerText, string column, string formatString)
{
var expression = new GridGroupByExpression();
//
// Select Field
//
var gridSelectByField = new GridGroupByField
{
FieldName = column,
HeaderText = headerText,
FormatString = formatString
};
expression.SelectFields.Add(gridSelectByField);
//
// Group Field
//
var gridGroupByField = new GridGroupByField();
gridGroupByField.FieldName = column;
expression.GroupByFields.Add(gridGroupByField);
return expression;
}
/// <summary>
/// Event fuer die Checkbox die alle Standorte anzeigt
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void AllLocationsCheckBox_Changed(object sender, EventArgs e)
{
//AddAdressButton.Enabled = true;
if(AllLocationsCheckBox.Checked == true)
{
StandortDropDown.Enabled = false;
GridGroupByExpression expression1 = GridGroupByExpression.Parse("Group By Location");
GridGroupByField existing = expression1.SelectFields.FindByName("Location");
if (existing == null) //field is not present
{
//Construct and add a new aggregate field
GridGroupByField field = new GridGroupByField();
field.FieldName = "Location";
//field.FieldAlias = "SubTotal";
//field.Aggregate = GridAggregateFunction.Sum;
field.FormatString = "{0:C}";
expression1.SelectFields.Add(field);
}
else //field is present then set a format string
{
existing.FormatString = "{0:C}";
}
this.RadGridAbrechnung.MasterTableView.GroupByExpressions.Add(expression1);
RadGridAbrechnung.Rebind();
}
else
{
StandortDropDown.Enabled = true;
StandortDropDown.DataBind();
this.RadGridAbrechnung.MasterTableView.GroupByExpressions.Clear();
this.RadGridAbrechnung.Rebind();
}
}
public override StandardValuesCollection GetStandardValues(ITypeDescriptorContext context)
{
//the actual list of standard items to return
StandardValuesCollection list = null;
if (context.Instance is Picker)
{
Picker picker = (Picker)context.Instance;
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name == picker.DataCommand
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
if (context.Instance is ScreenPageTemplate)
{
ScreenPageTemplate pageTemplate = (ScreenPageTemplate)context.Instance;
if (!String.IsNullOrEmpty(pageTemplate.DataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name == pageTemplate.DataCommand
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is Grid)
{
Grid grid = (Grid)context.Instance;
if (!String.IsNullOrEmpty(grid.SelectDataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name == grid.SelectDataCommand
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is GridColumn)
{
GridColumn col = (GridColumn)context.Instance;
if (!String.IsNullOrEmpty(col.Parent.SelectDataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name == col.Parent.SelectDataCommand
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is GridGroupByField)
{
GridGroupByField groupByField = (GridGroupByField)context.Instance;
if ((groupByField.Expression != null) && (groupByField.Expression.Grid != null))
{
if (!String.IsNullOrEmpty(groupByField.Expression.Grid.SelectDataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name == groupByField.Expression.Grid.SelectDataCommand
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
}
if (context.Instance is Widget)
{
//if propery is DataField
if (context.PropertyDescriptor.Name.ToLower() == "datafield")
{
list = GetDataFieldColumns(context, list);
}
else
{
if (context.Instance is DropDownListControl)
{
DropDownListControl control = (DropDownListControl)context.Instance;
if (!String.IsNullOrEmpty(control.SelectDataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name.ToLower() == control.SelectDataCommand.ToLower()
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is ListBoxControl)
{
ListBoxControl control = (ListBoxControl)context.Instance;
if (!String.IsNullOrEmpty(control.SelectDataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name.ToLower() == control.SelectDataCommand.ToLower()
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is TreeViewControl)
{
TreeViewControl control = (TreeViewControl)context.Instance;
if (!String.IsNullOrEmpty(control.SelectDataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name.ToLower() == control.SelectDataCommand.ToLower()
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
}
}
if (context.Instance is DataCommandValidator)
{
DataCommandValidator validator = (DataCommandValidator)context.Instance;
if (!String.IsNullOrEmpty(validator.DataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name.ToLower() == validator.DataCommand.ToLower()
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is WorkflowDynamicSecurityGroup)
{
WorkflowDynamicSecurityGroup dynamicGroup = (WorkflowDynamicSecurityGroup)context.Instance;
if (!String.IsNullOrEmpty(dynamicGroup.DataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name.ToLower() == dynamicGroup.DataCommand.ToLower()
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is EmailWorkflowAction)
{
EmailWorkflowAction emailAction = (EmailWorkflowAction)context.Instance;
string dataCommandName = null;
switch (context.PropertyDescriptor.Name.ToLower())
{
case "attachmentdocumentidfield":
case "attachmenttoaddressfield":
dataCommandName = emailAction.AttachmentDataCommand;
break;
case "bccaddressdisplaynamefield":
case "bccaddressfield":
case "bcctoaddressfield":
dataCommandName = emailAction.BCCAddressDataCommand;
break;
case "ccaddressdisplaynamefield":
case "ccaddressfield":
case "cctoaddressfield":
dataCommandName = emailAction.CCAddressDataCommand;
break;
case "contenttemplatefield":
dataCommandName = emailAction.ContentTemplateDataCommand;
break;
case "fromaddressdisplaynamefield":
case "fromaddressfield":
case "fromtoaddressfield":
dataCommandName = emailAction.FromAddressDataCommand;
break;
case "subjectfield":
case "subjecttoaddressfield":
dataCommandName = emailAction.SubjectDataCommand;
break;
case "toaddressdisplaynamefield":
case "toaddressfield":
dataCommandName = emailAction.ToAddressDataCommand;
break;
}
if (!String.IsNullOrEmpty(dataCommandName))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name.ToLower() == dataCommandName.ToLower()
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is WorkflowContentDataItem)
{
WorkflowContentDataItem emailDataItem = (WorkflowContentDataItem)context.Instance;
if (!String.IsNullOrEmpty(emailDataItem.DataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name.ToLower() == emailDataItem.DataCommand.ToLower()
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is ContentDataItem)
{
ContentDataItem contentDataItem = (ContentDataItem)context.Instance;
if (!String.IsNullOrEmpty(contentDataItem.DataCommand))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name.ToLower() == contentDataItem.DataCommand.ToLower()
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
if (context.Instance is SMSWorkflowAction)
{
SMSWorkflowAction smsAction = (SMSWorkflowAction)context.Instance;
string dataCommandName = null;
switch (context.PropertyDescriptor.Name.ToLower().Substring(0, 2))
{
case "co": //content
dataCommandName = smsAction.ContentTemplateDataCommand;
break;
case "ph": //phone
dataCommandName = smsAction.PhoneDataCommand;
break;
}
if (!String.IsNullOrEmpty(dataCommandName))
{
var retVal = from item in Configuration.GetInstance().DataCommands
from column in item.Columns
where item.Name.ToLower() == dataCommandName.ToLower()
select column.Name;
var tempList = retVal.ToList <String>();
tempList.Insert(0, String.Empty);
string[] items = tempList.ToArray <string>();
list = new StandardValuesCollection(items);
}
}
return(list);
}
protected void Page_Load(object sender, System.EventArgs e)
{
RadGrid RadGrid1 = new RadGrid();
this.SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["RmsPM.Data.ConnectionString"].ConnectionString.ToString();
this.SqlDataSource2.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["RmsPM.Data.ConnectionString"].ConnectionString.ToString();
//Add the RadGrid instance to the controls
this.PlaceHolder1.Controls.Add(RadGrid1);
if (!IsPostBack)
{
RadGrid1.Skin = "Default";
RadGrid1.DataSourceID = "SqlDataSource1";
//RadGrid1.DataSource = DataSourse().Tables[0];
RadGrid1.MasterTableView.DataKeyNames = new string[] { "groupcode" };
RadGrid1.Width = Unit.Percentage(100);
RadGrid1.PageSize = 5;
RadGrid1.AllowPaging = true;
RadGrid1.AutoGenerateColumns = false;
//Set options to enable Group-by
RadGrid1.GroupingEnabled = true;
//RadGrid1.ShowGroupPanel = true;
// RadGrid1.ClientSettings.AllowDragToGroup = false;
RadGrid1.ClientSettings.AllowColumnsReorder = true;
//Add Customers table
RadGrid1.MasterTableView.PageSize = 15;
GridBoundColumn boundColumn;
//boundColumn = new GridBoundColumn();
//RadGrid1.MasterTableView.Columns.Add(boundColumn);
//boundColumn.DataField = "GroupCode";
//boundColumn.HeaderText = "类别编号";
boundColumn = new GridBoundColumn();
RadGrid1.MasterTableView.Columns.Add(boundColumn);
boundColumn.DataField = "GroupName";
boundColumn.HeaderText = "类别名称";
//Add Orders table
GridTableView tableViewOrders = new GridTableView(RadGrid1);
RadGrid1.MasterTableView.DetailTables.Add(tableViewOrders);
tableViewOrders.DataSourceID = "SqlDataSource2";
//tableViewOrders.DataSource = DataSourse().Tables[1];
tableViewOrders.DataKeyNames = new string[] { "ProcedureCode" };
GridRelationFields relationFields = new GridRelationFields();
tableViewOrders.ParentTableRelation.Add(relationFields);
relationFields.MasterKeyField = "groupcode";
relationFields.DetailKeyField = "SysType";
//Add a group-by expression as string into Customer's collection
//RadGrid1.MasterTableView.GroupByExpressions.Add(new GridGroupByExpression("GroupName Group By GroupName"));
//Add a group-by expression by defining fields into Orders' collection
GridGroupByExpression expression = new GridGroupByExpression();
GridGroupByField gridGroupByField = new GridGroupByField();
//Add select fileds (before the "Group By" clause)
//gridGroupByField = new GridGroupByField();
//gridGroupByField.FieldName = "ProcedureCode";
//gridGroupByField.FormatString = "ProcedureCode: {0}";
//expression.SelectFields.Add(gridGroupByField);
//gridGroupByField = new GridGroupByField();
//gridGroupByField.FieldName = "ProcedureName";
//gridGroupByField.FormatString = "Total shipping cost is <strong>{0}</strong>";
////gridGroupByField.Aggregate = GridAggregateFunction.Sum;
//expression.SelectFields.Add(gridGroupByField);
////Add a filed for group-by (after the "Group By" clause)
//gridGroupByField = new GridGroupByField();
//gridGroupByField.FieldName = "ProcedureCode";
//expression.GroupByFields.Add(gridGroupByField);
////This expression as string would look like:
//// "RequiredDate, Freight Group By RequiredDate"
////but the display format of filed values wolld be different
//tableViewOrders.GroupByExpressions.Add(expression);
boundColumn = new GridBoundColumn();
tableViewOrders.Columns.Add(boundColumn);
boundColumn.DataField = "ProcedureCode";
boundColumn.HeaderText = "流程编号";
boundColumn = new GridBoundColumn();
GridHyperLinkColumn ghlk = new GridHyperLinkColumn();
tableViewOrders.Columns.Add(ghlk);
string[] urlField = new string[2];
urlField[0] = "Applicationpath";
urlField[1] = "ProcedureCode";
ghlk.DataNavigateUrlFields = urlField;
ghlk.HeaderText = "流程名称";
// ghlk
ghlk.DataNavigateUrlFormatString = "javascript:modifyProcedure('{0}','{1}','','');";
ghlk.DataTextField = "ProcedureName";
}
}
public GridGroupHeaderItem(GridGroupByField field, GridViewDataColumn column)
{
this.field = field;
this.column = column;
}
