protected void objectDataSource_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
        {
            e.InputParameters["totalCount"] = LastQueryRowCount;

            if (e.ExecutingSelectCount == false)
            {
                string where = e.InputParameters["where"] as string;

                if (MostSupervisor == false || NormalSupervisior == false)
                {
                    //检查是否具有分类授权
                    WfApplicationAuthCollection authInfo = WfApplicationAuthAdapter.Instance.GetUserApplicationAuthInfo(DeluxeIdentity.Current.User);
                    var builder = authInfo.GetApplicationAndProgramBuilder("APPLICATION_NAME", "PROGRAM_NAME");
                    if (builder.IsEmpty == false)
                    {
                        if (string.IsNullOrEmpty(where) == false)
                            where += " AND ";

                        where += "(" + builder.ToSqlString(TSqlBuilder.Instance) + ")";

                        e.InputParameters["where"] = where;
                    }
                    else
                    {
                        e.Cancel = true; //没有定义任何权限，不能查询
                    }
                }
            }
        }

 protected void dsMain_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (e.ExecutingSelectCount == false)
     {
         e.InputParameters["where"] = BuildWhereCondition();
     }
 }

 protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (!IsPostBack)
     {
         e.Cancel = true;
     }
 }

 protected void odsItems_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     e.InputParameters["langCode"] = this.CurrentLanguage;
     e.InputParameters["pageID"] = this.PageID;
     e.InputParameters["count"] = this.NewsCount;
     e.InputParameters["skipMain"] = this.SkipMain;
 }

 protected void dsDinamicaCriptografia_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (drlMensaje.SelectedValue == "-1" || drlGrupoMensaje.SelectedValue == "-1")
     {
         e.Cancel = true;
     }
 }

		protected void dataSourceMain_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
		{
			WhereSqlClauseBuilder where = new WhereSqlClauseBuilder();
			where.AppendItem("TASK_GUID", Request.QueryString["id"]);

			dataSourceMain.Condition = where;
		}

 protected void ObjectDataSourceUnreadComments_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (UserContext.Current != null)
     {
         e.InputParameters["DepartmentGuid"] = UserContext.Current.SelectedInstance.InstanceId;
     }
 }

        protected void dsBooks_Selecting( object sender, ObjectDataSourceSelectingEventArgs e )
        {
            e.InputParameters[ "fromYear" ] = Convert.ToInt32( tbxFromPublishingYear.Text );

            if( string.IsNullOrEmpty( tbxToPublishingYear.Text ) )
                e.InputParameters[ "toYear" ] = DateTime.Now.Year;
            else
                e.InputParameters[ "toYear" ] = Convert.ToInt32( tbxToPublishingYear.Text );

            List<int> selectedThemes = new List<int>();
            foreach( ListItem item in cblThemes.Items )
            {
                if( item.Selected )
                    selectedThemes.Add( Convert.ToInt32( item.Value ) );
            }

            e.InputParameters[ "themes" ] = selectedThemes.ToArray();

            if( rblLanguages.SelectedIndex == 0 )
                e.InputParameters[ "language" ] = null;
            else
                e.InputParameters[ "language" ] = rblLanguages.SelectedValue;

            if( ddlOffices.SelectedIndex == 0 )
                e.InputParameters[ "officeID" ] = -1;
            else
                e.InputParameters[ "officeID" ] = Convert.ToInt32( ddlOffices.SelectedValue );
        }

 protected void ObjectDataSourceDoNotEmailList_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (UserContext.Current != null)
     {
         e.InputParameters["InstanceId"] = UserContext.Current.SelectedInstance.InstanceId;
     }
 }

        protected void ObjSolicitudesT_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
        {
            classFiltro f = new classFiltro();
            f.VIG_SOL = Convert.ToInt16(Request.Cookies["sircc_vig"].Value);

            if (chkDepDel.Checked)
            {
                f.DEP_PSOL = CboDepDel.SelectedValue;
            }

            if (chkObj.Checked)
            {
                f.OBJ_SOL = txtObj.Text.ToUpper();
            }

            if (chkFecha.Checked) {
                f.TIPO_FECHA =(classFiltro.TipoFecha)cboTipoFecha.SelectedIndex;
                f.FECHA_I = Convert.ToDateTime(txtFechaIni.Text);
                f.FECHA_F = Convert.ToDateTime(txtFechaFin.Text);
            }
            if (chkFuncionario.Checked) {
                f.ID_ABOG_ENC = CboEncargados.SelectedValue;
            }
            if (chkCodSol.Checked) {
                f.COD_SOL = TxtCodSol.Text;
            }

            e.InputParameters["Filtro"] = f;
        }

 protected void ObjectDataSourceProduct_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (!e.ExecutingSelectCount)
     {
         e.Arguments.StartRowIndex = this.AspNetPager1.StartRecordIndex;
         e.Arguments.MaximumRows = this.AspNetPager1.PageSize;
     }
 }

 protected void odsConsumation_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (Request.QueryString["Id"] != null)
     {
         //Set the input parameter Id of the GetItemById method to the Id in the query string
         e.InputParameters["Id"] = Request.QueryString["Id"];
     }
 }

 protected void ObjectDataSourceRequest_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (UserContext.Current != null)
     {
         e.InputParameters["DepartmentGuid"] = UserContext.Current.SelectedInstance.InstanceId;
         e.InputParameters["Type"] = ArticleType.Request.ToString();
     }
 }

 protected void MailLogDataSource_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (!IsAdmin)
     {
         Miami.Substitute.Dal.User user = new Miami.Substitute.Dal.User();
         DataView dv = user.LoadForMain(Micajah.Common.Security.UserContext.Current.UserId);
         e.InputParameters["LocationId"] = dv[0]["LocationId"];
     }
 }

 protected void odsCities_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     int region = (int)e.InputParameters["regionID"];
     if (region == 0)
     {
         e.Cancel = true;
     }
     e.InputParameters["language"] = this.CurrentLanguage;
 }

		protected void dataSourceMain_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
		{
			if (this.IsPostBack == false && this.Request["id"] != null)
			{
				WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
				builder.AppendItem("SynchronizeID", this.Request["id"]);
				this.dataSourceMain.Condition = builder;
			}
		}

 protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     e.InputParameters["userName"] = UserName_tbx.Text;
     //var business = new Bussiness.PlayerBussiness();
     //var player = business.GetUserSingleByNickName(UserName_tbx.Text);
     //if (player == null)
     //{
     //     error_lbl.Text="Username is not exits or not active ,Change to Acive it";
     //}
 }

 protected void dsTransformacion_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (Page.IsPostBack)
     {
         if (refrescarGrilla == false)
         {
             e.Cancel = true;
         }
     }
 }

		protected void dataSourceMain_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
		{
			WhereSqlClauseBuilder builder = ConditionMapping.GetWhereSqlClauseBuilder(this.Condition);

			string cate = Request.QueryString["category"];
			if (string.IsNullOrEmpty(cate) == false)
				builder.AppendItem("CATEGORY", cate);

			this.dataSourceMain.Condition = builder;
		}

 protected void odsCenters_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
 {
     if (regionID == -1)
     {
         e.Cancel = true;
     }
     e.InputParameters["specializationID"] = specializationID;
     e.InputParameters["regionID"] = regionID;
     e.InputParameters["cityID"] = cityID;
     e.InputParameters["language"] = this.CurrentLanguage;
 }