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");
}
