private void Birth_Form_Load(object sender, EventArgs e) { string SQL_Query = "SELECT Real_Name, Phone, Birth, Now_Company, Now_Live, "; SQL_Query += " SWITCH(Archive_Type = 'Archive', '客户', Archive_Type = 'Friend', '朋友') AS Type "; SQL_Query += "FROM Archive_Table WHERE DateDiff('d', DATE(), Birth) > 31"; dataGridView_Info.DataSource = Class_SQL_Deal.DataTable_Get(SQL_Query); }
private void button_SearchDiary_Click(object sender, EventArgs e) { string SQL_Query_Diary = string.Empty; SQL_Query_Diary = "SELECT Diary_Title,Diary_Text, Diary_Date FROM Diary_Table "; SQL_Query_Diary += "WHERE Diary_Date BETWEEN #" + dateTimePicker_StartTime.Value.ToShortDateString() + "# AND #" + dateTimePicker_EndTime.Value.ToShortDateString() + "#"; dataGridView_Diary.DataSource = Class_SQL_Deal.DataTable_Get(SQL_Query_Diary); }
private void VisitInfo_Form_Load(object sender, EventArgs e) { string SQL_Query = "SELECT Real_Name, Phone, Visit_Date, Visit_Reamrk, Visit_Place, "; SQL_Query += " SWITCH(Visit_Type = 'Archive', '客户', Visit_Type = 'Friend', '朋友') AS Type "; SQL_Query += "FROM Visit_Table WHERE DATE() < Visit_Date"; dataGridView_Info.DataSource = Class_SQL_Deal.DataTable_Get(SQL_Query); }
private void button_View_Click(object sender, EventArgs e) { if (richTextBox_Diary.Text != "") { if (MessageBox.Show("您还有未保存的日记,若跳转请点击确认!", "Tips", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { groupBox_Title.Visible = false; richTextBox_Diary.Visible = false; groupBox_View.Visible = true; dataGridView_Diary.Visible = true; dataGridView_Diary.DataSource = Class_SQL_Deal.DataTable_Get("SELECT Diary_Title,Diary_Text, Diary_Date FROM Diary_Table ");//加载日记数据 } } else { groupBox_Title.Visible = false; richTextBox_Diary.Visible = false; groupBox_View.Visible = true; dataGridView_Diary.Visible = true; dataGridView_Diary.DataSource = Class_SQL_Deal.DataTable_Get("SELECT Diary_Title,Diary_Text, Diary_Date FROM Diary_Table ");//加载日记数据 } }