2023-05-23 16:13:17 +08:00
/// <summary>
///Data Implemention Object
///BASIC CRUD CLASS FOR TABLE t_erp_purch_ship
///By wm
2023-09-04 22:41:19 +08:00
///on 08/04/2023
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_purch_ship_base_Imp
[Serializable] class Erp_purch_ship_base_Imp : BaseModel_Imp {
protected override void datarowToModel ( DataRow dr , BaseModel obj )
{
if ( dr ! = null )
{
Erp_purch_ship_base tmpObj = ( Erp_purch_ship_base ) obj ;
if ( dr . Table . Columns . Contains ( "id" ) & & ! ( dr [ "id" ] is DBNull ) )
{
tmpObj . ID = Convert . ToInt32 ( dr [ "id" ] . ToString ( ) ) ; ;
}
if ( dr . Table . Columns . Contains ( "shipOrder" ) & & ! ( dr [ "shipOrder" ] is DBNull ) )
{
tmpObj . _shipOrder = dr [ "shipOrder" ] . ToString ( ) ;
tmpObj . _OshipOrder = dr [ "shipOrder" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "driverID" ) & & ! ( dr [ "driverID" ] is DBNull ) )
{
tmpObj . _driverID = dr [ "driverID" ] . ToString ( ) ;
tmpObj . _OdriverID = dr [ "driverID" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "driverName" ) & & ! ( dr [ "driverName" ] is DBNull ) )
{
tmpObj . _driverName = dr [ "driverName" ] . ToString ( ) ;
tmpObj . _OdriverName = dr [ "driverName" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "driverPhone" ) & & ! ( dr [ "driverPhone" ] is DBNull ) )
{
tmpObj . _driverPhone = dr [ "driverPhone" ] . ToString ( ) ;
tmpObj . _OdriverPhone = dr [ "driverPhone" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "veNumber" ) & & ! ( dr [ "veNumber" ] is DBNull ) )
{
tmpObj . _veNumber = dr [ "veNumber" ] . ToString ( ) ;
tmpObj . _OveNumber = dr [ "veNumber" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "temperature" ) & & ! ( dr [ "temperature" ] is DBNull ) )
{
tmpObj . _temperature = Convert . ToDecimal ( dr [ "temperature" ] . ToString ( ) ) ; ;
tmpObj . _Otemperature = Convert . ToDecimal ( dr [ "temperature" ] . ToString ( ) ) ; ;
}
if ( dr . Table . Columns . Contains ( "company" ) & & ! ( dr [ "company" ] is DBNull ) )
{
tmpObj . _company = dr [ "company" ] . ToString ( ) ;
tmpObj . _Ocompany = dr [ "company" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "remark" ) & & ! ( dr [ "remark" ] is DBNull ) )
{
tmpObj . _remark = dr [ "remark" ] . ToString ( ) ;
tmpObj . _Oremark = dr [ "remark" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "operater" ) & & ! ( dr [ "operater" ] is DBNull ) )
{
tmpObj . _operater = Convert . ToInt32 ( dr [ "operater" ] . ToString ( ) ) ; ;
tmpObj . _Ooperater = Convert . ToInt32 ( dr [ "operater" ] . ToString ( ) ) ; ;
}
if ( dr . Table . Columns . Contains ( "dr" ) & & ! ( dr [ "dr" ] is DBNull ) )
{
tmpObj . _dr = Convert . ToBoolean ( dr [ "dr" ] . ToString ( ) ) ; ;
}
if ( dr . Table . Columns . Contains ( "createtime" ) & & ! ( dr [ "createtime" ] is DBNull ) )
{
tmpObj . _createtime = dr [ "createtime" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "lastmodified" ) & & ! ( dr [ "lastmodified" ] is DBNull ) )
{
tmpObj . _lastmodified = dr [ "lastmodified" ] . ToString ( ) ;
}
}
}
protected override void CmdPrepare ( SqlCommand oraCmd ) {
Erp_purch_ship_base tmpObj = ( Erp_purch_ship_base ) modelObj ;
switch ( this . _op_flag ) {
case ( int ) op_flag . add :
_strSql = "INSERT INTO dbo.T_ERP_PURCH_SHIP({0}) VALUES({1} )" ;
_strSql = String . Format ( _strSql , getFields ( tmpObj ) , getValues ( tmpObj ) ) ;
break ;
case ( int ) op_flag . update :
// _strSql = "UPDATE dbo.T_ERP_PURCH_SHIP SET SHIPORDER = @SHIPORDER,DRIVERID = @DRIVERID,DRIVERNAME = @DRIVERNAME,DRIVERPHONE = @DRIVERPHONE,VENUMBER = @VENUMBER,TEMPERATURE = @TEMPERATURE,COMPANY = @COMPANY,REMARK = @REMARK,OPERATER = @OPERATER,LASTMODIFIED = getdate() WHERE ID = @ID";
_strSql = "UPDATE dbo.T_ERP_PURCH_SHIP {0} WHERE ID = @ID" ;
_strSql = String . Format ( _strSql , getChangedFields ( tmpObj ) ) ;
break ;
case ( int ) op_flag . delete :
// _strSql = "UPDATE dbo.T_ERP_PURCH_SHIP SET DR =0 WHERE ID = @ID";
_strSql = "delete from dbo.T_ERP_PURCH_SHIP WHERE ID = @ID" ;
break ;
case ( int ) op_flag . getObj :
_strSql = "SELECT * FROM dbo.T_ERP_PURCH_SHIP WHERE ID = @ID" ;
break ;
case ( int ) op_flag . queryAll :
_strSql = "SELECT * FROM dbo.T_ERP_PURCH_SHIP WHERE DR =1 " ;
// if (this.rownumEnd >0 )
{
// _strSql = "SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ID DESC) as sortNo FROM dbo.T_ERP_PURCH_SHIP WHERE DR =1 )AS SORTEDTB WHERE DR =1 AND sortNo BETWEEN @START AND @END";
}
// _strSql += ";SELECT COUNT(*) FROM T_ERP_PURCH_SHIP WHERE DR =1";
break ;
case ( int ) op_flag . queryActived :
_strSql = "SELECT * FROM dbo.T_ERP_PURCH_SHIP WHERE DR =1" ;
_strSql + = ";SELECT COUNT(*) FROM T_ERP_PURCH_SHIP WHERE DR =1" ;
break ;
case ( int ) op_flag . getPk :
_strSql = "SELECT MAX(ID) FROM dbo.T_ERP_PURCH_SHIP WHERE DR =1" ;
break ;
case ( int ) op_flag . getCount :
_strSql = "SELECT COUNT(*) FROM T_ERP_PURCH_SHIP WHERE DR =1" ;
break ;
}
oraCmd . CommandText = _strSql ;
fillParameters ( oraCmd , tmpObj ) ;
}
private string getFields ( Erp_purch_ship_base tmpObj )
{
String colums = "" ;
colums + = tmpObj . _shipOrder = = null ? "" : "SHIPORDER" + "," ;
colums + = tmpObj . _driverID = = null ? "" : "DRIVERID" + "," ;
colums + = tmpObj . _driverName = = null ? "" : "DRIVERNAME" + "," ;
colums + = tmpObj . _driverPhone = = null ? "" : "DRIVERPHONE" + "," ;
colums + = tmpObj . _veNumber = = null ? "" : "VENUMBER" + "," ;
colums + = tmpObj . _temperature = = null ? "" : "TEMPERATURE" + "," ;
colums + = tmpObj . _company = = null ? "" : "COMPANY" + "," ;
colums + = tmpObj . _remark = = null ? "" : "REMARK" + "," ;
colums + = tmpObj . _operater = = null ? "" : "OPERATER" + "," ;
return colums . Substring ( 0 , colums . Length - 1 ) ;
}
private string getValues ( Erp_purch_ship_base tmpObj )
{
String values = "" ;
values + = tmpObj . _shipOrder = = null ? "" : "@SHIPORDER" + "," ;
values + = tmpObj . _driverID = = null ? "" : "@DRIVERID" + "," ;
values + = tmpObj . _driverName = = null ? "" : "@DRIVERNAME" + "," ;
values + = tmpObj . _driverPhone = = null ? "" : "@DRIVERPHONE" + "," ;
values + = tmpObj . _veNumber = = null ? "" : "@VENUMBER" + "," ;
values + = tmpObj . _temperature = = null ? "" : "@TEMPERATURE" + "," ;
values + = tmpObj . _company = = null ? "" : "@COMPANY" + "," ;
values + = tmpObj . _remark = = null ? "" : "@REMARK" + "," ;
values + = tmpObj . _operater = = null ? "" : "@OPERATER" + "," ;
return values . Substring ( 0 , values . Length - 1 ) ;
}
private string getChangedFields ( Erp_purch_ship_base tmpObj )
{
string updateFields = " set " ;
2023-09-04 22:41:19 +08:00
if ( tmpObj . _shipOrder ! = null & & tmpObj . _shipOrder ! = tmpObj . _OshipOrder )
2023-05-23 16:13:17 +08:00
{
updateFields + = "SHIPORDER = @SHIPORDER," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _driverID ! = null & & tmpObj . _driverID ! = tmpObj . _OdriverID )
2023-05-23 16:13:17 +08:00
{
updateFields + = "DRIVERID = @DRIVERID," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _driverName ! = null & & tmpObj . _driverName ! = tmpObj . _OdriverName )
2023-05-23 16:13:17 +08:00
{
updateFields + = "DRIVERNAME = @DRIVERNAME," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _driverPhone ! = null & & tmpObj . _driverPhone ! = tmpObj . _OdriverPhone )
2023-05-23 16:13:17 +08:00
{
updateFields + = "DRIVERPHONE = @DRIVERPHONE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _veNumber ! = null & & tmpObj . _veNumber ! = tmpObj . _OveNumber )
2023-05-23 16:13:17 +08:00
{
updateFields + = "VENUMBER = @VENUMBER," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _temperature ! = null & & tmpObj . _temperature ! = tmpObj . _Otemperature )
2023-05-23 16:13:17 +08:00
{
updateFields + = "TEMPERATURE = @TEMPERATURE," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _company ! = null & & tmpObj . _company ! = tmpObj . _Ocompany )
2023-05-23 16:13:17 +08:00
{
updateFields + = "COMPANY = @COMPANY," ;
}
2023-09-04 22:41:19 +08:00
if ( tmpObj . _remark ! = null & & tmpObj . _remark ! = tmpObj . _Oremark )
2023-05-23 16:13:17 +08:00
{
updateFields + = "REMARK = @REMARK," ;
}
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_purch_ship_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 ( "@SHIPORDER" , VerifyDbnull ( tmpObj . _shipOrder ) ) ;
oraCmd . Parameters . AddWithValue ( "@DRIVERID" , VerifyDbnull ( tmpObj . _driverID ) ) ;
oraCmd . Parameters . AddWithValue ( "@DRIVERNAME" , VerifyDbnull ( tmpObj . _driverName ) ) ;
oraCmd . Parameters . AddWithValue ( "@DRIVERPHONE" , VerifyDbnull ( tmpObj . _driverPhone ) ) ;
oraCmd . Parameters . AddWithValue ( "@VENUMBER" , VerifyDbnull ( tmpObj . _veNumber ) ) ;
oraCmd . Parameters . AddWithValue ( "@TEMPERATURE" , VerifyDbnull ( tmpObj . _temperature ) ) ;
oraCmd . Parameters . AddWithValue ( "@COMPANY" , VerifyDbnull ( tmpObj . _company ) ) ;
oraCmd . Parameters . AddWithValue ( "@REMARK" , VerifyDbnull ( tmpObj . _remark ) ) ;
oraCmd . Parameters . AddWithValue ( "@OPERATER" , VerifyDbnull ( tmpObj . _operater ) ) ;
// oraCmd.Parameters.AddWithValue("@LASTMODIFIED", "getdate()") ;
return ;
case ( int ) op_flag . add :
if ( tmpObj . _shipOrder ! = null )
oraCmd . Parameters . AddWithValue ( "@SHIPORDER" , VerifyDbnull ( tmpObj . _shipOrder ) ) ;
if ( tmpObj . _driverID ! = null )
oraCmd . Parameters . AddWithValue ( "@DRIVERID" , VerifyDbnull ( tmpObj . _driverID ) ) ;
if ( tmpObj . _driverName ! = null )
oraCmd . Parameters . AddWithValue ( "@DRIVERNAME" , VerifyDbnull ( tmpObj . _driverName ) ) ;
if ( tmpObj . _driverPhone ! = null )
oraCmd . Parameters . AddWithValue ( "@DRIVERPHONE" , VerifyDbnull ( tmpObj . _driverPhone ) ) ;
if ( tmpObj . _veNumber ! = null )
oraCmd . Parameters . AddWithValue ( "@VENUMBER" , VerifyDbnull ( tmpObj . _veNumber ) ) ;
if ( tmpObj . _temperature ! = null )
oraCmd . Parameters . AddWithValue ( "@TEMPERATURE" , VerifyDbnull ( tmpObj . _temperature ) ) ;
if ( tmpObj . _company ! = null )
oraCmd . Parameters . AddWithValue ( "@COMPANY" , VerifyDbnull ( tmpObj . _company ) ) ;
if ( tmpObj . _remark ! = null )
oraCmd . Parameters . AddWithValue ( "@REMARK" , VerifyDbnull ( tmpObj . _remark ) ) ;
if ( tmpObj . _operater ! = null )
oraCmd . Parameters . AddWithValue ( "@OPERATER" , VerifyDbnull ( tmpObj . _operater ) ) ;
return ;
}
}
protected override enumDbInstance instance
{
get
{
return enumDbInstance . wms_erp ;
}
}
}
#endregion
}