protected void Page_Load(object sender, EventArgs e) { if (Session["userinfo"] == null) { Response.Redirect("Home.aspx"); } else { using (SqlConnection cn = new SqlConnection(tmpdbhelper.DB_CnStr)) { cn.Open(); SqlCommand cmd = new SqlCommand(@"Select ComName from ParameterSetting where ComNumber=1"); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { Lbl_CompanyName.Text = dr["ComName"].ToString(); } } } UserInfo tmpUserInfo = null; if (Session["userinfo"] is UserInfo) { tmpUserInfo = (UserInfo)Session["userinfo"]; Lb_UserInfo.Text = tmpUserInfo.Department + "/" + tmpUserInfo.position + "/" + tmpUserInfo.Name; //判斷代理期限是否失效 using (SqlConnection cn = new SqlConnection(tmpdbhelper.DB_CnStr)) { cn.Open(); SqlCommand cmd = new SqlCommand(@"Select EndTime From AgentInfo Where EID=@EID"); cmd.Connection = cn; cmd.Parameters.AddWithValue("@EID", tmpUserInfo.EID); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { DateTime strDate_EndTime = DateTime.Parse(dr["EndTime"].ToString()); DateTime Now = DateTime.Now; if ((Now - strDate_EndTime).TotalSeconds < 0) { using (SqlConnection cn2 = new SqlConnection(tmpdbhelper.DB_CnStr)) { cn2.Open(); SqlCommand cmd2 = new SqlCommand(@"Update UserInfo Set agent=@agent Where EID=@EID"); cmd2.Connection = cn2; cmd2.Parameters.AddWithValue("@EID", tmpUserInfo.EID); cmd2.Parameters.AddWithValue("@agent", ""); cmd2.ExecuteNonQuery(); SqlCommand cmd3 = new SqlCommand(@"Delete from AgentInfo Where EID=@EID"); cmd3.Connection = cn2; cmd3.Parameters.AddWithValue("@EID", tmpUserInfo.EID); cmd3.ExecuteNonQuery(); } } } cn.Close(); } } //判斷_給予權限_期限是否失效 using (SqlConnection cn = new SqlConnection(tmpdbhelper.DB_CnStr)) { cn.Open(); SqlCommand cmd = new SqlCommand(@"Select Date_End From Warrant Where R_EID=@R_EID and effective=@effective"); cmd.Connection = cn; cmd.Parameters.AddWithValue("@R_EID", tmpUserInfo.EID); cmd.Parameters.AddWithValue("@effective", 1); using (SqlDataReader dr = cmd.ExecuteReader()) { //暫時權限 if (dr.Read()) { DateTime strDate_EndTime = DateTime.Parse(dr["Date_End"].ToString()); DateTime Now = DateTime.Now; if ((Now - strDate_EndTime).TotalSeconds < 0) { using (SqlConnection cn2 = new SqlConnection(tmpdbhelper.DB_CnStr)) { cn2.Open(); SqlCommand cmd2 = new SqlCommand(@"Update UserInfo Set temp_Permission=@temp_Permission Where EID=@EID"); cmd2.Connection = cn2; cmd2.Parameters.AddWithValue("@EID", tmpUserInfo.EID); cmd2.Parameters.AddWithValue("@temp_Permission", ""); cmd2.ExecuteNonQuery(); SqlCommand cmd3 = new SqlCommand(@"Update Warrant Set effective=@effective Where R_EID=@R_EID"); cmd3.Connection = cn2; cmd3.Parameters.AddWithValue("@R_EID", tmpUserInfo.EID); cmd3.Parameters.AddWithValue("@effective", 0); cmd3.ExecuteNonQuery(); } if (tmpUserInfo.Permission < 5) { LinkButton1.Visible = true; } } else { if (tmpUserInfo.temp_Permission < 5) { LinkButton1.Visible = true; } } } else { if (tmpUserInfo.Permission < 5) { LinkButton1.Visible = true; } } cn.Close(); } } //判斷該員工是否離職 using (SqlConnection cn = new SqlConnection(tmpdbhelper.DB_CnStr)) { cn.Open(); SqlCommand cmd = new SqlCommand(@"Select job From UserInfo Where EID=@EID"); cmd.Connection = cn; cmd.Parameters.AddWithValue("@EID", tmpUserInfo.EID); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { if (dr["job"].ToString() == "1") { } else { Session["userinfo"] = null; Response.Write("<script>alert('該員工已離職!');location.href='Home.aspx';</script>"); } } } cn.Close(); } } } }
protected void BtnSchedule_Click(object sender, EventArgs e) { sendMail(sender, e); int ind = 0; BillPayEntry entry = new BillPayEntry(); entry.PaymentTransactionDate = PaymentDateField.Text; entry.RecipientBusinessAddress = BusinessAddressField.Text; entry.RecipientBusinessName = BusinessNameField.Text; entry.AmountPaid = AmountField.Text; entry.PaymentDetails = PaymentDetailsField.Text; UserInfo temp = (UserInfo)Session["currentuser"]; entry.EmailAddress = temp.EmailAddress; if (temp.MybillPayments == null) { List <BillPayEntry> newBill = new List <BillPayEntry>(); newBill.Add(entry); temp.MybillPayments = newBill; } else { temp.MybillPayments.Add(entry); } // Response.Redirect("payment.aspx"); ///gridview DataTable dt = new DataTable(); dt.Columns.Add("Transaction Date"); dt.Columns.Add("Recipient Name"); dt.Columns.Add("Recipient Address"); dt.Columns.Add("Amount"); dt.Columns.Add("Status"); DataRow dr = null; if (ViewState["transactions"] != null) { for (int i = 0; i < 1; i++) { dt = (DataTable)ViewState["transactions"]; if (dt.Rows.Count > 0) { dr = dt.NewRow(); dr["Transaction Date"] = PaymentDateField.Text; dr["Recipient Name"] = BusinessNameField.Text; dr["Recipient Address"] = BusinessAddressField.Text; dr["Amount"] = AmountField.Text; dr["Status"] = "In progress"; dt.Rows.InsertAt(dr, 0); GridView1.DataSource = dt; GridView1.DataBind(); updateDatabase(sender, e); PaymentDateField.Text = ""; BusinessNameField.Text = ""; BusinessAddressField.Text = ""; AmountField.Text = ""; PaymentDetailsField.Text = ""; } } } else { dr = dt.NewRow(); dr["Transaction Date"] = PaymentDateField.Text; dr["Recipient Name"] = BusinessNameField.Text; dr["Recipient Address"] = BusinessAddressField.Text; dr["Amount"] = AmountField.Text; dr["Status"] = "In progress"; dt.Rows.Add(dr); GridView1.DataSource = dt; GridView1.DataBind(); updateDatabase(sender, e); PaymentDateField.Text = ""; BusinessNameField.Text = ""; BusinessAddressField.Text = ""; AmountField.Text = ""; PaymentDetailsField.Text = ""; } ViewState["transactions"] = dt; updateDatabase(sender, e); PaymentDateField.Text = ""; BusinessNameField.Text = ""; BusinessAddressField.Text = ""; AmountField.Text = ""; PaymentDetailsField.Text = ""; ///gridview }