2023-05-23 16:13:17 +08:00
/// <summary>
///Data Implemention Object
///BASIC CRUD CLASS FOR TABLE t_Employee
///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 Employee_base_Imp
[Serializable] class Employee_base_Imp : BaseModel_Imp {
protected override void datarowToModel ( DataRow dr , BaseModel obj )
{
if ( dr ! = null )
{
Employee_base tmpObj = ( Employee_base ) obj ;
if ( dr . Table . Columns . Contains ( "id" ) & & ! ( dr [ "id" ] is DBNull ) )
{
tmpObj . ID = Convert . ToInt32 ( dr [ "id" ] . ToString ( ) ) ; ;
}
if ( dr . Table . Columns . Contains ( "em_name" ) & & ! ( dr [ "em_name" ] is DBNull ) )
{
tmpObj . _em_name = dr [ "em_name" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_name = dr [ "em_name" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_sex" ) & & ! ( dr [ "em_sex" ] is DBNull ) )
{
tmpObj . _em_sex = Convert . ToBoolean ( dr [ "em_sex" ] . ToString ( ) ) ; ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_sex = Convert . ToBoolean ( dr [ "em_sex" ] . ToString ( ) ) ; ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_birthday" ) & & ! ( dr [ "em_birthday" ] is DBNull ) )
{
tmpObj . _em_birthday = dr [ "em_birthday" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_birthday = dr [ "em_birthday" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_education" ) & & ! ( dr [ "em_education" ] is DBNull ) )
{
tmpObj . _em_education = dr [ "em_education" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_education = dr [ "em_education" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_dept" ) & & ! ( dr [ "em_dept" ] is DBNull ) )
{
tmpObj . _em_dept = dr [ "em_dept" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_dept = dr [ "em_dept" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_jobcode" ) & & ! ( dr [ "em_jobcode" ] is DBNull ) )
{
tmpObj . _em_jobcode = dr [ "em_jobcode" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_jobcode = dr [ "em_jobcode" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_type" ) & & ! ( dr [ "em_type" ] is DBNull ) )
{
tmpObj . _em_type = dr [ "em_type" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_type = dr [ "em_type" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_idnum" ) & & ! ( dr [ "em_idnum" ] is DBNull ) )
{
tmpObj . _em_idnum = dr [ "em_idnum" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_idnum = dr [ "em_idnum" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_cellnum" ) & & ! ( dr [ "em_cellnum" ] is DBNull ) )
{
tmpObj . _em_cellnum = dr [ "em_cellnum" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_cellnum = dr [ "em_cellnum" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_email" ) & & ! ( dr [ "em_email" ] is DBNull ) )
{
tmpObj . _em_email = dr [ "em_email" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_email = dr [ "em_email" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_account" ) & & ! ( dr [ "em_account" ] is DBNull ) )
{
tmpObj . _em_account = dr [ "em_account" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_account = dr [ "em_account" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_passwd" ) & & ! ( dr [ "em_passwd" ] is DBNull ) )
{
tmpObj . _em_passwd = dr [ "em_passwd" ] . ToString ( ) ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_passwd = dr [ "em_passwd" ] . ToString ( ) ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "em_profile" ) & & ! ( dr [ "em_profile" ] is DBNull ) )
{
2023-09-04 22:41:19 +08:00
tmpObj . _em_profile = dr [ "em_profile" ] . ToString ( ) ; ;
tmpObj . _Oem_profile = ( dr [ "em_profile" ] . ToString ( ) ) ; ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "token" ) & & ! ( dr [ "token" ] is DBNull ) )
{
2023-09-04 22:41:19 +08:00
tmpObj . _token = ( dr [ "token" ] . ToString ( ) ) ; ;
tmpObj . _Otoken = ( dr [ "token" ] . ToString ( ) ) ; ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "dr" ) & & ! ( dr [ "dr" ] is DBNull ) )
{
tmpObj . _dr = Convert . ToBoolean ( dr [ "dr" ] . ToString ( ) ) ; ;
}
if ( dr . Table . Columns . Contains ( "operater" ) & & ! ( dr [ "operater" ] is DBNull ) )
{
tmpObj . _operater = Convert . ToInt32 ( dr [ "operater" ] . ToString ( ) ) ; ;
2023-09-04 22:41:19 +08:00
tmpObj . _Ooperater = Convert . ToInt32 ( dr [ "operater" ] . ToString ( ) ) ; ;
2023-05-23 16:13:17 +08:00
}
if ( dr . Table . Columns . Contains ( "create_time" ) & & ! ( dr [ "create_time" ] is DBNull ) )
{
tmpObj . _create_time = dr [ "create_time" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "lastmodified" ) & & ! ( dr [ "lastmodified" ] is DBNull ) )
{
tmpObj . _lastmodified = dr [ "lastmodified" ] . ToString ( ) ;
}
if ( dr . Table . Columns . Contains ( "em_isOnline" ) & & ! ( dr [ "em_isOnline" ] is DBNull ) )
{
tmpObj . _em_isOnline = Convert . ToBoolean ( dr [ "em_isOnline" ] . ToString ( ) ) ; ;
2023-09-04 22:41:19 +08:00
tmpObj . _Oem_isOnline = Convert . ToBoolean ( dr [ "em_isOnline" ] . ToString ( ) ) ; ;
2023-05-23 16:13:17 +08:00
}
}
}
protected override void CmdPrepare ( SqlCommand oraCmd ) {
Employee_base tmpObj = ( Employee_base ) modelObj ;
switch ( this . _op_flag ) {
case ( int ) op_flag . add :
2023-09-04 22:41:19 +08:00
_strSql = "INSERT INTO dbo.T_EMPLOYEE({0}) VALUES({1} )" ;
_strSql = String . Format ( _strSql , getFields ( tmpObj ) , getValues ( tmpObj ) ) ;
2023-05-23 16:13:17 +08:00
break ;
case ( int ) op_flag . update :
2023-09-04 22:41:19 +08:00
// _strSql = "UPDATE dbo.T_EMPLOYEE SET EM_NAME = @EM_NAME,EM_SEX = @EM_SEX,EM_BIRTHDAY = @EM_BIRTHDAY,EM_EDUCATION = @EM_EDUCATION,EM_DEPT = @EM_DEPT,EM_JOBCODE = @EM_JOBCODE,EM_TYPE = @EM_TYPE,EM_IDNUM = @EM_IDNUM,EM_CELLNUM = @EM_CELLNUM,EM_EMAIL = @EM_EMAIL,EM_ACCOUNT = @EM_ACCOUNT,EM_PASSWD = @EM_PASSWD,EM_PROFILE = @EM_PROFILE,TOKEN = @TOKEN,OPERATER = @OPERATER,LASTMODIFIED = getdate(),EM_ISONLINE = @EM_ISONLINE WHERE ID = @ID";
_strSql = "UPDATE dbo.T_EMPLOYEE {0} WHERE ID = @ID" ;
_strSql = String . Format ( _strSql , getChangedFields ( tmpObj ) ) ;
2023-05-23 16:13:17 +08:00
break ;
case ( int ) op_flag . delete :
// _strSql = "UPDATE dbo.T_EMPLOYEE SET DR =0 WHERE ID = @ID";
_strSql = "delete from dbo.T_EMPLOYEE WHERE ID = @ID" ;
break ;
case ( int ) op_flag . getObj :
_strSql = "SELECT * FROM dbo.T_EMPLOYEE WHERE ID = @ID" ;
break ;
case ( int ) op_flag . queryAll :
_strSql = "SELECT * FROM dbo.T_EMPLOYEE WHERE DR =1 " ;
2023-09-04 22:41:19 +08:00
// if (this.rownumEnd >0 )
2023-05-23 16:13:17 +08:00
{
2023-09-04 22:41:19 +08:00
// _strSql = "SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ID DESC) as sortNo FROM dbo.T_EMPLOYEE WHERE DR =1 )AS SORTEDTB WHERE DR =1 AND sortNo BETWEEN @START AND @END";
2023-05-23 16:13:17 +08:00
}
2023-09-04 22:41:19 +08:00
// _strSql += ";SELECT COUNT(*) FROM T_EMPLOYEE WHERE DR =1";
2023-05-23 16:13:17 +08:00
break ;
case ( int ) op_flag . queryActived :
_strSql = "SELECT * FROM dbo.T_EMPLOYEE WHERE DR =1" ;
_strSql + = ";SELECT COUNT(*) FROM T_EMPLOYEE WHERE DR =1" ;
break ;
case ( int ) op_flag . getPk :
_strSql = "SELECT MAX(ID) FROM dbo.T_EMPLOYEE WHERE DR =1" ;
break ;
case ( int ) op_flag . getCount :
_strSql = "SELECT COUNT(*) FROM T_EMPLOYEE WHERE DR =1" ;
break ;
}
oraCmd . CommandText = _strSql ;
fillParameters ( oraCmd , tmpObj ) ;
}
2023-09-04 22:41:19 +08:00
private string getFields ( Employee_base tmpObj )
{
String colums = "" ;
colums + = tmpObj . _em_name = = null ? "" : "EM_NAME" + "," ;
colums + = tmpObj . _em_sex = = null ? "" : "EM_SEX" + "," ;
colums + = tmpObj . _em_birthday = = null ? "" : "EM_BIRTHDAY" + "," ;
colums + = tmpObj . _em_education = = null ? "" : "EM_EDUCATION" + "," ;
colums + = tmpObj . _em_dept = = null ? "" : "EM_DEPT" + "," ;
colums + = tmpObj . _em_jobcode = = null ? "" : "EM_JOBCODE" + "," ;
colums + = tmpObj . _em_type = = null ? "" : "EM_TYPE" + "," ;
colums + = tmpObj . _em_idnum = = null ? "" : "EM_IDNUM" + "," ;
colums + = tmpObj . _em_cellnum = = null ? "" : "EM_CELLNUM" + "," ;
colums + = tmpObj . _em_email = = null ? "" : "EM_EMAIL" + "," ;
colums + = tmpObj . _em_account = = null ? "" : "EM_ACCOUNT" + "," ;
colums + = tmpObj . _em_passwd = = null ? "" : "EM_PASSWD" + "," ;
colums + = tmpObj . _em_profile = = null ? "" : "EM_PROFILE" + "," ;
colums + = tmpObj . _token = = null ? "" : "TOKEN" + "," ;
colums + = tmpObj . _operater = = null ? "" : "OPERATER" + "," ;
colums + = tmpObj . _em_isOnline = = null ? "" : "EM_ISONLINE" + "," ;
return colums . Substring ( 0 , colums . Length - 1 ) ;
}
2023-05-23 16:13:17 +08:00
2023-09-04 22:41:19 +08:00
private string getValues ( Employee_base tmpObj )
{
String values = "" ;
values + = tmpObj . _em_name = = null ? "" : "@EM_NAME" + "," ;
values + = tmpObj . _em_sex = = null ? "" : "@EM_SEX" + "," ;
values + = tmpObj . _em_birthday = = null ? "" : "@EM_BIRTHDAY" + "," ;
values + = tmpObj . _em_education = = null ? "" : "@EM_EDUCATION" + "," ;
values + = tmpObj . _em_dept = = null ? "" : "@EM_DEPT" + "," ;
values + = tmpObj . _em_jobcode = = null ? "" : "@EM_JOBCODE" + "," ;
values + = tmpObj . _em_type = = null ? "" : "@EM_TYPE" + "," ;
values + = tmpObj . _em_idnum = = null ? "" : "@EM_IDNUM" + "," ;
values + = tmpObj . _em_cellnum = = null ? "" : "@EM_CELLNUM" + "," ;
values + = tmpObj . _em_email = = null ? "" : "@EM_EMAIL" + "," ;
values + = tmpObj . _em_account = = null ? "" : "@EM_ACCOUNT" + "," ;
values + = tmpObj . _em_passwd = = null ? "" : "@EM_PASSWD" + "," ;
values + = tmpObj . _em_profile = = null ? "" : "@EM_PROFILE" + "," ;
values + = tmpObj . _token = = null ? "" : "@TOKEN" + "," ;
values + = tmpObj . _operater = = null ? "" : "@OPERATER" + "," ;
values + = tmpObj . _em_isOnline = = null ? "" : "@EM_ISONLINE" + "," ;
return values . Substring ( 0 , values . Length - 1 ) ;
}
private string getChangedFields ( Employee_base tmpObj )
{
string updateFields = " set " ;
if ( tmpObj . _em_name ! = null & & tmpObj . _em_name ! = tmpObj . _Oem_name )
{
updateFields + = "EM_NAME = @EM_NAME," ;
}
if ( tmpObj . _em_sex ! = null & & tmpObj . _em_sex ! = tmpObj . _Oem_sex )
{
updateFields + = "EM_SEX = @EM_SEX," ;
}
if ( tmpObj . _em_birthday ! = null & & tmpObj . _em_birthday ! = tmpObj . _Oem_birthday )
{
updateFields + = "EM_BIRTHDAY = @EM_BIRTHDAY," ;
}
if ( tmpObj . _em_education ! = null & & tmpObj . _em_education ! = tmpObj . _Oem_education )
{
updateFields + = "EM_EDUCATION = @EM_EDUCATION," ;
}
if ( tmpObj . _em_dept ! = null & & tmpObj . _em_dept ! = tmpObj . _Oem_dept )
{
updateFields + = "EM_DEPT = @EM_DEPT," ;
}
if ( tmpObj . _em_jobcode ! = null & & tmpObj . _em_jobcode ! = tmpObj . _Oem_jobcode )
{
updateFields + = "EM_JOBCODE = @EM_JOBCODE," ;
}
if ( tmpObj . _em_type ! = null & & tmpObj . _em_type ! = tmpObj . _Oem_type )
{
updateFields + = "EM_TYPE = @EM_TYPE," ;
}
if ( tmpObj . _em_idnum ! = null & & tmpObj . _em_idnum ! = tmpObj . _Oem_idnum )
{
updateFields + = "EM_IDNUM = @EM_IDNUM," ;
}
if ( tmpObj . _em_cellnum ! = null & & tmpObj . _em_cellnum ! = tmpObj . _Oem_cellnum )
{
updateFields + = "EM_CELLNUM = @EM_CELLNUM," ;
}
if ( tmpObj . _em_email ! = null & & tmpObj . _em_email ! = tmpObj . _Oem_email )
{
updateFields + = "EM_EMAIL = @EM_EMAIL," ;
}
if ( tmpObj . _em_account ! = null & & tmpObj . _em_account ! = tmpObj . _Oem_account )
{
updateFields + = "EM_ACCOUNT = @EM_ACCOUNT," ;
}
if ( tmpObj . _em_passwd ! = null & & tmpObj . _em_passwd ! = tmpObj . _Oem_passwd )
{
updateFields + = "EM_PASSWD = @EM_PASSWD," ;
}
if ( tmpObj . _em_profile ! = null & & tmpObj . _em_profile ! = tmpObj . _Oem_profile )
{
updateFields + = "EM_PROFILE = @EM_PROFILE," ;
}
if ( tmpObj . _token ! = null & & tmpObj . _token ! = tmpObj . _Otoken )
{
updateFields + = "TOKEN = @TOKEN," ;
}
if ( tmpObj . _operater ! = null & & tmpObj . _operater ! = tmpObj . _Ooperater )
{
updateFields + = "OPERATER = @OPERATER," ;
}
updateFields + = "LASTMODIFIED = getdate()" ;
if ( tmpObj . _em_isOnline ! = null & & tmpObj . _em_isOnline ! = tmpObj . _Oem_isOnline )
{
updateFields + = "EM_ISONLINE = @EM_ISONLINE," ;
}
return updateFields ;
}
2023-05-23 16:13:17 +08:00
private void fillParameters ( SqlCommand oraCmd , Employee_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 :
2023-09-04 22:41:19 +08:00
oraCmd . Parameters . AddWithValue ( "@ID" , tmpObj . ID ) ;
oraCmd . Parameters . AddWithValue ( "@EM_NAME" , VerifyDbnull ( tmpObj . _em_name ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_SEX" , VerifyDbnull ( tmpObj . _em_sex ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_BIRTHDAY" , VerifyDbnull ( tmpObj . _em_birthday ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_EDUCATION" , VerifyDbnull ( tmpObj . _em_education ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_DEPT" , VerifyDbnull ( tmpObj . _em_dept ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_JOBCODE" , VerifyDbnull ( tmpObj . _em_jobcode ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_TYPE" , VerifyDbnull ( tmpObj . _em_type ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_IDNUM" , VerifyDbnull ( tmpObj . _em_idnum ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_CELLNUM" , VerifyDbnull ( tmpObj . _em_cellnum ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_EMAIL" , VerifyDbnull ( tmpObj . _em_email ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_ACCOUNT" , VerifyDbnull ( tmpObj . _em_account ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_PASSWD" , VerifyDbnull ( tmpObj . _em_passwd ) ) ;
oraCmd . Parameters . AddWithValue ( "@EM_PROFILE" , VerifyDbnull ( tmpObj . _em_profile ) ) ;
oraCmd . Parameters . AddWithValue ( "@TOKEN" , VerifyDbnull ( tmpObj . _token ) ) ;
oraCmd . Parameters . AddWithValue ( "@OPERATER" , VerifyDbnull ( tmpObj . _operater ) ) ;
// oraCmd.Parameters.AddWithValue("@LASTMODIFIED", "getdate()") ;
oraCmd . Parameters . AddWithValue ( "@EM_ISONLINE" , VerifyDbnull ( tmpObj . _em_isOnline ) ) ;
return ;
case ( int ) op_flag . add :
if ( tmpObj . _em_name ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_NAME" , VerifyDbnull ( tmpObj . _em_name ) ) ;
if ( tmpObj . _em_sex ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_SEX" , VerifyDbnull ( tmpObj . _em_sex ) ) ;
if ( tmpObj . _em_birthday ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_BIRTHDAY" , VerifyDbnull ( tmpObj . _em_birthday ) ) ;
if ( tmpObj . _em_education ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_EDUCATION" , VerifyDbnull ( tmpObj . _em_education ) ) ;
if ( tmpObj . _em_dept ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_DEPT" , VerifyDbnull ( tmpObj . _em_dept ) ) ;
if ( tmpObj . _em_jobcode ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_JOBCODE" , VerifyDbnull ( tmpObj . _em_jobcode ) ) ;
if ( tmpObj . _em_type ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_TYPE" , VerifyDbnull ( tmpObj . _em_type ) ) ;
if ( tmpObj . _em_idnum ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_IDNUM" , VerifyDbnull ( tmpObj . _em_idnum ) ) ;
if ( tmpObj . _em_cellnum ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_CELLNUM" , VerifyDbnull ( tmpObj . _em_cellnum ) ) ;
if ( tmpObj . _em_email ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_EMAIL" , VerifyDbnull ( tmpObj . _em_email ) ) ;
if ( tmpObj . _em_account ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_ACCOUNT" , VerifyDbnull ( tmpObj . _em_account ) ) ;
if ( tmpObj . _em_passwd ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_PASSWD" , VerifyDbnull ( tmpObj . _em_passwd ) ) ;
if ( tmpObj . _em_profile ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_PROFILE" , VerifyDbnull ( tmpObj . _em_profile ) ) ;
if ( tmpObj . _token ! = null )
oraCmd . Parameters . AddWithValue ( "@TOKEN" , VerifyDbnull ( tmpObj . _token ) ) ;
if ( tmpObj . _operater ! = null )
oraCmd . Parameters . AddWithValue ( "@OPERATER" , VerifyDbnull ( tmpObj . _operater ) ) ;
if ( tmpObj . _em_isOnline ! = null )
oraCmd . Parameters . AddWithValue ( "@EM_ISONLINE" , VerifyDbnull ( tmpObj . _em_isOnline ) ) ;
return ;
2023-05-23 16:13:17 +08:00
}
2023-09-04 22:41:19 +08:00
2023-05-23 16:13:17 +08:00
}
protected override enumDbInstance instance
{
get
{
2023-09-04 22:41:19 +08:00
2023-05-23 16:13:17 +08:00
return enumDbInstance . platForm ;
}
}
}
#endregion
}