예제 #1
0
        private void setCondition()
        {
            //绑定表数据
            List <StationSubEntity> allEntity = StationSubFactory.GetAll();

            List <string> plines = new List <string>();

            foreach (var p in allEntity)
            {
                if ((!plines.Contains(p.PLINE_CODE)) && (!string.IsNullOrWhiteSpace(p.PLINE_CODE)))
                {
                    plines.Add(p.PLINE_CODE);
                }
            }

            ASPxGridView1.DataSource = allEntity;
            GridViewDataComboBoxColumn colPline      = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn;
            List <ProductLineEntity>   plineEntities = ProductLineFactory.GetByIDs(plines.ToArray());

            colPline.PropertiesComboBox.DataSource = plineEntities;
            colPline.PropertiesComboBox.ValueField = "RMES_ID";
            colPline.PropertiesComboBox.TextField  = "PLINE_NAME";

            ASPxGridView1.DataBind();
        }
예제 #2
0
    protected void WorkUnit_DataBinding(object sender, EventArgs e)
    {
        ASPxComboBox workUnit = sender as ASPxComboBox;
        DataTable    dt       = new DataTable();

        dt.Columns.Add("DISPLAY");
        dt.Columns.Add("VALUE");

        userManager              theUserManager = (userManager)Session["theUserManager"];
        List <LocationEntity>    locations      = LocationFactory.GetAll();
        List <ProductLineEntity> PLines         = ProductLineFactory.GetAll();

        foreach (ProductLineEntity p in PLines)
        {
            dt.Rows.Add(p.PLINE_NAME, p.RMES_ID);
        }
        foreach (LocationEntity l in locations)
        {
            dt.Rows.Add(l.LOCATION_NAME, l.RMES_ID);
        }
        workUnit.DataSource = dt;
        workUnit.ValueField = "VALUE";
        workUnit.TextField  = "DISPLAY";
        //workUnit.DataBind();
    }
예제 #3
0
        protected void ComboBoxPline_DataBinding(object sender, EventArgs e)
        {
            ASPxComboBox             colPline      = sender as ASPxComboBox;
            List <ProductLineEntity> plineEntities = ProductLineFactory.GetAll();

            colPline.DataSource = plineEntities;
            colPline.ValueField = "RMES_ID";
            colPline.TextField  = "PLINE_NAME";
        }
예제 #4
0
    private void setCondition()
    {
        //绑定表数据
        userManager theUserManager = (userManager)Session["theUserManager"];

        theCompanyCode = theUserManager.getCompanyCode();
        string theUserId = theUserManager.getUserId();

        List <LineSideStockEntity> dataSource = LineSideStockFactory.GetAll();

        if (!plineCode.SelectedItem.Value.ToString().Equals("All"))
        {
            dataSource = (from s in dataSource where s.PLINE_CODE == (plineCode.SelectedItem.Value.ToString()) select s).ToList <LineSideStockEntity>();
        }
        if (storeCode.SelectedItem != null && !storeCode.SelectedItem.Value.ToString().Equals("All"))
        {
            dataSource = (from s in dataSource where s.STORE_CODE == (storeCode.SelectedItem.Value.ToString()) select s).ToList <LineSideStockEntity>();
        }


        ASPxGridView1.DataSource = dataSource;

        GridViewDataComboBoxColumn comFactory = ASPxGridView1.Columns["FACTORY_CODE"] as GridViewDataComboBoxColumn;
        DataTable dt_factory = new DataTable();

        dt_factory.Columns.Add("text");
        dt_factory.Columns.Add("value");
        dt_factory.Rows.Add("园区", "8101");
        dt_factory.Rows.Add("基地", "8102");
        comFactory.PropertiesComboBox.TextField  = "text";
        comFactory.PropertiesComboBox.ValueField = "value";

        GridViewDataComboBoxColumn comStore = ASPxGridView1.Columns["STORE_CODE"] as GridViewDataComboBoxColumn;
        List <LineSideStoreEntity> stores   = LinesideStoreFactory.GetAll();

        comStore.PropertiesComboBox.DataSource = stores;
        comStore.PropertiesComboBox.TextField  = "STORE_NAME";
        comStore.PropertiesComboBox.ValueField = "STORE_CODE";

        GridViewDataComboBoxColumn comPline = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn;
        List <ProductLineEntity>   plines   = ProductLineFactory.GetAll();

        comPline.PropertiesComboBox.DataSource = plines;
        comPline.PropertiesComboBox.TextField  = "PLINE_NAME";
        comPline.PropertiesComboBox.ValueField = "RMES_ID";


        GridViewDataComboBoxColumn comLocation = ASPxGridView1.Columns["LOCATION_CODE"] as GridViewDataComboBoxColumn;

        ASPxGridView1.DataBind();
    }
예제 #5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         cdate1.Value = DateTime.Today.AddDays(-3);
         cdate2.Value = DateTime.Today.AddDays(1);
         List <ProductLineEntity> plines = ProductLineFactory.GetAll();
         foreach (var p in plines)
         {
             ComPline.Items.Add(p.PLINE_NAME, p.RMES_ID);
         }
     }
     BindData();
 }
예제 #6
0
    private void setCondition()
    {
        List <ProcessEntity> allEntity = ProcessFactory.GetAll();

        ASPxGridView1.DataSource = allEntity;

        DataTable dt = new DataTable();

        dt.Columns.Add("DISPLAY");
        dt.Columns.Add("VALUE");

        List <LocationEntity>    locations = LocationFactory.GetAll();
        List <ProductLineEntity> PLines    = ProductLineFactory.GetAll();

        foreach (ProductLineEntity p in PLines)
        {
            dt.Rows.Add(p.PLINE_NAME, p.RMES_ID);
        }
        foreach (LocationEntity l in locations)
        {
            dt.Rows.Add(l.LOCATION_NAME, l.RMES_ID);
        }

        GridViewDataComboBoxColumn col = ASPxGridView1.Columns["WORKUNIT_CODE"] as GridViewDataComboBoxColumn;

        col.PropertiesComboBox.DataSource = dt;
        col.PropertiesComboBox.ValueField = "VALUE";
        col.PropertiesComboBox.TextField  = "DISPLAY";

        DataTable dt1 = new DataTable();

        dt1.Columns.Add("DISPLAY");
        dt1.Columns.Add("WORKSHOP_CODE");
        dt1.Rows.Add("园区", "8101");
        dt1.Rows.Add("基地", "8102");


        GridViewDataComboBoxColumn com = ASPxGridView1.Columns["WORKSHOP_CODE"] as GridViewDataComboBoxColumn;

        com.PropertiesComboBox.DataSource = dt1;
        com.PropertiesComboBox.ValueField = "WORKSHOP_CODE";
        com.PropertiesComboBox.TextField  = "DISPLAY";

        ASPxGridView1.DataBind();
    }
예제 #7
0
        protected void Page_Load(object sender, EventArgs e)
        {
            userManager theUserManager = (userManager)Session["theUserManager"];

            theCompanyCode = theUserManager.getCompanyCode();
            theUserId      = theUserManager.getUserId();
            theProgramCode = "ssd1200";
            if (!IsPostBack)
            {
                ASPxDateEdit1.Date = DateTime.Now;
                ASPxDateEdit2.Date = DateTime.Now;
                List <ProductLineEntity> user_plines = ProductLineFactory.GetByUserID(theUserManager.getUserId(), theProgramCode);
                ASPxComboBoxPline.DataSource = user_plines;
                ASPxComboBoxPline.TextField  = "PLINE_NAME";
                ASPxComboBoxPline.ValueField = "PLINE_CODE";
                ASPxComboBoxPline.DataBind();
            }

            setCondition();
        }
예제 #8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        userManager theUserManager = (userManager)Session["theUserManager"];

        theCompanyCode = theUserManager.getCompanyCode();

        if (!IsPostBack)
        {
            List <ProductLineEntity>   plineEntities = ProductLineFactory.GetAll();
            List <LineSideStoreEntity> stores        = LinesideStoreFactory.GetAll();

            foreach (var s in stores)
            {
                storeCode.Items.Add(s.STORE_NAME, s.STORE_CODE);
            }

            foreach (var p in plineEntities)
            {
                plineCode.Items.Add(p.PLINE_NAME, p.PLINE_CODE);
            }
        }

        setCondition();
    }