protected void btnJobs_Click(object sender, EventArgs e) { Miami.Substitute.Bll.Job job = new Miami.Substitute.Bll.Job(); JobList.DataSource = job.SearchOpenJobs(drJobs.DateStart, drJobs.DateEnd, tbJobs.Value); JobList.DataBind(); Highlight(); }
protected void Page_Load(object sender, EventArgs e) { Miami.Substitute.Bll.Preferred preferred = new Miami.Substitute.Bll.Preferred(); VisibleControls(preferred.IsPreferredExists); Miami.Substitute.Bll.Job job = new Miami.Substitute.Bll.Job(); lblLegend.Text = String.Empty; JobList.DataSource = job.SearchOpenJobs(drJobs.DateStart, drJobs.DateEnd, tbJobs.Value); JobList.DataBind(); Highlight(); }
private void Bind() { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString); string sql = "select J_ID 班种编号,J_Name 班种名称,J_Property 班种性质,J_Onwork1 上半时间一,J_Offwork1 下班时间一,J_Onwork2 上班时间二,J_Offwork2 下班时间二 from [Tb_job_kind]"; SqlDataAdapter sda = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); sda.Fill(ds, "temp"); con.Close(); JobList.DataSource = ds.Tables["temp"].DefaultView; JobList.DataBind(); }
//Method that binds all of the data to the dropdown menus protected void BindBasicData() { SchoolList.DataSource = CreateSchoolList(); SchoolList.DataTextField = "SchoolName"; SchoolList.DataValueField = "SchoolValue"; JobList.DataSource = CreateJobList(); JobList.DataTextField = "JobName"; JobList.DataValueField = "JobValue"; JobList_HS.DataSource = CreateJobList(); JobList_HS.DataTextField = "JobName"; JobList_HS.DataValueField = "JobValue"; SchoolList.DataBind(); JobList.DataBind(); JobList_HS.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Miami.Substitute.Dal.User user = new Miami.Substitute.Dal.User(); DataView dv = user.LoadForMain(Micajah.Common.Security.UserContext.Current.UserId); lblLocationSelected.Text = dv[0]["LocationId"].ToString(); DefaultLocationLabel.Text = "Location: <b>" + dv[0]["RegionName"] + " " + dv[0]["LocationName"] + "</b>"; if (Request.QueryString["Assign"] != null && Request.QueryString["Assign"].ToString().Length > 0) { Session["Assign"] = Request.QueryString["Assign"].ToString(); Response.Redirect("Worksheet.aspx"); } if (Session["lblStatusSelected"] != null && Session["lblStatusSelected"].ToString().Length > 0) { lblStatusSelected.Text = Session["lblStatusSelected"].ToString(); } else { lblStatusSelected.Text = "1"; } if (Session["lblDateSelected"] != null && Session["lblDateSelected"].ToString().Length > 0) { lblDateSelected.Text = Session["lblDateSelected"].ToString(); } else { lblDateSelected.Text = string.Empty; } if (Session["lblDateSelectedTo"] != null && Session["lblDateSelectedTo"].ToString().Length > 0) { lblDateSelectedTo.Text = Session["lblDateSelectedTo"].ToString(); } else { lblDateSelectedTo.Text = string.Empty; } IndicateSelected(); JobList.DataBind(); bool isNoRecords = JobList.MasterTableView.Items.Count == 0; lblNoRecords.Visible = isNoRecords; JobList.Visible = !isNoRecords; }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["pageid"] != null) { return; } Miami.Substitute.Bll.Job job = new Miami.Substitute.Bll.Job(); JobList.DataSource = job.SearchOpenJobs(DateTime.Now.Date.AddDays(-1), DateTime.Now.AddYears(10), 2); JobList.DataBind(); DataView dv = job.SearchOpenJobs(DateTime.Now.Date.AddDays(-1), DateTime.Now.AddYears(10), 3); if (dv != null && dv.Count > 0) { ResponseGridView.DataSource = dv; ResponseGridView.DataBind(); } else { ResponseGridView.Visible = false; lblResponseTitle.Visible = false; } Miami.Substitute.Dal.User user = new Miami.Substitute.Dal.User(); dv = user.LoadForMain(Micajah.Common.Security.UserContext.Current.UserId); if (Session["IsCounted"] == null || Convert.ToInt32(Session["IsCounted"]) == 0) { user.InsertUsage(2, Convert.ToInt32(dv[0]["LocationId"].ToString())); Session["IsCounted"] = 1; } dv.Table.Columns.Add("FullName", Type.GetType("System.String")); dv[0]["FullName"] = dv[0]["FirstName"] + " " + dv[0]["MiddleName"] + (String)(dv[0]["MiddleName"].ToString().Length > 0 ? ". " : "") + dv[0]["LastName"]; dv.Table.Columns.Add("ContactInfo", Type.GetType("System.String")); dv[0]["ContactInfo"] = dv[0]["Address"] + "<br>" + dv[0]["Address2"] + "<br>" + dv[0]["Phone"] + "<br>" + dv[0]["EmailProfile"]; dv.Table.Columns.Add("JobCode", Type.GetType("System.String")); dv[0]["JobCode"] = dv[0]["JobPosition"] + " / " + dv[0]["JobAssignmentDescription"]; if (user.FirstName.Length > 0) { lblName.Text = "Hi, " + Convert.ToString(user.FirstName[0].ToString().ToUpper() + user.FirstName.ToLower().Substring(1, user.FirstName.Length - 1)).TrimEnd(' '); } dv.Table.Columns.Add("SubjectLevel", Type.GetType("System.String")); dv[0]["SubjectLevel"] = "<table border='0' cellspacing='0' cellpadding='0'>"; //DataView dvCoverage = user.LoadCoverage(Micajah.Common.Security.UserContext.Current.UserId); //if (dvCoverage != null && dvCoverage.Table != null && dvCoverage.Table.Rows.Count > 0) //{ // foreach (DataRow dr in dvCoverage.Table.Rows) // { // if (!dr.IsNull("SubjectName") && !dr.IsNull("LevelName") && !dr.IsNull("ExpireYear") != null) // dv[0]["SubjectLevel"] += "<tr><td><b>" + dr["SubjectName"].ToString() + "</b></td><td><b> / </b></td><td><b>" + dr["LevelName"].ToString() + "</b></td><td><b> / </b></td><td><b>" + dr["ExpireYear"].ToString() + "</b></td></tr>"; // } //} dv[0]["SubjectLevel"] += "</table>"; ViewProfile.DataSource = dv; ViewProfile.DataBind(); Master.VisibleLeftArea = false; Master.VisibleMainMenu = false; Master.VisiblePageTitle = false; Master.VisibleBreadCrumbs = false; }