protected void Button1_Click(object sender, EventArgs e)
{
Lib.Player player = (Lib.Player)Session["player"];
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
if (TextBox1.Text != "")
{
d.Add("head", TextBox1.Text.Trim());
d.Add("text", FTB.Text);
d.Add("player", player.ID);
d.Add("date", DateTime.Now);
d.Add("acc", Request.Params["account"]);
try
{
du.executeNonQueryByText("insert into suggestion (head,text,player,date,acc) values (@head,@text,@player,@date,@acc)", d);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('新增成功');window.close();", true);
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('" + ex.Message + "');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('請輸入標題');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string sid = Request.QueryString["head"];
Lib.Player p = (Lib.Player)Session["player"];
SqlDataSource1.SelectParameters["sid"].DefaultValue = sid;
SqlDataSource1.SelectParameters["player"].DefaultValue = p.ID;
//FormView1.FindControl("answerLabel").t
Label datelabel = (Label)FormView1.FindControl("dateLabel");
Label date_answerLabel = (Label)FormView1.FindControl("date_answerLabel");
datelabel.Text = Lib.SysSetting.ToRocDateFormat(datelabel.Text);
date_answerLabel.Text = Lib.SysSetting.ToRocDateFormat(date_answerLabel.Text);
Label answer1 = (Label)FormView1.FindControl("answerLabel");
Label answer2 = (Label)FormView1.FindControl("answer2Label");
Label answer3 = (Label)FormView1.FindControl("answer3Label");
Label date_answer = (Label)FormView1.FindControl("date_answerLabel");
if (answer1.Text.Trim() == "")
{
FormView1.FindControl("Label1").Visible = false;
}
if (answer2.Text.Trim() == "")
{
FormView1.FindControl("Label2").Visible = false;
}
if (answer3.Text.Trim() == "")
{
FormView1.FindControl("Label3").Visible = false;
}
if (date_answer.Text.Trim() == "")
{
FormView1.FindControl("Label4").Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//User_ID.Text = Request.Params["ID"].ToString();
if (Session["player"] != null)
{
Lib.Player player = (Lib.Player)Session["player"];
if (!player.IsCanReSetPassword)
{
//如果Session不對的話, 重新導到哪一頁.
Response.Redirect("Login.aspx");
}
else
{
if (!player.IsMustReSetPassword)
{
User_ID.Text = player.ID;
txtMail.Visible = false;
Label4.Visible = false;
Label5.Visible = false;
}
else
{
User_ID.Text = player.ID;
txtMail.Text = player.Mail;
txtMail.Visible = true;
Label4.Visible = true;
Label5.Visible = true;
}
}
}
else
{
Response.Redirect("Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["player"] != null)
{
Lib.Player a = (Lib.Player)Session["player"];
SqlDataSource1.SelectParameters["player"].DefaultValue = a.ID;
}
}
protected void submit_Click(object sender, EventArgs e)
{
if (this.IsPostBack)
{
Lib.Player player = (Lib.Player)Session["player"];
if (player.IsCanReSetPassword)
{
if (txtPwd.Text.Trim() == txtPwd_Confirm.Text.Trim())
{
if (string.IsNullOrEmpty(Request.Form["hidden_msg_confirm"]) && string.IsNullOrEmpty(Request.Form["hidden_msg"]))
{
if (!player.IsMustReSetPassword)
{
//如果Session正確的話, 重新導到哪一頁.
//才可以接受變更.
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
d.Add(@"id", player.ID);
d.Add(@"password", txtPwd_Confirm.Text.Trim());
du.executeNonQueryBysp(@"Ex105_UpdatePassword", d);
Session["player"] = null;
Response.Redirect("Redirect.html");
}
else
{
//如果Session正確的話, 重新導到哪一頁.
//才可以接受變更.
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
d.Add(@"id", player.ID);
d.Add(@"password", txtPwd_Confirm.Text.Trim());
d.Add(@"mail", Request.Form["txtMail"].Trim());
du.executeNonQueryBysp(@"Ex105_UpdatePasswordnMail", d);
Session["player"] = null;
Response.Redirect("Redirect.html");
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('密碼不正確');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('密碼不一致');", true);
}
}
else
{
Response.Redirect("Login.aspx");
Session.Clear();
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
Lib.Player p = new Lib.Player();
p = (Lib.Player)Session["player"];
string id = p.ID;
SqlDataSource2.SelectParameters["type"].DefaultValue = "id";
SqlDataSource2.SelectParameters["value"].DefaultValue = DropDownList1.SelectedValue;
SqlDataSource2.SelectParameters["operator"].DefaultValue = id;
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, this.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Lib.Player a = new Lib.Player();
a = (Lib.Player)Session["player"];
string op_id = a.ID;
//if (DateTime.Now > DateTime.Today.AddHours(Lib.SysSetting.reserveTimeUnit.TotalHours))
if (DateTime.Now > DateTime.Today.AddDays(1).AddHours(-Lib.SysSetting.reserveTimeUnit.TotalHours))
{
SqlDataSource2.SelectParameters["date"].DefaultValue = DateTime.Today.AddDays(1).ToShortDateString();
SqlDataSource2.SelectParameters["op_id"].DefaultValue = op_id;
}
else
{
SqlDataSource2.SelectParameters["date"].DefaultValue = DateTime.Today.ToShortDateString();
SqlDataSource2.SelectParameters["op_id"].DefaultValue = op_id;
}
if (!Page.IsPostBack)
{
Calendar1.Visible = false;
dateDiv.Visible = false;
}
else
{
Calendar1.Visible = true;
TaiwanCalendar tc = new TaiwanCalendar();
CultureInfo ci = new CultureInfo("zh-TW");
ci.DateTimeFormat.Calendar = tc;
ci.DateTimeFormat.YearMonthPattern = "民國yy年MM月";
ci.DateTimeFormat.FirstDayOfWeek = DayOfWeek.Sunday;
Thread.CurrentThread.CurrentCulture = ci;
dateDiv.Visible = true;
}
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, this.ToString());
Response.Redirect("Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Lib.Player p = new Lib.Player();
p = (Lib.Player)Session["player"];
string id = p.ID;
SqlDataSource1.SelectParameters["id"].DefaultValue = id;
Label2.Text = id;
if (GridView2.Rows.Count > 0)
{
}
else
{
//sit_ups_pic.Visible = false;
//push_ups_pic.Visible = false;
//run_pic.Visible = false;
}
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, this.ToString());
}
}
protected void DropDownList1_DataBound(object sender, EventArgs e)
{
try
{
Lib.Player p = new Lib.Player();
p = (Lib.Player)Session["player"];
string id = p.ID;
for (int i = 0; i < DropDownList1.Items.Count; i++)
{
//DropDownList1.Items[i].Text = Lib.SysSetting.ToRocDateFormat(Convert.ToDateTime(DropDownList1.Items[i].Text).ToShortDateString());
DropDownList1.Items[i].Text = Lib.SysSetting.ToRocDateFormat(DropDownList1.Items[i].Text);
}
if (DropDownList1.Items.Count > 0)
{
SqlDataSource2.SelectParameters["type"].DefaultValue = "id";
SqlDataSource2.SelectParameters["value"].DefaultValue = DropDownList1.SelectedValue;
SqlDataSource2.SelectParameters["operator"].DefaultValue = id;
}
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, this.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.MaintainScrollPositionOnPostBack = true;
if (Session["account"] != null)
{
if (!Page.IsPostBack)
{
//Page.MaintainScrollPositionOnPostBack = true;
Account a = (Account)Session["account"];
OP_Value.Value = a.AccountName;
userInfo.Text = "歡迎 " + a.AccountName + " 來到國軍基本體能鑑測網, <A style=\"COLOR: blue\" id=ctl00_logout href=\"Logout.aspx\">登出</A>" + " , 現在是中華民國 " + Lib.SysSetting.ToRocDateFormat(DateTime.Now.ToString("yyyy")) + " 年 " + DateTime.Now.Month.ToString() + " 月 " + DateTime.Now.Day.ToString() + " 日 " + Lib.SysSetting.ToRocWeekFormat(DateTime.Now.DayOfWeek);
#region
//DataUtility du = new DataUtility();
//Dictionary<string, object> d = new Dictionary<string, object>();
//DataTable dt = du.getDataTableByText("select * from RelatedLink");
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// MenuItem test = new MenuItem();
// test.ImageUrl = dt.Rows[i]["path"].ToString();
// test.NavigateUrl = dt.Rows[i]["url"].ToString();
// test.Target = "_blank";
// Menu3.Items.Add(test);
//}
#endregion
if (a.Role == ((int)SysSetting.Role.admin_hq).ToString())
{
//2016-11-29新增公告功能
MenuItem i1 = new MenuItem("最近消息管理", "", "images/nav_break.gif");
i1.NavigateUrl = "~/HQ_Bulletin.aspx";
Menu1.Items.Add(i1);
MenuItem i2 = new MenuItem("鑑測站行事曆", "", "images/nav_break.gif");
i2.NavigateUrl = "~/HQ_SchMag.aspx";
Menu1.Items.Add(i2);
MenuItem i3 = new MenuItem("帳號管理者", "", "images/nav_break.gif");
i3.NavigateUrl = "~/HQ_MagAccMag.aspx";
Menu1.Items.Add(i3);
//MenuItem i4 = new MenuItem("國軍單位資料", "", "images/nav_break.gif");
//i4.NavigateUrl = "~/HQ_ProfileMag.aspx";
//Menu1.Items.Add(i4);
MenuItem i4 = new MenuItem("重設密碼", "", "images/nav_break.gif");
i4.NavigateUrl = "~/HQ_ReSetPassword.aspx";
Menu1.Items.Add(i4);
MenuItem i5 = new MenuItem("相關連結", "", "images/nav_break.gif");
i5.NavigateUrl = "~/HQ_LinkRefMag.aspx";
Menu1.Items.Add(i5);
MenuItem i6 = new MenuItem("事件記錄檢視", "", "images/nav_break.gif");
i6.NavigateUrl = "~/HQ_LogView.aspx";
Menu1.Items.Add(i6);
MenuItem i8 = new MenuItem("文件區維護", "", "images/nav_break.gif");
i8.NavigateUrl = "~/HQ_FileManage.aspx";
Menu1.Items.Add(i8);
MenuItem i9 = new MenuItem("成績統計", "", "images/nav_break.gif");
i9.NavigateUrl = "~/Reporting.aspx";
Menu1.Items.Add(i9);
MenuItem i10 = new MenuItem("成績查詢", "", "images/nav_break.gif");
i10.NavigateUrl = "~/SearchScore.aspx";
Menu1.Items.Add(i10);
MenuItem i11 = new MenuItem("逾期處理", "", "images/nav_break.gif");
i11.NavigateUrl = "~/OverDue.aspx";
Menu1.Items.Add(i11);
MenuItem i7 = new MenuItem("設定個人資訊", "", "images/nav_break.gif");
i7.NavigateUrl = "~/Pro.aspx";
Menu1.Items.Add(i7);
MenuItem i12 = new MenuItem("刪除人工鑑測成績", "", "images/nav_break.gif");
i12.NavigateUrl = "~/DeleteArtificialScore.aspx";
Menu2.Items.Add(i12);
MenuItem i13 = new MenuItem("設定聯絡資訊", "", "images/nav_break.gif");
i13.NavigateUrl = "~/HQ_Contact.aspx";
Menu2.Items.Add(i13);
//108年維保新增
MenuItem i14 = new MenuItem("資料查詢及異動", "", "images/nav_break.gif");
i14.NavigateUrl = "~/108_Data_Update.aspx";
Menu2.Items.Add(i14);
MenuItem i15 = new MenuItem("伺服器狀態", "", "images/nav_break.gif");
i15.NavigateUrl = "~/108_ServerStatus.aspx";
Menu2.Items.Add(i15);
}
if (a.Role == ((int)SysSetting.Role.mag_hq).ToString())
{
MenuItem i2 = new MenuItem("進階使用者", "", "images/nav_break.gif");
i2.NavigateUrl = "~/HQ_UserAccMag.aspx";
Menu1.Items.Add(i2);
MenuItem i4 = new MenuItem("批次帳號維護", "", "images/nav_break.gif");
i4.NavigateUrl = "~/BatchAccMag.aspx";
Menu1.Items.Add(i4);
MenuItem i6 = new MenuItem("團報管理者審核", "", "images/nav_break.gif");
i6.NavigateUrl = "~/CheckAdvancedUser.aspx";
Menu1.Items.Add(i6);
MenuItem i8 = new MenuItem("重設密碼", "", "images/nav_break.gif");
i8.NavigateUrl = "~/HQ_ReSetPassword.aspx";
Menu1.Items.Add(i8);
MenuItem i5 = new MenuItem("成績統計", "", "images/nav_break.gif");
i5.NavigateUrl = "~/Reporting.aspx";
Menu1.Items.Add(i5);
MenuItem i7 = new MenuItem("成績查詢", "", "images/nav_break.gif");
i7.NavigateUrl = "~/SearchScore.aspx";
Menu1.Items.Add(i7);
MenuItem i3 = new MenuItem("設定個人資訊", "", "images/nav_break.gif");
i3.NavigateUrl = "~/Pro.aspx";
Menu1.Items.Add(i3);
//暫時開啟
if (a.AccountName == "cola" | a.AccountName == "asz1330")
{
MenuItem i12 = new MenuItem("刪除人工鑑測成績", "", "images/nav_break.gif");
i12.NavigateUrl = "~/DeleteArtificialScore.aspx";
Menu1.Items.Add(i12);
}
/*
* MenuItem i2 = new MenuItem("個人資料維護");
* i2.NavigateUrl = "~/Pro.aspx";
* Menu1.Items.Add(i2);*/
}
if (a.Role == ((int)SysSetting.Role.user_hg).ToString())
{
foreach (KeyValuePair <string, string> item in a.OptionCode)
{
MenuItem i = new MenuItem(item.Key, "", "images/nav_break.gif");
i.NavigateUrl = "~/" + item.Value;
Menu1.Items.Add(i);
if (item.Key == "團體報進")
{
MenuItem i2 = new MenuItem("團體報進成績", "", "images/nav_break.gif");
i2.NavigateUrl = "~/TeamScore.aspx";
Menu1.Items.Add(i2);
MenuItem i3 = new MenuItem("成績查詢", "", "images/nav_break.gif");
i3.NavigateUrl = "~/SearchScore.aspx";
Menu1.Items.Add(i3);
MenuItem i4 = new MenuItem("成績統計", "", "images/nav_break.gif");
i4.NavigateUrl = "~/Reporting.aspx";
Menu1.Items.Add(i4);
MenuItem i5 = new MenuItem("生日查詢", "", "images/nav_break.gif");
i5.NavigateUrl = "~/HQ_ViewTeamPlayer.aspx";
Menu1.Items.Add(i5);
}
}
MenuItem i1 = new MenuItem("設定個人資訊", "", "images/nav_break.gif");
i1.NavigateUrl = "~/Pro.aspx";
Menu1.Items.Add(i1);
}
}
}
if (Session["player"] != null)
{
Lib.Player p = (Lib.Player)Session["player"];
if (p.IsMustReSetPassword == true)
{
Session.Clear();
Response.Redirect("~/Login.aspx");
}
OP_Value.Value = p.Name;
userInfo.Text = "歡迎 " + p.ID + " 來到國軍基本體能鑑測網, <A style=\"COLOR: blue\" id=ctl00_logout href=\"Logout.aspx\">登出</A>" + " , 現在是中華民國 " + Lib.SysSetting.ToRocDateFormat(DateTime.Now.ToString("yyyy")) + " 年 " + DateTime.Now.Month.ToString() + " 月 " + DateTime.Now.Day.ToString() + " 日 " + Lib.SysSetting.ToRocWeekFormat(DateTime.Now.DayOfWeek);
#region
//DataUtility du = new DataUtility();
//Dictionary<string, object> d = new Dictionary<string, object>();
//DataTable dt = du.getDataTableByText("select * from RelatedLink");
//if (Menu3.Items.Count == 0)
//{
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// MenuItem test = new MenuItem();
// test.ImageUrl = dt.Rows[i]["path"].ToString();
// test.NavigateUrl = dt.Rows[i]["url"].ToString();
// test.Target = "_blank";
// Menu3.Items.Add(test);
// }
//}
#endregion
if (!Page.IsPostBack)
{
MenuItem i1 = new MenuItem("基本項目報進", "", "images/nav_break.gif");
i1.NavigateUrl = "~/SelfReserver.aspx";
Menu1.Items.Add(i1);
MenuItem i8 = new MenuItem("替代項目報進", "", "images/nav_break.gif");
i8.NavigateUrl = "~/ReplaceItemReserver.aspx";
Menu1.Items.Add(i8);
//MenuItem i9 = new MenuItem("申請補測報進", "", "images/nav_break.gif");
//i9.NavigateUrl = "~/RepairTest.aspx";
//Menu1.Items.Add(i9);
MenuItem i6 = new MenuItem("個人成績", "", "images/nav_break.gif");
i6.NavigateUrl = "~/SelfScore.aspx";
Menu1.Items.Add(i6);
MenuItem i2 = new MenuItem("意見區", "", "images/nav_break.gif");
i2.NavigateUrl = "~/Suggestion.aspx";
Menu1.Items.Add(i2);
//MenuItem i3 = new MenuItem("討論區", "", "images/nav_break.gif");
//i3.NavigateUrl = "~/Discussion.aspx";
//Menu1.Items.Add(i3);
MenuItem i7 = new MenuItem("設定個人資訊", "", "images/nav_break.gif");
i7.NavigateUrl = "~/Pro_Player.aspx";
Menu1.Items.Add(i7);
}
}
if (Session["account"] == null && Session["player"] == null)
{
Response.Redirect("~/Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Lib.Player p;
if (Session["player"] != null)
{
if (!Page.IsPostBack)
{
p = new Lib.Player();
p = (Lib.Player)Session["player"];
acc_u.Value = p.ID.Trim();
name_u.Value = p.Name.Trim();
pwd_u.Value = Lib.SysSetting.ToRocDateFormat(p.Birth.ToShortDateString()).Trim();
unit_u.Value = p.Unit_Code.Trim();
rank_u.Value = p.Rank_Code.Trim();
mail_u.Value = p.Mail.Trim();
pwd_HF.Value = p.Password.Trim();
}
else
{
//string tt = submitType.Value;
if (submitType.Value == "updateBtn")
{
Dictionary <string, object> d = new Dictionary <string, object>();
Lib.DataUtility du = new Lib.DataUtility();
d.Add("id", acc_u.Value);
d.Add("name", name_u.Value);
d.Add("unit_code", unit_u.Value);
d.Add("rank_code", rank_u.Value);
d.Add("mail", mail_u.Value);
du.executeNonQueryByText("update player set name = @name , unit_code = @unit_code , rank_code = @rank_code , mail = @mail where id = @id", d);
p = new Lib.Player();
p = (Lib.Player)Session["player"];
p.Name = name_u.Value;
p.Unit_Code = unit_u.Value;
p.Rank_Code = rank_u.Value;
p.Mail = mail_u.Value;
Session["player"] = p;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('更新成功');", true);
}
else if (submitType.Value == "pwdchange")
{
p = new Lib.Player();
p = (Lib.Player)Session["player"];
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
var newPwd = pwd_HF.Value;
d.Add(@"id", p.ID);
d.Add(@"password", newPwd);
du.executeNonQueryBysp(@"Ex105_UpdatePassword", d);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('更新成功');", true);
/* Reset Player Session
* cc.Password = newPwd;
* pwd_u.Value = newPwd;
* Session["account"] = acc; */
TabContainer1.ActiveTabIndex = 1;
submitType.Value = "";
}
}
}
}
