コード例 #1
0
        /// <summary>
        /// 查询上架信息(上架表有上架信息)
        /// </summary>
        /// <param name="Request"></param>
        /// <returns></returns>
        //public GetShelvesByConditionResponse GetReceiptReceiving(ReceiptReceivingSearchCondition Request)
        //{
        //    GetShelvesByConditionResponse ConditionResponse = new GetShelvesByConditionResponse();
        //    string sqlWhere = SearchConditionsqlWhere(Request);
        //    DbParam[] dbParams = new DbParam[]{
        //        new DbParam("@WhereSql", DbType.String,Request.RID, ParameterDirection.Input),
        //    };
        //    DataSet ds = this.ExecuteDataSet("Proc_GetReceiptReceiving", dbParams);
        //    ConditionResponse.storesByGetReceipt = ds.Tables[0].ConvertToEntity<StoresByGetReceipt>();
        //    ConditionResponse.Shelves = ds.Tables[1].ConvertToEntityCollection<Shelves>();
        //    return ConditionResponse;
        //}
        private string SearchConditionsqlWhere(ReceiptReceivingSearchCondition Condition)
        {
            StringBuilder sb = new StringBuilder();

            if (Condition.RID != 0)
            {
                sb.Append("and r.id='" + Condition.RID + "'");
            }
            return(sb.ToString());
        }
コード例 #2
0
        /// <summary>
        /// 查询上架信息(上架表没有上架单)
        /// </summary>
        /// <param name="Request"></param>
        /// <returns></returns>
        public GetShelvesByConditionResponse GetShelves(ReceiptReceivingSearchCondition Request)
        {
            GetShelvesByConditionResponse ConditionResponse = new GetShelvesByConditionResponse();
            string sqlWhere = SearchConditionsqlWhere(Request);

            DbParam[] dbParams = new DbParam[] {
                new DbParam("@WhereSql", DbType.String, Request.RID, ParameterDirection.Input),
            };
            DataSet ds = this.ExecuteDataSet("Proc_WMS_GetShelves", dbParams);

            ConditionResponse.storesByGetReceipt = ds.Tables[0].ConvertToEntity <StoresByGetReceipt>();
            ConditionResponse.Shelves            = ds.Tables[1].ConvertToEntityCollection <Shelves>();
            return(ConditionResponse);
        }