Exemplo n.º 1
0
        public List <SP_GetAddressListToBindGrid_Result> GetAddressByObjectNameReferenceID(string SourceObjectName, long ReferenceID, string TargetObjectName, string SessionID, string UserID, string[] conn)
        {
            List <SP_GetAddressListToBindGrid_Result> AddressList = new List <SP_GetAddressListToBindGrid_Result>();
            BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));

            AddressList = (from sp in db.SP_GetAddressListToBindGrid(SourceObjectName, ReferenceID)
                           orderby sp.Sequence
                           where sp.Active != "Y"  // active=isArchive
                           select sp).ToList();
            SaveTempDataToDB(AddressList, SessionID, UserID, TargetObjectName, conn);
            return(AddressList);
        }