Exemple #1
0
    /// <summary>
    /// Bind Result of search criteria
    /// </summary>
    private void BindDataGrid()
    {
        whereClause = (isSort && ViewState["whereClause"] != null) ? ViewState["whereClause"].ToString() : whereClause;
        if (whereClause == "")
        {
            whereClause = "SellToCustNo=''";
        }

        if (ddlHeaderType.SelectedValue.Trim().ToLower() == "in" || ddlSearchType.SelectedItem.Value.Trim() == "I")
        {
            SOHEADERTABLE = "SOHeaderHist";
        }

        DataTable dsSoFind = sOEFind.GetSalesOrder(whereClause, SOHEADERTABLE);

        ViewState["dtSOFind"] = dsSoFind;
        if (dsSoFind != null)
        {
            dtSoFind = dsSoFind;
            if (dtSoFind.Rows.Count == 0)
            {
                DataRow dr = dtSoFind.NewRow();
                dtSoFind.Rows.Add(dr);
            }
            int allowedRowCount = Convert.ToInt32(ViewState["MaxRowCount"].ToString());
            if (dtSoFind.Rows.Count < allowedRowCount)
            {
                ViewState["whereClause"]  = whereClause;
                dtSoFind.DefaultView.Sort = (hidSort.Value == "") ? "SoNo asc" : hidSort.Value;
                gvFind.DataSource         = dtSoFind.DefaultView.ToTable();
                //gvFind.DataBind();
                GridPager.InitPager(gvFind, 20);
                ExportSoFind();
            }
            else
            {
                gvFind.DataSource = null;
                gvFind.DataBind();
                utility.DisplayMessage(PFC.SOE.Enums.MessageType.Failure, "Maximum row exceeds for this search.please enter additional data.", lblMessage);
                //ScriptManager.RegisterClientScriptBlock(ibtnOrderSearch, ibtnOrderSearch.GetType(), "search", "alert('');", true);
            }

            gvFind.Visible = true;
            upSOGrid.Update();
        }
        if (dsSoFind == null || dsSoFind.Rows.Count == 0)
        {
            gvFind.DataSource = null;;
            gvFind.DataBind();
            utility.DisplayMessage(PFC.SOE.Enums.MessageType.Success, "No record found", lblMessage);
            upSOGrid.Update();
            upMessage.Update();
        }
        upSOGrid.Update();
        upSOSearch.Update();
        upMessage.Update();
    }