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'"));
}