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
}
