714 lines
26 KiB
C#
714 lines
26 KiB
C#
/// <summary>
|
|
///WCF Data Object
|
|
///BASIC CLASS FOR TABLE t_erp_purch_d
|
|
///By wm
|
|
///on 01/13/2024
|
|
/// </summary>
|
|
|
|
using System;
|
|
using System.Runtime.Serialization;
|
|
using System.Data;
|
|
using DeiNiu.wms.Data.Model;
|
|
namespace DeiNiu.wms.Data.Model.Wcf
|
|
{
|
|
|
|
#region WcfErp_purch_d
|
|
/// <summary>
|
|
/// This object represents the properties and methods of a WcfErp_purch_d.
|
|
/// </summary>
|
|
[DataContract]
|
|
public class WcfErp_purch_d {
|
|
|
|
internal int _id;
|
|
internal string _pur_order= String.Empty;
|
|
internal int _pur_order_sn;
|
|
internal decimal _packingQty;
|
|
internal string _goods_id= String.Empty;
|
|
internal string _batch= String.Empty;
|
|
internal string _productDate= String.Empty;
|
|
internal string _validDate= String.Empty;
|
|
internal decimal _count;
|
|
internal decimal _arriveCount;
|
|
internal decimal _receiveCount;
|
|
internal string _receiveRemark= String.Empty;
|
|
internal decimal _rejectCount;
|
|
internal decimal _validCount;
|
|
internal decimal _onShelfCount;
|
|
internal int _storeType;
|
|
internal int _zhitongPartion;
|
|
internal string _customerId= String.Empty;
|
|
internal decimal _custQty;
|
|
internal string _custPoNo= String.Empty;
|
|
internal string _custNote= String.Empty;
|
|
internal string _add_date= String.Empty;
|
|
internal int _erp_state;
|
|
internal int _wms_state;
|
|
internal decimal _price;
|
|
internal string _ext1= String.Empty;
|
|
internal string _ext2= String.Empty;
|
|
internal string _ext3= String.Empty;
|
|
internal string _ext4= String.Empty;
|
|
internal int _operater;
|
|
internal bool _dr;
|
|
internal string _createtime= String.Empty;
|
|
internal string _lastmodified= String.Empty;
|
|
internal bool _ERP_Down;
|
|
internal string _ERP_Down_Date= String.Empty;
|
|
internal string _ERP_Down_User= String.Empty;
|
|
internal string _entid= String.Empty;
|
|
|
|
public WcfErp_purch_d () {
|
|
}
|
|
|
|
public WcfErp_purch_d (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("pur_order") && !(dr["pur_order"] is DBNull))
|
|
{
|
|
_pur_order = dr["pur_order"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("pur_order_sn") && !(dr["pur_order_sn"] is DBNull))
|
|
{
|
|
_pur_order_sn = Convert.ToInt32(dr["pur_order_sn"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("packingQty") && !(dr["packingQty"] is DBNull))
|
|
{
|
|
_packingQty = Convert.ToDecimal(dr["packingQty"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("goods_id") && !(dr["goods_id"] is DBNull))
|
|
{
|
|
_goods_id = dr["goods_id"].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()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("arriveCount") && !(dr["arriveCount"] is DBNull))
|
|
{
|
|
_arriveCount = Convert.ToDecimal(dr["arriveCount"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("receiveCount") && !(dr["receiveCount"] is DBNull))
|
|
{
|
|
_receiveCount = Convert.ToDecimal(dr["receiveCount"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("receiveRemark") && !(dr["receiveRemark"] is DBNull))
|
|
{
|
|
_receiveRemark = dr["receiveRemark"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("rejectCount") && !(dr["rejectCount"] is DBNull))
|
|
{
|
|
_rejectCount = Convert.ToDecimal(dr["rejectCount"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("validCount") && !(dr["validCount"] is DBNull))
|
|
{
|
|
_validCount = Convert.ToDecimal(dr["validCount"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("onShelfCount") && !(dr["onShelfCount"] is DBNull))
|
|
{
|
|
_onShelfCount = Convert.ToDecimal(dr["onShelfCount"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("storeType") && !(dr["storeType"] is DBNull))
|
|
{
|
|
_storeType = Convert.ToInt32(dr["storeType"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("zhitongPartion") && !(dr["zhitongPartion"] is DBNull))
|
|
{
|
|
_zhitongPartion = Convert.ToInt32(dr["zhitongPartion"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("customerId") && !(dr["customerId"] is DBNull))
|
|
{
|
|
_customerId = dr["customerId"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("custQty") && !(dr["custQty"] is DBNull))
|
|
{
|
|
_custQty = Convert.ToDecimal(dr["custQty"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("custPoNo") && !(dr["custPoNo"] is DBNull))
|
|
{
|
|
_custPoNo = dr["custPoNo"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("custNote") && !(dr["custNote"] is DBNull))
|
|
{
|
|
_custNote = dr["custNote"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("add_date") && !(dr["add_date"] is DBNull))
|
|
{
|
|
_add_date = dr["add_date"].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("wms_state") && !(dr["wms_state"] is DBNull))
|
|
{
|
|
_wms_state = Convert.ToInt32(dr["wms_state"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("price") && !(dr["price"] is DBNull))
|
|
{
|
|
_price = Convert.ToDecimal(dr["price"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("ext1") && !(dr["ext1"] is DBNull))
|
|
{
|
|
_ext1 = dr["ext1"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("ext2") && !(dr["ext2"] is DBNull))
|
|
{
|
|
_ext2 = dr["ext2"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("ext3") && !(dr["ext3"] is DBNull))
|
|
{
|
|
_ext3 = dr["ext3"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("ext4") && !(dr["ext4"] is DBNull))
|
|
{
|
|
_ext4 = dr["ext4"].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() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("ERP_Down") && !(dr["ERP_Down"] is DBNull))
|
|
{
|
|
_ERP_Down = Convert.ToBoolean(dr["ERP_Down"].ToString()); ;
|
|
}
|
|
if (dr.Table.Columns.Contains("ERP_Down_Date") && !(dr["ERP_Down_Date"] is DBNull))
|
|
{
|
|
_ERP_Down_Date = dr["ERP_Down_Date"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("ERP_Down_User") && !(dr["ERP_Down_User"] is DBNull))
|
|
{
|
|
_ERP_Down_User = dr["ERP_Down_User"].ToString() ;
|
|
}
|
|
if (dr.Table.Columns.Contains("entid") && !(dr["entid"] is DBNull))
|
|
{
|
|
_entid = dr["entid"].ToString() ;
|
|
}
|
|
}
|
|
#endregion
|
|
}
|
|
|
|
public WcfErp_purch_d( Erp_purch_d dbObj){
|
|
#region get data from dbobj
|
|
|
|
_id= dbObj.ID;
|
|
pur_order = dbObj.pur_order;
|
|
|
|
pur_order_sn = dbObj.pur_order_sn;
|
|
|
|
packingQty = dbObj.packingQty;
|
|
|
|
goods_id = dbObj.goods_id;
|
|
|
|
batch = dbObj.batch;
|
|
|
|
productDate = dbObj.productDate;
|
|
|
|
validDate = dbObj.validDate;
|
|
|
|
count = dbObj.count;
|
|
|
|
arriveCount = dbObj.arriveCount;
|
|
|
|
receiveCount = dbObj.receiveCount;
|
|
|
|
receiveRemark = dbObj.receiveRemark;
|
|
|
|
rejectCount = dbObj.rejectCount;
|
|
|
|
validCount = dbObj.validCount;
|
|
|
|
onShelfCount = dbObj.onShelfCount;
|
|
|
|
storeType = dbObj.storeType;
|
|
|
|
zhitongPartion = dbObj.zhitongPartion;
|
|
|
|
customerId = dbObj.customerId;
|
|
|
|
custQty = dbObj.custQty;
|
|
|
|
custPoNo = dbObj.custPoNo;
|
|
|
|
custNote = dbObj.custNote;
|
|
|
|
add_date = dbObj.add_date;
|
|
|
|
erp_state = dbObj.erp_state;
|
|
|
|
wms_state = dbObj.wms_state;
|
|
|
|
price = dbObj.price;
|
|
|
|
ext1 = dbObj.ext1;
|
|
|
|
ext2 = dbObj.ext2;
|
|
|
|
ext3 = dbObj.ext3;
|
|
|
|
ext4 = dbObj.ext4;
|
|
|
|
operater = dbObj.operater;
|
|
|
|
ERP_Down = dbObj.ERP_Down;
|
|
|
|
ERP_Down_Date = dbObj.ERP_Down_Date;
|
|
|
|
ERP_Down_User = dbObj.ERP_Down_User;
|
|
|
|
entid = dbObj.entid;
|
|
|
|
#endregion
|
|
|
|
}
|
|
|
|
|
|
|
|
#region Public Properties
|
|
|
|
[DataMember]
|
|
public int id{
|
|
get {return _id;}
|
|
set {_id = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string pur_order{
|
|
get {return _pur_order;}
|
|
set {_pur_order = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int pur_order_sn{
|
|
get {return _pur_order_sn;}
|
|
set {_pur_order_sn = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal packingQty{
|
|
get {return _packingQty;}
|
|
set {_packingQty = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string goods_id{
|
|
get {return _goods_id;}
|
|
set {_goods_id = 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;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal arriveCount{
|
|
get {return _arriveCount;}
|
|
set {_arriveCount = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal receiveCount{
|
|
get {return _receiveCount;}
|
|
set {_receiveCount = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string receiveRemark{
|
|
get {return _receiveRemark;}
|
|
set {_receiveRemark = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal rejectCount{
|
|
get {return _rejectCount;}
|
|
set {_rejectCount = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal validCount{
|
|
get {return _validCount;}
|
|
set {_validCount = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal onShelfCount{
|
|
get {return _onShelfCount;}
|
|
set {_onShelfCount = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int storeType{
|
|
get {return _storeType;}
|
|
set {_storeType = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int zhitongPartion{
|
|
get {return _zhitongPartion;}
|
|
set {_zhitongPartion = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string customerId{
|
|
get {return _customerId;}
|
|
set {_customerId = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal custQty{
|
|
get {return _custQty;}
|
|
set {_custQty = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string custPoNo{
|
|
get {return _custPoNo;}
|
|
set {_custPoNo = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string custNote{
|
|
get {return _custNote;}
|
|
set {_custNote = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string add_date{
|
|
get {return _add_date;}
|
|
set {_add_date = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int erp_state{
|
|
get {return _erp_state;}
|
|
set {_erp_state = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public int wms_state{
|
|
get {return _wms_state;}
|
|
set {_wms_state = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public decimal price{
|
|
get {return _price;}
|
|
set {_price = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string ext1{
|
|
get {return _ext1;}
|
|
set {_ext1 = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string ext2{
|
|
get {return _ext2;}
|
|
set {_ext2 = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string ext3{
|
|
get {return _ext3;}
|
|
set {_ext3 = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string ext4{
|
|
get {return _ext4;}
|
|
set {_ext4 = 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;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public bool ERP_Down{
|
|
get {return _ERP_Down;}
|
|
set {_ERP_Down = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string ERP_Down_Date{
|
|
get {return _ERP_Down_Date;}
|
|
set {_ERP_Down_Date = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string ERP_Down_User{
|
|
get {return _ERP_Down_User;}
|
|
set {_ERP_Down_User = value;}
|
|
}
|
|
|
|
|
|
[DataMember]
|
|
public string entid{
|
|
get {return _entid;}
|
|
set {_entid = value;}
|
|
}
|
|
|
|
|
|
#endregion
|
|
|
|
public Erp_purch_d getDbObject(){
|
|
|
|
Erp_purch_d dbObj = new Erp_purch_d(id);
|
|
dbObj.ID= id ;
|
|
dbObj.pur_order = pur_order;
|
|
|
|
dbObj.pur_order_sn = pur_order_sn;
|
|
|
|
dbObj.packingQty = packingQty;
|
|
|
|
dbObj.goods_id = goods_id;
|
|
|
|
dbObj.batch = batch;
|
|
|
|
dbObj.productDate = productDate;
|
|
|
|
dbObj.validDate = validDate;
|
|
|
|
dbObj.count = count;
|
|
|
|
dbObj.arriveCount = arriveCount;
|
|
|
|
dbObj.receiveCount = receiveCount;
|
|
|
|
dbObj.receiveRemark = receiveRemark;
|
|
|
|
dbObj.rejectCount = rejectCount;
|
|
|
|
dbObj.validCount = validCount;
|
|
|
|
dbObj.onShelfCount = onShelfCount;
|
|
|
|
dbObj.storeType = storeType;
|
|
|
|
dbObj.zhitongPartion = zhitongPartion;
|
|
|
|
dbObj.customerId = customerId;
|
|
|
|
dbObj.custQty = custQty;
|
|
|
|
dbObj.custPoNo = custPoNo;
|
|
|
|
dbObj.custNote = custNote;
|
|
|
|
dbObj.add_date = add_date;
|
|
|
|
dbObj.erp_state = erp_state;
|
|
|
|
dbObj.wms_state = wms_state;
|
|
|
|
dbObj.price = price;
|
|
|
|
dbObj.ext1 = ext1;
|
|
|
|
dbObj.ext2 = ext2;
|
|
|
|
dbObj.ext3 = ext3;
|
|
|
|
dbObj.ext4 = ext4;
|
|
|
|
dbObj.operater = operater;
|
|
|
|
dbObj.ERP_Down = ERP_Down;
|
|
|
|
dbObj.ERP_Down_Date = ERP_Down_Date;
|
|
|
|
dbObj.ERP_Down_User = ERP_Down_User;
|
|
|
|
dbObj.entid = entid;
|
|
|
|
return dbObj;
|
|
|
|
}
|
|
|
|
|
|
|
|
public WcfErp_purch_d getWcfObject( Erp_purch_d dbObj){
|
|
|
|
WcfErp_purch_d wcfObj = new WcfErp_purch_d();
|
|
wcfObj.id= dbObj.ID;
|
|
wcfObj.pur_order = dbObj.pur_order;
|
|
|
|
wcfObj.pur_order_sn = dbObj.pur_order_sn;
|
|
|
|
wcfObj.packingQty = dbObj.packingQty;
|
|
|
|
wcfObj.goods_id = dbObj.goods_id;
|
|
|
|
wcfObj.batch = dbObj.batch;
|
|
|
|
wcfObj.productDate = dbObj.productDate;
|
|
|
|
wcfObj.validDate = dbObj.validDate;
|
|
|
|
wcfObj.count = dbObj.count;
|
|
|
|
wcfObj.arriveCount = dbObj.arriveCount;
|
|
|
|
wcfObj.receiveCount = dbObj.receiveCount;
|
|
|
|
wcfObj.receiveRemark = dbObj.receiveRemark;
|
|
|
|
wcfObj.rejectCount = dbObj.rejectCount;
|
|
|
|
wcfObj.validCount = dbObj.validCount;
|
|
|
|
wcfObj.onShelfCount = dbObj.onShelfCount;
|
|
|
|
wcfObj.storeType = dbObj.storeType;
|
|
|
|
wcfObj.zhitongPartion = dbObj.zhitongPartion;
|
|
|
|
wcfObj.customerId = dbObj.customerId;
|
|
|
|
wcfObj.custQty = dbObj.custQty;
|
|
|
|
wcfObj.custPoNo = dbObj.custPoNo;
|
|
|
|
wcfObj.custNote = dbObj.custNote;
|
|
|
|
wcfObj.add_date = dbObj.add_date;
|
|
|
|
wcfObj.erp_state = dbObj.erp_state;
|
|
|
|
wcfObj.wms_state = dbObj.wms_state;
|
|
|
|
wcfObj.price = dbObj.price;
|
|
|
|
wcfObj.ext1 = dbObj.ext1;
|
|
|
|
wcfObj.ext2 = dbObj.ext2;
|
|
|
|
wcfObj.ext3 = dbObj.ext3;
|
|
|
|
wcfObj.ext4 = dbObj.ext4;
|
|
|
|
wcfObj.operater = dbObj.operater;
|
|
|
|
wcfObj.ERP_Down = dbObj.ERP_Down;
|
|
|
|
wcfObj.ERP_Down_Date = dbObj.ERP_Down_Date;
|
|
|
|
wcfObj.ERP_Down_User = dbObj.ERP_Down_User;
|
|
|
|
wcfObj.entid = dbObj.entid;
|
|
|
|
return wcfObj;
|
|
|
|
}
|
|
|
|
}
|
|
|
|
|
|
|
|
#endregion
|
|
}
|