2023-05-23 16:13:17 +08:00
/// <summary>
///Data Implemention Object
///BASIC CRUD CLASS FOR TABLE t_erp_sale_d
///By wm
2024-02-06 19:36:47 +08:00
///on 01/13/2024
2023-05-23 16:13:17 +08:00
/// </summary>
using System ;
using DeiNiu.Utils ;
using System.Data.SqlClient ;
using DeiNiu.Data.BaseObject ;
using System.Data ;
namespace DeiNiu.wms.Data.Model
{
#region Erp_sale_d_base_Imp
[Serializable] class Erp_sale_d_base_Imp : BaseModel_Imp {
protected override void datarowToModel ( DataRow dr , BaseModel obj )
{
if ( dr ! = null )
{
Erp_sale_d_base tmpObj = ( Erp_sale_d_base ) obj ;
if ( dr . Table . Columns . Contains ( "id" ) & & ! ( dr [ "id" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . ID = Convert . ToInt32 ( dr [ "id" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "id" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "sale_order" ) & & ! ( dr [ "sale_order" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _sale_order = dr [ "sale_order" ] . ToString ( ) ;
tmpObj . _Osale_order = dr [ "sale_order" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "sale_order" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "sale_order_sn" ) & & ! ( dr [ "sale_order_sn" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _sale_order_sn = Convert . ToInt32 ( dr [ "sale_order_sn" ] . ToString ( ) ) ; ;
tmpObj . _Osale_order_sn = Convert . ToInt32 ( dr [ "sale_order_sn" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "sale_order_sn" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "order_type" ) & & ! ( dr [ "order_type" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _order_type = dr [ "order_type" ] . ToString ( ) ;
tmpObj . _Oorder_type = dr [ "order_type" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "order_type" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "erp_state" ) & & ! ( dr [ "erp_state" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _erp_state = Convert . ToInt32 ( dr [ "erp_state" ] . ToString ( ) ) ; ;
tmpObj . _Oerp_state = Convert . ToInt32 ( dr [ "erp_state" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "erp_state" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "wms_state" ) & & ! ( dr [ "wms_state" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _wms_state = Convert . ToInt32 ( dr [ "wms_state" ] . ToString ( ) ) ; ;
tmpObj . _Owms_state = Convert . ToInt32 ( dr [ "wms_state" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "wms_state" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "purchseOrder" ) & & ! ( dr [ "purchseOrder" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _purchseOrder = dr [ "purchseOrder" ] . ToString ( ) ;
tmpObj . _OpurchseOrder = dr [ "purchseOrder" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "purchseOrder" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "price" ) & & ! ( dr [ "price" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _price = Convert . ToDecimal ( dr [ "price" ] . ToString ( ) ) ; ;
tmpObj . _Oprice = Convert . ToDecimal ( dr [ "price" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "price" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "packingQty" ) & & ! ( dr [ "packingQty" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _packingQty = Convert . ToDecimal ( dr [ "packingQty" ] . ToString ( ) ) ; ;
tmpObj . _OpackingQty = Convert . ToDecimal ( dr [ "packingQty" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "packingQty" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "priority" ) & & ! ( dr [ "priority" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _priority = Convert . ToInt32 ( dr [ "priority" ] . ToString ( ) ) ; ;
tmpObj . _Opriority = Convert . ToInt32 ( dr [ "priority" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "priority" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "goods_id" ) & & ! ( dr [ "goods_id" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _goods_id = dr [ "goods_id" ] . ToString ( ) ;
tmpObj . _Ogoods_id = dr [ "goods_id" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "goods_id" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "skuId" ) & & ! ( dr [ "skuId" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _skuId = Convert . ToInt32 ( dr [ "skuId" ] . ToString ( ) ) ; ;
tmpObj . _OskuId = Convert . ToInt32 ( dr [ "skuId" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "skuId" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "skuCode" ) & & ! ( dr [ "skuCode" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _skuCode = dr [ "skuCode" ] . ToString ( ) ;
tmpObj . _OskuCode = dr [ "skuCode" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "skuCode" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "batch" ) & & ! ( dr [ "batch" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _batch = dr [ "batch" ] . ToString ( ) ;
tmpObj . _Obatch = dr [ "batch" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "batch" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "product_date" ) & & ! ( dr [ "product_date" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _product_date = dr [ "product_date" ] . ToString ( ) ;
tmpObj . _Oproduct_date = dr [ "product_date" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "product_date" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "save_date" ) & & ! ( dr [ "save_date" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _save_date = dr [ "save_date" ] . ToString ( ) ;
tmpObj . _Osave_date = dr [ "save_date" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "save_date" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "count" ) & & ! ( dr [ "count" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _count = Convert . ToDecimal ( dr [ "count" ] . ToString ( ) ) ; ;
tmpObj . _Ocount = Convert . ToDecimal ( dr [ "count" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "count" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "reviseCount" ) & & ! ( dr [ "reviseCount" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _reviseCount = Convert . ToDecimal ( dr [ "reviseCount" ] . ToString ( ) ) ; ;
tmpObj . _OreviseCount = Convert . ToDecimal ( dr [ "reviseCount" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "reviseCount" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "pickCount" ) & & ! ( dr [ "pickCount" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _pickCount = Convert . ToDecimal ( dr [ "pickCount" ] . ToString ( ) ) ; ;
tmpObj . _OpickCount = Convert . ToDecimal ( dr [ "pickCount" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "pickCount" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "add_date" ) & & ! ( dr [ "add_date" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _add_date = dr [ "add_date" ] . ToString ( ) ;
tmpObj . _Oadd_date = dr [ "add_date" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "add_date" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "entid" ) & & ! ( dr [ "entid" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _entid = dr [ "entid" ] . ToString ( ) ;
tmpObj . _Oentid = dr [ "entid" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "entid" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "orgid" ) & & ! ( dr [ "orgid" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _orgid = dr [ "orgid" ] . ToString ( ) ;
tmpObj . _Oorgid = dr [ "orgid" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "orgid" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "oppcontid" ) & & ! ( dr [ "oppcontid" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _oppcontid = dr [ "oppcontid" ] . ToString ( ) ;
tmpObj . _Ooppcontid = dr [ "oppcontid" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "oppcontid" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "whtype" ) & & ! ( dr [ "whtype" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _whtype = Convert . ToInt32 ( dr [ "whtype" ] . ToString ( ) ) ; ;
tmpObj . _Owhtype = Convert . ToInt32 ( dr [ "whtype" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "whtype" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "whname" ) & & ! ( dr [ "whname" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _whname = dr [ "whname" ] . ToString ( ) ;
tmpObj . _Owhname = dr [ "whname" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "whname" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "suppliersId" ) & & ! ( dr [ "suppliersId" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _suppliersId = dr [ "suppliersId" ] . ToString ( ) ;
tmpObj . _OsuppliersId = dr [ "suppliersId" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "suppliersId" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "validBy" ) & & ! ( dr [ "validBy" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _validBy = dr [ "validBy" ] . ToString ( ) ;
tmpObj . _OvalidBy = dr [ "validBy" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "validBy" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "validByTime" ) & & ! ( dr [ "validByTime" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _validByTime = dr [ "validByTime" ] . ToString ( ) ;
tmpObj . _OvalidByTime = dr [ "validByTime" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "validByTime" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "validBy1" ) & & ! ( dr [ "validBy1" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _validBy1 = dr [ "validBy1" ] . ToString ( ) ;
tmpObj . _OvalidBy1 = dr [ "validBy1" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "validBy1" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "validByTime1" ) & & ! ( dr [ "validByTime1" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _validByTime1 = dr [ "validByTime1" ] . ToString ( ) ;
tmpObj . _OvalidByTime1 = dr [ "validByTime1" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "validByTime1" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "locationid" ) & & ! ( dr [ "locationid" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _locationid = dr [ "locationid" ] . ToString ( ) ;
tmpObj . _Olocationid = dr [ "locationid" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "locationid" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "liangdeng" ) & & ! ( dr [ "liangdeng" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _liangdeng = Convert . ToBoolean ( dr [ "liangdeng" ] . ToString ( ) ) ; ;
tmpObj . _Oliangdeng = Convert . ToBoolean ( dr [ "liangdeng" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "liangdeng" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "fuhezt" ) & & ! ( dr [ "fuhezt" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _fuhezt = Convert . ToBoolean ( dr [ "fuhezt" ] . ToString ( ) ) ; ;
tmpObj . _Ofuhezt = Convert . ToBoolean ( dr [ "fuhezt" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "fuhezt" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "dengmie" ) & & ! ( dr [ "dengmie" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _dengmie = Convert . ToBoolean ( dr [ "dengmie" ] . ToString ( ) ) ; ;
tmpObj . _Odengmie = Convert . ToBoolean ( dr [ "dengmie" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "dengmie" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "checkedBy2" ) & & ! ( dr [ "checkedBy2" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _checkedBy2 = dr [ "checkedBy2" ] . ToString ( ) ;
tmpObj . _OcheckedBy2 = dr [ "checkedBy2" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "checkedBy2" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "checkedBy2time" ) & & ! ( dr [ "checkedBy2time" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _checkedBy2time = dr [ "checkedBy2time" ] . ToString ( ) ;
tmpObj . _OcheckedBy2time = dr [ "checkedBy2time" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "checkedBy2time" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "ext1" ) & & ! ( dr [ "ext1" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _ext1 = dr [ "ext1" ] . ToString ( ) ;
tmpObj . _Oext1 = dr [ "ext1" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "ext1" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "ext2" ) & & ! ( dr [ "ext2" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _ext2 = dr [ "ext2" ] . ToString ( ) ;
tmpObj . _Oext2 = dr [ "ext2" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "ext2" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "ext3" ) & & ! ( dr [ "ext3" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _ext3 = dr [ "ext3" ] . ToString ( ) ;
tmpObj . _Oext3 = dr [ "ext3" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "ext3" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "ext4" ) & & ! ( dr [ "ext4" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _ext4 = dr [ "ext4" ] . ToString ( ) ;
tmpObj . _Oext4 = dr [ "ext4" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "ext4" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "operater" ) & & ! ( dr [ "operater" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _operater = Convert . ToInt32 ( dr [ "operater" ] . ToString ( ) ) ; ;
tmpObj . _Ooperater = Convert . ToInt32 ( dr [ "operater" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "operater" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "lastmodified" ) & & ! ( dr [ "lastmodified" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _lastmodified = dr [ "lastmodified" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "lastmodified" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "createtime" ) & & ! ( dr [ "createtime" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _createtime = dr [ "createtime" ] . ToString ( ) ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "createtime" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "dr" ) & & ! ( dr [ "dr" ] is DBNull ) )
{
2024-02-06 19:36:47 +08:00
try
{
2023-05-23 16:13:17 +08:00
tmpObj . _dr = Convert . ToBoolean ( dr [ "dr" ] . ToString ( ) ) ; ;
2024-02-06 19:36:47 +08:00
}
catch ( Exception er )
{
LogHelper . debug ( this . GetType ( ) , "value :" + dr [ "dr" ] . ToString ( ) ) ;
LogHelper . debug ( this . GetType ( ) , er . Message ) ;
}
2023-05-23 16:13:17 +08:00
}
}
}
protected override void CmdPrepare ( SqlCommand oraCmd ) {
Erp_sale_d_base tmpObj = ( Erp_sale_d_base ) modelObj ;
switch ( this . _op_flag ) {
case ( int ) op_flag . add :
_strSql = "INSERT INTO dbo.T_ERP_SALE_D({0}) VALUES({1} )" ;
_strSql = String . Format ( _strSql , getFields ( tmpObj ) , getValues ( tmpObj ) ) ;
break ;
case ( int ) op_flag . update :
// _strSql = "UPDATE dbo.T_ERP_SALE_D SET SALE_ORDER = @SALE_ORDER,SALE_ORDER_SN = @SALE_ORDER_SN,ORDER_TYPE = @ORDER_TYPE,ERP_STATE = @ERP_STATE,WMS_STATE = @WMS_STATE,PURCHSEORDER = @PURCHSEORDER,PRICE = @PRICE,PACKINGQTY = @PACKINGQTY,PRIORITY = @PRIORITY,GOODS_ID = @GOODS_ID,SKUID = @SKUID,SKUCODE = @SKUCODE,BATCH = @BATCH,PRODUCT_DATE = @PRODUCT_DATE,SAVE_DATE = @SAVE_DATE,COUNT = @COUNT,REVISECOUNT = @REVISECOUNT,PICKCOUNT = @PICKCOUNT,ADD_DATE = @ADD_DATE,ENTID = @ENTID,ORGID = @ORGID,OPPCONTID = @OPPCONTID,WHTYPE = @WHTYPE,WHNAME = @WHNAME,SUPPLIERSID = @SUPPLIERSID,VALIDBY = @VALIDBY,VALIDBYTIME = @VALIDBYTIME,VALIDBY1 = @VALIDBY1,VALIDBYTIME1 = @VALIDBYTIME1,LOCATIONID = @LOCATIONID,LIANGDENG = @LIANGDENG,FUHEZT = @FUHEZT,DENGMIE = @DENGMIE,CHECKEDBY2 = @CHECKEDBY2,CHECKEDBY2TIME = @CHECKEDBY2TIME,EXT1 = @EXT1,EXT2 = @EXT2,EXT3 = @EXT3,EXT4 = @EXT4,OPERATER = @OPERATER,LASTMODIFIED = getdate() WHERE ID = @ID";
_strSql = "UPDATE dbo.T_ERP_SALE_D {0} WHERE ID = @ID" ;
_strSql = String . Format ( _strSql , getChangedFields ( tmpObj ) ) ;
break ;
case ( int ) op_flag . delete :
// _strSql = "UPDATE dbo.T_ERP_SALE_D SET DR =0 WHERE ID = @ID";
_strSql = "delete from dbo.T_ERP_SALE_D WHERE ID = @ID" ;
break ;
case ( int ) op_flag . getObj :
_strSql = "SELECT * FROM dbo.T_ERP_SALE_D WHERE ID = @ID" ;
break ;
case ( int ) op_flag . queryAll :
_strSql = "SELECT * FROM dbo.T_ERP_SALE_D WHERE DR =1 " ;
// if (this.rownumEnd >0 )
{
// _strSql = "SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ID DESC) as sortNo FROM dbo.T_ERP_SALE_D WHERE DR =1 )AS SORTEDTB WHERE DR =1 AND sortNo BETWEEN @START AND @END";
}
// _strSql += ";SELECT COUNT(*) FROM T_ERP_SALE_D WHERE DR =1";
break ;
case ( int ) op_flag . queryActived :
_strSql = "SELECT * FROM dbo.T_ERP_SALE_D WHERE DR =1" ;
_strSql + = ";SELECT COUNT(*) FROM T_ERP_SALE_D WHERE DR =1" ;
break ;
case ( int ) op_flag . getPk :
_strSql = "SELECT MAX(ID) FROM dbo.T_ERP_SALE_D WHERE DR =1" ;
break ;
case ( int ) op_flag . getCount :
_strSql = "SELECT COUNT(*) FROM T_ERP_SALE_D WHERE DR =1" ;
break ;
}
oraCmd . CommandText = _strSql ;
fillParameters ( oraCmd , tmpObj ) ;
}
private string getFields ( Erp_sale_d_base tmpObj )
{
String colums = "" ;
colums + = tmpObj . _sale_order = = null ? "" : "SALE_ORDER" + "," ;
colums + = tmpObj . _sale_order_sn = = null ? "" : "SALE_ORDER_SN" + "," ;
colums + = tmpObj . _order_type = = null ? "" : "ORDER_TYPE" + "," ;
colums + = tmpObj . _erp_state = = null ? "" : "ERP_STATE" + "," ;
colums + = tmpObj . _wms_state = = null ? "" : "WMS_STATE" + "," ;
colums + = tmpObj . _purchseOrder = = null ? "" : "PURCHSEORDER" + "," ;
colums + = tmpObj . _price = = null ? "" : "PRICE" + "," ;
colums + = tmpObj . _packingQty = = null ? "" : "PACKINGQTY" + "," ;
colums + = tmpObj . _priority = = null ? "" : "PRIORITY" + "," ;
colums + = tmpObj . _goods_id = = null ? "" : "GOODS_ID" + "," ;
colums + = tmpObj . _skuId = = null ? "" : "SKUID" + "," ;
colums + = tmpObj . _skuCode = = null ? "" : "SKUCODE" + "," ;
colums + = tmpObj . _batch = = null ? "" : "BATCH" + "," ;
colums + = tmpObj . _product_date = = null ? "" : "PRODUCT_DATE" + "," ;
colums + = tmpObj . _save_date = = null ? "" : "SAVE_DATE" + "," ;
colums + = tmpObj . _count = = null ? "" : "COUNT" + "," ;
colums + = tmpObj . _reviseCount = = null ? "" : "REVISECOUNT" + "," ;
colums + = tmpObj . _pickCount = = null ? "" : "PICKCOUNT" + "," ;
colums + = tmpObj . _add_date = = null ? "" : "ADD_DATE" + "," ;
colums + = tmpObj . _entid = = null ? "" : "ENTID" + "," ;
colums + = tmpObj . _orgid = = null ? "" : "ORGID" + "," ;
colums + = tmpObj . _oppcontid = = null ? "" : "OPPCONTID" + "," ;
colums + = tmpObj . _whtype = = null ? "" : "WHTYPE" + "," ;
colums + = tmpObj . _whname = = null ? "" : "WHNAME" + "," ;
colums + = tmpObj . _suppliersId = = null ? "" : "SUPPLIERSID" + "," ;
colums + = tmpObj . _validBy = = null ? "" : "VALIDBY" + "," ;
colums + = tmpObj . _validByTime = = null ? "" : "VALIDBYTIME" + "," ;
colums + = tmpObj . _validBy1 = = null ? "" : "VALIDBY1" + "," ;
colums + = tmpObj . _validByTime1 = = null ? "" : "VALIDBYTIME1" + "," ;
colums + = tmpObj . _locationid = = null ? "" : "LOCATIONID" + "," ;
colums + = tmpObj . _liangdeng = = null ? "" : "LIANGDENG" + "," ;
colums + = tmpObj . _fuhezt = = null ? "" : "FUHEZT" + "," ;
colums + = tmpObj . _dengmie = = null ? "" : "DENGMIE" + "," ;
colums + = tmpObj . _checkedBy2 = = null ? "" : "CHECKEDBY2" + "," ;
colums + = tmpObj . _checkedBy2time = = null ? "" : "CHECKEDBY2TIME" + "," ;
colums + = tmpObj . _ext1 = = null ? "" : "EXT1" + "," ;
colums + = tmpObj . _ext2 = = null ? "" : "EXT2" + "," ;
colums + = tmpObj . _ext3 = = null ? "" : "EXT3" + "," ;
colums + = tmpObj . _ext4 = = null ? "" : "EXT4" + "," ;
colums + = tmpObj . _operater = = null ? "" : "OPERATER" + "," ;
return colums . Substring ( 0 , colums . Length - 1 ) ;
}
private string getValues ( Erp_sale_d_base tmpObj )
{
String values = "" ;
values + = tmpObj . _sale_order = = null ? "" : "@SALE_ORDER" + "," ;
values + = tmpObj . _sale_order_sn = = null ? "" : "@SALE_ORDER_SN" + "," ;
values + = tmpObj . _order_type = = null ? "" : "@ORDER_TYPE" + "," ;
values + = tmpObj . _erp_state = = null ? "" : "@ERP_STATE" + "," ;
values + = tmpObj . _wms_state = = null ? "" : "@WMS_STATE" + "," ;
values + = tmpObj . _purchseOrder = = null ? "" : "@PURCHSEORDER" + "," ;
values + = tmpObj . _price = = null ? "" : "@PRICE" + "," ;
values + = tmpObj . _packingQty = = null ? "" : "@PACKINGQTY" + "," ;
values + = tmpObj . _priority = = null ? "" : "@PRIORITY" + "," ;
values + = tmpObj . _goods_id = = null ? "" : "@GOODS_ID" + "," ;
values + = tmpObj . _skuId = = null ? "" : "@SKUID" + "," ;
values + = tmpObj . _skuCode = = null ? "" : "@SKUCODE" + "," ;
values + = tmpObj . _batch = = null ? "" : "@BATCH" + "," ;
values + = tmpObj . _product_date = = null ? "" : "@PRODUCT_DATE" + "," ;
values + = tmpObj . _save_date = = null ? "" : "@SAVE_DATE" + "," ;
values + = tmpObj . _count = = null ? "" : "@COUNT" + "," ;
values + = tmpObj . _reviseCount = = null ? "" : "@REVISECOUNT" + "," ;
values + = tmpObj . _pickCount = = null ? "" : "@PICKCOUNT" + "," ;
values + = tmpObj . _add_date = = null ? "" : "@ADD_DATE" + "," ;
values + = tmpObj . _entid = = null ? "" : "@ENTID" + "," ;
values + = tmpObj . _orgid = = null ? "" : "@ORGID" + "," ;
values + = tmpObj . _oppcontid = = null ? "" : "@OPPCONTID" + "," ;
values + = tmpObj . _whtype = = null ? "" : "@WHTYPE" + "," ;
values + = tmpObj . _whname = = null ? "" : "@WHNAME" + "," ;
values + = tmpObj . _suppliersId = = null ? "" : "@SUPPLIERSID" + "," ;
values + = tmpObj . _validBy = = null ? "" : "@VALIDBY" + "," ;
values + = tmpObj . _validByTime = = null ? "" : "@VALIDBYTIME" + "," ;
values + = tmpObj . _validBy1 = = null ? "" : "@VALIDBY1" + "," ;
values + = tmpObj . _validByTime1 = = null ? "" : "@VALIDBYTIME1" + "," ;
values + = tmpObj . _locationid = = null ? "" : "@LOCATIONID" + "," ;
values + = tmpObj . _liangdeng = = null ? "" : "@LIANGDENG" + "," ;
values + = tmpObj . _fuhezt = = null ? "" : "@FUHEZT" + "," ;
values + = tmpObj . _dengmie = = null ? "" : "@DENGMIE" + "," ;
values + = tmpObj . _checkedBy2 = = null ? "" : "@CHECKEDBY2" + "," ;
values + = tmpObj . _checkedBy2time = = null ? "" : "@CHECKEDBY2TIME" + "," ;
values + = tmpObj . _ext1 = = null ? "" : "@EXT1" + "," ;
values + = tmpObj . _ext2 = = null ? "" : "@EXT2" + "," ;
values + = tmpObj . _ext3 = = null ? "" : "@EXT3" + "," ;
values + = tmpObj . _ext4 = = null ? "" : "@EXT4" + "," ;
values + = tmpObj . _operater = = null ? "" : "@OPERATER" + "," ;
return values . Substring ( 0 , values . Length - 1 ) ;
}
private string getChangedFields ( Erp_sale_d_base tmpObj )
{
string updateFields = " set " ;
2023-09-04 22:41:19 +08:00
if ( tmpObj . _sale_order ! = null & & tmpObj . _sale_order ! = tmpObj . _Osale_order )
2023-05-23 16:13:17 +08:00
{
updateFields + = "SALE_ORDER = @SALE_ORDER," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _sale_order_sn ! = null & & tmpObj . _sale_order_sn ! = tmpObj . _Osale_order_sn )
2023-05-23 16:13:17 +08:00
{
updateFields + = "SALE_ORDER_SN = @SALE_ORDER_SN," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _order_type ! = null & & tmpObj . _order_type ! = tmpObj . _Oorder_type )
2023-05-23 16:13:17 +08:00
{
updateFields + = "ORDER_TYPE = @ORDER_TYPE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _erp_state ! = null & & tmpObj . _erp_state ! = tmpObj . _Oerp_state )
2023-05-23 16:13:17 +08:00
{
updateFields + = "ERP_STATE = @ERP_STATE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _wms_state ! = null & & tmpObj . _wms_state ! = tmpObj . _Owms_state )
2023-05-23 16:13:17 +08:00
{
updateFields + = "WMS_STATE = @WMS_STATE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _purchseOrder ! = null & & tmpObj . _purchseOrder ! = tmpObj . _OpurchseOrder )
2023-05-23 16:13:17 +08:00
{
updateFields + = "PURCHSEORDER = @PURCHSEORDER," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _price ! = null & & tmpObj . _price ! = tmpObj . _Oprice )
2023-05-23 16:13:17 +08:00
{
updateFields + = "PRICE = @PRICE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _packingQty ! = null & & tmpObj . _packingQty ! = tmpObj . _OpackingQty )
2023-05-23 16:13:17 +08:00
{
updateFields + = "PACKINGQTY = @PACKINGQTY," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _priority ! = null & & tmpObj . _priority ! = tmpObj . _Opriority )
2023-05-23 16:13:17 +08:00
{
updateFields + = "PRIORITY = @PRIORITY," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _goods_id ! = null & & tmpObj . _goods_id ! = tmpObj . _Ogoods_id )
2023-05-23 16:13:17 +08:00
{
updateFields + = "GOODS_ID = @GOODS_ID," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _skuId ! = null & & tmpObj . _skuId ! = tmpObj . _OskuId )
2023-05-23 16:13:17 +08:00
{
updateFields + = "SKUID = @SKUID," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _skuCode ! = null & & tmpObj . _skuCode ! = tmpObj . _OskuCode )
2023-05-23 16:13:17 +08:00
{
updateFields + = "SKUCODE = @SKUCODE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _batch ! = null & & tmpObj . _batch ! = tmpObj . _Obatch )
2023-05-23 16:13:17 +08:00
{
updateFields + = "BATCH = @BATCH," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _product_date ! = null & & tmpObj . _product_date ! = tmpObj . _Oproduct_date )
2023-05-23 16:13:17 +08:00
{
updateFields + = "PRODUCT_DATE = @PRODUCT_DATE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _save_date ! = null & & tmpObj . _save_date ! = tmpObj . _Osave_date )
2023-05-23 16:13:17 +08:00
{
updateFields + = "SAVE_DATE = @SAVE_DATE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _count ! = null & & tmpObj . _count ! = tmpObj . _Ocount )
2023-05-23 16:13:17 +08:00
{
updateFields + = "COUNT = @COUNT," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _reviseCount ! = null & & tmpObj . _reviseCount ! = tmpObj . _OreviseCount )
2023-05-23 16:13:17 +08:00
{
updateFields + = "REVISECOUNT = @REVISECOUNT," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _pickCount ! = null & & tmpObj . _pickCount ! = tmpObj . _OpickCount )
2023-05-23 16:13:17 +08:00
{
updateFields + = "PICKCOUNT = @PICKCOUNT," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _add_date ! = null & & tmpObj . _add_date ! = tmpObj . _Oadd_date )
2023-05-23 16:13:17 +08:00
{
updateFields + = "ADD_DATE = @ADD_DATE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _entid ! = null & & tmpObj . _entid ! = tmpObj . _Oentid )
2023-05-23 16:13:17 +08:00
{
updateFields + = "ENTID = @ENTID," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _orgid ! = null & & tmpObj . _orgid ! = tmpObj . _Oorgid )
2023-05-23 16:13:17 +08:00
{
updateFields + = "ORGID = @ORGID," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _oppcontid ! = null & & tmpObj . _oppcontid ! = tmpObj . _Ooppcontid )
2023-05-23 16:13:17 +08:00
{
updateFields + = "OPPCONTID = @OPPCONTID," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _whtype ! = null & & tmpObj . _whtype ! = tmpObj . _Owhtype )
2023-05-23 16:13:17 +08:00
{
updateFields + = "WHTYPE = @WHTYPE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _whname ! = null & & tmpObj . _whname ! = tmpObj . _Owhname )
2023-05-23 16:13:17 +08:00
{
updateFields + = "WHNAME = @WHNAME," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _suppliersId ! = null & & tmpObj . _suppliersId ! = tmpObj . _OsuppliersId )
2023-05-23 16:13:17 +08:00
{
updateFields + = "SUPPLIERSID = @SUPPLIERSID," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _validBy ! = null & & tmpObj . _validBy ! = tmpObj . _OvalidBy )
2023-05-23 16:13:17 +08:00
{
updateFields + = "VALIDBY = @VALIDBY," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _validByTime ! = null & & tmpObj . _validByTime ! = tmpObj . _OvalidByTime )
2023-05-23 16:13:17 +08:00
{
updateFields + = "VALIDBYTIME = @VALIDBYTIME," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _validBy1 ! = null & & tmpObj . _validBy1 ! = tmpObj . _OvalidBy1 )
2023-05-23 16:13:17 +08:00
{
updateFields + = "VALIDBY1 = @VALIDBY1," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _validByTime1 ! = null & & tmpObj . _validByTime1 ! = tmpObj . _OvalidByTime1 )
2023-05-23 16:13:17 +08:00
{
updateFields + = "VALIDBYTIME1 = @VALIDBYTIME1," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _locationid ! = null & & tmpObj . _locationid ! = tmpObj . _Olocationid )
2023-05-23 16:13:17 +08:00
{
updateFields + = "LOCATIONID = @LOCATIONID," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _liangdeng ! = null & & tmpObj . _liangdeng ! = tmpObj . _Oliangdeng )
2023-05-23 16:13:17 +08:00
{
updateFields + = "LIANGDENG = @LIANGDENG," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _fuhezt ! = null & & tmpObj . _fuhezt ! = tmpObj . _Ofuhezt )
2023-05-23 16:13:17 +08:00
{
updateFields + = "FUHEZT = @FUHEZT," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _dengmie ! = null & & tmpObj . _dengmie ! = tmpObj . _Odengmie )
2023-05-23 16:13:17 +08:00
{
updateFields + = "DENGMIE = @DENGMIE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _checkedBy2 ! = null & & tmpObj . _checkedBy2 ! = tmpObj . _OcheckedBy2 )
2023-05-23 16:13:17 +08:00
{
updateFields + = "CHECKEDBY2 = @CHECKEDBY2," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _checkedBy2time ! = null & & tmpObj . _checkedBy2time ! = tmpObj . _OcheckedBy2time )
2023-05-23 16:13:17 +08:00
{
updateFields + = "CHECKEDBY2TIME = @CHECKEDBY2TIME," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _ext1 ! = null & & tmpObj . _ext1 ! = tmpObj . _Oext1 )
2023-05-23 16:13:17 +08:00
{
updateFields + = "EXT1 = @EXT1," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _ext2 ! = null & & tmpObj . _ext2 ! = tmpObj . _Oext2 )
2023-05-23 16:13:17 +08:00
{
updateFields + = "EXT2 = @EXT2," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _ext3 ! = null & & tmpObj . _ext3 ! = tmpObj . _Oext3 )
2023-05-23 16:13:17 +08:00
{
updateFields + = "EXT3 = @EXT3," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _ext4 ! = null & & tmpObj . _ext4 ! = tmpObj . _Oext4 )
2023-05-23 16:13:17 +08:00
{
updateFields + = "EXT4 = @EXT4," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _operater ! = null & & tmpObj . _operater ! = tmpObj . _Ooperater )
2023-05-23 16:13:17 +08:00
{
updateFields + = "OPERATER = @OPERATER," ;
}
updateFields + = "LASTMODIFIED = getdate()" ;
return updateFields ;
}
private void fillParameters ( SqlCommand oraCmd , Erp_sale_d_base tmpObj ) {
switch ( this . _op_flag ) {
case ( int ) op_flag . getObj :
case ( int ) op_flag . delete :
oraCmd . Parameters . AddWithValue ( "@ID" , tmpObj . ID ) ;
return ;
case ( int ) op_flag . getPk :
oraCmd . Parameters . AddWithValue ( "@ID" , tmpObj . ID ) ;
return ;
case ( int ) op_flag . queryAll :
if ( this . rownumEnd > 0 )
{
oraCmd . Parameters . AddWithValue ( "@START" , this . _rownumStart ) ;
oraCmd . Parameters . AddWithValue ( "@END" , this . _rownumEnd ) ;
}
return ;
case 0 :
case ( int ) op_flag . queryActived :
return ;
case ( int ) op_flag . update :
oraCmd . Parameters . AddWithValue ( "@ID" , tmpObj . ID ) ;
oraCmd . Parameters . AddWithValue ( "@SALE_ORDER" , VerifyDbnull ( tmpObj . _sale_order ) ) ;
oraCmd . Parameters . AddWithValue ( "@SALE_ORDER_SN" , VerifyDbnull ( tmpObj . _sale_order_sn ) ) ;
oraCmd . Parameters . AddWithValue ( "@ORDER_TYPE" , VerifyDbnull ( tmpObj . _order_type ) ) ;
oraCmd . Parameters . AddWithValue ( "@ERP_STATE" , VerifyDbnull ( tmpObj . _erp_state ) ) ;
oraCmd . Parameters . AddWithValue ( "@WMS_STATE" , VerifyDbnull ( tmpObj . _wms_state ) ) ;
oraCmd . Parameters . AddWithValue ( "@PURCHSEORDER" , VerifyDbnull ( tmpObj . _purchseOrder ) ) ;
oraCmd . Parameters . AddWithValue ( "@PRICE" , VerifyDbnull ( tmpObj . _price ) ) ;
oraCmd . Parameters . AddWithValue ( "@PACKINGQTY" , VerifyDbnull ( tmpObj . _packingQty ) ) ;
oraCmd . Parameters . AddWithValue ( "@PRIORITY" , VerifyDbnull ( tmpObj . _priority ) ) ;
oraCmd . Parameters . AddWithValue ( "@GOODS_ID" , VerifyDbnull ( tmpObj . _goods_id ) ) ;
oraCmd . Parameters . AddWithValue ( "@SKUID" , VerifyDbnull ( tmpObj . _skuId ) ) ;
oraCmd . Parameters . AddWithValue ( "@SKUCODE" , VerifyDbnull ( tmpObj . _skuCode ) ) ;
oraCmd . Parameters . AddWithValue ( "@BATCH" , VerifyDbnull ( tmpObj . _batch ) ) ;
oraCmd . Parameters . AddWithValue ( "@PRODUCT_DATE" , VerifyDbnull ( tmpObj . _product_date ) ) ;
oraCmd . Parameters . AddWithValue ( "@SAVE_DATE" , VerifyDbnull ( tmpObj . _save_date ) ) ;
oraCmd . Parameters . AddWithValue ( "@COUNT" , VerifyDbnull ( tmpObj . _count ) ) ;
oraCmd . Parameters . AddWithValue ( "@REVISECOUNT" , VerifyDbnull ( tmpObj . _reviseCount ) ) ;
oraCmd . Parameters . AddWithValue ( "@PICKCOUNT" , VerifyDbnull ( tmpObj . _pickCount ) ) ;
oraCmd . Parameters . AddWithValue ( "@ADD_DATE" , VerifyDbnull ( tmpObj . _add_date ) ) ;
oraCmd . Parameters . AddWithValue ( "@ENTID" , VerifyDbnull ( tmpObj . _entid ) ) ;
oraCmd . Parameters . AddWithValue ( "@ORGID" , VerifyDbnull ( tmpObj . _orgid ) ) ;
oraCmd . Parameters . AddWithValue ( "@OPPCONTID" , VerifyDbnull ( tmpObj . _oppcontid ) ) ;
oraCmd . Parameters . AddWithValue ( "@WHTYPE" , VerifyDbnull ( tmpObj . _whtype ) ) ;
oraCmd . Parameters . AddWithValue ( "@WHNAME" , VerifyDbnull ( tmpObj . _whname ) ) ;
oraCmd . Parameters . AddWithValue ( "@SUPPLIERSID" , VerifyDbnull ( tmpObj . _suppliersId ) ) ;
oraCmd . Parameters . AddWithValue ( "@VALIDBY" , VerifyDbnull ( tmpObj . _validBy ) ) ;
oraCmd . Parameters . AddWithValue ( "@VALIDBYTIME" , VerifyDbnull ( tmpObj . _validByTime ) ) ;
oraCmd . Parameters . AddWithValue ( "@VALIDBY1" , VerifyDbnull ( tmpObj . _validBy1 ) ) ;
oraCmd . Parameters . AddWithValue ( "@VALIDBYTIME1" , VerifyDbnull ( tmpObj . _validByTime1 ) ) ;
oraCmd . Parameters . AddWithValue ( "@LOCATIONID" , VerifyDbnull ( tmpObj . _locationid ) ) ;
oraCmd . Parameters . AddWithValue ( "@LIANGDENG" , VerifyDbnull ( tmpObj . _liangdeng ) ) ;
oraCmd . Parameters . AddWithValue ( "@FUHEZT" , VerifyDbnull ( tmpObj . _fuhezt ) ) ;
oraCmd . Parameters . AddWithValue ( "@DENGMIE" , VerifyDbnull ( tmpObj . _dengmie ) ) ;
oraCmd . Parameters . AddWithValue ( "@CHECKEDBY2" , VerifyDbnull ( tmpObj . _checkedBy2 ) ) ;
oraCmd . Parameters . AddWithValue ( "@CHECKEDBY2TIME" , VerifyDbnull ( tmpObj . _checkedBy2time ) ) ;
oraCmd . Parameters . AddWithValue ( "@EXT1" , VerifyDbnull ( tmpObj . _ext1 ) ) ;
oraCmd . Parameters . AddWithValue ( "@EXT2" , VerifyDbnull ( tmpObj . _ext2 ) ) ;
oraCmd . Parameters . AddWithValue ( "@EXT3" , VerifyDbnull ( tmpObj . _ext3 ) ) ;
oraCmd . Parameters . AddWithValue ( "@EXT4" , VerifyDbnull ( tmpObj . _ext4 ) ) ;
oraCmd . Parameters . AddWithValue ( "@OPERATER" , VerifyDbnull ( tmpObj . _operater ) ) ;
// oraCmd.Parameters.AddWithValue("@LASTMODIFIED", "getdate()") ;
return ;
case ( int ) op_flag . add :
if ( tmpObj . _sale_order ! = null )
oraCmd . Parameters . AddWithValue ( "@SALE_ORDER" , VerifyDbnull ( tmpObj . _sale_order ) ) ;
if ( tmpObj . _sale_order_sn ! = null )
oraCmd . Parameters . AddWithValue ( "@SALE_ORDER_SN" , VerifyDbnull ( tmpObj . _sale_order_sn ) ) ;
if ( tmpObj . _order_type ! = null )
oraCmd . Parameters . AddWithValue ( "@ORDER_TYPE" , VerifyDbnull ( tmpObj . _order_type ) ) ;
if ( tmpObj . _erp_state ! = null )
oraCmd . Parameters . AddWithValue ( "@ERP_STATE" , VerifyDbnull ( tmpObj . _erp_state ) ) ;
if ( tmpObj . _wms_state ! = null )
oraCmd . Parameters . AddWithValue ( "@WMS_STATE" , VerifyDbnull ( tmpObj . _wms_state ) ) ;
if ( tmpObj . _purchseOrder ! = null )
oraCmd . Parameters . AddWithValue ( "@PURCHSEORDER" , VerifyDbnull ( tmpObj . _purchseOrder ) ) ;
if ( tmpObj . _price ! = null )
oraCmd . Parameters . AddWithValue ( "@PRICE" , VerifyDbnull ( tmpObj . _price ) ) ;
if ( tmpObj . _packingQty ! = null )
oraCmd . Parameters . AddWithValue ( "@PACKINGQTY" , VerifyDbnull ( tmpObj . _packingQty ) ) ;
if ( tmpObj . _priority ! = null )
oraCmd . Parameters . AddWithValue ( "@PRIORITY" , VerifyDbnull ( tmpObj . _priority ) ) ;
if ( tmpObj . _goods_id ! = null )
oraCmd . Parameters . AddWithValue ( "@GOODS_ID" , VerifyDbnull ( tmpObj . _goods_id ) ) ;
if ( tmpObj . _skuId ! = null )
oraCmd . Parameters . AddWithValue ( "@SKUID" , VerifyDbnull ( tmpObj . _skuId ) ) ;
if ( tmpObj . _skuCode ! = null )
oraCmd . Parameters . AddWithValue ( "@SKUCODE" , VerifyDbnull ( tmpObj . _skuCode ) ) ;
if ( tmpObj . _batch ! = null )
oraCmd . Parameters . AddWithValue ( "@BATCH" , VerifyDbnull ( tmpObj . _batch ) ) ;
if ( tmpObj . _product_date ! = null )
oraCmd . Parameters . AddWithValue ( "@PRODUCT_DATE" , VerifyDbnull ( tmpObj . _product_date ) ) ;
if ( tmpObj . _save_date ! = null )
oraCmd . Parameters . AddWithValue ( "@SAVE_DATE" , VerifyDbnull ( tmpObj . _save_date ) ) ;
if ( tmpObj . _count ! = null )
oraCmd . Parameters . AddWithValue ( "@COUNT" , VerifyDbnull ( tmpObj . _count ) ) ;
if ( tmpObj . _reviseCount ! = null )
oraCmd . Parameters . AddWithValue ( "@REVISECOUNT" , VerifyDbnull ( tmpObj . _reviseCount ) ) ;
if ( tmpObj . _pickCount ! = null )
oraCmd . Parameters . AddWithValue ( "@PICKCOUNT" , VerifyDbnull ( tmpObj . _pickCount ) ) ;
if ( tmpObj . _add_date ! = null )
oraCmd . Parameters . AddWithValue ( "@ADD_DATE" , VerifyDbnull ( tmpObj . _add_date ) ) ;
if ( tmpObj . _entid ! = null )
oraCmd . Parameters . AddWithValue ( "@ENTID" , VerifyDbnull ( tmpObj . _entid ) ) ;
if ( tmpObj . _orgid ! = null )
oraCmd . Parameters . AddWithValue ( "@ORGID" , VerifyDbnull ( tmpObj . _orgid ) ) ;
if ( tmpObj . _oppcontid ! = null )
oraCmd . Parameters . AddWithValue ( "@OPPCONTID" , VerifyDbnull ( tmpObj . _oppcontid ) ) ;
if ( tmpObj . _whtype ! = null )
oraCmd . Parameters . AddWithValue ( "@WHTYPE" , VerifyDbnull ( tmpObj . _whtype ) ) ;
if ( tmpObj . _whname ! = null )
oraCmd . Parameters . AddWithValue ( "@WHNAME" , VerifyDbnull ( tmpObj . _whname ) ) ;
if ( tmpObj . _suppliersId ! = null )
oraCmd . Parameters . AddWithValue ( "@SUPPLIERSID" , VerifyDbnull ( tmpObj . _suppliersId ) ) ;
if ( tmpObj . _validBy ! = null )
oraCmd . Parameters . AddWithValue ( "@VALIDBY" , VerifyDbnull ( tmpObj . _validBy ) ) ;
if ( tmpObj . _validByTime ! = null )
oraCmd . Parameters . AddWithValue ( "@VALIDBYTIME" , VerifyDbnull ( tmpObj . _validByTime ) ) ;
if ( tmpObj . _validBy1 ! = null )
oraCmd . Parameters . AddWithValue ( "@VALIDBY1" , VerifyDbnull ( tmpObj . _validBy1 ) ) ;
if ( tmpObj . _validByTime1 ! = null )
oraCmd . Parameters . AddWithValue ( "@VALIDBYTIME1" , VerifyDbnull ( tmpObj . _validByTime1 ) ) ;
if ( tmpObj . _locationid ! = null )
oraCmd . Parameters . AddWithValue ( "@LOCATIONID" , VerifyDbnull ( tmpObj . _locationid ) ) ;
if ( tmpObj . _liangdeng ! = null )
oraCmd . Parameters . AddWithValue ( "@LIANGDENG" , VerifyDbnull ( tmpObj . _liangdeng ) ) ;
if ( tmpObj . _fuhezt ! = null )
oraCmd . Parameters . AddWithValue ( "@FUHEZT" , VerifyDbnull ( tmpObj . _fuhezt ) ) ;
if ( tmpObj . _dengmie ! = null )
oraCmd . Parameters . AddWithValue ( "@DENGMIE" , VerifyDbnull ( tmpObj . _dengmie ) ) ;
if ( tmpObj . _checkedBy2 ! = null )
oraCmd . Parameters . AddWithValue ( "@CHECKEDBY2" , VerifyDbnull ( tmpObj . _checkedBy2 ) ) ;
if ( tmpObj . _checkedBy2time ! = null )
oraCmd . Parameters . AddWithValue ( "@CHECKEDBY2TIME" , VerifyDbnull ( tmpObj . _checkedBy2time ) ) ;
if ( tmpObj . _ext1 ! = null )
oraCmd . Parameters . AddWithValue ( "@EXT1" , VerifyDbnull ( tmpObj . _ext1 ) ) ;
if ( tmpObj . _ext2 ! = null )
oraCmd . Parameters . AddWithValue ( "@EXT2" , VerifyDbnull ( tmpObj . _ext2 ) ) ;
if ( tmpObj . _ext3 ! = null )
oraCmd . Parameters . AddWithValue ( "@EXT3" , VerifyDbnull ( tmpObj . _ext3 ) ) ;
if ( tmpObj . _ext4 ! = null )
oraCmd . Parameters . AddWithValue ( "@EXT4" , VerifyDbnull ( tmpObj . _ext4 ) ) ;
if ( tmpObj . _operater ! = null )
oraCmd . Parameters . AddWithValue ( "@OPERATER" , VerifyDbnull ( tmpObj . _operater ) ) ;
return ;
}
}
protected override enumDbInstance instance
{
get
{
return enumDbInstance . wms_erp ;
}
}
}
#endregion
}