2023-09-04 22:41:19 +08:00
|
|
|
|
/// <summary>
|
|
|
|
|
///WCF Data Object
|
|
|
|
|
///BASIC CLASS FOR TABLE t_wmsOrderDetail
|
|
|
|
|
///By wm
|
2023-11-21 19:18:23 +08:00
|
|
|
|
///on 10/16/2023
|
2023-09-04 22:41:19 +08:00
|
|
|
|
/// </summary>
|
|
|
|
|
|
|
|
|
|
using System;
|
|
|
|
|
using System.Runtime.Serialization;
|
|
|
|
|
using System.Data;
|
|
|
|
|
using DeiNiu.wms.Data.Model;
|
|
|
|
|
namespace DeiNiu.wms.Data.Model.Wcf
|
|
|
|
|
{
|
|
|
|
|
|
|
|
|
|
#region WcfWmsOrderDetail
|
|
|
|
|
/// <summary>
|
|
|
|
|
/// This object represents the properties and methods of a WcfWmsOrderDetail.
|
|
|
|
|
/// </summary>
|
|
|
|
|
[DataContract]
|
|
|
|
|
public class WcfWmsOrderDetail {
|
|
|
|
|
|
|
|
|
|
internal int _id;
|
|
|
|
|
internal string _orderNo= String.Empty;
|
|
|
|
|
internal int _skuId;
|
|
|
|
|
internal string _skuCode= String.Empty;
|
|
|
|
|
internal string _goodsId= String.Empty;
|
|
|
|
|
internal string _goodsName= String.Empty;
|
|
|
|
|
internal string _unit= String.Empty;
|
|
|
|
|
internal string _batch= String.Empty;
|
|
|
|
|
internal string _productDate= String.Empty;
|
|
|
|
|
internal string _validDate= String.Empty;
|
|
|
|
|
internal decimal _count;
|
2023-11-21 19:18:23 +08:00
|
|
|
|
internal decimal _finishedCount;
|
2023-09-04 22:41:19 +08:00
|
|
|
|
internal decimal _price;
|
|
|
|
|
internal int _state;
|
|
|
|
|
internal int _whtype;
|
|
|
|
|
internal int _toWhType;
|
|
|
|
|
internal string _locationId= String.Empty;
|
|
|
|
|
internal int _partion;
|
|
|
|
|
internal string _description= String.Empty;
|
|
|
|
|
internal int _operater;
|
|
|
|
|
internal bool _dr;
|
|
|
|
|
internal string _createtime= String.Empty;
|
|
|
|
|
internal string _lastmodified= String.Empty;
|
|
|
|
|
|
|
|
|
|
public WcfWmsOrderDetail () {
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public WcfWmsOrderDetail (DataRow dr) {
|
|
|
|
|
#region get data from dr
|
|
|
|
|
if (dr != null )
|
|
|
|
|
{
|
|
|
|
|
if (dr.Table.Columns.Contains("id") && !(dr["id"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_id = Convert.ToInt32(dr["id"].ToString()); ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("orderNo") && !(dr["orderNo"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_orderNo = dr["orderNo"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("skuId") && !(dr["skuId"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_skuId = Convert.ToInt32(dr["skuId"].ToString()); ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("skuCode") && !(dr["skuCode"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_skuCode = dr["skuCode"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("goodsId") && !(dr["goodsId"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_goodsId = dr["goodsId"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("goodsName") && !(dr["goodsName"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_goodsName = dr["goodsName"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("unit") && !(dr["unit"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_unit = dr["unit"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("batch") && !(dr["batch"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_batch = dr["batch"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("productDate") && !(dr["productDate"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_productDate = dr["productDate"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("validDate") && !(dr["validDate"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_validDate = dr["validDate"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("count") && !(dr["count"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_count = Convert.ToDecimal(dr["count"].ToString()); ;
|
|
|
|
|
}
|
2023-11-21 19:18:23 +08:00
|
|
|
|
if (dr.Table.Columns.Contains("finishedCount") && !(dr["finishedCount"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_finishedCount = Convert.ToDecimal(dr["finishedCount"].ToString()); ;
|
|
|
|
|
}
|
2023-09-04 22:41:19 +08:00
|
|
|
|
if (dr.Table.Columns.Contains("price") && !(dr["price"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_price = Convert.ToDecimal(dr["price"].ToString()); ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("state") && !(dr["state"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_state = Convert.ToInt32(dr["state"].ToString()); ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("whtype") && !(dr["whtype"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_whtype = Convert.ToInt32(dr["whtype"].ToString()); ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("toWhType") && !(dr["toWhType"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_toWhType = Convert.ToInt32(dr["toWhType"].ToString()); ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("locationId") && !(dr["locationId"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_locationId = dr["locationId"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("partion") && !(dr["partion"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_partion = Convert.ToInt32(dr["partion"].ToString()); ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("description") && !(dr["description"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_description = dr["description"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("operater") && !(dr["operater"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_operater = Convert.ToInt32(dr["operater"].ToString()); ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("dr") && !(dr["dr"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_dr = Convert.ToBoolean(dr["dr"].ToString()); ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("createtime") && !(dr["createtime"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_createtime = dr["createtime"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
if (dr.Table.Columns.Contains("lastmodified") && !(dr["lastmodified"] is DBNull))
|
|
|
|
|
{
|
|
|
|
|
_lastmodified = dr["lastmodified"].ToString() ;
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
#endregion
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public WcfWmsOrderDetail( WmsOrderDetail dbObj){
|
|
|
|
|
#region get data from dbobj
|
|
|
|
|
|
|
|
|
|
_id= dbObj.ID;
|
|
|
|
|
orderNo = dbObj.orderNo;
|
|
|
|
|
|
|
|
|
|
skuId = dbObj.skuId;
|
|
|
|
|
|
|
|
|
|
skuCode = dbObj.skuCode;
|
|
|
|
|
|
|
|
|
|
goodsId = dbObj.goodsId;
|
|
|
|
|
|
|
|
|
|
goodsName = dbObj.goodsName;
|
|
|
|
|
|
|
|
|
|
unit = dbObj.unit;
|
|
|
|
|
|
|
|
|
|
batch = dbObj.batch;
|
|
|
|
|
|
|
|
|
|
productDate = dbObj.productDate;
|
|
|
|
|
|
|
|
|
|
validDate = dbObj.validDate;
|
|
|
|
|
|
|
|
|
|
count = dbObj.count;
|
|
|
|
|
|
2023-11-21 19:18:23 +08:00
|
|
|
|
finishedCount = dbObj.finishedCount;
|
|
|
|
|
|
2023-09-04 22:41:19 +08:00
|
|
|
|
price = dbObj.price;
|
|
|
|
|
|
|
|
|
|
state = dbObj.state;
|
|
|
|
|
|
|
|
|
|
whtype = dbObj.whtype;
|
|
|
|
|
|
|
|
|
|
toWhType = dbObj.toWhType;
|
|
|
|
|
|
|
|
|
|
locationId = dbObj.locationId;
|
|
|
|
|
|
|
|
|
|
partion = dbObj.partion;
|
|
|
|
|
|
|
|
|
|
description = dbObj.description;
|
|
|
|
|
|
|
|
|
|
operater = dbObj.operater;
|
|
|
|
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#region Public Properties
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public int id{
|
|
|
|
|
get {return _id;}
|
|
|
|
|
set {_id = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string orderNo{
|
|
|
|
|
get {return _orderNo;}
|
|
|
|
|
set {_orderNo = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public int skuId{
|
|
|
|
|
get {return _skuId;}
|
|
|
|
|
set {_skuId = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string skuCode{
|
|
|
|
|
get {return _skuCode;}
|
|
|
|
|
set {_skuCode = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string goodsId{
|
|
|
|
|
get {return _goodsId;}
|
|
|
|
|
set {_goodsId = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string goodsName{
|
|
|
|
|
get {return _goodsName;}
|
|
|
|
|
set {_goodsName = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string unit{
|
|
|
|
|
get {return _unit;}
|
|
|
|
|
set {_unit = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string batch{
|
|
|
|
|
get {return _batch;}
|
|
|
|
|
set {_batch = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string productDate{
|
|
|
|
|
get {return _productDate;}
|
|
|
|
|
set {_productDate = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string validDate{
|
|
|
|
|
get {return _validDate;}
|
|
|
|
|
set {_validDate = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public decimal count{
|
|
|
|
|
get {return _count;}
|
|
|
|
|
set {_count = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
2023-11-21 19:18:23 +08:00
|
|
|
|
[DataMember]
|
|
|
|
|
public decimal finishedCount{
|
|
|
|
|
get {return _finishedCount;}
|
|
|
|
|
set {_finishedCount = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
2023-09-04 22:41:19 +08:00
|
|
|
|
[DataMember]
|
|
|
|
|
public decimal price{
|
|
|
|
|
get {return _price;}
|
|
|
|
|
set {_price = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public int state{
|
|
|
|
|
get {return _state;}
|
|
|
|
|
set {_state = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public int whtype{
|
|
|
|
|
get {return _whtype;}
|
|
|
|
|
set {_whtype = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public int toWhType{
|
|
|
|
|
get {return _toWhType;}
|
|
|
|
|
set {_toWhType = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string locationId{
|
|
|
|
|
get {return _locationId;}
|
|
|
|
|
set {_locationId = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public int partion{
|
|
|
|
|
get {return _partion;}
|
|
|
|
|
set {_partion = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string description{
|
|
|
|
|
get {return _description;}
|
|
|
|
|
set {_description = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public int operater{
|
|
|
|
|
get {return _operater;}
|
|
|
|
|
set {_operater = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public bool dr{
|
|
|
|
|
get {return _dr;}
|
|
|
|
|
set {_dr = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string createtime{
|
|
|
|
|
get {return _createtime;}
|
|
|
|
|
set {_createtime = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
[DataMember]
|
|
|
|
|
public string lastmodified{
|
|
|
|
|
get {return _lastmodified;}
|
|
|
|
|
set {_lastmodified = value;}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
|
|
public WmsOrderDetail getDbObject(){
|
|
|
|
|
|
|
|
|
|
WmsOrderDetail dbObj = new WmsOrderDetail(id);
|
|
|
|
|
dbObj.ID= id ;
|
|
|
|
|
dbObj.orderNo = orderNo;
|
|
|
|
|
|
|
|
|
|
dbObj.skuId = skuId;
|
|
|
|
|
|
|
|
|
|
dbObj.skuCode = skuCode;
|
|
|
|
|
|
|
|
|
|
dbObj.goodsId = goodsId;
|
|
|
|
|
|
|
|
|
|
dbObj.goodsName = goodsName;
|
|
|
|
|
|
|
|
|
|
dbObj.unit = unit;
|
|
|
|
|
|
|
|
|
|
dbObj.batch = batch;
|
|
|
|
|
|
|
|
|
|
dbObj.productDate = productDate;
|
|
|
|
|
|
|
|
|
|
dbObj.validDate = validDate;
|
|
|
|
|
|
|
|
|
|
dbObj.count = count;
|
|
|
|
|
|
2023-11-21 19:18:23 +08:00
|
|
|
|
dbObj.finishedCount = finishedCount;
|
|
|
|
|
|
2023-09-04 22:41:19 +08:00
|
|
|
|
dbObj.price = price;
|
|
|
|
|
|
|
|
|
|
dbObj.state = state;
|
|
|
|
|
|
|
|
|
|
dbObj.whtype = whtype;
|
|
|
|
|
|
|
|
|
|
dbObj.toWhType = toWhType;
|
|
|
|
|
|
|
|
|
|
dbObj.locationId = locationId;
|
|
|
|
|
|
|
|
|
|
dbObj.partion = partion;
|
|
|
|
|
|
|
|
|
|
dbObj.description = description;
|
|
|
|
|
|
|
|
|
|
dbObj.operater = operater;
|
|
|
|
|
|
|
|
|
|
return dbObj;
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
public WcfWmsOrderDetail getWcfObject( WmsOrderDetail dbObj){
|
|
|
|
|
|
|
|
|
|
WcfWmsOrderDetail wcfObj = new WcfWmsOrderDetail();
|
|
|
|
|
wcfObj.id= dbObj.ID;
|
|
|
|
|
wcfObj.orderNo = dbObj.orderNo;
|
|
|
|
|
|
|
|
|
|
wcfObj.skuId = dbObj.skuId;
|
|
|
|
|
|
|
|
|
|
wcfObj.skuCode = dbObj.skuCode;
|
|
|
|
|
|
|
|
|
|
wcfObj.goodsId = dbObj.goodsId;
|
|
|
|
|
|
|
|
|
|
wcfObj.goodsName = dbObj.goodsName;
|
|
|
|
|
|
|
|
|
|
wcfObj.unit = dbObj.unit;
|
|
|
|
|
|
|
|
|
|
wcfObj.batch = dbObj.batch;
|
|
|
|
|
|
|
|
|
|
wcfObj.productDate = dbObj.productDate;
|
|
|
|
|
|
|
|
|
|
wcfObj.validDate = dbObj.validDate;
|
|
|
|
|
|
|
|
|
|
wcfObj.count = dbObj.count;
|
|
|
|
|
|
2023-11-21 19:18:23 +08:00
|
|
|
|
wcfObj.finishedCount = dbObj.finishedCount;
|
|
|
|
|
|
2023-09-04 22:41:19 +08:00
|
|
|
|
wcfObj.price = dbObj.price;
|
|
|
|
|
|
|
|
|
|
wcfObj.state = dbObj.state;
|
|
|
|
|
|
|
|
|
|
wcfObj.whtype = dbObj.whtype;
|
|
|
|
|
|
|
|
|
|
wcfObj.toWhType = dbObj.toWhType;
|
|
|
|
|
|
|
|
|
|
wcfObj.locationId = dbObj.locationId;
|
|
|
|
|
|
|
|
|
|
wcfObj.partion = dbObj.partion;
|
|
|
|
|
|
|
|
|
|
wcfObj.description = dbObj.description;
|
|
|
|
|
|
|
|
|
|
wcfObj.operater = dbObj.operater;
|
|
|
|
|
|
|
|
|
|
return wcfObj;
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#endregion
|
|
|
|
|
}
|