仓库查询，下属库位条数的获取

        /// <summary>
        /// 从数据库中得到职务数据帮定到deptDataGrid
        /// </summary>
        protected void DeptDataBind()
        {
            
            
            string deptID = "";
            deptDataGrid.DataSource = null;
            deptDataGrid.DataMember = null;
            deptDataGrid.DataBind();

            DataTable dptdt = new DataTable();
            dptdt = new StorePublicFacade().GetTableStructure("dpt", " and sht=''");
            dptdt.Columns.Add("flg", typeof(int));
            DataRow dptrow = dptdt.NewRow();
            dptdt.Rows.Add(dptrow);

            if (deptPspTextBox.Text.Trim() != string.Empty)
                dptrow["psp"] = deptPspTextBox.Text.Trim();
            deptID = deptSupDropDownList.SelectedValue.Trim();
            dptrow["sup"] = deptID;

            dptrow["txt"] = deptNameTextBox.Text;
            dptrow["sht"] = deptShtTextBox.Text.Trim();

            dptrow["typ"] = "2";
            dptrow["del"] = "0";
            dptrow["flg"] = flg;
            dptrow["psp"] = deptPspTextBox.Text;
            Int32 count;
            DataTable dt = new SetFacade().QueryDpt(dptdt,navPvdInfo.CurrentPageIndex,navPvdInfo.PageSize,out count);
            navPvdInfo.Count = count;
            if (dt == null )
            {
                dt = new DataTable();
            }                       
            deptDataGrid.DataSource = dt;
            deptDataGrid.DataBind();

           
            for (Int32 i = 0; i < dt.Rows.Count; i++)
            {                
                sht = dt.Rows[i]["sht"].ToString();
                
                count1 = new SetFacade().GetStorewbyid1(sht);
                deptDataGrid.Rows[i].Cells[4].Text = Convert.ToString(count1);
            }           
        }

其中，下属库位的绑定

 for (Int32 i = 0; i < dt.Rows.Count; i++)
            {                
                sht = dt.Rows[i]["sht"].ToString();
                
                count1 = new SetFacade().GetStorewbyid1(sht);
                deptDataGrid.Rows[i].Cells[4].Text = Convert.ToString(count1);
            }