服务缓存JSON格式返回信息

Contract层

    //安卓基础信息缓存接口
     //安卓基础信息缓存接口
        //获取分库信息
        [WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        string GetReservoirCache(int dep_id);

Service层

 //安卓基础信息缓存
        //获取库存信息
        public string GetReservoirCache(int dep_id)
        {
            return MyBaseBLL.GetReservoirCache(dep_id);
        }

BLL层

   //安卓信息缓存
        //安卓库区信息缓存
        public FeedbackInfomation GetReservoirCache(int dep_id)
        {
            FeedbackInfomation fi = new FeedbackInfomation();
            try
            {
                fi.Result = MyBaseDAL.SelectReservoirCacheAndroid(dep_id);
                fi.ErrorStatus = STATUS_ADAPTER.QUERY_NORMAL;
                fi.FeedbackMessage = "";
                return fi;
            }
            catch (Exception ex)
            {
                fi.Result = "";
                fi.FeedbackMessage = ex.Message.ToString();
                fi.ErrorStatus = STATUS_ADAPTER.QUERY_ERROR;
                return fi;
            }

        }

DAL层

  public List<StorageEntity> SelectReservoirCacheAndroid(int dep_id)
        {
            string sqlstr = " select * from ReservoirArea a inner join ReservoirNature b on  " +
                "a.Rar_Rna_ID = b.Rna_ID  " +
                "where Rar_Dep_ID = {0}";
            sqlstr = string.Format(sqlstr, dep_id);
            DataSet ds = SqlDataHelper.ExecuteDataSet(SqlDataHelper.GetConnection(), CommandType.Text, sqlstr);
            List<StorageEntity> listres =  DsToStorageEntityList(ds);
            return listres;

        }

 public List<StorageEntity> DsToStorageEntityList(DataSet ds)
        {
            List<StorageEntity> Ses = new List<StorageEntity>();
            if (DataValidate.CheckDataSetNotEmpty(ds))
            {
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    StorageEntity se = new StorageEntity();
                    se.StorageID = dr["Dep_ID"].ToString();
                    se.StorageName = dr["Dep_Name"].ToString();
                    se.Remark = dr["Dep_Remark"].ToString();
                    se.IfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Dep_IfUse"]) == true ? false : dr["Dep_IfUse"]);
                    Ses.Add(se);
                }
            }
            return Ses;
        }

StroageEntity

namespace CMST.Storage.Server.Data.BaseManage
{
    [DataContract]
    
    public class StorageEntity : INotifyPropertyChanged
    {
        private string _storageId;
        [DataMember]
        public string StorageID
        {
            get { return this._storageId; }
            set { this._storageId = value; OnPropertyChanged("StorageID"); }
        }
        public event PropertyChangedEventHandler PropertyChanged;

        private string _storageName;
        [DataMember]
        public string StorageName
        {
            get { return this._storageName; }
            set { this._storageName = value; OnPropertyChanged("StorageName"); }
        }

        private string _remark;
        [DataMember]
        public string Remark
        {
            get { return this._remark; }
            set { this._remark = value; OnPropertyChanged("Remark"); }
        }

        private bool _ifUse;
        [DataMember]
        public bool IfUse
        {
            get { return this._ifUse; }
            set { this._ifUse = value; this.OnPropertyChanged("IfUse"); }
        }


      

        protected void OnPropertyChanged(string PropertyName)
        {
            PropertyChangedEventHandler handler = PropertyChanged;
            if (handler != null)
            {
                handler(this, new PropertyChangedEventArgs(PropertyName));
            }
        }
    }