Ejemplos de Khabardaan.Code.DAL DBToolsDataContext en C# (CSharp)

Ejemplo n.º 1

Archivo: BaseBOLGarbageWords.cs Proyecto: bidaad/KhabardaanWebsite

    int IBaseBOL.GetCount(SearchFilterCollection sFilterCols)
    {
        int    RecordCount = 1;
        string WhereCond   = Tools.GetCondition(sFilterCols).Replace("''", "'");
        var    ResultQuery = new Khabardaan.Code.DAL.DBToolsDataContext().spGetCount(TableOrViewName, WhereCond);

        RecordCount = (int)ResultQuery.ReturnValue;
        return(RecordCount);
    }

Ejemplo n.º 2

Archivo: BaseBOLNewsNewsFlows.cs Proyecto: bidaad/KhabardaanWebsite

    public int GetCount(SearchFilterCollection sFilterCols)
    {
        string             WhereCond;
        int                RecordCount = 1;
        DBToolsDataContext dcTools     = new DBToolsDataContext();

        WhereCond = Tools.GetCondition(sFilterCols);
        if (WhereCond == "")
        {
            WhereCond = " NewsCode = " + MasterCode;
        }
        else
        {
            WhereCond = " NewsCode = " + MasterCode + " and " + WhereCond;
        }

        WhereCond = WhereCond.Replace("''", "'");
        var ResultQuery = dcTools.spGetCount(TableOrViewName, WhereCond);

        RecordCount = (int)ResultQuery.ReturnValue;
        return(RecordCount);
    }