Esempio n. 1
0
        protected void btnQuery_Click(object sender, EventArgs e)
        {
            paras = new Parameters();
            paras.WarehouseNo = txtWarehouseNo.Text.Trim();
            paras.InStockF = txtInStockF.Text.Trim();
            paras.InStockT = txtInStockT.Text.Trim();
            paras.MachingState = ddlMachingState.SelectedValue;
            paras.Maching = ddlMaching.SelectedValue;
            paras.Brand = ddlBrand.SelectedValue;
            paras.Model = ddlModel.SelectedValue;
            paras.Parameter = ddlParameter.SelectedValue;
            paras.Supplier = ddlSupplier.SelectedValue;

            DataSet ds = DAL.StocksDAL.GetStocks("", paras.WarehouseNo, paras.Maching, paras.Brand, paras.Model, paras.Parameter, paras.Supplier, paras.InStockF, paras.InStockT, "", "", "0", paras.MachingState);
            int rowsCount = ds.Tables[0].Rows.Count;
            if (rowsCount > pageSize)
            {
                totalPage = (int)Math.Ceiling((double)rowsCount / (double)pageSize);
            }
            else
            {
                totalPage = 1;
            }

            GVDataBind(1);
        }
Esempio n. 2
0
        protected void btnOkScrap_Click(object sender, EventArgs e)
        {
            if (txtScrapReason.Text.Trim()=="")
            {
                MsgBox("请输入废损原因!");
            }
            else
            {
                DAL.StocksDAL.DelStocksToScrapInID(crapRow, DateTime.Now.ToString("yyyy-MM-dd"), Session["userName"].ToString(), txtScrapReason.Text.Trim());
                divQuery.Visible = true;
                showpage.Visible = true;
                divOkScrap.Visible = false;
                crapRow = "";
                gvStock.Columns[0].Visible = true;

                paras = new Parameters();
                paras.WarehouseNo = txtWarehouseNo.Text.Trim();
                paras.InStockF = txtInStockF.Text.Trim();
                paras.InStockT = txtInStockT.Text.Trim();
                paras.MachingState = ddlMachingState.SelectedValue;
                paras.Maching = ddlMaching.SelectedValue;
                paras.Brand = ddlBrand.SelectedValue;
                paras.Model = ddlModel.SelectedValue;
                paras.Parameter = ddlParameter.SelectedValue;
                paras.Supplier = ddlSupplier.SelectedValue;

                DataSet ds = DAL.StocksDAL.GetStocks("", paras.WarehouseNo, paras.Maching, paras.Brand, paras.Model, paras.Parameter, paras.Supplier, paras.InStockF, paras.InStockT, "", "", "0", paras.MachingState);
                int rowsCount = ds.Tables[0].Rows.Count;
                if (rowsCount > pageSize)
                {
                    totalPage = (int)Math.Ceiling((double)rowsCount / (double)pageSize);
                }
                else
                {
                    totalPage = 1;
                }

                GVDataBind(1);
            }
        }