Ejemplo n.º 1
0
    protected void BindData()
    {
        DataFactory dal = new DataFactory();
        DataTable   dt  = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_CallTransfer_SP", new List <IFields>()
        {
            dal.CreateIFields().Append("Option", "GetSys").Append("sys", hidsys.Text)
        }).GetTable();

        if (dt != null && dt.Rows.Count > 0)
        {
            StoreSys.DataSource = dt;
            StoreSys.DataBind();
        }
    }
Ejemplo n.º 2
0
    public void ComboboxBind()
    {
        DataSet dsStat = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Report_SP", new List <IFields>()
        {
            dal.CreateIFields().Append("Option", "StatBind")
        }).GetList();

        StoreStat.DataSource = dsStat;
        StoreStat.DataBind();

        DataSet dsSys = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Report_SP", new List <IFields>()
        {
            dal.CreateIFields().Append("Option", "SysBind")
        }).GetList();

        StoreSys.DataSource = dsSys;
        StoreSys.DataBind();
    }
Ejemplo n.º 3
0
    private void DefaultData()
    {
        DataSet dsStat = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_USER_SP", new List <IFields>()
        {
            dal.CreateIFields()
            .Append("Option", "GetStat")
        }).GetList();

        StoreStat.DataSource = dsStat;
        StoreStat.DataBind();

        DataSet dsGrade = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_USER_SP", new List <IFields>()
        {
            dal.CreateIFields()
            .Append("Option", "GetGrade")
        }).GetList();

        StoreGrade.DataSource = dsGrade;
        StoreGrade.DataBind();

        DataSet dsDept = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_USER_SP", new List <IFields>()
        {
            dal.CreateIFields()
            .Append("Option", "GetDept")
        }).GetList();

        StoreDept.DataSource = dsDept;
        StoreDept.DataBind();

        DataSet dsGroup = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_USER_SP", new List <IFields>()
        {
            dal.CreateIFields()
            .Append("Option", "GetGroup")
        }).GetList();

        StoreSys.DataSource = dsGroup;
        StoreSys.DataBind();

        cmbUserStat.SelectedItem.Value  = "CON/HKG";
        cmbSys.SelectedItem.Value       = "G09";
        cmbUserGrade.SelectedItem.Value = "User";
        cmbUserDept.SelectedItem.Value  = "OP";
    }