197 lines
		
	
	
		
			5.3 KiB
		
	
	
	
		
			C#
		
	
	
	
		
		
			
		
	
	
			197 lines
		
	
	
		
			5.3 KiB
		
	
	
	
		
			C#
		
	
	
	
| 
								 | 
							
								using System;
							 | 
						|||
| 
								 | 
							
								using System.Collections.Generic;
							 | 
						|||
| 
								 | 
							
								using System.Linq;
							 | 
						|||
| 
								 | 
							
								using Oracle.ManagedDataAccess.Types;
							 | 
						|||
| 
								 | 
							
								using Prism.Mvvm;
							 | 
						|||
| 
								 | 
							
								using SqlSugar;
							 | 
						|||
| 
								 | 
							
								namespace DM_Weight.Models
							 | 
						|||
| 
								 | 
							
								{
							 | 
						|||
| 
								 | 
							
								    /// <summary>
							 | 
						|||
| 
								 | 
							
								    /// 
							 | 
						|||
| 
								 | 
							
								    ///</summary>
							 | 
						|||
| 
								 | 
							
								    [Serializable]
							 | 
						|||
| 
								 | 
							
								    [SugarTable("channel_stock")]
							 | 
						|||
| 
								 | 
							
								    public class ChannelStock : BindableBase
							 | 
						|||
| 
								 | 
							
								    {
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "chsguid", IsPrimaryKey = true)]
							 | 
						|||
| 
								 | 
							
								        public string Id { get; set; }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName ="chnguid")]
							 | 
						|||
| 
								 | 
							
								        public string Chnguid { get; set; }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: NULL
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "machine_id")]
							 | 
						|||
| 
								 | 
							
								        public string MachineId { get; set; }
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: NULL
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "row_no")]
							 | 
						|||
| 
								 | 
							
								        public int DrawerNo { get; set; }
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: NULL
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "col_no")]
							 | 
						|||
| 
								 | 
							
								        public int ColNo { get; set; }
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: NULL
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "pos_no")]
							 | 
						|||
| 
								 | 
							
								        public int PosNo { get; set; }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: NULL
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "drug_id")]
							 | 
						|||
| 
								 | 
							
								        public string DrugId { get; set; }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: NULL
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "manu_no")]
							 | 
						|||
| 
								 | 
							
								        public string ManuNo { get; set; }
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: NULL
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "eff_date")]
							 | 
						|||
| 
								 | 
							
								        public string EffDate { get; set; }
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: NULL
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "quantity")]
							 | 
						|||
| 
								 | 
							
								        public int Quantity { get; set; }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: 1
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "drawer_type")]
							 | 
						|||
| 
								 | 
							
								        public int DrawerType { get; set; }
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: 1
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "board_type")]
							 | 
						|||
| 
								 | 
							
								        public int BoardType { get; set; }
							 | 
						|||
| 
								 | 
							
								        /// <summary>
							 | 
						|||
| 
								 | 
							
								        ///  
							 | 
						|||
| 
								 | 
							
								        /// 默认值: 1
							 | 
						|||
| 
								 | 
							
								        ///</summary>
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(ColumnName = "state")]
							 | 
						|||
| 
								 | 
							
								        public int? State { get; set; }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public bool IsSelected { get; set; }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public InOutInvoice Invoice { get; set; }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public string Location
							 | 
						|||
| 
								 | 
							
								        {
							 | 
						|||
| 
								 | 
							
								            get => DrawerNo + "-" + ColNo;
							 | 
						|||
| 
								 | 
							
								        }
							 | 
						|||
| 
								 | 
							
								        private int _addQuantity = 0;
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public int AddQuantity
							 | 
						|||
| 
								 | 
							
								        {
							 | 
						|||
| 
								 | 
							
								            get => _addQuantity;
							 | 
						|||
| 
								 | 
							
								            set
							 | 
						|||
| 
								 | 
							
								            {
							 | 
						|||
| 
								 | 
							
								                SetProperty(ref _addQuantity, value);
							 | 
						|||
| 
								 | 
							
								            }
							 | 
						|||
| 
								 | 
							
								        }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        private int _takeQuantity = 0;
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public int TakeQuantity
							 | 
						|||
| 
								 | 
							
								        {
							 | 
						|||
| 
								 | 
							
								            get => _takeQuantity;
							 | 
						|||
| 
								 | 
							
								            set
							 | 
						|||
| 
								 | 
							
								            {
							 | 
						|||
| 
								 | 
							
								                if (value > Quantity)
							 | 
						|||
| 
								 | 
							
								                {
							 | 
						|||
| 
								 | 
							
								                    throw new ArgumentException("取药数量不能大于库存");
							 | 
						|||
| 
								 | 
							
								                }
							 | 
						|||
| 
								 | 
							
								                SetProperty(ref _takeQuantity, value);
							 | 
						|||
| 
								 | 
							
								            }
							 | 
						|||
| 
								 | 
							
								        }
							 | 
						|||
| 
								 | 
							
								        //private string _tipMessage=string.Empty;
							 | 
						|||
| 
								 | 
							
								        //[SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        //public string TipMessage
							 | 
						|||
| 
								 | 
							
								        //{
							 | 
						|||
| 
								 | 
							
								        //    get => _tipMessage;
							 | 
						|||
| 
								 | 
							
								        //    set
							 | 
						|||
| 
								 | 
							
								        //    {
							 | 
						|||
| 
								 | 
							
								        //        SetProperty(ref _tipMessage, value);
							 | 
						|||
| 
								 | 
							
								        //    }
							 | 
						|||
| 
								 | 
							
								        //}
							 | 
						|||
| 
								 | 
							
								        private int _returnQuantity = 0;
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public int ReturnQuantity
							 | 
						|||
| 
								 | 
							
								        {
							 | 
						|||
| 
								 | 
							
								            get => _returnQuantity;
							 | 
						|||
| 
								 | 
							
								            set
							 | 
						|||
| 
								 | 
							
								            {
							 | 
						|||
| 
								 | 
							
								                SetProperty(ref _returnQuantity, value);
							 | 
						|||
| 
								 | 
							
								            }
							 | 
						|||
| 
								 | 
							
								        }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        private int _checkQuantity = 0;
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public int CheckQuantity
							 | 
						|||
| 
								 | 
							
								        {
							 | 
						|||
| 
								 | 
							
								            get => _checkQuantity;
							 | 
						|||
| 
								 | 
							
								            set
							 | 
						|||
| 
								 | 
							
								            {
							 | 
						|||
| 
								 | 
							
								                if (value < 0)
							 | 
						|||
| 
								 | 
							
								                {
							 | 
						|||
| 
								 | 
							
								                    throw new ArgumentException("盘点数量不能是负数");
							 | 
						|||
| 
								 | 
							
								                }
							 | 
						|||
| 
								 | 
							
								                SetProperty(ref _checkQuantity, value);
							 | 
						|||
| 
								 | 
							
								            }
							 | 
						|||
| 
								 | 
							
								        }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public int? CanReturnQuantity { get; set; }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        private DrugInfo? _DrugInfo;
							 | 
						|||
| 
								 | 
							
								        [Navigate(NavigateType.ManyToOne, nameof(DrugId))]
							 | 
						|||
| 
								 | 
							
								        public DrugInfo DrugInfo { get => _DrugInfo; set => SetProperty(ref _DrugInfo, value); }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public int process { get; set; } = 0;
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        private DrugManuNo? _drugManuNo;
							 | 
						|||
| 
								 | 
							
								        [SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        public DrugManuNo? drugManuNo { get => _drugManuNo; set => SetProperty(ref _drugManuNo, value); }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        //private string _manuNoEffDate;
							 | 
						|||
| 
								 | 
							
								        //[SugarColumn(IsIgnore = true)]
							 | 
						|||
| 
								 | 
							
								        //public string ManuNoEffDate { get => _manuNoEffDate; set => SetProperty(ref _manuNoEffDate, value); }
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								
							 | 
						|||
| 
								 | 
							
								        private ChannelList? _channelList;
							 | 
						|||
| 
								 | 
							
								        [Navigate(NavigateType.ManyToOne, nameof(Chnguid))]
							 | 
						|||
| 
								 | 
							
								        public ChannelList ChannelLst { get => _channelList; set => SetProperty(ref _channelList, value); }
							 | 
						|||
| 
								 | 
							
								    }
							 | 
						|||
| 
								 | 
							
								}
							 |