public List <SalesPerson> doFindSalesPersonAll() { BaseDao <SalesPerson> baseDao = DaoFactory <SalesPerson> .CreateBaseDao(typeof(SalesPerson)); string sql = "SELECT ZMKHDM AS DealerCode,VSXSRY AS SalesPersonCode,SALES_PERSON.VSXSYC AS SalesPersonName," + "SALES_PERSON.VTZJHM AS CertificateNo FROM SJVDTALIB.ISM40 SALES_PERSON WHERE ZMDWDM='08'"; return(baseDao.FindAll(sql)); }
public List <Dealer> doFindDealerAll() { BaseDao <Dealer> baseDao = DaoFactory <Dealer> .CreateBaseDao(typeof(Dealer)); string sql = "SELECT DEALER.ZMKHDM AS DealerCode,DEALER.ZMKHMC AS DealerName,DEALER.ZMNDDM AS NetCode,EXTEND.JSFXDM AS RegionCode FROM SJVDTALIB.XTM16 DEALER,SJVDTALIB.ISM02 EXTEND " + "WHERE DEALER.ZMDWDM='08' AND EXTEND.ZMDWDM='08' AND DEALER.ZMKHDM=EXTEND.ZMKHDM"; return(baseDao.FindAll(sql)); }
public List <County> doFindCountyAll() { BaseDao <County> baseDao = DaoFactory <County> .CreateBaseDao(typeof(County)); string sql = "SELECT COUNTY.VSXJDM AS CountyCode,COUNTY.VSXJMC AS CountyName,CITY.VSDSDM AS CityCode,CITY.VSDSMC AS CityName," + "PROVINCE.VSSSDM AS ProvinceCode,PROVINCE.VSSSMC AS ProvinceName FROM SJVDTALIB.ISM10 COUNTY,SJVDTALIB.ISM09 CITY,SJVDTALIB.ISM08 PROVINCE " + "WHERE COUNTY.ZMDWDM='08' AND CITY.ZMDWDM='08' AND PROVINCE.ZMDWDM='08' AND COUNTY.VSDSDM=CITY.VSDSDM AND CITY.VSSSDM=PROVINCE.VSSSDM"; return(baseDao.FindAll(sql)); }
public List <Color> doFindColorAll() { BaseDao <Color> baseDao = DaoFactory <Color> .CreateBaseDao(typeof(Color)); string sql = "SELECT XSYSDM AS ColorCode,XSYSMC AS ColorName,'' AS ModelCode FROM SJVDTALIB.XSM04 COLOR WHERE COLOR.ZMDWDM='08'"; return(baseDao.FindAll(sql)); //return baseDao.FindAll("SELECT VW_COLOR.XSYSDM AS VwColorCode,BSYSDM AS ColorCode,XSYSMC AS ColorName,'' AS ModelCode " + //"FROM SJVDTALIB.XSM04 VW_COLOR,SJVDTALIB.KCM14 COLOR WHERE VW_COLOR.ZMDWDM='08' AND COLOR.ZMDWDM='08' AND VW_COLOR.XSYSDM=COLOR.XSYSDM"); }
public List <ModelGroup> doFindModelGroupAll() { //log.Info("doFindModelPrAll begin"); getLogger(this).Info("doFindModelGroupAll begin"); BaseDao <ModelGroup> baseDao = DaoFactory <ModelGroup> .CreateBaseDao(typeof(ModelGroup)); List <ModelGroup> list = baseDao.FindAll("SELECT XSCLDM AS ModelGroupCode,BSCLDM AS ModelCode,CHAR(KCMDY1) AS ModelYear,KCVER1 AS ModelVersion,BSNSYM AS InteriorCode," + "CYCLP1 AS PrList, BSPNXH AS ModelPrNo FROM SJVDTALIB.KCM32 MODEL_GROUP WHERE ZMDWDM = '08' AND KCMDY1>=" + CfgReader.ModelGroupDataBeginYear); getLogger(this).Info("doFindModelGroupAll end"); return(list); }
public List <Interior> doFindInteriorAll() { BaseDao <Interior> baseDao = DaoFactory <Interior> .CreateBaseDao(typeof(Interior)); return(baseDao.FindAll("SELECT BSNSYM AS InteriorCode, BSNSJC AS InteriorName, '' AS ModelCode FROM SJVDTALIB.KCM10 INTERIOR WHERE ZMDWDM = '08'")); }
public List <Model> doFindModelAll() { BaseDao <Model> baseDao = DaoFactory <Model> .CreateBaseDao(typeof(Model)); return(baseDao.FindAll("SELECT BSCLDM AS ModelCode,XSCLMC AS ModelName,XSCXFL SeriesCode FROM SJVDTALIB.KCM09 MODEL WHERE ZMDWDM='08'")); }
public List <Series> doFindSeriesAll() { BaseDao <Series> baseDao = DaoFactory <Series> .CreateBaseDao(typeof(Series)); return(baseDao.FindAll("SELECT XSCXFL AS SeriesCode,XSCXFC AS SeriesName FROM SJVDTALIB.XSM11 SERIES WHERE ZMDWDM='08'")); }