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

来源：互联网发布：windows mobile刷安卓编辑：程序博客网时间：2024/06/05 10:31

        /// <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);            }

0 0