void _runCreate(string nValue, string nName,
SqlFieldId_ nSqlFieldId = SqlFieldId_.mNone_)
{
if (false == mBeg)
{
mValue += ",";
}
mValue += mFieldCharacter;
mValue += nName;
mValue += mFieldCharacter;
mValue += " ";
mValue += nValue;
if ((nSqlFieldId & SqlFieldId_.mZeroFill_) > 0)
{
mValue += " ZEROFILL";
}
if ((nSqlFieldId & SqlFieldId_.mBinary_) > 0)
{
mValue += " BINARY";
}
if ((nSqlFieldId & SqlFieldId_.mNotNull_) > 0)
{
mValue += " NOT NULL";
}
if ((nSqlFieldId & SqlFieldId_.mAutoIncremet_) > 0)
{
mValue += " AUTO_INCREMENT";
}
if (mBeg)
{
mBeg = false;
}
}
public void _serialize(ref bool nValue, string nName,
SqlFieldId_ nSqlFieldId = SqlFieldId_.mNone_)
{
if (SqlDeal_.mCreate_ == mSqlDeal)
{
this._runCreate(@"TINYINT(1)", nName, nSqlFieldId);
}
else if ((SqlDeal_.mPrimary_ == mSqlDeal) &&
((nSqlFieldId & SqlFieldId_.mPrimary_) > 0))
{
this._runPrimary(nName);
}
else if (SqlDeal_.mSelect_ == mSqlDeal)
{
this._runSelect(nName);
}
else if (SqlDeal_.mWhere_ == mSqlDeal)
{
this._runWhere(nValue, nName);
}
else if (SqlDeal_.mInsert_ == mSqlDeal)
{
this._runInsert(nValue);
}
else if (SqlDeal_.mInsertUpdate_ == mSqlDeal)
{
this._runInsertUpdate(nName);
}
else if (SqlDeal_.mInsertUpdateE_ == mSqlDeal)
{
this._runInsertUpdateE(nName, nValue);
}
else if (SqlDeal_.mInsertUpdateEx_ == mSqlDeal)
{
this._runInsertUpdateEx(nName);
}
else if (SqlDeal_.mUpdate_ == mSqlDeal)
{
this._runUpdate(nValue, nName);
}
else if (SqlDeal_.mUpdateSelect_ == mSqlDeal)
{
this._updateSelect(nName);
}
else if (SqlDeal_.mUpdateWhen_ == mSqlDeal)
{
this._updateWhen(nValue);
}
else if (SqlDeal_.mUpdateThen_ == mSqlDeal)
{
this._updateThen(nValue, nName);
}
else
{
}
}
public void _serialize(ref byte[] nValue, string nName,
SqlFieldId_ nSqlFieldId = SqlFieldId_.mNone_)
{
string name = string.Format(@"{0}_i", nName);
int size_ = mMySqlDataReader.GetInt32(name);
nValue = new byte[size_];
int ordinal = mMySqlDataReader.GetOrdinal(nName);
mMySqlDataReader.GetBytes(ordinal, 0, nValue, 0, size_);
}
public void _serialize(ref byte[] nValue, string nName,
SqlFieldId_ nSqlFieldId = SqlFieldId_.mNone_)
{
if (SqlDeal_.mCreate_ == mSqlDeal)
{
this._createBlob(nName);
}
else if (SqlDeal_.mSelect_ == mSqlDeal)
{
this._selectBlob(nName);
}
else if (SqlDeal_.mInsertUpdateE_ == mSqlDeal)
{
this._insertUpdateEBlob(nValue, nName);
}
else if (SqlDeal_.mInsertUpdateEx_ == mSqlDeal)
{
this._insertUpdateExBlob(nName);
}
}
public void _serialize <__t>(ref __t nValue, string nName,
SqlFieldId_ nSqlFieldId = SqlFieldId_.mNone_)
{
}
public void _serialize(ref ulong nValue, string nName,
SqlFieldId_ nSqlFieldId = SqlFieldId_.mNone_)
{
nValue = mMySqlDataReader.GetUInt64(nName);
}
public void _serialize(ref int nValue, string nName,
SqlFieldId_ nSqlFieldId = SqlFieldId_.mNone_)
{
nValue = mMySqlDataReader.GetInt32(nName);
}
public void _serialize(ref byte nValue, string nName,
SqlFieldId_ nSqlFieldId = SqlFieldId_.mNone_)
{
nValue = mMySqlDataReader.GetByte(nName);
}