/// <summary>
        ///  B端商户拉取收货人地址缓存到本地 add By  caoheyang   20150702
        /// </summary>
        /// <param name="model">参数实体</param>
        /// <returns></returns>
        public ResultModel <object> ConsigneeAddressB(ConsigneeAddressBPM model)
        {
            string maxDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            IList <ConsigneeAddressBDM> models = receviceAddressDao.ConsigneeAddressB(model);
            var res = new
            {
                MaxDate = maxDate,
                Data    = models
            };

            return(ResultModel <object> .Conclude(SystemState.Success, res));
        }
Ejemplo n.º 2
0
        /// <summary>
        ///  B端商户拉取收货人地址缓存到本地 add By  caoheyang   20150702
        /// </summary>
        /// <param name="model">参数实体</param>
        /// <returns></returns>
        public IList <ConsigneeAddressBDM> ConsigneeAddressB(ConsigneeAddressBPM model)
        {
            IList <ConsigneeAddressBDM> models = new List <ConsigneeAddressBDM>();
            const string  querysql             = @"
select  Id ,PhoneNo,Address,CONVERT(varchar(100),PubDate, 120) as PubDate
from    dbo.ReceviceAddress
where   PubDate > @PubDate
        and BusinessId = @BusinessId";
            IDbParameters dbParameters         = DbHelper.CreateDbParameters();

            dbParameters.Add("BusinessId", DbType.Int32, 4).Value = model.BusinessId;
            dbParameters.Add("PubDate", DbType.DateTime).Value    = (model.PubDate == null
                ? Convert.ToDateTime("2015-01-01 00:00:00")
                : Convert.ToDateTime(model.PubDate));
            DataTable dt = DataTableHelper.GetTable(DbHelper.ExecuteDataset(SuperMan_Read, querysql, dbParameters));

            if (DataTableHelper.CheckDt(dt))
            {
                models = DataTableHelper.ConvertDataTableList <ConsigneeAddressBDM>(dt);
            }
            return(models);
        }
Ejemplo n.º 3
0
 public ResultModel <object> ConsigneeAddressB([FromBody] ConsigneeAddressBPM model)
 {
     return(receviceAddressProvider.ConsigneeAddressB(model));
 }