ldj/WcfServiceErp/wcfData/wcfErp_sale_d.cs

839 lines
30 KiB
C#

/// <summary>
///WCF Data Object
///BASIC CLASS FOR TABLE t_erp_sale_d
///By wm
///on 06/06/2023
/// </summary>
using System;
using System.Runtime.Serialization;
using System.Data;
namespace DeiNiu.wms.Data.Model.Wcf
{
#region WcfErp_sale_d
/// <summary>
/// This object represents the properties and methods of a WcfErp_sale_d.
/// </summary>
[DataContract]
public class WcfErp_sale_d {
internal int _id;
internal string _sale_order= String.Empty;
internal int _sale_order_sn;
internal string _order_type= String.Empty;
internal int _erp_state;
internal int _wms_state;
internal string _purchseOrder= String.Empty;
internal decimal _price;
internal decimal _packingQty;
internal int _priority;
internal string _goods_id= String.Empty;
internal int _skuId;
internal string _skuCode= String.Empty;
internal string _batch= String.Empty;
internal string _product_date= String.Empty;
internal string _save_date= String.Empty;
internal decimal _count;
internal decimal _reviseCount;
internal decimal _pickCount;
internal string _add_date= String.Empty;
internal string _entid= String.Empty;
internal string _orgid= String.Empty;
internal string _oppcontid= String.Empty;
internal int _whtype;
internal string _whname= String.Empty;
internal string _suppliersId= String.Empty;
internal string _validBy= String.Empty;
internal string _validByTime= String.Empty;
internal string _validBy1= String.Empty;
internal string _validByTime1= String.Empty;
internal string _locationid= String.Empty;
internal bool _liangdeng;
internal bool _fuhezt;
internal bool _dengmie;
internal string _checkedBy2= String.Empty;
internal string _checkedBy2time= String.Empty;
internal string _ext1= String.Empty;
internal string _ext2= String.Empty;
internal string _ext3= String.Empty;
internal string _ext4= String.Empty;
internal int _operater;
internal string _lastmodified= String.Empty;
internal string _createtime= String.Empty;
internal bool _dr;
public WcfErp_sale_d () {
}
public WcfErp_sale_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("sale_order") && !(dr["sale_order"] is DBNull))
{
_sale_order = dr["sale_order"].ToString() ;
}
if (dr.Table.Columns.Contains("sale_order_sn") && !(dr["sale_order_sn"] is DBNull))
{
_sale_order_sn = Convert.ToInt32(dr["sale_order_sn"].ToString()); ;
}
if (dr.Table.Columns.Contains("order_type") && !(dr["order_type"] is DBNull))
{
_order_type = dr["order_type"].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("purchseOrder") && !(dr["purchseOrder"] is DBNull))
{
_purchseOrder = dr["purchseOrder"].ToString() ;
}
if (dr.Table.Columns.Contains("price") && !(dr["price"] is DBNull))
{
_price = Convert.ToDecimal(dr["price"].ToString()); ;
}
if (dr.Table.Columns.Contains("packingQty") && !(dr["packingQty"] is DBNull))
{
_packingQty = Convert.ToDecimal(dr["packingQty"].ToString()); ;
}
if (dr.Table.Columns.Contains("priority") && !(dr["priority"] is DBNull))
{
_priority = Convert.ToInt32(dr["priority"].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("product_date") && !(dr["product_date"] is DBNull))
{
_product_date = dr["product_date"].ToString() ;
}
if (dr.Table.Columns.Contains("save_date") && !(dr["save_date"] is DBNull))
{
_save_date = dr["save_date"].ToString() ;
}
if (dr.Table.Columns.Contains("count") && !(dr["count"] is DBNull))
{
_count = Convert.ToDecimal(dr["count"].ToString()); ;
}
if (dr.Table.Columns.Contains("reviseCount") && !(dr["reviseCount"] is DBNull))
{
_reviseCount = Convert.ToDecimal(dr["reviseCount"].ToString()); ;
}
if (dr.Table.Columns.Contains("pickCount") && !(dr["pickCount"] is DBNull))
{
_pickCount = Convert.ToDecimal(dr["pickCount"].ToString()); ;
}
if (dr.Table.Columns.Contains("add_date") && !(dr["add_date"] is DBNull))
{
_add_date = dr["add_date"].ToString() ;
}
if (dr.Table.Columns.Contains("entid") && !(dr["entid"] is DBNull))
{
_entid = dr["entid"].ToString() ;
}
if (dr.Table.Columns.Contains("orgid") && !(dr["orgid"] is DBNull))
{
_orgid = dr["orgid"].ToString() ;
}
if (dr.Table.Columns.Contains("oppcontid") && !(dr["oppcontid"] is DBNull))
{
_oppcontid = dr["oppcontid"].ToString() ;
}
if (dr.Table.Columns.Contains("whtype") && !(dr["whtype"] is DBNull))
{
_whtype = Convert.ToInt32(dr["whtype"].ToString()); ;
}
if (dr.Table.Columns.Contains("whname") && !(dr["whname"] is DBNull))
{
_whname = dr["whname"].ToString() ;
}
if (dr.Table.Columns.Contains("suppliersId") && !(dr["suppliersId"] is DBNull))
{
_suppliersId = dr["suppliersId"].ToString() ;
}
if (dr.Table.Columns.Contains("validBy") && !(dr["validBy"] is DBNull))
{
_validBy = dr["validBy"].ToString() ;
}
if (dr.Table.Columns.Contains("validByTime") && !(dr["validByTime"] is DBNull))
{
_validByTime = dr["validByTime"].ToString() ;
}
if (dr.Table.Columns.Contains("validBy1") && !(dr["validBy1"] is DBNull))
{
_validBy1 = dr["validBy1"].ToString() ;
}
if (dr.Table.Columns.Contains("validByTime1") && !(dr["validByTime1"] is DBNull))
{
_validByTime1 = dr["validByTime1"].ToString() ;
}
if (dr.Table.Columns.Contains("locationid") && !(dr["locationid"] is DBNull))
{
_locationid = dr["locationid"].ToString() ;
}
if (dr.Table.Columns.Contains("liangdeng") && !(dr["liangdeng"] is DBNull))
{
_liangdeng = Convert.ToBoolean(dr["liangdeng"].ToString()); ;
}
if (dr.Table.Columns.Contains("fuhezt") && !(dr["fuhezt"] is DBNull))
{
_fuhezt = Convert.ToBoolean(dr["fuhezt"].ToString()); ;
}
if (dr.Table.Columns.Contains("dengmie") && !(dr["dengmie"] is DBNull))
{
_dengmie = Convert.ToBoolean(dr["dengmie"].ToString()); ;
}
if (dr.Table.Columns.Contains("checkedBy2") && !(dr["checkedBy2"] is DBNull))
{
_checkedBy2 = dr["checkedBy2"].ToString() ;
}
if (dr.Table.Columns.Contains("checkedBy2time") && !(dr["checkedBy2time"] is DBNull))
{
_checkedBy2time = dr["checkedBy2time"].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("lastmodified") && !(dr["lastmodified"] is DBNull))
{
_lastmodified = dr["lastmodified"].ToString() ;
}
if (dr.Table.Columns.Contains("createtime") && !(dr["createtime"] is DBNull))
{
_createtime = dr["createtime"].ToString() ;
}
if (dr.Table.Columns.Contains("dr") && !(dr["dr"] is DBNull))
{
_dr = Convert.ToBoolean(dr["dr"].ToString()); ;
}
}
#endregion
}
public WcfErp_sale_d( Erp_sale_d dbObj){
#region get data from dbobj
_id= dbObj.ID;
sale_order = dbObj.sale_order;
sale_order_sn = dbObj.sale_order_sn;
order_type = dbObj.order_type;
erp_state = dbObj.erp_state;
wms_state = dbObj.wms_state;
purchseOrder = dbObj.purchseOrder;
price = dbObj.price;
packingQty = dbObj.packingQty;
priority = dbObj.priority;
goods_id = dbObj.goods_id;
skuId = dbObj.skuId;
skuCode = dbObj.skuCode;
batch = dbObj.batch;
product_date = dbObj.product_date;
save_date = dbObj.save_date;
count = dbObj.count;
reviseCount = dbObj.reviseCount;
pickCount = dbObj.pickCount;
add_date = dbObj.add_date;
entid = dbObj.entid;
orgid = dbObj.orgid;
oppcontid = dbObj.oppcontid;
whtype = dbObj.whtype;
whname = dbObj.whname;
suppliersId = dbObj.suppliersId;
validBy = dbObj.validBy;
validByTime = dbObj.validByTime;
validBy1 = dbObj.validBy1;
validByTime1 = dbObj.validByTime1;
locationid = dbObj.locationid;
liangdeng = dbObj.liangdeng;
fuhezt = dbObj.fuhezt;
dengmie = dbObj.dengmie;
checkedBy2 = dbObj.checkedBy2;
checkedBy2time = dbObj.checkedBy2time;
ext1 = dbObj.ext1;
ext2 = dbObj.ext2;
ext3 = dbObj.ext3;
ext4 = dbObj.ext4;
operater = dbObj.operater;
#endregion
}
#region Public Properties
[DataMember]
public int id{
get {return _id;}
set {_id = value;}
}
[DataMember]
public string sale_order{
get {return _sale_order;}
set {_sale_order = value;}
}
[DataMember]
public int sale_order_sn{
get {return _sale_order_sn;}
set {_sale_order_sn = value;}
}
[DataMember]
public string order_type{
get {return _order_type;}
set {_order_type = 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 string purchseOrder{
get {return _purchseOrder;}
set {_purchseOrder = value;}
}
[DataMember]
public decimal price{
get {return _price;}
set {_price = value;}
}
[DataMember]
public decimal packingQty{
get {return _packingQty;}
set {_packingQty = value;}
}
[DataMember]
public int priority{
get {return _priority;}
set {_priority = 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 product_date{
get {return _product_date;}
set {_product_date = value;}
}
[DataMember]
public string save_date{
get {return _save_date;}
set {_save_date = value;}
}
[DataMember]
public decimal count{
get {return _count;}
set {_count = value;}
}
[DataMember]
public decimal reviseCount{
get {return _reviseCount;}
set {_reviseCount = value;}
}
[DataMember]
public decimal pickCount{
get {return _pickCount;}
set {_pickCount = value;}
}
[DataMember]
public string add_date{
get {return _add_date;}
set {_add_date = value;}
}
[DataMember]
public string entid{
get {return _entid;}
set {_entid = value;}
}
[DataMember]
public string orgid{
get {return _orgid;}
set {_orgid = value;}
}
[DataMember]
public string oppcontid{
get {return _oppcontid;}
set {_oppcontid = value;}
}
[DataMember]
public int whtype{
get {return _whtype;}
set {_whtype = value;}
}
[DataMember]
public string whname{
get {return _whname;}
set {_whname = value;}
}
[DataMember]
public string suppliersId{
get {return _suppliersId;}
set {_suppliersId = value;}
}
[DataMember]
public string validBy{
get {return _validBy;}
set {_validBy = value;}
}
[DataMember]
public string validByTime{
get {return _validByTime;}
set {_validByTime = value;}
}
[DataMember]
public string validBy1{
get {return _validBy1;}
set {_validBy1 = value;}
}
[DataMember]
public string validByTime1{
get {return _validByTime1;}
set {_validByTime1 = value;}
}
[DataMember]
public string locationid{
get {return _locationid;}
set {_locationid = value;}
}
[DataMember]
public bool liangdeng{
get {return _liangdeng;}
set {_liangdeng = value;}
}
[DataMember]
public bool fuhezt{
get {return _fuhezt;}
set {_fuhezt = value;}
}
[DataMember]
public bool dengmie{
get {return _dengmie;}
set {_dengmie = value;}
}
[DataMember]
public string checkedBy2{
get {return _checkedBy2;}
set {_checkedBy2 = value;}
}
[DataMember]
public string checkedBy2time{
get {return _checkedBy2time;}
set {_checkedBy2time = 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 string lastmodified{
get {return _lastmodified;}
set {_lastmodified = value;}
}
[DataMember]
public string createtime{
get {return _createtime;}
set {_createtime = value;}
}
[DataMember]
public bool dr{
get {return _dr;}
set {_dr = value;}
}
#endregion
public Erp_sale_d getDbObject(){
Erp_sale_d dbObj = new Erp_sale_d(id);
dbObj.ID= id ;
dbObj.sale_order = sale_order;
dbObj.sale_order_sn = sale_order_sn;
dbObj.order_type = order_type;
dbObj.erp_state = erp_state;
dbObj.wms_state = wms_state;
dbObj.purchseOrder = purchseOrder;
dbObj.price = price;
dbObj.packingQty = packingQty;
dbObj.priority = priority;
dbObj.goods_id = goods_id;
dbObj.skuId = skuId;
dbObj.skuCode = skuCode;
dbObj.batch = batch;
dbObj.product_date = product_date;
dbObj.save_date = save_date;
dbObj.count = count;
dbObj.reviseCount = reviseCount;
dbObj.pickCount = pickCount;
dbObj.add_date = add_date;
dbObj.entid = entid;
dbObj.orgid = orgid;
dbObj.oppcontid = oppcontid;
dbObj.whtype = whtype;
dbObj.whname = whname;
dbObj.suppliersId = suppliersId;
dbObj.validBy = validBy;
dbObj.validByTime = validByTime;
dbObj.validBy1 = validBy1;
dbObj.validByTime1 = validByTime1;
dbObj.locationid = locationid;
dbObj.liangdeng = liangdeng;
dbObj.fuhezt = fuhezt;
dbObj.dengmie = dengmie;
dbObj.checkedBy2 = checkedBy2;
dbObj.checkedBy2time = checkedBy2time;
dbObj.ext1 = ext1;
dbObj.ext2 = ext2;
dbObj.ext3 = ext3;
dbObj.ext4 = ext4;
dbObj.operater = operater;
return dbObj;
}
public WcfErp_sale_d getWcfObject( Erp_sale_d dbObj){
WcfErp_sale_d wcfObj = new WcfErp_sale_d();
wcfObj.id= dbObj.ID;
wcfObj.sale_order = dbObj.sale_order;
wcfObj.sale_order_sn = dbObj.sale_order_sn;
wcfObj.order_type = dbObj.order_type;
wcfObj.erp_state = dbObj.erp_state;
wcfObj.wms_state = dbObj.wms_state;
wcfObj.purchseOrder = dbObj.purchseOrder;
wcfObj.price = dbObj.price;
wcfObj.packingQty = dbObj.packingQty;
wcfObj.priority = dbObj.priority;
wcfObj.goods_id = dbObj.goods_id;
wcfObj.skuId = dbObj.skuId;
wcfObj.skuCode = dbObj.skuCode;
wcfObj.batch = dbObj.batch;
wcfObj.product_date = dbObj.product_date;
wcfObj.save_date = dbObj.save_date;
wcfObj.count = dbObj.count;
wcfObj.reviseCount = dbObj.reviseCount;
wcfObj.pickCount = dbObj.pickCount;
wcfObj.add_date = dbObj.add_date;
wcfObj.entid = dbObj.entid;
wcfObj.orgid = dbObj.orgid;
wcfObj.oppcontid = dbObj.oppcontid;
wcfObj.whtype = dbObj.whtype;
wcfObj.whname = dbObj.whname;
wcfObj.suppliersId = dbObj.suppliersId;
wcfObj.validBy = dbObj.validBy;
wcfObj.validByTime = dbObj.validByTime;
wcfObj.validBy1 = dbObj.validBy1;
wcfObj.validByTime1 = dbObj.validByTime1;
wcfObj.locationid = dbObj.locationid;
wcfObj.liangdeng = dbObj.liangdeng;
wcfObj.fuhezt = dbObj.fuhezt;
wcfObj.dengmie = dbObj.dengmie;
wcfObj.checkedBy2 = dbObj.checkedBy2;
wcfObj.checkedBy2time = dbObj.checkedBy2time;
wcfObj.ext1 = dbObj.ext1;
wcfObj.ext2 = dbObj.ext2;
wcfObj.ext3 = dbObj.ext3;
wcfObj.ext4 = dbObj.ext4;
wcfObj.operater = dbObj.operater;
return wcfObj;
}
}
#endregion
}