protected void ToDo_OnClick(object sender, EventArgs e)
{
if (GridView1.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('目前沒有資料');", true);
}
else
{
DataTable dt = new DataTable();
dt.TableName = "upload";
dt.Columns.Add("sid");
dt.Columns.Add("status");
Lib.DataUtility center = new Lib.DataUtility(Lib.DataUtility.ConnectionType.CenterDB);
List <Dictionary <string, object> > list_u = new List <Dictionary <string, object> >();
foreach (GridViewRow row in GridView1.Rows)
{
DataRow _row = dt.NewRow();
Dictionary <string, object> d_u = new Dictionary <string, object>();
RadioButtonList dbl = (RadioButtonList)row.Cells[6].FindControl("rbl");
var _v = dbl.SelectedValue;
_row["sid"] = row.Cells[7].Text;
_row["status"] = _v;
d_u.Add("sid", row.Cells[7].Text);
d_u.Add("status", _v);
dt.Rows.Add(_row);
list_u.Add(d_u);
}
try
{
MainWS.WebService MainWs = new MainWS.WebService();
string msg = MainWs.UploadResult(dt, "pending");
if (msg == "done")
{
center.executeNonQueryByText("update result set status = @status where sid = @sid", list_u);
Dictionary <string, object> d_log = new Dictionary <string, object>();
d_log.Add("acc", ((Lib.Center.Account_c)Session["account"]).Account);
d_log.Add("name", ((Lib.Center.Account_c)Session["account"]).Name);
d_log.Add("log", "上傳未檢錄成績 " + GridView1.Rows.Count.ToString() + " 筆");
d_log.Add("date", DateTime.Now);
center.executeNonQueryByText("insert into log values (@acc,@name,@log,@date)", d_log);
Account_c acc = (Account_c)Session["account"];
Lib.SysSetting.AddLog("成績上傳", acc.Account, "上傳未檢錄成績 " + GridView1.Rows.Count.ToString() + " 筆", DateTime.Now);
list_u.Clear();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('上傳成功');",
true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert(\"" + msg + "\");", true);
}
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert(\"" + ex.Message + "\");", true);
}
GridView1.DataBind();
TabContainer1.ActiveTabIndex = 4;
}
}
protected void Button7_Click(object sender, EventArgs e)
{
try
{
//string script = @"<script language='JavaScript'>window.location.reload();</script>";
string memo = DropDownList1.SelectedValue + DropDownList2.SelectedValue + DropDownList3.SelectedValue;
if (DropDownList1.SelectedItem.ToString() != DropDownList2.SelectedItem.ToString() && DropDownList2.SelectedItem.ToString() != DropDownList3.SelectedItem.ToString() && DropDownList1.SelectedItem.ToString() != DropDownList3.SelectedItem.ToString())
{
if (TB_id.Text != "")
{
Dictionary <string, object> d = new Dictionary <string, object>();
Lib.DataUtility du = new Lib.DataUtility();
d.Add("id", TB_id.Text.Trim());
d.Add("date", System.DateTime.Today);
DataTable dt = du.getDataTableByText(@"select status, memo from result where id = @id and date = @date", d);
if (dt.Rows.Count == 1)
{
if (dt.Rows[0]["status"].ToString().Substring(0, 1) != "2")
{
Account_c acc = (Account_c)Session["account"];
Lib.SysSetting.AddLog("設定鑑測項目", acc.Account, @"設定對象 : " + TB_id.Text.Trim() + "原鑑測項目 : " + dt.Rows[0]["memo"].ToString() + " 新鑑測項目 : " + memo, DateTime.Now);
d.Add("memo", memo);
new Lib.DataUtility().executeNonQueryByText("update result set memo = @memo where id = @id and date = @date", d);
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('設定鑑測項目完畢');", true);
TB_id.Text = string.Empty;
Re_Select();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('此人員受測資料已上傳，不可變更鑑測項目');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('查無今日受測資料');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('請輸入身分證字號');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('鑑測項目不可重覆 , 請重設鑑測項目');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('" + ex.Message + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//ShowSystemMode();
if (!Page.IsPostBack)
{
Lib.DataUtility du = new Lib.DataUtility();
DataTable dt = new DataTable();
dt = du.getDataTableByText("select item, value from sysvalue");
string checkV = dt.Rows[1][1].ToString();
if (checkV == "local")
{
CheckBoxList1.Items[0].Selected = true;
CheckBoxList1.Items[1].Selected = false;
}
else
{
CheckBoxList1.Items[1].Selected = true;
CheckBoxList1.Items[0].Selected = false;
}
checkV = dt.Rows[2][1].ToString();
txtRemoteIP.Text = checkV;
}
Account_c acc = (Account_c)Session["account"];
if (acc != null)
{
if (acc.Role == User_Role.Administrator)
{
ClearResult.Visible = true;
ClearResult.Enabled = true;
btnSwitch.Visible = true;
btnSwitch.Enabled = true;
Button1.Visible = true;
Button1.Enabled = true;
}
else
{
ClearResult.Visible = false;
ClearResult.Enabled = false;
btnSwitch.Visible = false;
btnSwitch.Enabled = false;
Button1.Visible = false;
Button1.Enabled = false;
}
ShowSystemMode();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "javascript:alert('逾時登出，請重新登入');window.location='./Login.aspx';", true);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
//if (id.Value != "" && situps.Value != "" && pushups.Value != "" && run.Value != "" && id.Value == checkid.Value )
if (id.Value != "" && id.Value == checkid.Value)
{
if (status.Value == "001")
{ //For status 001
string t = old_run_score;
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
//
//d.Add("id", string t = (id.Value == "")?id.Value : System.DBNull.Value);
if (!situps.Disabled)
{
if (situps.Value == "")
{
d.Add("sit_ups", DBNull.Value);
}
else
{
d.Add("sit_ups", Convert.ToInt32(situps.Value));
}
}
else
{
int total = 0;
if (situps_min.Value == "" && situps_sec.Value == "")
{
d.Add("sit_ups", DBNull.Value);
}
else
{
if (situps_min.Value != "")
{
total += Convert.ToInt32(situps_min.Value) * 60;
}
if (situps_sec.Value != "")
{
total += Convert.ToInt32(situps_sec.Value);
}
if (total != 0)
{
d.Add("sit_ups", total);
}
else
{
d.Add("sit_ups", DBNull.Value);
}
}
}
if (!pushups.Disabled)
{
if (pushups.Value == "")
{
d.Add("push_ups", DBNull.Value);
}
else
{
d.Add("push_ups", Convert.ToInt32(pushups.Value));
}
}
else
{
int total = 0;
if (pushups_min.Value == "" && pushups_sec.Value == "")
{
d.Add("push_ups", DBNull.Value);
}
else
{
if (pushups_min.Value != "")
{
total += Convert.ToInt32(pushups_min.Value) * 60;
}
if (pushups_sec.Value != "")
{
total += Convert.ToInt32(pushups_sec.Value);
}
if (total != 0)
{
d.Add("push_ups", total);
}
else
{
d.Add("push_ups", DBNull.Value);
}
}
}
if (!run.Disabled)
{
if (run.Value == "")
{
d.Add("run", DBNull.Value);
}
else
{
d.Add("run", Convert.ToInt32(run.Value));
}
}
else
{
int total = 0;
if (run_min.Value == "" && run_sec.Value == "")
{
d.Add("run", DBNull.Value);
}
else
{
if (run_min.Value != "")
{
total += Convert.ToInt32(run_min.Value) * 60;
}
if (run_sec.Value != "")
{
total += Convert.ToInt32(run_sec.Value);
}
if (total != 0)
{
d.Add("run", total);
}
else
{
d.Add("run", DBNull.Value);
}
}
}
d.Add("id", id.Value);
//d.Add("date", Convert.ToDateTime(dateValue.Value));
try
{
du.executeNonQueryBysp("Race_ResultCorrect", d);
Account_c acc = (Account_c)Session["account"];
Lib.SysSetting.AddLog("成績補正", acc.Account, "補正對象: (" + id.Value + ") 補正前成績為(" + sit_ups_name.Text + ": " + old_situps + "次, " + push_ups_name.Text + ": " + old_pushups + "次, " + run_name.Text + ": " + old_run + "秒)" + "補正後成績為(" + sit_ups_name.Text + ": " + situps.Value + "次, " + situps_min.Value + "分:" + situps_sec.Value + "秒" + push_ups_name.Text + ": " + pushups.Value + "次, " + pushups_min.Value + "分:" + pushups_sec.Value + "秒" + run_name.Text + ": " + run.Value + "次," + run_min.Value + "分:" + run_sec.Value + "秒)", DateTime.Now);
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('完成補正成績');", true);
id.Value = "";
situps.Value = "";
situps_min.Value = "";
situps_sec.Value = "";
pushups.Value = "";
pushups_min.Value = "";
pushups_sec.Value = "";
run.Value = "";
run_min.Value = "";
run_sec.Value = "";
name.Value = "";
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('" + ex.Message.ToString() + "');", true);
}
}
else
{ //For Status 102, 103
string t = old_run_score;
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
//
//d.Add("id", string t = (id.Value == "")?id.Value : System.DBNull.Value);
if (!situps.Disabled)
{
if (situps.Value == "")
{
d.Add("sit_ups", DBNull.Value);
}
else
{
d.Add("sit_ups", Convert.ToInt32(situps.Value));
}
}
else
{
int total = 0;
if (situps_min.Value == "" && situps_sec.Value == "")
{
d.Add("sit_ups", DBNull.Value);
}
else
{
if (situps_min.Value != "")
{
total += Convert.ToInt32(situps_min.Value) * 60;
}
if (situps_sec.Value != "")
{
total += Convert.ToInt32(situps_sec.Value);
}
if (total != 0)
{
d.Add("sit_ups", total);
}
else
{
d.Add("sit_ups", DBNull.Value);
}
}
}
if (!pushups.Disabled)
{
if (pushups.Value == "")
{
d.Add("push_ups", DBNull.Value);
}
else
{
d.Add("push_ups", Convert.ToInt32(pushups.Value));
}
}
else
{
int total = 0;
if (pushups_min.Value == "" && pushups_sec.Value == "")
{
d.Add("push_ups", DBNull.Value);
}
else
{
if (pushups_min.Value != "")
{
total += Convert.ToInt32(pushups_min.Value) * 60;
}
if (pushups_sec.Value != "")
{
total += Convert.ToInt32(pushups_sec.Value);
}
if (total != 0)
{
d.Add("push_ups", total);
}
else
{
d.Add("push_ups", DBNull.Value);
}
}
}
if (!run.Disabled)
{
if (run.Value == "")
{
d.Add("run", DBNull.Value);
}
else
{
d.Add("run", Convert.ToInt32(run.Value));
}
}
else
{
int total = 0;
if (run_min.Value == "" && run_sec.Value == "")
{
d.Add("run", DBNull.Value);
}
else
{
if (run_min.Value != "")
{
total += Convert.ToInt32(run_min.Value) * 60;
}
if (run_sec.Value != "")
{
total += Convert.ToInt32(run_sec.Value);
}
if (total != 0)
{
d.Add("run", total);
}
else
{
d.Add("run", DBNull.Value);
}
}
}
d.Add("id", id.Value);
//d.Add("date", Convert.ToDateTime(dateValue.Value));
try
{
du.executeNonQueryBysp("Race_ResultCorrect", d);
d.Clear();
d.Add("id", id.Value);
du.executeNonQueryBysp("Race_CalResult", d);
Account_c acc = (Account_c)Session["account"];
//Lib.SysSetting.AddLog("成績補正", acc.Account, "補正對象: (" + id.Value + ") 補正前成績為(" + sit_ups_name.Text + ": " + old_situps + "次, " + push_ups_name.Text + ": " + old_pushups + "次, " + run_name.Text + ": " + old_run + "秒)" + "補正後成績為(" + sit_ups_name.Text + ": " + situps.Value + "次, " + push_ups_name.Text + ": " + pushups.Value + "次, " + run_name.Text + ": " + run.Value + "秒)", DateTime.Now);
Lib.SysSetting.AddLog("成績補正", acc.Account, "補正對象: (" + id.Value + ") 補正前成績為(" + sit_ups_name.Text + ": " + old_situps + "次, " + push_ups_name.Text + ": " + old_pushups + "次, " + run_name.Text + ": " + old_run + "秒)" + "補正後成績為(" + sit_ups_name.Text + ": " + situps.Value + "次, " + situps_min.Value + "分:" + situps_sec.Value + "秒" + push_ups_name.Text + ": " + pushups.Value + "次, " + pushups_min.Value + "分:" + pushups_sec.Value + "秒" + run_name.Text + ": " + run.Value + "次," + run_min.Value + "分:" + run_sec.Value + "秒)", DateTime.Now);
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('完成補正成績');", true);
id.Value = "";
situps.Value = "";
situps_min.Value = "";
situps_sec.Value = "";
pushups.Value = "";
pushups_min.Value = "";
pushups_sec.Value = "";
run.Value = "";
run_min.Value = "";
run_sec.Value = "";
name.Value = "";
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('" + ex.Message.ToString() + "');", true);
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('資料有缺漏!!!');", true);
}
}
protected void upload_OnClick(object sender, EventArgs e)
{
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
try
{
d.Add("status", "102");
DataTable dt = du.getDataTableBysp("Race_SelectResult", d); // 102 未上傳合格
if (dt.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('目前沒有成績');", true);
GridView3.DataBind();
}
else
{
dt.TableName = "upload";
if (Lib.SysSetting.CourrentUploadMode() == Lib.SysSetting.UploadMode.Remote)
{
RemoteWS.WebService RemoteWS = new RemoteWS.WebService();
RemoteWS.Url = "http://" + Lib.SysSetting.GetRemoteIP() + "/WebService.asmx";
RemoteWS.Discover();
string msg = RemoteWS.InsertResult(dt);
if (msg == "Done")
{
try
{
// // 上傳更新總部資料
// main.executeNonQueryByText("update result set height = @height, weight=@weight, BMI = @BMI, bodyfat = @bodyfat, sit_ups = @sit_ups, sit_ups_score = @sit_ups_score, push_ups = @push_ups, push_ups_score = @push_ups_score, run = @run, run_score = @run_score, status = @status where sid = @sid", list);
// 更新鑑測站資料狀態
d.Clear();
d.Add("result", dt);
int count = dt.Rows.Count;
dt = du.getDataTableBysp("Race_UpdateResultAfterUpload", d);
if (dt.Rows.Count == 1 && dt.Rows[0][0].ToString() == "Done")
{
Dictionary <string, object> d_log = new Dictionary <string, object>();
d_log.Add("acc", ((Lib.Center.Account_c)Session["account"]).Account);
d_log.Add("name", ((Lib.Center.Account_c)Session["account"]).Name);
d_log.Add("log", "上傳合格成績 " + count + " 筆");
d_log.Add("date", DateTime.Now);
du.executeNonQueryByText("insert into log values (@acc,@name,@log,@date)", d_log);
Account_c acc = (Account_c)Session["account"];
Lib.SysSetting.AddLog("成績上傳", acc.Account, "上傳合格成績 " + count + " 筆", DateTime.Now);
dt.Dispose();
//list.Clear();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('上傳合格成績" + count + " 筆成功');", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('更新local資料庫成績失敗');", 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(\"" + msg + "\");", true);
}
}
else
{
try
{
d.Clear();
d.Add("result", dt);
int count = dt.Rows.Count;
dt = du.getDataTableBysp("Race_UpdateResultAfterUpload", d);
if (dt.Rows.Count == 1 && dt.Rows[0][0].ToString() == "Done")
{
Dictionary <string, object> d_log = new Dictionary <string, object>();
d_log.Add("acc", ((Lib.Center.Account_c)Session["account"]).Account);
d_log.Add("name", ((Lib.Center.Account_c)Session["account"]).Name);
d_log.Add("log", "上傳合格成績 " + count + " 筆");
d_log.Add("date", DateTime.Now);
du.executeNonQueryByText("insert into log values (@acc,@name,@log,@date)", d_log);
Account_c acc = (Account_c)Session["account"];
Lib.SysSetting.AddLog("成績上傳", acc.Account, "上傳合格成績 " + count + " 筆", DateTime.Now);
dt.Dispose();
//list.Clear();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('上傳合格成績" + count + " 筆成功');", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('更新local資料庫成績失敗');", true);
}
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert(\"" + ex.Message + "\");", true);
}
}
}
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert(\"" + ex.Message + "\");", true);
}
GridView3.DataBind();
Label1.Text = "合格成績共" + GridView3.Rows.Count.ToString() + "筆";
TabContainer1.ActiveTabIndex = 0;
}
protected void Button2_Click(object sender, EventArgs e)
{
if (check_num.Value == "1")//前台傳回來的值(1：正確、0：錯誤)
{
string t = old_run_score;
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
d.Clear();
//判斷身份證字號是否正確
if (id1.Value != "" && id1.Value == checkid.Value)
{
//判斷第一項是用次數還是秒
//使用分秒
if (sit_note == "秒")
{
//2016-1-14新判斷
//分、秒都有值
if (!string.IsNullOrEmpty(txb_sit1.Text.Trim()) & !string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
int sit_sec = (Convert.ToInt32(txb_sit1.Text.Trim()) * 60) + Convert.ToInt32(txb_sit2.Text.Trim());
d.Add("sit_ups", sit_sec);
new_sit_ups = sit_sec.ToString();
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_sit1.Text.Trim()) & string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
int sit_sec = (Convert.ToInt32(txb_sit1.Text.Trim()) * 60);
d.Add("sit_ups", sit_sec);
new_sit_ups = sit_sec.ToString();
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_sit1.Text.Trim()) & !string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
int sit_sec = Convert.ToInt32(txb_sit2.Text.Trim());
d.Add("sit_ups", sit_sec);
new_sit_ups = sit_sec.ToString();
}
//都空白
else
{
d.Add("sit_ups", DBNull.Value);
new_sit_ups = string.Empty;
}
}
//使用次數
else
{
//2016-1-26再修正值不等於"秒"，也是判斷二個欄位來相加
//分、秒都有值
if (!string.IsNullOrEmpty(txb_sit1.Text.Trim()) & !string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
int sit_sec = (Convert.ToInt32(txb_sit1.Text.Trim()) * 60) + Convert.ToInt32(txb_sit2.Text.Trim());
d.Add("sit_ups", sit_sec);
new_sit_ups = sit_sec.ToString();
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_sit1.Text.Trim()) & string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
int sit_sec = (Convert.ToInt32(txb_sit1.Text.Trim()) * 60);
d.Add("sit_ups", sit_sec);
new_sit_ups = sit_sec.ToString();
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_sit1.Text.Trim()) & !string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
int sit_sec = Convert.ToInt32(txb_sit2.Text.Trim());
d.Add("sit_ups", sit_sec);
new_sit_ups = sit_sec.ToString();
}
//都空白
else
{
d.Add("sit_ups", DBNull.Value);
new_sit_ups = string.Empty;
}
}
//判斷第二項是用次數還是秒
//使用分秒
if (push_note == "秒")
{
//2016-1-14新判斷
//分、秒都有值
if (!string.IsNullOrEmpty(txb_push1.Text.Trim()) & !string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
int push_sec = (Convert.ToInt32(txb_push1.Text.Trim()) * 60) + Convert.ToInt32(txb_push2.Text.Trim());
d.Add("push_ups", push_sec);
new_push_ups = push_sec.ToString();
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_push1.Text.Trim()) & string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
int push_sec = (Convert.ToInt32(txb_push1.Text.Trim()) * 60);
d.Add("push_ups", push_sec);
new_push_ups = push_sec.ToString();
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_push1.Text.Trim()) & !string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
int push_sec = Convert.ToInt32(txb_push2.Text.Trim());
d.Add("push_ups", push_sec);
new_push_ups = push_sec.ToString();
}
//都空白
else
{
d.Add("push_ups", DBNull.Value);
new_push_ups = string.Empty;
}
}
//使用次數
else
{
if (!string.IsNullOrEmpty(txb_push1.Text.Trim()) & !string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
int push_sec = (Convert.ToInt32(txb_push1.Text.Trim()) * 60) + Convert.ToInt32(txb_push2.Text.Trim());
d.Add("push_ups", push_sec);
new_push_ups = push_sec.ToString();
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_push1.Text.Trim()) & string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
int push_sec = (Convert.ToInt32(txb_push1.Text.Trim()) * 60);
d.Add("push_ups", push_sec);
new_push_ups = push_sec.ToString();
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_push1.Text.Trim()) & !string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
int push_sec = Convert.ToInt32(txb_push2.Text.Trim());
d.Add("push_ups", push_sec);
new_push_ups = push_sec.ToString();
}
//都空白
else
{
d.Add("push_ups", DBNull.Value);
new_push_ups = string.Empty;
}
}
//判斷第三項是用次數還是秒
//使用分秒
if (run_note == "秒")
{
//2016-1-14新判斷
//分、秒都有值
if (!string.IsNullOrEmpty(txb_run1.Text.Trim()) & !string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
int run_sec = (Convert.ToInt32(txb_run1.Text.Trim()) * 60) + Convert.ToInt32(txb_run2.Text.Trim());
d.Add("run", run_sec);
new_run = run_sec.ToString();
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_run1.Text.Trim()) & string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
int run_sec = (Convert.ToInt32(txb_run1.Text.Trim()) * 60);
d.Add("run", run_sec);
new_run = run_sec.ToString();
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_run1.Text.Trim()) & !string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
int run_sec = Convert.ToInt32(txb_run2.Text.Trim());
d.Add("run", run_sec);
new_run = run_sec.ToString();
}
//都空白
else
{
d.Add("run", DBNull.Value);
new_run = string.Empty;
}
}
//使用次數
else
{
//分、秒都有值
if (!string.IsNullOrEmpty(txb_run1.Text.Trim()) & !string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
int run_sec = (Convert.ToInt32(txb_run1.Text.Trim()) * 60) + Convert.ToInt32(txb_run2.Text.Trim());
d.Add("run", run_sec);
new_run = run_sec.ToString();
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_run1.Text.Trim()) & string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
int run_sec = (Convert.ToInt32(txb_run1.Text.Trim()) * 60);
d.Add("run", run_sec);
new_run = run_sec.ToString();
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_run1.Text.Trim()) & !string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
int run_sec = Convert.ToInt32(txb_run2.Text);
d.Add("run", run_sec);
new_run = run_sec.ToString();
}
//都空白
else
{
d.Add("run", DBNull.Value);
new_run = string.Empty;
}
}
d.Add("id", id1.Value.ToUpper());
d.Add("date", Convert.ToDateTime(dateValue.Value));
try
{
du.executeNonQueryByText("update result set sit_ups = @sit_ups, push_ups = @push_ups, run=@run where id = @id and date = @date and status in ('102','103','105')", d);
//2017-1-26再重新計算一次成績
Dictionary <string, object> d1 = new Dictionary <string, object>();
d1.Add("id", id1.Value.ToUpper());
d1.Add("date", Convert.ToDateTime(dateValue.Value));
//2018-10-11新增異動時間點
DateTime ChangeDate = new DateTime(2018, 12, 31, 23, 59, 59);
DateTime TodayDate = Convert.ToDateTime(dateValue.Value);
if (TodayDate > ChangeDate)
{
du.executeNonQueryBysp("Ex108_CalResultByID", d1);
}
else
{
du.executeNonQueryBysp("Ex106_CalResultByID", d1);
}
d1.Clear();
Account_c acc = (Account_c)Session["account"];
//Lib.SysSetting.AddLog("成績補正", acc.Account, "補正對象: (" + id.Value + ") 補正前成績為(" + sit_ups_name.Text + ": " + old_situps + "次/秒, " + push_ups_name.Text + ": " + old_pushups + "次/秒, " + run_name.Text + ": " + old_run + "次/秒)" + "補正後成績為(" + sit_ups_name.Text + ": " + sit_value + "次/秒, " + push_ups_name.Text + ": " + push_value + "次/秒, " + run_name.Text + ": " + run_value + "次/秒)", DateTime.Now);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("id", id1.Value.ToUpper());
dic.Add("name", name.Value);
dic.Add("date", Convert.ToDateTime(dateValue.Value));
if (!string.IsNullOrEmpty(old_situps))
{
dic.Add("old_sit_ups", old_situps);
}
else
{
dic.Add("old_sit_ups", DBNull.Value);
}
if (!string.IsNullOrEmpty(old_pushups))
{
dic.Add("old_push_ups", old_pushups);
}
else
{
dic.Add("old_push_ups", DBNull.Value);
}
if (!string.IsNullOrEmpty(old_run))
{
dic.Add("old_run", old_run);
}
else
{
dic.Add("old_run", DBNull.Value);
}
if (!string.IsNullOrEmpty(new_sit_ups))
{
dic.Add("new_sit_ups", new_sit_ups);
}
else
{
dic.Add("new_sit_ups", DBNull.Value);
}
if (!string.IsNullOrEmpty(new_push_ups))
{
dic.Add("new_push_ups", new_push_ups);
}
else
{
dic.Add("new_push_ups", DBNull.Value);
}
if (!string.IsNullOrEmpty(new_run))
{
dic.Add("new_run", new_run);
}
else
{
dic.Add("new_run", DBNull.Value);
}
dic.Add("account", acc.Account);
if (!string.IsNullOrEmpty(acc.ID))
{
dic.Add("account_id", acc.ID);
}
else
{
dic.Add("account_id", DBNull.Value);
}
dic.Add("update_time", DateTime.Now);
dic.Add("type", "成績補正");
Lib.SysSetting.AddResultCorrectLog(dic);
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('成績補正完成!!');", true);
id1.Value = "";
//situps.Value = "";
//pushups.Value = "";
//run.Value = "";
name.Value = "";
//清空欄位
txb_sit1.Text = null;
txb_sit2.Text = null;
txb_push1.Text = null;
txb_push2.Text = null;
txb_run1.Text = null;
txb_run2.Text = null;
sit_note = string.Empty;
push_note = string.Empty;
run_note = string.Empty;
sit_value = string.Empty;
push_value = string.Empty;
run_value = string.Empty;
new_sit_ups = string.Empty;
new_push_ups = string.Empty;
new_run = string.Empty;
//2016-1-25修改完後欄位全關閉
sit_ups_name.Text = null;
txb_sit1.Visible = false;
txb_sit2.Visible = false;
lab_sit1.Text = null;
lab_sit2.Text = null;
push_ups_name.Text = null;
txb_push1.Visible = false;
txb_push2.Visible = false;
lab_push1.Text = null;
lab_push2.Text = null;
run_name.Text = null;
txb_run1.Visible = false;
txb_run2.Visible = false;
lab_run1.Text = null;
lab_run2.Text = null;
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('" + ex.Message.ToString() + "');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('資料有誤!!請重新執行搜尋!!');", true);
//清空欄位
name.Value = null;
txb_sit1.Text = null;
txb_sit2.Text = null;
txb_push1.Text = null;
txb_push2.Text = null;
txb_run1.Text = null;
txb_run2.Text = null;
sit_note = string.Empty;
push_note = string.Empty;
run_note = string.Empty;
sit_value = string.Empty;
push_value = string.Empty;
run_value = string.Empty;
//2016-1-25修改完後欄位全關閉
sit_ups_name.Text = null;
txb_sit1.Visible = false;
txb_sit2.Visible = false;
lab_sit1.Text = null;
lab_sit2.Text = null;
push_ups_name.Text = null;
txb_push1.Visible = false;
txb_push2.Visible = false;
lab_push1.Text = null;
lab_push2.Text = null;
run_name.Text = null;
txb_run1.Visible = false;
txb_run2.Visible = false;
lab_run1.Text = null;
lab_run2.Text = null;
}
}
}
public void SaveScore()
{
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
try
{
if (!situps.Disabled)
{
if (situps.Value == "")
{
d.Add("sit_ups", DBNull.Value);
}
else
{
d.Add("sit_ups", Convert.ToInt32(situps.Value));
}
}
else
{
int total = 0;
if (situps.Value == "" && situps_min.Value == "" && situps_sec.Value == "")
{
d.Add("sit_ups", DBNull.Value);
}
else if (situps.Value != "")
{
d.Add("sit_ups", situps.Value);
}
else
{
if (situps_min.Value != "")
{
total += Convert.ToInt32(situps_min.Value) * 60;
}
if (situps_sec.Value != "")
{
total += Convert.ToInt32(situps_sec.Value);
}
if (total != 0)
{
d.Add("sit_ups", total);
}
else
{
d.Add("sit_ups", DBNull.Value);
}
}
}
if (!pushups.Disabled)
{
if (pushups.Value == "")
{
d.Add("push_ups", DBNull.Value);
}
else
{
d.Add("push_ups", Convert.ToInt32(pushups.Value));
}
}
else
{
int total = 0;
if (pushups.Value == "" && pushups_min.Value == "" && pushups_sec.Value == "")
{
d.Add("push_ups", DBNull.Value);
}
else if (pushups.Value != "")
{
d.Add("push_ups", pushups.Value);
}
else
{
if (pushups_min.Value != "")
{
total += Convert.ToInt32(pushups_min.Value) * 60;
}
if (pushups_sec.Value != "")
{
total += Convert.ToInt32(pushups_sec.Value);
}
if (total != 0)
{
d.Add("push_ups", total);
}
else
{
d.Add("push_ups", DBNull.Value);
}
}
}
if (!run.Disabled)
{
if (run.Value == "")
{
d.Add("run", DBNull.Value);
}
else
{
d.Add("run", Convert.ToInt32(run.Value));
}
}
else
{
int total = 0;
if (run.Value == "" && run_min.Value == "" && run_sec.Value == "")
{
d.Add("run", DBNull.Value);
}
else if (run.Value != "")
{
d.Add("run", run.Value);
}
else
{
if (run_min.Value != "")
{
total += Convert.ToInt32(run_min.Value) * 60;
}
if (run_sec.Value != "")
{
total += Convert.ToInt32(run_sec.Value);
}
if (total != 0)
{
d.Add("run", total);
}
else
{
d.Add("run", DBNull.Value);
}
}
}
d.Add("id", id.Value);
du.executeNonQueryByText("update result set sit_ups = @sit_ups, push_ups = @push_ups, run=@run where id = @id and status in ('001','103','102') and (memo != '000' or memo != '999')", d);
Account_c acc = (Account_c)Session["account"];
Lib.SysSetting.AddLog("替代方案成績輸入", acc.Account, @"輸入對象: (" + id.Value + ") 輸入成績為(" + sit_ups_name.Text + ": " + situps.Value + "次, " + situps_min.Value + "分:" + situps_sec.Value + "秒" + push_ups_name.Text + ": " + pushups.Value + "次, " + pushups_min.Value + "分:" + pushups_sec.Value + "秒" + run_name.Text + ": " + run.Value + "次," + run_min.Value + "分:" + run_sec.Value + "秒)", DateTime.Now);
if (status.Value == "102" || status.Value == "103")
{ //status = 合格或不合格 , 需要再做成績補正
d.Clear();
d.Add("id", id.Value);
du.executeNonQueryBysp("Race_CalResult", d);
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('替代方案成績輸入完成!!');", true);
id.Value = "";
situps.Value = "";
situps_min.Value = "";
situps_sec.Value = "";
pushups.Value = "";
pushups_min.Value = "";
pushups_sec.Value = "";
run.Value = "";
run_min.Value = "";
run_sec.Value = "";
name.Value = "";
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, "Race_ReplaceItemScore.aspx");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('" + ex.Message.ToString() + "');", true);
}
}
protected void upload_OnClick(object sender, EventArgs e)
{
Lib.DataUtility du = new Lib.DataUtility();
DataTable dt = du.getDataTableByText("select * from result where status = @status and result is NULL", "status", "102"); // 102 未上傳合格
if (dt.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('目前沒有成績');", true);
GridView3.DataBind();
}
else
{
dt.TableName = "upload";
MainWS.WebService MainWs = new MainWS.WebService();
string msg = MainWs.UploadResult(dt, "102");
if (msg == "done")
{
//Lib.DataUtility main = new Lib.DataUtility(Lib.DataUtility.ConnectionType.MainDB);
//List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
List <Dictionary <string, object> > list_u = new List <Dictionary <string, object> >();
foreach (DataRow row in dt.Rows)
{
// Dictionary<string, object> d = new Dictionary<string, object>();
Dictionary <string, object> d_u = new Dictionary <string, object>();
// d.Add("sid", row["sid"]);
d_u.Add("sid", row["sid"]);
// d.Add("height", row["height"]);
// d.Add("weight", row["weight"]);
// d.Add("BMI", row["BMI"]);
// d.Add("bodyfat", row["bodyfat"]);
// d.Add("sit_ups", row["sit_ups"]);
// d.Add("sit_ups_score", row["sit_ups_score"]);
// d.Add("push_ups", row["push_ups"]);
// d.Add("push_ups_score", row["push_ups_score"]);
// d.Add("run", row["run"]);
// d.Add("run_score", row["run_score"]);
// d.Add("status", "202"); // 202 已上傳合格
// list.Add(d);
list_u.Add(d_u);
}
try
{
// // 上傳更新總部資料
// main.executeNonQueryByText("update result set height = @height, weight=@weight, BMI = @BMI, bodyfat = @bodyfat, sit_ups = @sit_ups, sit_ups_score = @sit_ups_score, push_ups = @push_ups, push_ups_score = @push_ups_score, run = @run, run_score = @run_score, status = @status where sid = @sid", list);
// 更新鑑測站資料狀態
du.executeNonQueryByText("update result set status = '202' where sid = @sid", list_u);
Dictionary <string, object> d_log = new Dictionary <string, object>();
d_log.Add("acc", ((Lib.Center.Account_c)Session["account"]).Account);
d_log.Add("name", ((Lib.Center.Account_c)Session["account"]).Name);
d_log.Add("log", "上傳合格成績 " + dt.Rows.Count.ToString() + " 筆");
d_log.Add("date", DateTime.Now);
du.executeNonQueryByText("insert into log values (@acc,@name,@log,@date)", d_log);
Account_c acc = (Account_c)Session["account"];
Lib.SysSetting.AddLog("成績上傳", acc.Account, "上傳合格成績 " + dt.Rows.Count.ToString() + " 筆", DateTime.Now);
dt.Dispose();
//list.Clear();
list_u.Clear();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('上傳合格成績成功');", 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(\"" + msg + "\");", true);
}
GridView3.DataBind();
}
}
protected void ReActionUpload_OnClick(object sender, EventArgs e)
{
Lib.DataUtility du = new Lib.DataUtility();
DataTable dt = du.getDataTableByText("select * from result where status = @status and result is NULL", "status", "105"); // 未上傳補測
if (dt.Rows.Count == 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('目前沒有成績');", true);
}
else
{
foreach (DataRow _row in dt.Rows)
{
foreach (GridViewRow row in GridView5.Rows)
{
RadioButtonList dbl = (RadioButtonList)row.Cells[8].FindControl("rb2");
var _v = dbl.SelectedValue;
if (_row["id"].ToString() == row.Cells[1].Text)
{
_row["status"] = _v;
}
}
}
dt.TableName = "upload";
MainWS.WebService MainWs = new MainWS.WebService();
string msg = MainWs.UploadResult(dt, "105");
if (msg == "done")
{
List <Dictionary <string, object> > list_u = new List <Dictionary <string, object> >();
foreach (DataRow row in dt.Rows)
{
Dictionary <string, object> d_u = new Dictionary <string, object>();
d_u.Add("sid", row["sid"]);
d_u.Add("status", row["status"]);
list_u.Add(d_u);
}
try
{
// 上傳更新總部資料
//main.executeNonQueryByText("update result set height = @height, weight=@weight, BMI = @BMI, bodyfat = @bodyfat, sit_ups = @sit_ups, sit_ups_score = @sit_ups_score, push_ups = @push_ups, push_ups_score = @push_ups_score, run = @run, run_score = @run_score, status = @status where sid = @sid", list);
// 更新鑑測站資料狀態
du.executeNonQueryByText("update result set status = @status where sid = @sid", list_u);
Dictionary <string, object> d_log = new Dictionary <string, object>();
d_log.Add("acc", ((Lib.Center.Account_c)Session["account"]).Account);
d_log.Add("name", ((Lib.Center.Account_c)Session["account"]).Name);
d_log.Add("log", "上傳補測成績 " + dt.Rows.Count.ToString() + " 筆");
d_log.Add("date", DateTime.Now);
du.executeNonQueryByText("insert into log values (@acc,@name,@log,@date)", d_log);
Account_c acc = (Account_c)Session["account"];
Lib.SysSetting.AddLog("成績上傳", acc.Account, "上傳補測成績 " + dt.Rows.Count.ToString() + " 筆", DateTime.Now);
dt.Dispose();
//list.Clear();
list_u.Clear();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('上傳補測成績成功');", 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(\"" + msg + "\");", true);
}
GridView5.DataBind();
TabContainer1.ActiveTabIndex = 3;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if ((Account_c)Session["account"] != null)
{
Account_c acc = (Account_c)Session["account"];
user.Text = " 歡迎 " + acc.Account + " 登入系統 , 現在是中華民國 " + Lib.SysSetting.ToRocDateFormat(DateTime.Now.ToString("yyyy")) + " 年 " + DateTime.Now.Month.ToString() + " 月 " + DateTime.Now.Day.ToString() + " 日 " + Lib.SysSetting.ToRocWeekFormat(DateTime.Now.DayOfWeek) + ", ";
//user.Text = acc.Account;
MenuItem item_new = new MenuItem("鑑測系統設定");
item_new.NavigateUrl = "~/SysSetting.aspx";
Menu1.Items.Add(item_new);
switch (acc.Role)
{
case User_Role.Administrator:
MenuItem item = new MenuItem("個人資訊設定");
item.NavigateUrl = "~/Pro.aspx";
Menu1.Items.Add(item);
MenuItem item1 = new MenuItem("帳號管理者管理");
item1.NavigateUrl = "~/AccMagEdit.aspx";
Menu1.Items.Add(item1);
MenuItem item2 = new MenuItem("事件記錄簿檢視");
item2.NavigateUrl = "~/LogView.aspx";
Menu1.Items.Add(item2);
MenuItem item21 = new MenuItem("系統維護");
item21.NavigateUrl = "~/SysAdmin.aspx";
Menu1.Items.Add(item21);
break;
case User_Role.AccountManager:
MenuItem item3 = new MenuItem("個人資訊設定");
item3.NavigateUrl = "~/Pro.aspx";
Menu1.Items.Add(item3);
MenuItem item4 = new MenuItem("使用者管理");
item4.NavigateUrl = "~/UserMagEdit.aspx";
Menu1.Items.Add(item4);
break;
case User_Role.CenterSupervisor:
MenuItem item5 = new MenuItem("個人資訊設定");
item5.NavigateUrl = "~/Pro.aspx";
Menu1.Items.Add(item5);
MenuItem item18 = new MenuItem("查詢鑑測狀態");
item18.NavigateUrl = "~/ViewResult.aspx";
Menu2.Items.Add(item18);
MenuItem item6 = new MenuItem("成績管理");
item6.NavigateUrl = "~/ResultMag.aspx";
Menu2.Items.Add(item6);
MenuItem item17 = new MenuItem("現報成績管理");
item17.NavigateUrl = "~/PresentResultMag.aspx";
Menu2.Items.Add(item17);
MenuItem item25 = new MenuItem("人工成績管理");
item25.NavigateUrl = "~/HumanResultMag.aspx";
Menu2.Items.Add(item25);
MenuItem item24 = new MenuItem("人工鑑測成績輸入");
item24.NavigateUrl = "~/ScoreKeyin.aspx";
Menu1.Items.Add(item24);
MenuItem item8 = new MenuItem("資料下載");
item8.NavigateUrl = "~/Download.aspx";
Menu1.Items.Add(item8);
MenuItem item13 = new MenuItem("成績補正");
item13.NavigateUrl = "~/ResultCorrect.aspx";
Menu1.Items.Add(item13);
MenuItem item14 = new MenuItem("成績統計");
item14.NavigateUrl = "~/Reporting.aspx";
Menu1.Items.Add(item14);
MenuItem item19 = new MenuItem("數據資料檢視");
item19.NavigateUrl = "~/107_Result_Chart.aspx";
Menu2.Items.Add(item19);
MenuItem item22 = new MenuItem("設定鑑測項目");
item22.NavigateUrl = "~/ChangeItem.aspx";
Menu1.Items.Add(item22);
MenuItem item7 = new MenuItem("RFID對照表");
item7.NavigateUrl = "~/RFIDUpdate.aspx";
Menu1.Items.Add(item7);
MenuItem item12 = new MenuItem("系統維護");
item12.NavigateUrl = "~/SysAdmin.aspx";
Menu1.Items.Add(item12);
MenuItem item27 = new MenuItem("伺服器狀態");
item27.NavigateUrl = "~/108_CenterStatus.aspx";
Menu2.Items.Add(item27);
MenuItem item29 = new MenuItem("成績試算");
item29.NavigateUrl = "~/108_ScoreTrial.aspx";
Menu2.Items.Add(item29);
break;
case User_Role.CenterOfficer:
MenuItem item9 = new MenuItem("個人資訊設定");
item9.NavigateUrl = "~/Pro.aspx";
Menu1.Items.Add(item9);
MenuItem item10 = new MenuItem("查詢鑑測狀態");
item10.NavigateUrl = "~/ViewResult.aspx";
Menu1.Items.Add(item10);
MenuItem item11 = new MenuItem("清冊下載");
item11.NavigateUrl = "~/ToExcel.aspx";
Menu1.Items.Add(item11);
MenuItem item15 = new MenuItem("成績統計");
item15.NavigateUrl = "~/Reporting.aspx";
Menu1.Items.Add(item15);
MenuItem item16 = new MenuItem("成績查詢");
item16.NavigateUrl = "~/SearchScore.aspx";
Menu1.Items.Add(item16);
MenuItem item20 = new MenuItem("替代項目成績輸入");
item20.NavigateUrl = "~/ReplaceItemScore.aspx";
Menu1.Items.Add(item20);
MenuItem item23 = new MenuItem("成績試算");
item23.NavigateUrl = "~/108_ScoreTrial.aspx";
Menu1.Items.Add(item23);
MenuItem item26 = new MenuItem("數據資料檢視");
item26.NavigateUrl = "~/107_Result_Chart.aspx";
Menu1.Items.Add(item26);
MenuItem item28 = new MenuItem("伺服器狀態");
item28.NavigateUrl = "~/108_CenterStatus.aspx";
Menu2.Items.Add(item28);
break;
default:
break;
}
if (Lib.SysSetting.CurrentSystemMode() == Lib.SysSetting.SystemMode.Race)
{
string sPath = System.Web.HttpContext.Current.Request.Url.AbsolutePath;
System.IO.FileInfo oInfo = new System.IO.FileInfo(sPath);
string sRet = oInfo.Name;
if (sRet != "SysSetting.aspx" && sRet != "LogView.aspx" && sRet != "SysAdmin.aspx")
{
Response.Redirect("~/SysSetting.aspx");
}
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "javascript:alert('逾時登出，請重新登入');window.location='./Login.aspx';", true);
//Response.Redirect("~/Login.aspx");
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (check_num.Value == "1")//前台傳回來的值(1：正確、0：錯誤)
{
Lib.DataUtility du = new Lib.DataUtility();
Dictionary <string, object> d = new Dictionary <string, object>();
d.Clear();
//判斷身份證字號是否正確
if (id.Value != "" && id.Value == checkid.Value)
{
//2016新增
//判斷第一項是用次數還是秒
//使用分秒
if (sit_note == "秒")
{
//2016-1-14新判斷
//分、秒都有值
if (!string.IsNullOrEmpty(txb_sit1.Text.Trim()) & !string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
//再判斷欄位是不是小於60(拿掉)
//if (Convert.ToInt32(txb_sit1.Text.Trim()) < 60 & Convert.ToInt32(txb_sit2.Text.Trim()) < 60 & Convert.ToInt32(txb_sit1.Text.Trim()) >= 0 & Convert.ToInt32(txb_sit2.Text.Trim()) >= 0)
//{
int sit_sec = (Convert.ToInt32(txb_sit1.Text.Trim()) * 60) + Convert.ToInt32(txb_sit2.Text.Trim());
d.Add("sit_ups", sit_sec);
//}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「分」.「秒」欄位輸入範圍值應為：0-59');", true);
// return;
//}
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_sit1.Text.Trim()) & string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
//再判斷欄位是不是小於60(拿掉)
//if (Convert.ToInt32(txb_sit1.Text.Trim()) < 60 & Convert.ToInt32(txb_sit1.Text.Trim()) >= 0)
//{
int sit_sec = (Convert.ToInt32(txb_sit1.Text.Trim()) * 60);
d.Add("sit_ups", sit_sec);
//}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「分」欄位輸入範圍值應為：0-59');", true);
// return;
//}
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_sit1.Text.Trim()) & !string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
//再判斷欄位是不是小於60(拿掉)
//if (Convert.ToInt32(txb_sit2.Text.Trim()) < 60 & Convert.ToInt32(txb_sit2.Text.Trim()) >= 0)
//{
int sit_sec = Convert.ToInt32(txb_sit2.Text.Trim());
d.Add("sit_ups", sit_sec);
//}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「秒」欄位輸入範圍值應為：0-59');", true);
// return;
//}
}
//都空白
else
{
d.Add("sit_ups", DBNull.Value);
}
}
//200公尺游泳使用
else if (sit_note == "(合格:1/不合格:0)")
{
//判斷有沒有輸入值，沒有的話給null
if (!string.IsNullOrEmpty(txb_sit2.Text.Trim()))
//判斷是否值為0或1
{
if (txb_sit2.Text.Trim() == "0" || txb_sit2.Text.Trim() == "1")
{
d.Add("sit_ups", txb_sit2.Text.Trim());
}
else
{
//d.Add("sit_ups", DBNull.Value);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「200公尺游泳」項目請輸入正確格式(合格:1/不合格:0)');", true);
return;
}
}
else
{
d.Add("sit_ups", DBNull.Value);
}
}
//使用次數
else
{
//2016-1-26再修正值不等於"秒"，也是判斷二個欄位來相加
//分、秒都有值
if (!string.IsNullOrEmpty(txb_sit1.Text.Trim()) & !string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
int sit_sec = (Convert.ToInt32(txb_sit1.Text.Trim()) * 60) + Convert.ToInt32(txb_sit2.Text.Trim());
d.Add("sit_ups", sit_sec);
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_sit1.Text.Trim()) & string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
int sit_sec = (Convert.ToInt32(txb_sit1.Text.Trim()) * 60);
d.Add("sit_ups", sit_sec);
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_sit1.Text.Trim()) & !string.IsNullOrEmpty(txb_sit2.Text.Trim()))
{
int sit_sec = Convert.ToInt32(txb_sit2.Text.Trim());
d.Add("sit_ups", sit_sec);
}
//都空白
else
{
d.Add("sit_ups", DBNull.Value);
}
}
//判斷第二項是用次數還是秒
//使用分秒
if (push_note == "秒")
{
//2016-1-14新判斷
//分、秒都有值
if (!string.IsNullOrEmpty(txb_push1.Text.Trim()) & !string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
//再判斷欄位是不是小於60(拿掉)
//if (Convert.ToInt32(txb_push1.Text.Trim()) < 60 & Convert.ToInt32(txb_push2.Text.Trim()) < 60 & Convert.ToInt32(txb_push1.Text.Trim()) >= 0 & Convert.ToInt32(txb_push2.Text.Trim()) >= 0)
//{
int push_sec = (Convert.ToInt32(txb_push1.Text.Trim()) * 60) + Convert.ToInt32(txb_push2.Text.Trim());
d.Add("push_ups", push_sec);
//}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「分」.「秒」欄位輸入範圍值應為：0-59');", true);
// return;
//}
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_push1.Text.Trim()) & string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
//再判斷欄位是不是小於60(拿掉)
//if (Convert.ToInt32(txb_push1.Text.Trim()) < 60 & Convert.ToInt32(txb_push1.Text.Trim()) >= 0)
//{
int push_sec = (Convert.ToInt32(txb_push1.Text.Trim()) * 60);
d.Add("push_ups", push_sec);
//}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「分」欄位輸入範圍值應為：0-59');", true);
// return;
//}
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_push1.Text.Trim()) & !string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
//再判斷欄位是不是小於60(拿掉)
//if (Convert.ToInt32(txb_push2.Text.Trim()) < 60 & Convert.ToInt32(txb_push2.Text.Trim()) >= 0)
//{
int push_sec = Convert.ToInt32(txb_push2.Text.Trim());
d.Add("push_ups", push_sec);
//}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「秒」欄位輸入範圍值應為：0-59');", true);
// return;
//}
}
//都空白
else
{
d.Add("push_ups", DBNull.Value);
}
}
//200公尺游泳使用
else if (push_note == "(合格:1/不合格:0)")
{
//判斷有沒有輸入值，沒有的話給null
if (!string.IsNullOrEmpty(txb_push2.Text.Trim()))
//判斷是否值為0或1
{
if (txb_push2.Text.Trim() == "0" || txb_push2.Text.Trim() == "1")
{
d.Add("push_ups", txb_push2.Text.Trim());
}
else
{
//d.Add("push_ups", DBNull.Value);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「200公尺游泳」項目請輸入正確格式(合格:1/不合格:0)');", true);
return;
}
}
else
{
d.Add("push_ups", DBNull.Value);
}
}
//使用次數
else
{
//2016-1-26再修正值不等於"秒"，也是判斷二個欄位來相加
//分、秒都有值
if (!string.IsNullOrEmpty(txb_push1.Text.Trim()) & !string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
int push_sec = (Convert.ToInt32(txb_push1.Text.Trim()) * 60) + Convert.ToInt32(txb_push2.Text.Trim());
d.Add("push_ups", push_sec);
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_push1.Text.Trim()) & string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
int push_sec = (Convert.ToInt32(txb_push1.Text.Trim()) * 60);
d.Add("push_ups", push_sec);
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_push1.Text.Trim()) & !string.IsNullOrEmpty(txb_push2.Text.Trim()))
{
int push_sec = Convert.ToInt32(txb_push2.Text.Trim());
d.Add("push_ups", push_sec);
}
//都空白
else
{
d.Add("push_ups", DBNull.Value);
}
}
//判斷第三項是用次數還是秒
//使用分秒
if (run_note == "秒")
{
//2016-1-14新判斷
//分、秒都有值
if (!string.IsNullOrEmpty(txb_run1.Text.Trim()) & !string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
////再判斷欄位是不是小於60(拿掉)
//if (Convert.ToInt32(txb_run1.Text.Trim()) < 60 & Convert.ToInt32(txb_run2.Text.Trim()) < 60 & Convert.ToInt32(txb_run1.Text.Trim()) >= 0 & Convert.ToInt32(txb_run2.Text.Trim()) >= 0)
//{
int run_sec = (Convert.ToInt32(txb_run1.Text.Trim()) * 60) + Convert.ToInt32(txb_run2.Text.Trim());
d.Add("run", run_sec);
//}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「分」.「秒」欄位輸入範圍值應為：0-59');", true);
// return;
//}
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_run1.Text.Trim()) & string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
//再判斷欄位是不是小於60(拿掉)
//if (Convert.ToInt32(txb_run1.Text.Trim()) < 60 & Convert.ToInt32(txb_run1.Text.Trim()) >= 0)
//{
int run_sec = (Convert.ToInt32(txb_run1.Text.Trim()) * 60);
d.Add("run", run_sec);
//}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「分」欄位輸入範圍值應為：0-59');", true);
// return;
//}
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_run1.Text.Trim()) & !string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
//再判斷欄位是不是小於60(拿掉)
//if (Convert.ToInt32(txb_run2.Text.Trim()) < 60 & Convert.ToInt32(txb_run2.Text.Trim()) >= 0)
//{
int run_sec = Convert.ToInt32(txb_run2.Text.Trim());
d.Add("run", run_sec);
//}
//else
//{
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「秒」欄位輸入範圍值應為：0-59');", true);
// return;
//}
}
//都空白
else
{
d.Add("run", DBNull.Value);
}
}
//200公尺游泳使用
else if (run_note == "(合格:1/不合格:0)")
{
//判斷有沒有輸入值，沒有的話給null
if (!string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
//判斷是否值為0或1
if (txb_run2.Text.Trim() == "0" || txb_run2.Text.Trim() == "1")
{
d.Add("run", txb_run2.Text.Trim());
}
else
{
//d.Add("run", DBNull.Value);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('「200公尺游泳」項目請輸入正確格式(合格:1/不合格:0)');", true);
return;
}
}
else
{
d.Add("run", DBNull.Value);
}
}
//使用次數
else
{
//2016-1-26再修正值不等於"秒"，也是判斷二個欄位來相加
//分、秒都有值
if (!string.IsNullOrEmpty(txb_run1.Text.Trim()) & !string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
int run_sec = (Convert.ToInt32(txb_run1.Text.Trim()) * 60) + Convert.ToInt32(txb_run2.Text.Trim());
d.Add("run", run_sec);
}
//分有值、秒空白
else if (!string.IsNullOrEmpty(txb_run1.Text.Trim()) & string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
int run_sec = (Convert.ToInt32(txb_run1.Text.Trim()) * 60);
d.Add("run", run_sec);
}
//分空白、秒有值
else if (string.IsNullOrEmpty(txb_run1.Text.Trim()) & !string.IsNullOrEmpty(txb_run2.Text.Trim()))
{
int run_sec = Convert.ToInt32(txb_run2.Text.Trim());
d.Add("run", run_sec);
}
//都空白
else
{
d.Add("run", DBNull.Value);
}
}
//加入舊版回寫資料庫跟產生log
d.Add("id", id.Value);
d.Add("date", Convert.ToDateTime(dateValue.Value));
try
{
du.executeNonQueryByText("update result set sit_ups = @sit_ups, push_ups = @push_ups, run=@run where id = @id and date = @date and status in ('001') and (memo != '000' or memo != '999')", d);
Account_c acc = (Account_c)Session["account"];
Lib.SysSetting.AddLog("替代方案成績輸入", acc.Account, "輸入對象: (" + id.Value + ") 輸入成績為(" + sit_ups_name.Text.Trim() + ": " + sit_value + ", " + push_ups_name.Text.Trim() + ": " + push_value + ", " + run_name.Text.Trim() + ": " + run_value + ")", DateTime.Now);
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('替代方案成績輸入完成!!');", true);
id.Value = "";
name.Value = "";
//清空欄位
name.Value = null;
txb_sit1.Text = null;
txb_sit2.Text = null;
txb_push1.Text = null;
txb_push2.Text = null;
txb_run1.Text = null;
txb_run2.Text = null;
sit_note = string.Empty;
push_note = string.Empty;
run_note = string.Empty;
sit_value = string.Empty;
push_value = string.Empty;
run_value = string.Empty;
//2016-1-25修改完後欄位全關閉
sit_ups_name.Text = null;
txb_sit1.Visible = false;
txb_sit2.Visible = false;
lab_sit1.Text = null;
lab_sit2.Text = null;
push_ups_name.Text = null;
txb_push1.Visible = false;
txb_push2.Visible = false;
lab_push1.Text = null;
lab_push2.Text = null;
run_name.Text = null;
txb_run1.Visible = false;
txb_run2.Visible = false;
lab_run1.Text = null;
lab_run2.Text = null;
Button2.Visible = false;
}
catch (Exception ex)
{
Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, sender.ToString());
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('" + ex.Message.ToString() + "');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('資料有誤!!請重新執行搜尋!!');", true);
//清空欄位
name.Value = null;
txb_sit1.Text = null;
txb_sit2.Text = null;
txb_push1.Text = null;
txb_push2.Text = null;
txb_run1.Text = null;
txb_run2.Text = null;
sit_note = string.Empty;
push_note = string.Empty;
run_note = string.Empty;
sit_value = string.Empty;
push_value = string.Empty;
run_value = string.Empty;
//2016-1-25修改完後欄位全關閉
sit_ups_name.Text = null;
txb_sit1.Visible = false;
txb_sit2.Visible = false;
lab_sit1.Text = null;
lab_sit2.Text = null;
push_ups_name.Text = null;
txb_push1.Visible = false;
txb_push2.Visible = false;
lab_push1.Text = null;
lab_push2.Text = null;
run_name.Text = null;
txb_run1.Visible = false;
txb_run2.Visible = false;
lab_run1.Text = null;
lab_run2.Text = null;
}
}
}
