Пример #1
0
        private void BtnClickQue(object sender, RoutedEventArgs e)
        {
            data.Clear();
            data.Add(colHead);
            string          sqlStr = "call showCAcc;";
            MySqlCommand    cmd    = new MySqlCommand(sqlStr, con);
            MySqlDataReader reader = null;

            try {
                reader = cmd.ExecuteReader();
                CAccListItem item = new CAccListItem();
                while (reader.Read())
                {
                    item.SAccNum = reader.GetString(0);
                    item.BName   = reader.GetString(1);
                    item.CID     = reader.GetString(2);
                    item.LVDate  = reader.GetDateTime(3).ToLongDateString();

                    item.balance   = reader.GetString(4);
                    item.applyDate = reader.GetDateTime(5).ToLongDateString();
                    item.ODraft    = reader.GetString(6);
                    data.Add(new CAccListItem(item));
                }
                TxtAlert.Text = "Query success!";
            }
            catch (MySqlException ex) {
                TxtAlert.Text  = "Fail to execute sql command!\nError message: ";
                TxtAlert.Text += ex.Message;
            }
            finally {
                reader.Close();
            }
        }
Пример #2
0
 public void Init(CAccListItem item)
 {
     SAccNum   = item.SAccNum;
     BName     = item.BName;
     CID       = item.CID;
     LVDate    = item.LVDate;
     balance   = item.balance;
     applyDate = item.applyDate;
     ODraft    = item.ODraft;
 }
Пример #3
0
 public CAccListItem(CAccListItem item)
 {
     Init(item);
 }