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(); } }
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(); }
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"; }