Esempio n. 1
0
        public List <STOP> STOP_Find(List <STOP> list)
        {
            List <SqlParameter> parameters = new List <SqlParameter>();
            STOPTableSet        set        = new STOPTableSet(list);

            parameters.AddInputParameter("@ENP", SqlDbType.Structured, set.STOPResultTable);
            List <STOP> result = Execute_GetList(NomernikSTOPMaterializer.Instance, "STOP_Find", parameters);

            return(result);
        }
Esempio n. 2
0
        public void STOP_Save(IEnumerable <STOP> listSTOP, Nomernik.History nompHistory)
        {
            List <SqlParameter> parameters = new List <SqlParameter>();
            STOPTableSet        set        = new STOPTableSet(listSTOP);

            parameters.AddInputParameter("@stopTable", SqlDbType.Structured, set.STOPResultTable);
            parameters.AddInputParameter("@LoadDate", SqlDbType.DateTime, nompHistory.LoadDate);
            parameters.AddInputParameter("@FileDate", SqlDbType.DateTime, nompHistory.FileDate);
            parameters.AddInputParameter("@UserID", SqlDbType.BigInt, nompHistory.UserID);
            parameters.AddInputParameter("@CountAll", SqlDbType.BigInt, nompHistory.CountAll);
            parameters.AddInputParameter("@CountOur", SqlDbType.BigInt, nompHistory.CountOur);
            parameters.AddInputParameter("@CountChange", SqlDbType.BigInt, listSTOP.Count());
            //в процедуре идет запись данных в таблицу STOP и истории в STOPHistory
            Execute_StoredProcedure("STOP_Save", parameters);
        }