private void LoadData() { #region 加载数据 string strWhere = string.Format("ID='{0}'", Request.QueryString["id"].ToString()); BLL.vw_JC_Material bllMaterial = new BLL.vw_JC_Material(); DataRow drMaterial = bllMaterial.GetList(strWhere).Tables[0].Rows[0]; txbMaterialNO.Text = drMaterial["MaterialNO"].ToString(); txbMaterialName.Text = drMaterial["MaterialName"].ToString(); ddlPropertyName.SelectedValue = drMaterial["Property"].ToString(); txbSpecification.Text = drMaterial["Specification"].ToString(); txbModel.Text = drMaterial["Model"].ToString(); txbUnit.Text = drMaterial["Unit"].ToString(); nbxFixedLeadTime.Text = drMaterial["FixedLeadTime"].ToString(); nbxVariableLeadTime.Text = drMaterial["VariableLeadTime"].ToString(); nbxVariableBatch.Text = drMaterial["VariableBatch"].ToString(); nbxUnitStandardCost.Text = drMaterial["UnitStandardCost"].ToString(); tgbProcessRouteNO.Text = drMaterial["ProcessRouteNO"].ToString(); nbxProductionVolume.Text = drMaterial["ProductionVolume"].ToString(); nbxIncreaseAmount.Text = drMaterial["IncreaseAmount"].ToString(); nbxUnitStandardTime.Text = drMaterial["UnitStandardTime"].ToString(); #endregion #region 设置操作权限 #endregion #region 自动填充项 #endregion }
protected void BindGrid() { string strWhere = string.Format("Status = 'Y'"); string order = string.Format("{0} {1}", gridMaterial.SortField, gridMaterial.SortDirection); int pageSize = gridMaterial.PageSize; int pageIndex = gridMaterial.PageIndex; long records; BLL.vw_JC_Material bllMaterial = new BLL.vw_JC_Material(); DataSet dsMaterial = bllMaterial.GetListByPage(strWhere, order, pageSize, pageIndex, out records); DataTable dtSource = dsMaterial.Tables[0]; gridMaterial.DataSource = dtSource; gridMaterial.RecordCount = (int)records; gridMaterial.DataBind(); }