从类调用变量（DateTime） [英] Calling variables from class (DateTime)

问题描述

我需要从另一个类调用我的datetime变量，

I need to call my datetime variable from another class,

这是使用日期条件进行查询的代码

this is the code for querying with date condition

static DataTable GetCustomerRecords(DateTime date, DateTime date2)
        {
            var connSettings = ConfigurationManager.ConnectionStrings["MyDB"];
            {

                string CN = connSettings.ConnectionString;
                MySqlConnection conn = new MySqlConnection(CN);
                MySqlCommand cmd = new MySqlCommand("select value1, value2, value3, date2 from dummy table where date1 >= CAST(@startDate AS DATE) and date2 <= CAST(@endDate AS DATE)", conn);
                cmd.Parameters.AddWithValue("@startDate", date);
                cmd.Parameters.AddWithValue("@endDate", date2);
                MySqlDataAdapter data = new MySqlDataAdapter(cmd);
                conn.Open();
                DataTable dt = new DataTable();
                data.Fill(dt);
                return dt;
            }

        }

 public object QueryRecords(DateTime date, DateTime date2)
        {
            DataTable table = GetCustomerRecords();
            return table;
        }

我的DatePicker 1和2 ValueChanged

My DatePicker 1 and 2 ValueChanged

 GetRecords Retrieve = new GetRecords();
 private void datePicker1_ValueChanged(object sender, EventArgs e)
    {
        Retrieve.GetCustomerRecords(date)/error here of course
    }

    private void datePicker2_ValueChanged(object sender, EventArgs e)
    {
        Retrieve.GetCustomerRecords(date2)/error here of course

    }

我不知道如何做正确的方法调用，这里是新的。

i don't know how to do proper calling of method, im new at this.

推荐答案

这将是您的表单（代码背后），您将有三个事件。两个选择开始日期和结束日期。最后一个是你的按钮点击事件来调用你的其他类。

private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
  this.StartDate = dateTimePicker1.Value.Date;
}

private void dateTimePicker2_ValueChanged(object sender, EventArgs e)
{
  this.EndDate = dateTimePicker1.Value.Date;
}

private void button2_Click(object sender, EventArgs e)
{
  DataTable results = GetCustomerRecords.GetCustomerRecord(this.StartDate, this.EndDate);
}




public static class GetCustomerRecords
{
  public static DataTable GetCustomerRecord(DateTime date, DateTime date2)
  {
    DataTable dt = new DataTable();
    string connStr = ConfigurationManager.ConnectionStrings["YourConnStr"].ConnectionString;
    string query = @"select 
                      value1, 
                      value2, 
                      value3, 
                      date2 
                     from TABLE 
                     where date1 BETWEEN 
                     CAST(@startDate AS DATE) and CAST(@endDate AS DATE)";

    using(SqlConnection conn = new SqlConnection(connStr))
    using (SqlCommand cmd = new SqlCommand(query, conn))
    {
      cmd.Parameters.AddWithValue("@startDate", date);
      cmd.Parameters.AddWithValue("@endDate", date2);
      SqlDataAdapter adapter = new SqlDataAdapter();
      adapter.Fill(dt);
    }

     return dt;
   }
}

这篇关于从类调用变量（DateTime）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！