Exemple #1
0
        public void FillLocationGrid(long WarehouseID)
        {
            CustomProfile    profile         = CustomProfile.GetProfile();
            iWarehouseClient Warehouseclient = new iWarehouseClient();
            DataSet          ds = new DataSet();

            ds = Warehouseclient.GetWarehouseLocationByID(WarehouseID, profile.DBConnection._constr);
            GVLocation.DataSource = ds;
            // GVLocation.DataSource = Warehouseclient.GetWarehouseLocation(WarehouseID, profile.DBConnection._constr);
            GVLocation.DataBind();
        }
        private void GVLocDataBind()
        {
            StringBuilder sql = new StringBuilder(string.Format("select * from jp_wh_loc_v where area_id = '{0}'", DdlArea.SelectedValue));

            if (TxtLocation.Text.Trim() != "")
            {
                sql.Append(string.Format("and location like '{0}'", TxtLocation.Text));
            }
            GVLocation.DataSource = DBHelper.createGridView(sql.ToString());
            GVLocation.DataBind();
        }