?? schaddup.aspx.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using qminoa.Common.Data;
using qminoa.DA.Schedule;
namespace qminoa.Webs.Schedule
{
public class SchAddUp : qminoa.Webs.PageBase
{
protected System.Web.UI.WebControls.Image Image1;
protected System.Web.UI.WebControls.TextBox txtSubject;
protected System.Web.UI.WebControls.TextBox txtPlace;
protected System.Web.UI.WebControls.TextBox txtScheType;
protected System.Web.UI.WebControls.Image Image2;
protected System.Web.UI.WebControls.Image Image3;
protected System.Web.UI.WebControls.DropDownList dropPlace;
protected System.Web.UI.WebControls.DropDownList dropType;
protected System.Web.UI.WebControls.TextBox txtFDate;
protected System.Web.UI.WebControls.TextBox txtTDate;
protected System.Web.UI.WebControls.DropDownList dropFDate;
protected System.Web.UI.WebControls.DropDownList dropTDate;
protected System.Web.UI.WebControls.TextBox txtRemind;
protected System.Web.UI.WebControls.CheckBox chkRemind;
protected System.Web.UI.WebControls.TextBox txtContent;
protected System.Web.UI.WebControls.LinkButton cmdType;
protected System.Web.UI.WebControls.LinkButton cmdPlace;
protected System.Web.UI.WebControls.CheckBox chkPrivte;
protected System.Web.UI.WebControls.DropDownList dropRequenCate;
protected System.Web.UI.WebControls.CheckBox chkRepeat;
protected System.Web.UI.WebControls.TextBox txtUpToDate;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
protected System.Web.UI.WebControls.Label lblAuthorV;
protected System.Web.UI.WebControls.Label lblCDateV;
protected System.Web.UI.WebControls.ImageButton cmdSchedMsgDel;
protected System.Web.UI.WebControls.TextBox txtOtherMan;
protected System.Web.UI.WebControls.RangeValidator RangeValidator5;
protected System.Web.UI.WebControls.RangeValidator RangeValidator6;
protected System.Web.UI.WebControls.RangeValidator RangeValidator7;
protected System.Web.UI.WebControls.RangeValidator RangeValidator8;
protected System.Web.UI.WebControls.ImageButton cmdSaveExi;
protected System.Web.UI.WebControls.ImageButton cmdDel;
protected System.Web.UI.WebControls.ImageButton cmdExit;
protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
protected System.Web.UI.HtmlControls.HtmlButton cmdScheOMan;
protected System.Web.UI.WebControls.CheckBox chkImp;
private ScheduleDA scheduleDadaAccess = new ScheduleDA();
private int scheid = 0;
private static string reurl = "";
private static DateTime date = new DateTime();
private void Page_Load(object sender, System.EventArgs e)
{
this.PageBegin("我的日程",false);
reurl = Request.QueryString["reurl"];
if(Request.QueryString["day"] != null)
{
date = DateTime.Parse(Request.QueryString["day"]);
}
if(Request.QueryString["id"] != null)
{
scheid = Int32.Parse(Request.QueryString["id"]);
}
cmdSchedMsgDel.Attributes.Add("onclick", "return confirm('確定要刪除嗎？');");
if(!IsPostBack)
{
txtRemind.Enabled = chkRemind.Checked;
txtUpToDate.Enabled = chkRepeat.Checked;
dropRequenCate.Enabled = chkRepeat.Checked;
txtFDate.Text = date.ToString("d");
txtTDate.Text = date.ToString("d");
dropPlace.DataSource = scheduleDadaAccess.dropPlacebind();
dropPlace.DataBind();
dropType.DataSource = scheduleDadaAccess.dropTypebind();
dropType.DataBind();
dropPlace.SelectedIndex = 0;
dropType.SelectedIndex = 0;
if(Request.QueryString["id"] != null)
{
scheid = Int32.Parse(Request.QueryString["id"]);
FillPage();
if(scheduleDadaAccess.IsMySchedule(Convert.ToInt16(this.Empid),scheid) == 0)
{
cmdDel.Visible = true;
}
else
{
cmdSaveExi.Visible = false;
cmdDel.Visible = false;
ReadOnly();
}
}
}
}
private void ReadOnly()
{
txtSubject.ReadOnly = true;
txtPlace.ReadOnly = true;
txtScheType.ReadOnly = true;
txtFDate.ReadOnly = true;
txtTDate.ReadOnly = true;
txtContent.ReadOnly = true;
txtOtherMan.ReadOnly = true;
txtUpToDate.ReadOnly = true;
txtRemind.ReadOnly = true;
dropPlace.Enabled = false;
dropType.Enabled = false;
dropFDate.Enabled = false;
dropTDate.Enabled = false;
chkRemind.Enabled = false;
chkPrivte.Enabled = false;
chkRepeat.Enabled = false;
dropRequenCate.Enabled = false;
cmdPlace.Enabled = false;
cmdType.Enabled = false;
cmdScheOMan.Disabled = false;
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.cmdSaveExi.Click += new System.Web.UI.ImageClickEventHandler(this.cmdSaveExi_Click);
this.cmdDel.Click += new System.Web.UI.ImageClickEventHandler(this.cmdDel_Click);
this.cmdExit.Click += new System.Web.UI.ImageClickEventHandler(this.cmdExit_Click);
this.dropPlace.SelectedIndexChanged += new System.EventHandler(this.dropPlace_SelectedIndexChanged);
this.dropType.SelectedIndexChanged += new System.EventHandler(this.dropType_SelectedIndexChanged);
this.dropFDate.SelectedIndexChanged += new System.EventHandler(this.dropFDate_SelectedIndexChanged);
this.chkRemind.CheckedChanged += new System.EventHandler(this.chkRemind_CheckedChanged);
this.cmdType.Click += new System.EventHandler(this.cmdType_Click);
this.cmdPlace.Click += new System.EventHandler(this.cmdPlace_Click);
this.chkRepeat.CheckedChanged += new System.EventHandler(this.chkRepeat_CheckedChanged);
this.cmdSchedMsgDel.Click += new System.Web.UI.ImageClickEventHandler(this.cmdSchedMsgDel_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void FillPage()
{
DataTable empTB = (new ScheduleDA()).cpMySch(scheid).Tables[0];
DataRow row = empTB.Rows[0];
txtSubject.Text = row[ScheduleData.SUBJECT_FIELD].ToString();
txtScheType.Text = row[ScheduleData.SCHTYPE_FIELD].ToString();
txtPlace.Text = row[ScheduleData.PLACE_FIELD].ToString();
txtFDate.Text = DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).ToString("d");
txtTDate.Text = DateTime.Parse(row[ScheduleData.TDATE_FIELD].ToString()).ToString("d");
string txtfdate_time = DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).Hour + ":" + DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).Minute;
string txttdate_time = DateTime.Parse(row[ScheduleData.TDATE_FIELD].ToString()).Hour + ":" + DateTime.Parse(row[ScheduleData.FDATE_FIELD].ToString()).Minute;
for(int i = 0;i < dropFDate.Items.Count;i ++)
{
if(dropFDate.Items[i].Text.Trim('0') == txtfdate_time.Trim('0'))
{
dropFDate.SelectedIndex = i;
}
}
for(int j = 0;j < dropTDate.Items.Count;j ++)
{
if(dropTDate.Items[j].Text.Trim('0') == txttdate_time.Trim('0'))
{
dropTDate.SelectedIndex = j;
}
}
chkRemind.Checked = bool.Parse(row[ScheduleData.REMINDFLAG_FIELD].ToString());
txtRemind.Text = row[ScheduleData.REMINDDAY_FIELD].ToString();
txtContent.Text = row[ScheduleData.CONTENT_FIELD].ToString();
lblAuthorV.Text = row["EmpName"].ToString();
lblCDateV.Text = DateTime.Parse(row[ScheduleData.CDATE_FIELD].ToString()).ToString("g");
chkPrivte.Checked = bool.Parse(row[ScheduleData.PRIVFLAG_FIELD].ToString());
chkRepeat.Checked = bool.Parse(row[ScheduleData.REPEATFLAG_FIELD].ToString());
if(row[ScheduleData.REQUENCATE_FIELD] != DBNull.Value)
dropRequenCate.SelectedIndex = Convert.ToInt16(row[ScheduleData.REQUENCATE_FIELD].ToString());
if(row[ScheduleData.UPTODATE_FIELD] != DBNull.Value)
txtUpToDate.Text = DateTime.Parse(row[ScheduleData.UPTODATE_FIELD].ToString()).ToString("d");
txtRemind.Enabled = chkRemind.Checked;
txtUpToDate.Enabled = chkRepeat.Checked;
dropRequenCate.Enabled = chkRepeat.Checked;
SqlCommand objcommand = new SqlCommand();
SqlDataReader cpread;
objcommand = scheduleDadaAccess.cpOtherManRead(scheid);
objcommand.Connection.Open();
cpread = objcommand.ExecuteReader();
while(cpread.Read())
{
txtOtherMan.Text += cpread.GetValue(0).ToString() + ";";
}
cpread.Close();
objcommand.Connection.Close();
}
private void cmdPlace_Click(object sender, System.EventArgs e)
{
txtPlace.Text = dropPlace.SelectedItem.Text;
if (txtPlace.Visible == true)
{
txtPlace.Visible = false;
dropPlace.Visible = true;
}
else
{
txtPlace.Visible = true;
dropPlace.Visible = false;
}
}
private void cmdType_Click(object sender, System.EventArgs e)
{
txtScheType.Text = dropType.SelectedItem.Text;
if (txtScheType.Visible == true)
{
txtScheType.Visible = false;
dropType.Visible = true;
}
else
{
txtScheType.Visible = true;
dropType.Visible = false;
}
}
private void dropFDate_SelectedIndexChanged(object sender, System.EventArgs e)
{
dropTDate.SelectedIndex = dropFDate.SelectedIndex;
}
private void cmdSaveExi_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
ScheduleData scheData = new ScheduleData();
DataTable scheTB = scheData.Tables[ScheduleData.SCHEDULE_TABLE];
DataRow row = scheTB.NewRow();
scheTB.Rows.Add(row);
scheTB.AcceptChanges();
row[ScheduleData.SUBJECT_FIELD] = txtSubject.Text;
row[ScheduleData.PLACE_FIELD] = txtPlace.Text;
row[ScheduleData.SCHTYPE_FIELD] = txtScheType.Text;
row[ScheduleData.FDATE_FIELD] = DateTime.Parse(txtFDate.Text + " " + dropFDate.SelectedItem.Text);
row[ScheduleData.TDATE_FIELD] = DateTime.Parse(txtTDate.Text + " " + dropTDate.SelectedItem.Text);
row[ScheduleData.CONTENT_FIELD] = txtContent.Text;
row[ScheduleData.REMINDFLAG_FIELD] = chkRemind.Checked;
row[ScheduleData.PRIVFLAG_FIELD] = chkPrivte.Checked;
row[ScheduleData.REPEATFLAG_FIELD] = chkRepeat.Checked;
if(chkRemind.Checked == true)
{
row[ScheduleData.REMINDDAY_FIELD] = Int16.Parse(txtRemind.Text);
}
if(chkRepeat.Checked ==true)
{
row[ScheduleData.REQUENCATE_FIELD] = dropRequenCate.SelectedIndex;
if(txtUpToDate.Text != "")
{
row[ScheduleData.UPTODATE_FIELD] = DateTime.Parse(txtUpToDate.Text);
}
}
row[ScheduleData.EMPID_FIELD] = Convert.ToInt16(this.Empid);
if(scheid == 0)
{
int _schid = scheduleDadaAccess.ScheduleAdd(scheData);
SaveOtherSchedule(_schid);
}
else
{
row[ScheduleData.SCHID_FIELD] = scheid;
scheduleDadaAccess.ScheduleUpdate(scheData);
SaveOtherSchedule(scheid);
}
Response.Redirect(reurl+"?date="+date);
}
private void cmdDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
scheduleDadaAccess.cpSchDel(scheid);
Response.Redirect(reurl+"?date="+date);
}
private void cmdExit_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Response.Redirect(reurl+"?date="+date);
}
private void SaveOtherSchedule(int schid)
{
scheduleDadaAccess.cpDelOtherMan(schid);
string txtotherman;
txtotherman = txtOtherMan.Text;
string[] otherman = txtotherman.Split(new char[] {';'});
for(int i = 0;i < otherman.Length - 1;i ++)
{
scheduleDadaAccess.cpOtherManAddUp(schid,otherman[i]);
}
}
private void chkRepeat_CheckedChanged(object sender, System.EventArgs e)
{
dropRequenCate.Enabled = chkRepeat.Checked;
txtUpToDate.Enabled = chkRepeat.Checked;
}
private void chkRemind_CheckedChanged(object sender, System.EventArgs e)
{
txtRemind.Enabled = chkRemind.Checked;
}
private void dropPlace_SelectedIndexChanged(object sender, System.EventArgs e)
{
dropPlace.Visible = false;
txtPlace.Visible = true;
txtPlace.Text = dropPlace.SelectedItem.Text;
}
private void dropType_SelectedIndexChanged(object sender, System.EventArgs e)
{
dropType.Visible = false;
txtScheType.Visible = true;
txtScheType.Text = dropType.SelectedItem.Text;
}
private void cmdSchedMsgDel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
scheduleDadaAccess.cpDelOtherMan(scheid);
txtOtherMan.Text = "";
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -