/// ///WCF Data Object ///BASIC CLASS FOR TABLE t_erp_purch_d ///By wm ///on 01/13/2024 /// using System; using System.Runtime.Serialization; using System.Data; using DeiNiu.wms.Data.Model; namespace DeiNiu.wms.Data.Model.Wcf { #region WcfErp_purch_d /// /// This object represents the properties and methods of a WcfErp_purch_d. /// [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 }