659 lines
24 KiB
C#
659 lines
24 KiB
C#
/// <summary>
|
|
///WCF Data Object
|
|
///BASIC CLASS FOR TABLE t_erp_receiveValidDetail
|
|
///By wm
|
|
///on 07/21/2023
|
|
/// </summary>
|
|
|
|
using System;
|
|
using System.Runtime.Serialization;
|
|
using System.Data;
|
|
namespace DeiNiu.wms.Data.Model.Wcf
|
|
{
|
|
|
|
#region WcfErp_receiveValidDetail
|
|
/// <summary>
|
|
/// This object represents the properties and methods of a WcfErp_receiveValidDetail.
|
|
/// </summary>
|
|
[DataContract]
|
|
public class WcfErp_receiveValidDetail {
|
|
|
|
internal int _id;
|
|
internal string _flowNo= String.Empty;
|
|
internal string _receive_order= String.Empty;
|
|
internal int _purch_d_id;
|
|
internal string _preInOrder= String.Empty;
|
|
internal string _goods_id= String.Empty;
|
|
internal int _skuId;
|
|
internal string _skuCode= String.Empty;
|
|
internal string _batch= String.Empty;
|
|
internal string _productDate= String.Empty;
|
|
internal string _validDate= String.Empty;
|
|
internal decimal _valid_count;
|
|
internal decimal _seeds_count;
|
|
internal decimal _inCount;
|
|
internal decimal _upShelfCount;
|
|
internal int _validResult;
|
|
internal int _whType;
|
|
internal string _reason= String.Empty;
|
|
internal int _wms_state;
|
|
internal int _erp_state;
|
|
internal decimal _price;
|
|
internal int _validby;
|
|
internal int _validby1;
|
|
internal string _validByName= String.Empty;
|
|
internal string _validByName2= String.Empty;
|
|
internal string _validbyTime= String.Empty;
|
|
internal string _validbyTime1= String.Empty;
|
|
internal int _partion;
|
|
internal int _outDetailId;
|
|
internal string _poNo= String.Empty;
|
|
internal int _operater;
|
|
internal bool _dr;
|
|
internal string _createtime= String.Empty;
|
|
internal string _lastmodified= String.Empty;
|
|
|
|
public WcfErp_receiveValidDetail () {
|
|
}
|
|
|
|
public WcfErp_receiveValidDetail (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("flowNo") && !(dr["flowNo"] is DBNull))
|
|
{
|
|
_flowNo = dr["flowNo"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("receive_order") && !(dr["receive_order"] is DBNull))
|
|
{
|
|
_receive_order = dr["receive_order"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("purch_d_id") && !(dr["purch_d_id"] is DBNull))
|
|
{
|
|
_purch_d_id = Convert.ToInt32(dr["purch_d_id"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("preInOrder") && !(dr["preInOrder"] is DBNull))
|
|
{
|
|
_preInOrder = dr["preInOrder"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("goods_id") && !(dr["goods_id"] is DBNull))
|
|
{
|
|
_goods_id = dr["goods_id"].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("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("valid_count") && !(dr["valid_count"] is DBNull))
|
|
{
|
|
_valid_count = Convert.ToDecimal(dr["valid_count"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("seeds_count") && !(dr["seeds_count"] is DBNull))
|
|
{
|
|
_seeds_count = Convert.ToDecimal(dr["seeds_count"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("inCount") && !(dr["inCount"] is DBNull))
|
|
{
|
|
_inCount = Convert.ToDecimal(dr["inCount"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("upShelfCount") && !(dr["upShelfCount"] is DBNull))
|
|
{
|
|
_upShelfCount = Convert.ToDecimal(dr["upShelfCount"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("validResult") && !(dr["validResult"] is DBNull))
|
|
{
|
|
_validResult = Convert.ToInt32(dr["validResult"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("whType") && !(dr["whType"] is DBNull))
|
|
{
|
|
_whType = Convert.ToInt32(dr["whType"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("reason") && !(dr["reason"] is DBNull))
|
|
{
|
|
_reason = dr["reason"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("wms_state") && !(dr["wms_state"] is DBNull))
|
|
{
|
|
_wms_state = Convert.ToInt32(dr["wms_state"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("erp_state") && !(dr["erp_state"] is DBNull))
|
|
{
|
|
_erp_state = Convert.ToInt32(dr["erp_state"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("price") && !(dr["price"] is DBNull))
|
|
{
|
|
_price = Convert.ToDecimal(dr["price"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("validby") && !(dr["validby"] is DBNull))
|
|
{
|
|
_validby = Convert.ToInt32(dr["validby"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("validby1") && !(dr["validby1"] is DBNull))
|
|
{
|
|
_validby1 = Convert.ToInt32(dr["validby1"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("validByName") && !(dr["validByName"] is DBNull))
|
|
{
|
|
_validByName = dr["validByName"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("validByName2") && !(dr["validByName2"] is DBNull))
|
|
{
|
|
_validByName2 = dr["validByName2"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("validbyTime") && !(dr["validbyTime"] is DBNull))
|
|
{
|
|
_validbyTime = dr["validbyTime"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("validbyTime1") && !(dr["validbyTime1"] is DBNull))
|
|
{
|
|
_validbyTime1 = dr["validbyTime1"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("partion") && !(dr["partion"] is DBNull))
|
|
{
|
|
_partion = Convert.ToInt32(dr["partion"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("outDetailId") && !(dr["outDetailId"] is DBNull))
|
|
{
|
|
_outDetailId = Convert.ToInt32(dr["outDetailId"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("poNo") && !(dr["poNo"] is DBNull))
|
|
{
|
|
_poNo = dr["poNo"].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 WcfErp_receiveValidDetail( Erp_receiveValidDetail dbObj){
|
|
#region get data from dbobj
|
|
|
|
_id= dbObj.ID;
|
|
flowNo = dbObj.flowNo;
|
|
|
|
receive_order = dbObj.receive_order;
|
|
|
|
purch_d_id = dbObj.purch_d_id;
|
|
|
|
preInOrder = dbObj.preInOrder;
|
|
|
|
goods_id = dbObj.goods_id;
|
|
|
|
skuId = dbObj.skuId;
|
|
|
|
skuCode = dbObj.skuCode;
|
|
|
|
batch = dbObj.batch;
|
|
|
|
productDate = dbObj.productDate;
|
|
|
|
validDate = dbObj.validDate;
|
|
|
|
valid_count = dbObj.valid_count;
|
|
|
|
seeds_count = dbObj.seeds_count;
|
|
|
|
inCount = dbObj.inCount;
|
|
|
|
upShelfCount = dbObj.upShelfCount;
|
|
|
|
validResult = dbObj.validResult;
|
|
|
|
whType = dbObj.whType;
|
|
|
|
reason = dbObj.reason;
|
|
|
|
wms_state = dbObj.wms_state;
|
|
|
|
erp_state = dbObj.erp_state;
|
|
|
|
price = dbObj.price;
|
|
|
|
validby = dbObj.validby;
|
|
|
|
validby1 = dbObj.validby1;
|
|
|
|
validByName = dbObj.validByName;
|
|
|
|
validByName2 = dbObj.validByName2;
|
|
|
|
validbyTime = dbObj.validbyTime;
|
|
|
|
validbyTime1 = dbObj.validbyTime1;
|
|
|
|
partion = dbObj.partion;
|
|
|
|
outDetailId = dbObj.outDetailId;
|
|
|
|
poNo = dbObj.poNo;
|
|
|
|
operater = dbObj.operater;
|
|
|
|
#endregion
|
|
|
|
}
|
|
|
|
|
|
|
|
#region Public Properties
|
|
|
|
[DataMember]
|
|
public int id{
|
|
get {return _id;}
|
|
set {_id = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string flowNo{
|
|
get {return _flowNo;}
|
|
set {_flowNo = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string receive_order{
|
|
get {return _receive_order;}
|
|
set {_receive_order = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int purch_d_id{
|
|
get {return _purch_d_id;}
|
|
set {_purch_d_id = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string preInOrder{
|
|
get {return _preInOrder;}
|
|
set {_preInOrder = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string goods_id{
|
|
get {return _goods_id;}
|
|
set {_goods_id = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int skuId{
|
|
get {return _skuId;}
|
|
set {_skuId = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string skuCode{
|
|
get {return _skuCode;}
|
|
set {_skuCode = 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 valid_count{
|
|
get {return _valid_count;}
|
|
set {_valid_count = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal seeds_count{
|
|
get {return _seeds_count;}
|
|
set {_seeds_count = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal inCount{
|
|
get {return _inCount;}
|
|
set {_inCount = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal upShelfCount{
|
|
get {return _upShelfCount;}
|
|
set {_upShelfCount = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int validResult{
|
|
get {return _validResult;}
|
|
set {_validResult = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int whType{
|
|
get {return _whType;}
|
|
set {_whType = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string reason{
|
|
get {return _reason;}
|
|
set {_reason = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int wms_state{
|
|
get {return _wms_state;}
|
|
set {_wms_state = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int erp_state{
|
|
get {return _erp_state;}
|
|
set {_erp_state = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal price{
|
|
get {return _price;}
|
|
set {_price = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int validby{
|
|
get {return _validby;}
|
|
set {_validby = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int validby1{
|
|
get {return _validby1;}
|
|
set {_validby1 = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string validByName{
|
|
get {return _validByName;}
|
|
set {_validByName = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string validByName2{
|
|
get {return _validByName2;}
|
|
set {_validByName2 = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string validbyTime{
|
|
get {return _validbyTime;}
|
|
set {_validbyTime = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string validbyTime1{
|
|
get {return _validbyTime1;}
|
|
set {_validbyTime1 = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int partion{
|
|
get {return _partion;}
|
|
set {_partion = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int outDetailId{
|
|
get {return _outDetailId;}
|
|
set {_outDetailId = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string poNo{
|
|
get {return _poNo;}
|
|
set {_poNo = 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 Erp_receiveValidDetail getDbObject(){
|
|
|
|
Erp_receiveValidDetail dbObj = new Erp_receiveValidDetail(id);
|
|
dbObj.ID= id ;
|
|
dbObj.flowNo = flowNo;
|
|
|
|
dbObj.receive_order = receive_order;
|
|
|
|
dbObj.purch_d_id = purch_d_id;
|
|
|
|
dbObj.preInOrder = preInOrder;
|
|
|
|
dbObj.goods_id = goods_id;
|
|
|
|
dbObj.skuId = skuId;
|
|
|
|
dbObj.skuCode = skuCode;
|
|
|
|
dbObj.batch = batch;
|
|
|
|
dbObj.productDate = productDate;
|
|
|
|
dbObj.validDate = validDate;
|
|
|
|
dbObj.valid_count = valid_count;
|
|
|
|
dbObj.seeds_count = seeds_count;
|
|
|
|
dbObj.inCount = inCount;
|
|
|
|
dbObj.upShelfCount = upShelfCount;
|
|
|
|
dbObj.validResult = validResult;
|
|
|
|
dbObj.whType = whType;
|
|
|
|
dbObj.reason = reason;
|
|
|
|
dbObj.wms_state = wms_state;
|
|
|
|
dbObj.erp_state = erp_state;
|
|
|
|
dbObj.price = price;
|
|
|
|
dbObj.validby = validby;
|
|
|
|
dbObj.validby1 = validby1;
|
|
|
|
dbObj.validByName = validByName;
|
|
|
|
dbObj.validByName2 = validByName2;
|
|
|
|
dbObj.validbyTime = validbyTime;
|
|
|
|
dbObj.validbyTime1 = validbyTime1;
|
|
|
|
dbObj.partion = partion;
|
|
|
|
dbObj.outDetailId = outDetailId;
|
|
|
|
dbObj.poNo = poNo;
|
|
|
|
dbObj.operater = operater;
|
|
|
|
return dbObj;
|
|
|
|
}
|
|
|
|
|
|
|
|
public WcfErp_receiveValidDetail getWcfObject( Erp_receiveValidDetail dbObj){
|
|
|
|
WcfErp_receiveValidDetail wcfObj = new WcfErp_receiveValidDetail();
|
|
wcfObj.id= dbObj.ID;
|
|
wcfObj.flowNo = dbObj.flowNo;
|
|
|
|
wcfObj.receive_order = dbObj.receive_order;
|
|
|
|
wcfObj.purch_d_id = dbObj.purch_d_id;
|
|
|
|
wcfObj.preInOrder = dbObj.preInOrder;
|
|
|
|
wcfObj.goods_id = dbObj.goods_id;
|
|
|
|
wcfObj.skuId = dbObj.skuId;
|
|
|
|
wcfObj.skuCode = dbObj.skuCode;
|
|
|
|
wcfObj.batch = dbObj.batch;
|
|
|
|
wcfObj.productDate = dbObj.productDate;
|
|
|
|
wcfObj.validDate = dbObj.validDate;
|
|
|
|
wcfObj.valid_count = dbObj.valid_count;
|
|
|
|
wcfObj.seeds_count = dbObj.seeds_count;
|
|
|
|
wcfObj.inCount = dbObj.inCount;
|
|
|
|
wcfObj.upShelfCount = dbObj.upShelfCount;
|
|
|
|
wcfObj.validResult = dbObj.validResult;
|
|
|
|
wcfObj.whType = dbObj.whType;
|
|
|
|
wcfObj.reason = dbObj.reason;
|
|
|
|
wcfObj.wms_state = dbObj.wms_state;
|
|
|
|
wcfObj.erp_state = dbObj.erp_state;
|
|
|
|
wcfObj.price = dbObj.price;
|
|
|
|
wcfObj.validby = dbObj.validby;
|
|
|
|
wcfObj.validby1 = dbObj.validby1;
|
|
|
|
wcfObj.validByName = dbObj.validByName;
|
|
|
|
wcfObj.validByName2 = dbObj.validByName2;
|
|
|
|
wcfObj.validbyTime = dbObj.validbyTime;
|
|
|
|
wcfObj.validbyTime1 = dbObj.validbyTime1;
|
|
|
|
wcfObj.partion = dbObj.partion;
|
|
|
|
wcfObj.outDetailId = dbObj.outDetailId;
|
|
|
|
wcfObj.poNo = dbObj.poNo;
|
|
|
|
wcfObj.operater = dbObj.operater;
|
|
|
|
return wcfObj;
|
|
|
|
}
|
|
|
|
}
|
|
|
|
|
|
|
|
#endregion
|
|
}
|