コード例 #1
0
        public List<VIEW_FOR_SUPPLIER_MASTER_NEW> GetSupplier(int startIndex, int maximumRows, string sortExpression, string filterExpression, string scommode, string sfname, string slname, string semail, string smob, string stele)
        {
            if (!String.IsNullOrEmpty(filterExpression))
            {
                Supply = Supply.Where(filterExpression);
            }
            if (!String.IsNullOrEmpty(sortExpression))
            {
                Supply = Supply.OrderBy(sortExpression);
            }
            if (!String.IsNullOrEmpty(scommode))
            {
                NewSupplierDataContext db = new NewSupplierDataContext();
                Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.COMMUNICATION_MODE_NAME.Contains(scommode)));
            }
            if (!String.IsNullOrEmpty(sfname))
            {
                NewSupplierDataContext db = new NewSupplierDataContext();
                Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_COMPANY_NAME.Contains(sfname)));
            }
            if (!String.IsNullOrEmpty(slname))
            {
                NewSupplierDataContext db = new NewSupplierDataContext();
                Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_TYPE_NAME.Contains(slname)));
            }
            if (!String.IsNullOrEmpty(semail))
            {
                NewSupplierDataContext db = new NewSupplierDataContext();
                Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_REL_EMAIL.Contains(semail)));
            }
            if (!String.IsNullOrEmpty(smob))
            {
                NewSupplierDataContext db = new NewSupplierDataContext();
                Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_REL_MOBILE.Contains(smob)));
            }
            if (!String.IsNullOrEmpty(stele))
            {
                NewSupplierDataContext db = new NewSupplierDataContext();
                Supply = db.VIEW_FOR_SUPPLIER_MASTER_NEWs.Where(p => (p.SUPPLIER_REL_PHONE.Contains(stele)));
            }
            else
            {
                Supply = Supply.OrderBy("SUPPLIER_ID ASC");
            }

            return Supply.Skip(startIndex).Take(maximumRows).ToList();

        }
コード例 #2
0
        public List<VIEW_SUPPLIER_CONTECT_DETAIL> Contectdetail(string SUPPLIER_ID, string city, string state, string country)
        {

            if (!String.IsNullOrEmpty(city))
            {
                NewSupplierDataContext db = new NewSupplierDataContext();
                Contect = db.VIEW_SUPPLIER_CONTECT_DETAILs.Where(p => (p.CITY_NAME.Contains(city)));
            }
            if (!String.IsNullOrEmpty(state))
            {
                NewSupplierDataContext db = new NewSupplierDataContext();
                Contect = db.VIEW_SUPPLIER_CONTECT_DETAILs.Where(p => (p.STATE_NAME.Contains(state)));
            }
            if (!String.IsNullOrEmpty(country))
            {
                NewSupplierDataContext db = new NewSupplierDataContext();
                Contect = db.VIEW_SUPPLIER_CONTECT_DETAILs.Where(p => (p.COUNTRY_NAME.Contains(country)));
            }
            Contect = Contect.Where(String.Format(@"SUPPLIER_ID == {0}", SUPPLIER_ID));
            return Contect.ToList();
        }