public static void LoadSMSClients()
        {
            string _str = "select * from sms_client_tb";

            sms.smsClient _obj = null;
            using (var _dr = dbm.SelectCommand(_str))
            {
                if (_dr == null)
                {
                    return;
                }
                while (_dr.Read())
                {
                    _obj                = new smsClient();
                    _obj.account_id     = _dr["account_id"].ToInt32();
                    _obj.client_id      = _dr["client_id"].ToInt32();
                    _obj.client_name    = _dr["client_name"].ToStringNullable();
                    _obj.email          = _dr["client_email"].ToStringNullable();
                    _obj.client_phone   = _dr["client_phone"].ToStringNullable();
                    _obj.client_sms_cp  = _dr["client_sms_cp"].ToFloat();
                    _obj.default_header = _dr["d_header"].ToStringNullable();
                    _obj.default_msg    = _dr["d_message"].ToStringNullable();
                    _obj.fsys_id        = _dr["fsys_id"].ToInt32();
                    _obj.start_date     = _dr["start_date"] == null ? null : _dr.GetDateTime("start_date").ToString(new CultureInfo("en-US"));
                    _obj.start_date     = _dr["end_date"] == null ? null : _dr.GetDateTime("end_date").ToString(new CultureInfo("en-US"));
                    DATA_SMS_FILE_SYSTEM[_obj.fsys_id].sms_client_obj = _obj;
                    _obj = null;
                }
            }
        }
 private void ComposeSms_Load(object sender, EventArgs e)
 {
     CenterToScreen();
     m_client = (sms.smsClient) this.Tag;
     if (m_client == null)
     {
         this.Close(); return;
     }
     buttoncancel.PerformClick();
     backworker.RunWorkerAsync();
     this.FormClosing += new FormClosingEventHandler(ComposeSms_FormClosing);
 }