protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Session["number"] == null) { Response.Write("<script>alert('登录时间过期,请重新登录');window.location='../login.aspx';</script>"); return; } Calendar1.Visible = false; z_time.Text = DateTime.Now.ToString("yyyy-MM-dd"); Calendar2.Visible = false; r_time.Text = DateTime.Now.ToString("yyyy-MM-dd"); Calendar3.Visible = false; startdate.Text = DateTime.Now.ToString("yyyy-MM-dd"); Calendar4.Visible = false; enddate.Text = DateTime.Now.ToString("yyyy-MM-dd"); string fun = Request.QueryString["operfun"]; string operid = Request.QueryString["operid"]; string operleibie = null; String sql10 = "SELECT s_leibie FROM [ShenQingShenBao] where id='" + operid + "'"; // System.Diagnostics.Debug.Assert(false, sql10);//打印调试信息 DataTable dt_leibie = SqlHelper.ExecuteDataTable(sql10); int i_all = dt_leibie.Rows.Count; if (i_all > 0) { operleibie = dt_leibie.Rows[0][0].ToString(); } if (fun == "edit" && operleibie == "周计划") { string sql = "select * from [ZhouJiHua] where id='" + operid + "'"; // System.Diagnostics.Debug.Assert(false, sql); using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql)) { if (dr.Read()) //读入需要修改的内容 { person1 = new ZhouJiHua(); _ID.Text = dr["id"].ToString(); z_time.Text = dr["z_time"].ToString(); z_jihua.Text = dr["z_jihua"].ToString(); z_mubiao.Text = dr["z_mubiao"].ToString(); z_zhanbi.Text = dr["z_zhanbi"].ToString(); z_shishiqingkuang.Text = dr["z_shishiqingkuang"].ToString(); z_jieguo.Text = dr["z_jieguo"].ToString(); } } } if (fun == "edit" && operleibie == "日计划") { string sql = "select * from [RiJiHua] where id='" + operid + "'"; // System.Diagnostics.Debug.Assert(false, sql); using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql)) { if (dr.Read()) //读入需要修改的内容 { person2 = new RiJiHua(); _ID.Text = dr["id"].ToString(); r_time.Text = dr["r_time"].ToString(); r_jihua.Text = dr["r_jihua"].ToString(); r_mubiao.Text = dr["r_mubiao"].ToString(); r_gongshi.Text = dr["r_gongshi"].ToString(); r_neirong.Text = dr["r_neirong"].ToString(); r_jieguo.Text = dr["r_jieguo"].ToString(); } } } if (fun == "edit" && operleibie == "请假") { string sql = "select * from [qingjia] where id='" + operid + "'"; // System.Diagnostics.Debug.Assert(false, sql); using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql)) { if (dr.Read()) //读入需要修改的内容 { person3 = new qingjia(); _ID.Text = dr["Q_ID"].ToString(); ddl_shixiang.Text = dr["q_shixiang"].ToString(); string str2 = dr.GetString(dr.GetOrdinal("q_startdate")); string[] sArray = str2.Split(' '); startdate.Text = sArray[0]; string[] time1 = sArray[1].Split(':'); time11_d1.Text = time1[0]; time11_d2.Text = time1[1]; string str1 = dr.GetString(dr.GetOrdinal("q_enddate")); string[] sArray1 = str1.Split(' '); enddate.Text = sArray1[0]; string[] time2 = sArray1[1].Split(':'); time12_d1.Text = time2[0]; time12_d2.Text = time2[1]; thing.Text = dr["q_things"].ToString(); tianall.Text = dr["q_all"].ToString(); this.Label2.Text = dr["ImageUrl"].ToString(); } } } GridViewDataBind(); for (int i = 0; i <= 23; i++) { if (i < 10) { time11_d1.Items.Add('0' + i.ToString()); time12_d1.Items.Add('0' + i.ToString()); } else { time11_d1.Items.Add(i.ToString()); time12_d1.Items.Add(i.ToString()); } } for (int i = 0; i < 60; i++) { if (i < 10) { time11_d2.Items.Add('0' + i.ToString()); time12_d2.Items.Add('0' + i.ToString()); } else { time11_d2.Items.Add(i.ToString()); time12_d2.Items.Add(i.ToString()); } } time11_d1.Text = "09"; time12_d1.Text = "18"; } gvShow.Style.Add("table-layout", "fixed"); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Session["number"] == null) { Response.Write("<script>alert('登录时间过期,请重新登录');window.location='../login.aspx';</script>"); return; } Calendar1.Visible = false; // z_time.Text = DateTime.Now.ToString("yyyy-MM-dd"); z_time.Text = DateTime.Now.AddDays(Convert.ToDouble((0 - Convert.ToInt16(DateTime.Now.DayOfWeek)))).AddDays(1).ToString("yyyy-MM-dd");//得到一周的周一是yyyy-MM-dd,第一天从周一开始 Calendar2.Visible = false; r_time.Text = DateTime.Now.ToString("yyyy-MM-dd"); Calendar3.Visible = false; startdate.Text = DateTime.Now.ToString("yyyy-MM-dd"); Calendar4.Visible = false; enddate.Text = DateTime.Now.ToString("yyyy-MM-dd"); string fun = Request.QueryString["operfun"]; string operid = Request.QueryString["operid"]; if (fun == "Clicked") { string sql = "select * from [ZhouJiHua] where id='" + operid + "'"; // System.Diagnostics.Debug.Assert(false, sql); using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql)) { if (dr.Read()) //读入需要修改的内容 { person = new ZhouJiHua(); _ID.Text = dr["id"].ToString(); z_time.Text = dr["z_time"].ToString(); z_jihua.Text = dr["z_jihua"].ToString(); z_mubiao.Text = dr["z_mubiao"].ToString(); z_zhanbi.Text = dr["z_zhanbi"].ToString(); z_shishiqingkuang.Text = dr["z_shishiqingkuang"].ToString(); z_jieguo.Text = dr["z_jieguo"].ToString(); } } } else { // z_time.Text = DateTime.Now.AddDays(Convert.ToDouble((0 - Convert.ToInt16(DateTime.Now.DayOfWeek)))).AddDays(1).ToString("yyyy-MM-dd");//得到一周的周一是yyyy-MM-dd,第一天从周一开始 String sql20 = "SELECT * FROM [ZhouJiHua] where z_time='" + z_time.Text + "' and z_number='" + Session["number"] + "'"; DataTable dt_allgongzuori1 = SqlHelper.ExecuteDataTable(sql20); int i_all = dt_allgongzuori1.Rows.Count; String sql21 = "SELECT * FROM [ShenQingShenBao] where s_time='" + z_time.Text + "' and s_number='" + Session["number"] + "' and s_leibie='周计划'"; // System.Diagnostics.Debug.Assert(false, sql19);//打印调试信息 DataTable dt_allgongzuori2 = SqlHelper.ExecuteDataTable(sql21); int j_all = dt_allgongzuori2.Rows.Count; if (i_all > 0 && j_all > 0) { using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql20)) { if (dr.Read()) //读入需要修改的内容 { person = new ZhouJiHua(); _ID.Text = dr["id"].ToString(); z_time.Text = dr["z_time"].ToString(); z_jihua.Text = dr["z_jihua"].ToString(); z_mubiao.Text = dr["z_mubiao"].ToString(); z_zhanbi.Text = dr["z_zhanbi"].ToString(); z_shishiqingkuang.Text = dr["z_shishiqingkuang"].ToString(); z_jieguo.Text = dr["z_jieguo"].ToString(); } } } else { Response.Redirect("ShenQingShenBao.aspx"); } // z_time.Text = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"); //日期加减几天。 // z_time.Text = DateTime.Now.AddDays(Convert.ToDouble((0 - Convert.ToInt16(DateTime.Now.DayOfWeek)))).ToString("yyyy-MM-dd");//得到一周的第一天是yyyy-MM-dd,第一天从周日开始 //推算出一周的日期 //从周计划数据表中查询该周是否有日期已经填写了周计划,如果已填,则报异常,已填周计划;(shenqingshenbao) //若没有填写,则按正常流程填写 // z_time.Text = Calendar1.SelectedDate.ToString("yyyy-MM-dd");//选择的日期是几号 yyyy-MM-dd // string sunday = Calendar1.SelectedDate.AddDays(Convert.ToDouble((0 - Convert.ToInt16(Calendar1.SelectedDate.DayOfWeek)))).ToString("yyyy-MM-dd");//得到一周的第一天是yyyy-MM-dd,第一天从周日开始 /* System.DateTime sunday = Calendar1.SelectedDate.AddDays(Convert.ToDouble((0 - Convert.ToInt16(Calendar1.SelectedDate.DayOfWeek)))); //得到一周的第一天是yyyy/MM/dd,第一天从周日开始 * z_time.Text = sunday.AddDays(1).ToString("yyyy-MM-dd");//得到一周的周一是yyyy-MM-dd * if (!(z_time.Text == "")) * { * Calendar1.Visible = false; * z_time.Text = sunday.AddDays(1).ToString("yyyy-MM-dd"); * } */ //shenqingshenbao2: //获取当前时间 //推测出本周的所有日期 //在数据库中查询本周是否已填写周计划,若填写则读出周计划内容,若没有填写则跳转至shenqingshenbao页面,进行填写。 } GridViewDataBind(); for (int i = 0; i <= 23; i++) { if (i < 10) { time11_d1.Items.Add('0' + i.ToString()); time12_d1.Items.Add('0' + i.ToString()); } else { time11_d1.Items.Add(i.ToString()); time12_d1.Items.Add(i.ToString()); } } for (int i = 0; i < 60; i++) { if (i < 10) { time11_d2.Items.Add('0' + i.ToString()); time12_d2.Items.Add('0' + i.ToString()); } else { time11_d2.Items.Add(i.ToString()); time12_d2.Items.Add(i.ToString()); } } time11_d1.Text = "09"; time12_d1.Text = "18"; } gvShow.Style.Add("table-layout", "fixed"); }