public DealerStockVehicleInfo doFindDealerStockVehicleInfoById(string vin)
{
BaseDao <DealerStockVehicleInfo> baseDao = DaoFactory <DealerStockVehicleInfo> .CreateBaseDao(typeof(DealerStockVehicleInfo));
string sql = "SELECT CYVINM AS Vin,XSFDJH AS EngineNo,XSDPHM AS ChassisNo,ZMKHDM AS DealerCode,VTCLZT AS VehicleStatus,VTCLSX AS VehicleProperties," +
"GET_DATE_STRING(VTRKRQ) AS VehicleInStockDate,GET_DATE_STRING(VTOKRQ) AS VehicleOutStockDate FROM SJVDTALIB.ITM02 DEALER_VEHICLE WHERE ZMDWDM='08' AND CYVINM=@VIN";
return(baseDao.FindByid(sql, "VIN", vin));
}
public DealerUser doGetDealerUserInfo(string username)
{
BaseDao <DealerUser> baseDao = DaoFactory <DealerUser> .CreateBaseDao(typeof(DealerUser));
string sql = "SELECT ISCZXM AS Username,EBPSWD AS Password,ISRYXM AS EmployeeName,ISKHDM AS DealerCode,ISFXDM AS RegionCode,ZMCZJB AS RightLevel " +
"FROM SJVDTALIB.ISM01 DEALER_USER WHERE ISDWDM='08' AND ISJLZT='Y' AND ISCZXM=@USERNAME";
return(baseDao.FindByid(sql, "USERNAME", username));
}
public RetailOrderQueryDetailsVo doFindRetailOrderById(string orderNo, string remarkFlag)
{
BaseDao <RetailOrderQueryDetailsVo> baseDao = DaoFactory <RetailOrderQueryDetailsVo> .CreateBaseDao(typeof(RetailOrderQueryDetailsVo));
string selectFields = string.Empty;
string tableName = string.Empty;
string condition = string.Empty;
if (!string.IsNullOrWhiteSpace(remarkFlag) && "Y".Equals(remarkFlag))
{
selectFields = "RETAIL.CYVINM AS Vin,RETAIL.VSLSDD AS OrderNo,GET_DATE_TIME_STRING(RETAIL.VSLSRQ,RETAIL.VSLSSJ) AS RetailDateTime," +
"GET_DATE_STRING(RETAIL.VSLCRQ) AS OutStockDate,GET_DATE_STRING(RETAIL.DMFPRQ) AS InvoiceDate," +
"RETAIL.BSCLDM AS Model,RETAIL.XSYSDM AS Color,RETAIL.BSYSDM AS Color1,'' AS ModelYear,'' AS ModelVersion,RETAIL.BSNSYM AS Interior,RETAIL.BSPNXH AS PrList," +
"REMARK.VSYHMC AS CustomerName,RETAIL.VSXSLY AS SalesSource,RETAIL.VSDDZT AS OrderStatus,RETAIL.VSSFFJ AS Accessory,EXTEND.VSJLBZ AS Club," +
"GET_DATE_STRING(RETAIL.VSDJRQ) AS CreateDate,'' AS EngineNo,RETAIL.DMFPLX AS InvoiceType,RETAIL.DMFPHM AS InvoiceNo,REMARK.VSLXDZ AS Address,REMARK.VSRYXB AS Gender," +
"REMARK.VSXJDM AS County,RETAIL.DMKHLB AS CustomerType,RETAIL.DMCLYT AS VehiclePurpose,REMARK.VTZJLX AS CertificateType,REMARK.VTZJHM AS CertificateNo," +
"REMARK.DMDHHM AS Telephone,REMARK.DMSJHM AS Mobile,REMARK.VSDJYJ AS Email,REMARK.DMLXRM AS Contact,REMARK.DMYZBM AS ZipCode,RETAIL.DMZWZW AS Duty," +
"RETAIL.DMGSXZ AS CompanyProperty,RETAIL.DMCSHY AS CompanyIndustry,RETAIL.VSLSSX AS SalesType,RETAIL.VSLSKH AS ResellDealer," +
"CHAR(RETAIL.VSLSDJ) AS Price,CHAR(RETAIL.VSLSSL) AS Quantity,RETAIL.VSXSRY AS SalesPerson,'' AS VehicleInStockDate,'' AS VehicleOutStockDate," +
"RETAIL.VSLSBZ AS Remark,RETAIL.DMJFSZ AS UsePoint,CHAR(RETAIL.VSZFJE) AS PointAmount,RETAIL.VSPSLS AS PosFlowNo,RETAIL.VSLPCX AS Prize," +
"EXTEND.VSSBCL AS ThreeGuarantees,EXTEND.XSCPBZ AS LicenseRemark,EXTEND.XSLSCP AS LicenseNo,REMARK.VSSFWS AS OutSource";
tableName = "SJVDTALIB.IST15 RETAIL,SJVDTALIB.VST17 EXTEND,SJVDTALIB.VST19 REMARK";
condition = "AND RETAIL.ZMDWDM='08' AND EXTEND.ZMDWDM='08' AND REMARK.ZMDWDM='08' AND RETAIL.VSLSDD=EXTEND.VSLSDD AND RETAIL.VSLSDD=REMARK.VSLSDD " +
"AND RETAIL.VSLSDD=@ORDER_CODE";
}
else
{
selectFields = "RETAIL.CYVINM AS Vin,RETAIL.VSLSDD AS OrderNo,GET_DATE_TIME_STRING(RETAIL.VSLSRQ,RETAIL.VSLSSJ) AS RetailDateTime," +
"GET_DATE_STRING(RETAIL.VSLCRQ) AS OutStockDate,GET_DATE_STRING(RETAIL.DMFPRQ) AS InvoiceDate," +
"RETAIL.BSCLDM AS Model,RETAIL.XSYSDM AS Color,RETAIL.BSYSDM AS Color1,'' AS ModelYear,'' AS ModelVersion,RETAIL.BSNSYM AS Interior,RETAIL.BSPNXH AS PrList," +
"RETAIL.VSYHMC AS CustomerName,RETAIL.VSXSLY AS SalesSource,RETAIL.VSDDZT AS OrderStatus,RETAIL.VSSFFJ AS Accessory,EXTEND.VSJLBZ AS Club," +
"GET_DATE_STRING(RETAIL.VSDJRQ) AS CreateDate,'' AS EngineNo,RETAIL.DMFPLX AS InvoiceType,RETAIL.DMFPHM AS InvoiceNo,RETAIL.VSLXDZ AS Address,RETAIL.VSRYXB AS Gender," +
"RETAIL.VSXJDM AS County,RETAIL.DMKHLB AS CustomerType,RETAIL.DMCLYT AS VehiclePurpose,RETAIL.VTZJLX AS CertificateType,RETAIL.VTZJHM AS CertificateNo," +
"RETAIL.DMDHHM AS Telephone,RETAIL.DMSJHM AS Mobile,RETAIL.VSDJYJ AS Email,RETAIL.DMLXRM AS Contact,RETAIL.DMYZBM AS ZipCode,RETAIL.DMZWZW AS Duty," +
"RETAIL.DMGSXZ AS CompanyProperty,RETAIL.DMCSHY AS CompanyIndustry,RETAIL.VSLSSX AS SalesType,RETAIL.VSLSKH AS ResellDealer," +
"CHAR(RETAIL.VSLSDJ) AS Price,CHAR(RETAIL.VSLSSL) AS Quantity,RETAIL.VSXSRY AS SalesPerson,'' AS VehicleInStockDate,'' AS VehicleOutStockDate," +
"RETAIL.VSLSBZ AS Remark,RETAIL.DMJFSZ AS UsePoint,CHAR(RETAIL.VSZFJE) AS PointAmount,RETAIL.VSPSLS AS PosFlowNo,RETAIL.VSLPCX AS Prize," +
"EXTEND.VSSBCL AS ThreeGuarantees,EXTEND.XSCPBZ AS LicenseRemark,EXTEND.XSLSCP AS LicenseNo,EXTEND.VSSFWS AS OutSource";
tableName = "SJVDTALIB.IST15 RETAIL,SJVDTALIB.VST17 EXTEND";
condition = "AND RETAIL.ZMDWDM='08' AND EXTEND.ZMDWDM='08' AND RETAIL.VSLSDD=EXTEND.VSLSDD " +
"AND RETAIL.VSLSDD=@ORDER_CODE";
}
string sql = DB2Helper.GetSql(selectFields, tableName, condition);
return(baseDao.FindByid(sql, "ORDER_NO", orderNo));
}
