?? main.cs
字號:
this.label7.Size = new System.Drawing.Size(40, 16);
this.label7.TabIndex = 23;
this.label7.Text = "提示選項 ";
//
// label6
//
this.label6.Location = new System.Drawing.Point(8, 53);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(40, 16);
this.label6.TabIndex = 22;
this.label6.Text = "時間";
//
// label5
//
this.label5.Location = new System.Drawing.Point(328, 20);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(48, 16);
this.label5.TabIndex = 21;
this.label5.Text = "優先度";
//
// label4
//
this.label4.Location = new System.Drawing.Point(8, 20);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(40, 16);
this.label4.TabIndex = 20;
this.label4.Text = "類型";
//
// scheduleGroup
//
this.scheduleGroup.Controls.AddRange(new System.Windows.Forms.Control[] {
this.label2,
this.label1,
this.taskTitleBox,
this.taskDetailBox});
this.scheduleGroup.Location = new System.Drawing.Point(24, 8);
this.scheduleGroup.Name = "scheduleGroup";
this.scheduleGroup.Size = new System.Drawing.Size(744, 232);
this.scheduleGroup.TabIndex = 9;
this.scheduleGroup.TabStop = false;
this.scheduleGroup.Text = "新日程屬性";
//
// label2
//
this.label2.Location = new System.Drawing.Point(8, 67);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(40, 16);
this.label2.TabIndex = 3;
this.label2.Text = "內容";
//
// label1
//
this.label1.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label1.Location = new System.Drawing.Point(8, 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(40, 16);
this.label1.TabIndex = 2;
this.label1.Text = "標題";
//
// taskTitleBox
//
this.taskTitleBox.BackColor = System.Drawing.SystemColors.Info;
this.taskTitleBox.Location = new System.Drawing.Point(56, 32);
this.taskTitleBox.MaxLength = 256;
this.taskTitleBox.Name = "taskTitleBox";
this.taskTitleBox.Size = new System.Drawing.Size(624, 21);
this.taskTitleBox.TabIndex = 1;
this.taskTitleBox.Text = "";
//
// taskDetailBox
//
this.taskDetailBox.BackColor = System.Drawing.SystemColors.Info;
this.taskDetailBox.Location = new System.Drawing.Point(56, 72);
this.taskDetailBox.MaxLength = 8000;
this.taskDetailBox.Multiline = true;
this.taskDetailBox.Name = "taskDetailBox";
this.taskDetailBox.Size = new System.Drawing.Size(624, 136);
this.taskDetailBox.TabIndex = 2;
this.taskDetailBox.Text = "";
//
// OK
//
this.OK.Location = new System.Drawing.Point(680, 384);
this.OK.Name = "OK";
this.OK.TabIndex = 0;
this.OK.Text = "確定";
this.OK.Click += new System.EventHandler(this.OK_Click);
//
// tp_notdoneview
//
this.tp_notdoneview.Name = "tp_notdoneview";
this.tp_notdoneview.TabIndex = 0;
//
// MainForm
//
this.AutoScale = false;
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(792, 566);
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.tabControl1});
this.MaximizeBox = false;
this.Name = "MainForm";
this.Text = "SmartSchedule";
this.Load += new System.EventHandler(this.MainForm_Load);
this.tabControl1.ResumeLayout(false);
this.tabPage_scheduleshow.ResumeLayout(false);
this.tabControl2.ResumeLayout(false);
this.tp_dayview.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dg_dayview)).EndInit();
this.tp_thingsleft.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dg_Remain)).EndInit();
this.tp_addSchedule.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
this.scheduleGroup.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// 應用程序的主入口點。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new MainForm());
}
private void MainForm_Load(object sender, System.EventArgs e)
{
///設置控件屬性
///
taskDateTimeSetupBox.CustomFormat = "hh:mm:ss yyyy年MM月dd日,dddd";
///填充日視圖
///
myConn = new SqlConnection(ConnString);
try
{
myConn.Open();
}
catch(Exception ee)
{
MessageBox.Show (ee.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
Application.Exit();
}
Init_AddSchedulePage();
if ( Fill_dayview(DateTime.Now) == -1 || Fill_RemainView() == -1)
Application.Exit();
}
//////////////////////////////////////////////////////////////////////////
///<summary>
///用于生成日視圖
///</summary>
///<param name="GivenDay"></param>
private int Fill_dayview(DateTime GivenDay)
{
DataSet DS_DayView = new DataSet();
MySchedule DaySchedule = new MySchedule();
if(!DaySchedule.GetScheduleByGivenDay(ref myConn, ref DS_DayView, ref GivenDay))
return -1;
int nScheduleCount = DS_DayView.Tables["ScheduleList"].Rows.Count;
// if( nScheduleCount > 0)
dg_dayview.DataSource = DS_DayView.Tables["ScheduleList"].DefaultView;
return 0;
}
//////////////////////////////////////////////////////////////////////////
/// <summary>
/// 初始化“添加日程”屬性頁
/// </summary>
private bool Init_AddSchedulePage()
{
if(!Init_TaskTypeBox() || !Init_TaskPriorityBox())
return false;
taskTitleBox.Text = "";
taskDetailBox.Text = "";
taskDateTimeSetupBox.Value = DateTime.Now;
notifyCheckBox.Checked = true;
notifyTimeSetupBox.Enabled = true;
notifyTimeSetupBox.SelectedIndex = 0;
periodSetupListBox.SelectedIndex = 0;
return true;
}
//////////////////////////////////////////////////////////////////////////
/// <summary>
/// 初始化任務類型列表
/// </summary>
private bool Init_TaskTypeBox()
{
SqlDataAdapter da_tasktype = new SqlDataAdapter("FillTaskTypeBox",myConn);
da_tasktype.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet ds_TaskType = new DataSet();
try
{
da_tasktype.Fill(ds_TaskType, "TaskType");
taskTypeListbox.DataSource = ds_TaskType.Tables["TaskType"];
taskTypeListbox.DisplayMember = "TypeTitle";
taskTypeListbox.ValueMember = "TASKTYPE_ID";
}
catch(Exception e)
{
MessageBox.Show(e.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return false;
}
return true;
}
//////////////////////////////////////////////////////////////////////////
/// <summary>
/// 初始化任務優先度列表
/// </summary>
private bool Init_TaskPriorityBox()
{
SqlDataAdapter da_TaskPriority = new SqlDataAdapter("FillTaskPriorityBox",myConn);
da_TaskPriority.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet ds_TaskPriority = new DataSet();
try
{
da_TaskPriority.Fill(ds_TaskPriority, "TaskPriority");
taskPriorityListbox.DataSource = ds_TaskPriority.Tables["TaskPriority"];
taskPriorityListbox.DisplayMember = "PriorityTitle";
taskPriorityListbox.ValueMember = "PRIORITY_ID";
taskPriorityListbox.SelectedIndex = 1;
}
catch(Exception e)
{
MessageBox.Show(e.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return false;
}
return true;
}
//////////////////////////////////////////////////////////////////////////
/// <summary>
/// 計算提醒時間
/// </summary>
/// <param name="BeginTime"></param>
private DateTime notifyTimeCalc(ref DateTime BeginTime)
{
DateTime notifyTime = BeginTime;
string forwardTime = notifyTimeSetupBox.SelectedText.Trim();
if(notifyCheckBox.Checked)
{
switch(forwardTime)
{
case "準時提醒":
break;
case "提前15分鐘":
notifyTime.AddMinutes(-15);
break;
case "提前30分鐘":
notifyTime.AddMinutes(-30);
break;
case "提前45分鐘":
notifyTime.AddMinutes(-45);
break;
case "提前1小時":
notifyTime.AddHours(-1);
break;
case "提前2小時":
notifyTime.AddHours(-2);
break;
case "提前6小時":
notifyTime.AddHours(-6);
break;
case "提前12小時":
notifyTime.AddHours(-12);
break;
case "提前1天":
notifyTime.AddDays(-1);
break;
case "提前1周":
notifyTime.AddDays(-7);
break;
case "提前1月":
notifyTime.AddMonths(-1);
break;
default:
break;
}
}
return notifyTime;
}
private void notifyCheckBox_Click(object sender, System.EventArgs e)
{
notifyTimeSetupBox.Enabled = notifyCheckBox.Checked;
}
private void OK_Click(object sender, System.EventArgs e)
{
if(taskTitleBox.Text == "" )
{
MessageBox.Show("日程標題不能為空！","Error");
return;
}
if(taskTypeListbox.SelectedIndex == -1)
{
MessageBox.Show("請指定日程類型！","Error");
return;
}
if(taskPriorityListbox.SelectedIndex == -1)
{
MessageBox.Show("請指定優先度！","Error");
return;
}
string Title = taskTitleBox.Text.Trim(); //標題
string Detail = taskDetailBox.Text.Trim(); //內容
if(Detail == "") Detail = "無詳細信息";
DateTime BeginTime = DateTime.Parse(taskDateTimeSetupBox.Text.Trim()); //開始時間
if(BeginTime < DateTime.Now)
{
MessageBox.Show("日程開始時間已過！","Error");
return;
}
int Type = Int32.Parse(taskTypeListbox.SelectedValue.ToString()); //類型
int Priority = Int32.Parse(taskPriorityListbox.SelectedValue.ToString()); //優先級
int NeedNotify = 0;
if(notifyCheckBox.Checked) //是否需要提醒
NeedNotify = 1;
DateTime NotifyTime = BeginTime;
if(NeedNotify == 1)
notifyTimeCalc(ref BeginTime);
MySchedule NewSchedule = new MySchedule();
NewSchedule.SetSchedule(0, Title, Detail, BeginTime, NotifyTime, NeedNotify, Type, Priority);
if(!NewSchedule.InsertSchedule(ref myConn))
MessageBox.Show("添加新日程失敗！","Error");
MessageBox.Show("添加新日程成功！","OK");
return;
}
private void Cancel_Click(object sender, System.EventArgs e)
{
Init_AddSchedulePage();
}
private void tabControl1_SelectedIndexChanged(object sender, System.EventArgs e)
{
if ( Fill_dayview(DateTime.Now) == -1 || Fill_RemainView() == -1)
Application.Exit();
}
//////////////////////////////////////////////////////////////////////////
///<summary>
///用于生成未完成事件視圖
///</summary>
private int Fill_RemainView()
{
DataSet DS_Unfinished = new DataSet();
MySchedule UnfinishedSchedule = new MySchedule();
if(!UnfinishedSchedule.GetUnfinishedSchedule(ref myConn, ref DS_Unfinished))
return -1;
if(DS_Unfinished.Tables["ScheduleList"].Rows.Count > 0)
{
dg_Remain.DataSource = DS_Unfinished.Tables["ScheduleList"].DefaultView;
}
return 0;
}
private void ViewScheduleButton_Click(object sender, System.EventArgs e)
{
DateTime GivenDay = DateTime.Parse(SelectDay.Text.Trim());
Fill_dayview(GivenDay);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -