Exemple #1
0
        //public delegate DataSet GetDataDelegate();

        //public void BindDDL(GetDataDelegate getMethod, DropDownList ddl)
        //{
        //    DataSet ds = getMethod();
        //    ddl.Items.Add("");
        //    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        //    {
        //        ddl.Items.Add(ds.Tables[0].Rows[i][0].ToString());
        //    }
        //}

        //public void DDLDataBind()
        //{
        //    BindDDL(DAL.FacilityDAL.GetMaching, ddlMaching);
        //    BindDDL(DAL.FacilityDAL.GetBrand, ddlBrand);
        //    BindDDL(DAL.FacilityDAL.GetModel, ddlModel);
        //    BindDDL(DAL.FacilityDAL.GetParameter, ddlParameter);
        //}

        protected void btnQuery_Click(object sender, EventArgs e)
        {
            paras                 = new AllotStocksParameters();
            paras.EventNo         = txtEventNo.Text.Trim();
            paras.StoreNoA        = txtStoreNoA.Text.Trim();
            paras.StoreNoB        = txtStoreNoB.Text.Trim();
            paras.AllotStockDateF = txtAllotStockF.Text.Trim();
            paras.AllotStockDateT = txtAllotStockT.Text.Trim();
            paras.Maching         = ddlMaching.SelectedValue;
            paras.Brand           = ddlBrand.SelectedValue;
            paras.Model           = ddlModel.SelectedValue;
            paras.Parameter       = ddlParameter.SelectedValue;
            paras.SerialNo        = txtSerialNo.Text.Trim();
            paras.AllotStockState = ddlAllotState.SelectedValue;
            paras.Operator        = txtOperator.Text.Trim();

            DataSet ds        = DAL.AllotStocksDAL.GetAllotStocksTotal(paras.EventNo, paras.StoreNoA, paras.StoreNoB, paras.Maching, paras.Brand, paras.Model, paras.SerialNo, paras.Parameter, paras.AllotStockDateF, paras.AllotStockDateT, paras.Operator, paras.AllotStockState);
            int     rowsCount = ds.Tables[0].Rows.Count;

            if (rowsCount > pageSize)
            {
                totalPage = (int)Math.Ceiling((double)rowsCount / (double)pageSize);
            }
            else
            {
                totalPage = 1;
            }

            GVDataBind(1);
        }
Exemple #2
0
        //public delegate DataSet GetDataDelegate();
        //public void BindDDL(GetDataDelegate getMethod, DropDownList ddl)
        //{
        //    DataSet ds = getMethod();
        //    ddl.Items.Add("");
        //    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        //    {
        //        ddl.Items.Add(ds.Tables[0].Rows[i][0].ToString());
        //    }
        //}
        //public void DDLDataBind()
        //{
        //    BindDDL(DAL.FacilityDAL.GetMaching, ddlMaching);
        //    BindDDL(DAL.FacilityDAL.GetBrand, ddlBrand);
        //    BindDDL(DAL.FacilityDAL.GetModel, ddlModel);
        //    BindDDL(DAL.FacilityDAL.GetParameter, ddlParameter);
        //}
        protected void btnQuery_Click(object sender, EventArgs e)
        {
            paras = new AllotStocksParameters();
            paras.EventNo = txtEventNo.Text.Trim();
            paras.StoreNoA = txtStoreNoA.Text.Trim();
            paras.StoreNoB = txtStoreNoB.Text.Trim();
            paras.AllotStockDateF = txtAllotStockF.Text.Trim();
            paras.AllotStockDateT = txtAllotStockT.Text.Trim();
            paras.Maching = ddlMaching.SelectedValue;
            paras.Brand = ddlBrand.SelectedValue;
            paras.Model = ddlModel.SelectedValue;
            paras.Parameter = ddlParameter.SelectedValue;
            paras.SerialNo = txtSerialNo.Text.Trim();
            paras.AllotStockState = ddlAllotState.SelectedValue;
            paras.Operator = txtOperator.Text.Trim();

            DataSet ds = DAL.AllotStocksDAL.GetAllotStocksTotal(paras.EventNo, paras.StoreNoA, paras.StoreNoB, paras.Maching, paras.Brand, paras.Model, paras.SerialNo, paras.Parameter, paras.AllotStockDateF, paras.AllotStockDateT, paras.Operator, paras.AllotStockState);
            int rowsCount = ds.Tables[0].Rows.Count;
            if (rowsCount > pageSize)
            {
                totalPage = (int)Math.Ceiling((double)rowsCount / (double)pageSize);
            }
            else
            {
                totalPage = 1;
            }

            GVDataBind(1);
        }