Esempio n. 1
0
        protected override void LoadFromRow(DataRow _dataRow)
        {
            SummitDS.MessageRow _thisRow = _dataRow as SummitDS.MessageRow;

            if (_thisRow != null)
            {
                this._ID               = _thisRow.ID;
                this.m_dtMessageTime   = _thisRow.IsmessageTimeNull() ? (Nullable <DateTime>)null : _thisRow.messageTime;
                this.m_strMessage      = _thisRow.IsmessageNull() ? String.Empty : _thisRow.message;
                this.m_strAttachment   = _thisRow.IsattachemetNull() ? String.Empty : _thisRow.attachemet;
                this.m_iType           = _thisRow.IstypeNull() ? (Nullable <Int32>)null : _thisRow.type;
                this.m_iShopID         = _thisRow.Isshop_idNull() ? (Nullable <Int32>)null : _thisRow.shop_id;
                this.m_iPhoneUserID    = _thisRow.IsphoneUser_idNull() ? (Nullable <Int32>)null : _thisRow.phoneUser_id;
                this.m_strLocationLink = _thisRow.IslocationLinkNull() ? String.Empty : _thisRow.locationLink;
                this.m_bIsRead         = _thisRow.Isis_readNull() ? (Nullable <Boolean>)null : _thisRow.is_read;
                this.m_fLatitude       = _thisRow.IslatitudeNull() ? (Nullable <double>)null : _thisRow.latitude;
                this.m_fLongitude      = _thisRow.IslongitudeNull() ? (Nullable <double>)null : _thisRow.longitude;
                this.iPrivateLabelID   = _thisRow.Isprivate_label_idNull() ? (Nullable <Int32>)null : _thisRow.private_label_id;

                //  this.m_dt_ts = _thisRow.Is_tsNull() ? (Nullable<DateTime>) null : _thisRow._ts ;
                _rowToSave = _thisRow;
            }
        }
Esempio n. 2
0
        protected override void SaveToRow()
        {
            SummitDS.MessageDataTable _thisTable = new SummitDS.MessageDataTable();
            if (_rowToSave == null)
            {
                _rowToSave = _thisTable.NewMessageRow();
            }
            SummitDS.MessageRow _dataRow = _rowToSave as SummitDS.MessageRow;

            if (_dataRow != null)
            {
                if (IsExisting())
                {
                    if (!m_dtMessageTime.HasValue)
                    {
                        if (!_dataRow.IsmessageTimeNull())
                        {
                            _dataRow.SetmessageTimeNull();
                        }
                    }
                    else if (_dataRow.IsmessageTimeNull() ? true : _dataRow.messageTime != m_dtMessageTime.Value)
                    {
                        _dataRow.messageTime = m_dtMessageTime.Value;
                    }

                    if (String.IsNullOrEmpty(m_strMessage))
                    {
                        if (!_dataRow.IsmessageNull())
                        {
                            _dataRow.SetmessageNull();
                        }
                    }
                    else if (_dataRow.IsmessageNull() ? true : _dataRow.message != m_strMessage)
                    {
                        _dataRow.message = m_strMessage;
                    }

                    if (String.IsNullOrEmpty(m_strAttachment))
                    {
                        if (!_dataRow.IsattachemetNull())
                        {
                            _dataRow.SetattachemetNull();
                        }
                    }
                    else if (_dataRow.IsattachemetNull() ? true : _dataRow.attachemet != m_strAttachment)
                    {
                        _dataRow.attachemet = m_strAttachment;
                    }

                    if (iType.HasValue)
                    {
                        _dataRow.type = iType.Value;
                    }
                    else
                    {
                        _dataRow.SettypeNull();
                    }

                    if (iShopID.HasValue)
                    {
                        _dataRow.shop_id = iShopID.Value;
                    }
                    else
                    {
                        _dataRow.Setshop_idNull();
                    }

                    if (_dataRow.phoneUser_id != m_iPhoneUserID)
                    {
                        _dataRow.phoneUser_id = Convert.ToInt32(m_iPhoneUserID);
                    }

                    if (String.IsNullOrEmpty(m_strLocationLink))
                    {
                        if (!_dataRow.IslocationLinkNull())
                        {
                            _dataRow.SetlocationLinkNull();
                        }
                    }
                    else if (_dataRow.IslocationLinkNull() ? true : _dataRow.locationLink != m_strLocationLink)
                    {
                        _dataRow.locationLink = m_strLocationLink;
                    }

                    if (bIsRead.HasValue)
                    {
                        _dataRow.is_read = bIsRead.Value;
                    }
                    else
                    {
                        _dataRow.Setis_readNull();
                    }

                    if (fLatitude.HasValue)
                    {
                        _dataRow.latitude = fLatitude.Value;
                    }
                    else
                    {
                        _dataRow.SetlatitudeNull();
                    }

                    if (fLongitude.HasValue)
                    {
                        _dataRow.longitude = fLongitude.Value;
                    }
                    else
                    {
                        _dataRow.SetlongitudeNull();
                    }

                    if (m_iPrivateLabelID.HasValue)
                    {
                        _dataRow.private_label_id = iPrivateLabelID.Value;
                    }
                    else
                    {
                        _dataRow.Setprivate_label_idNull();
                    }
                }
                else
                {
                    if (dtMessageTime.HasValue)
                    {
                        _dataRow.messageTime = dtMessageTime.Value;
                    }
                    else
                    {
                        _dataRow.SetmessageTimeNull();
                    }

                    if (String.IsNullOrEmpty(strMessage))
                    {
                        _dataRow.SetmessageNull();
                    }
                    else
                    {
                        _dataRow.message = strMessage;
                    }

                    if (String.IsNullOrEmpty(strAttachment))
                    {
                        _dataRow.SetattachemetNull();
                    }
                    else
                    {
                        _dataRow.attachemet = strAttachment;
                    }

                    if (iType.HasValue)
                    {
                        _dataRow.type = iType.Value;
                    }
                    else
                    {
                        _dataRow.SettypeNull();
                    }

                    if (iShopID.HasValue)
                    {
                        _dataRow.shop_id = iShopID.Value;
                    }
                    else
                    {
                        _dataRow.Setshop_idNull();
                    }

                    if (iPhoneUserID.HasValue)
                    {
                        _dataRow.phoneUser_id = iPhoneUserID.Value;
                    }
                    else
                    {
                        _dataRow.SetphoneUser_idNull();
                    }

                    if (String.IsNullOrEmpty(strLocationLink))
                    {
                        _dataRow.SetlocationLinkNull();
                    }
                    else
                    {
                        _dataRow.locationLink = strLocationLink;
                    }

                    if (bIsRead.HasValue)
                    {
                        _dataRow.is_read = bIsRead.Value;
                    }
                    else
                    {
                        _dataRow.Setis_readNull();
                    }

                    if (fLatitude.HasValue)
                    {
                        _dataRow.latitude = fLatitude.Value;
                    }
                    else
                    {
                        _dataRow.SetlatitudeNull();
                    }

                    if (fLongitude.HasValue)
                    {
                        _dataRow.longitude = fLongitude.Value;
                    }
                    else
                    {
                        _dataRow.SetlongitudeNull();
                    }

                    if (m_iPrivateLabelID.HasValue)
                    {
                        _dataRow.private_label_id = iPrivateLabelID.Value;
                    }
                    else
                    {
                        _dataRow.Setprivate_label_idNull();
                    }

                    _thisTable.AddMessageRow(_dataRow);
                }
            }
        }