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 ");//加载日记数据
}
}
