文件操作 - ViewTimeTracker.aspx.cs
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\monitor.kimbly.in\wwwroot\ViewTimeTracker.aspx.cs
编辑文件内容
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; public partial class ViewTimeTracker : System.Web.UI.Page { #region PageMethods protected void Page_Load(object sender, EventArgs e) { if (GeneralMethods.EmployeeID == 0 || Convert.ToInt16(Session["employeeid"]) == 0) { Response.Redirect("Login.aspx"); } else if (!IsPostBack) { LoadEmployee(); txtSDate.Text = DateTime.Today.ToShortDateString(); txtEDate.Text = DateTime.Today.ToShortDateString(); CheckPageValidation(); } } protected void BtnSearch_Click(object sender, EventArgs e) { LoadGrid(); DataSet ds = SelectClass.getTotalTimeSpentBetweenDateByEmpID(Convert.ToInt16(ddlEmployee.SelectedValue), Convert.ToDateTime(txtSDate.Text), Convert.ToDateTime(txtEDate.Text)); string TotalTime = ds.Tables[0].Rows[0]["TotalTime"].ToString(); decimal RatePerHour = Convert.ToDecimal(ds.Tables[1].Rows[0]["RatePerHour"].ToString()); if (TotalTime != "") { string Hour = TotalTime.Substring(0, TotalTime.IndexOf(':')); string Minutes = TotalTime.Substring(TotalTime.IndexOf(':') + 1, TotalTime.LastIndexOf(':') - TotalTime.IndexOf(':') - 1); string Seconds = TotalTime.Substring(TotalTime.LastIndexOf(':') + 1); decimal dtm = (Convert.ToDecimal(Hour) * RatePerHour) + (Convert.ToDecimal(Minutes) * RatePerHour / 60) + ((Convert.ToDecimal(Seconds) / 60) * (RatePerHour / 60)); string Amt = Convert.ToString(dtm); if (Amt.IndexOf('.') != -1) { string Amount = Convert.ToString(dtm) + "000"; lblTotal.Text = "Total Time - " + TotalTime; lblAmount.Text = "Total Amount - " + "Rs:" + Amount.Substring(0, Amount.IndexOf('.') + 3); } else { lblTotal.Text = "Total Time - " + TotalTime; lblAmount.Text = "Total Amount - " + "Rs:" + Amt; } } else { lblTotal.Text = string.Empty; lblAmount.Text = string.Empty; } } protected void pay_Click(object sender, EventArgs e) { //InsertClass.InsertPayment(DateTime.Today, txtRem.Text, 1, Convert.ToDecimal(TxtAmt.Text)); //int key = 0; //string pids = ""; //for (int i = 0; i < GridView1.DataKeys.Count; i++) //{ // if (pids != "") // { // pids += ","; // } // key = Convert.ToInt32(GridView1.DataKeys[i].Value); // pids += key.ToString(); //} //UpdateClass.UpdatePayment(pids); //GridView1.DataBind(); } protected void grdTimeTracker_PageIndexChanging(object sender, GridViewPageEventArgs e) { grdTimeTracker.PageIndex = e.NewPageIndex; LoadGrid(); } #endregion //PageMethods #region Methods private void LoadGrid() { DataSet dsTimeTracker = new DataSet(); dsTimeTracker = SelectClass.GetMonitoringByDates(Convert.ToDateTime(txtSDate.Text), Convert.ToDateTime(txtEDate.Text), Convert.ToInt16(ddlEmployee.SelectedValue)); if (dsTimeTracker.Tables[0].Rows.Count > 0) { grdTimeTracker.DataSource = dsTimeTracker; grdTimeTracker.DataBind(); } else { grdTimeTracker.DataSource = null; grdTimeTracker.DataBind(); } } private void CheckPageValidation() { if (GeneralMethods.IsSuperAdmin == true) { ddlEmployee.Enabled = true; } else if (GeneralMethods.IsSuperAdmin == false) { ddlEmployee.Enabled = false; ddlEmployee.SelectedValue = Convert.ToString(GeneralMethods.EmployeeID); } } private void LoadEmployee() { DataSet dsEmployees = new DataSet(); dsEmployees = SelectClass.GetEmployees("",-1); if (dsEmployees.Tables[0].Rows.Count > 0) { ddlEmployee.DataSource = dsEmployees; ddlEmployee.DataTextField = "EmployeeName"; ddlEmployee.DataValueField = "AutoID"; ddlEmployee.DataBind(); ddlEmployee.Items.Insert(0, new ListItem("Select Employee", "0")); } } #endregion //Methods }
修改文件时间
将文件时间修改为当前时间的前一年
删除文件