protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserID"] != null) { PeriodsModel = PeriodsBll.GetModel(1); if (!((Convert.ToDateTime(PeriodsModel.StartTime)) <= (Convert.ToDateTime(DateTime.Now.ToString("yy-MM-dd"))) && (Convert.ToDateTime(DateTime.Now.ToString("yy-MM-dd")) <= (Convert.ToDateTime(PeriodsModel.EndTime))))) { Response.Redirect("/Message/TimeSetMessage.aspx?tid=1"); } else { string userID = Session["UserID"].ToString(); if (userID != "") { BindData(); //数据填充 } } } else { Response.Write("<script language=javascript>alert('您已经与服务器断开连接,请重新登录!');window.location.href='~/../../login.aspx';</script>"); } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ZQUSR.Model.sr_Periods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sr_Periods("); strSql.Append("PeriName,StartTime,EndTime,Extra1,Extra2)"); strSql.Append(" values ("); strSql.Append("@PeriName,@StartTime,@EndTime,@Extra1,@Extra2)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@PeriName", SqlDbType.NVarChar, 20), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@Extra1", SqlDbType.NVarChar, 10), new SqlParameter("@Extra2", SqlDbType.NVarChar, 10) }; parameters[0].Value = model.PeriName; parameters[1].Value = model.StartTime; parameters[2].Value = model.EndTime; parameters[3].Value = model.Extra1; parameters[4].Value = model.Extra2; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ZQUSR.Model.sr_Periods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update sr_Periods set "); strSql.Append("PeriName=@PeriName,"); strSql.Append("StartTime=@StartTime,"); strSql.Append("EndTime=@EndTime,"); strSql.Append("Extra1=@Extra1,"); strSql.Append("Extra2=@Extra2"); strSql.Append(" where PK_PID=@PK_PID "); SqlParameter[] parameters = { new SqlParameter("@PK_PID", SqlDbType.Int, 4), new SqlParameter("@PeriName", SqlDbType.NVarChar, 20), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@Extra1", SqlDbType.NVarChar, 10), new SqlParameter("@Extra2", SqlDbType.NVarChar, 10) }; parameters[0].Value = model.PK_PID; parameters[1].Value = model.PeriName; parameters[2].Value = model.StartTime; parameters[3].Value = model.EndTime; parameters[4].Value = model.Extra1; parameters[5].Value = model.Extra2; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lblNowTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); int intTid = Convert.ToInt32(Request.QueryString["tid"]); PeriodsModel = PeriodsBll.GetModel(intTid); lblName.Text = PeriodsModel.PeriName; lblStartTime.Text = PeriodsModel.StartTime.ToString("yyyy-MM-dd"); lblEndTime.Text = PeriodsModel.EndTime.ToString("yyyy-MM-dd"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PeriodsModel = PeriodsBll.GetModel(2); if (!((Convert.ToDateTime(PeriodsModel.StartTime)) <= (Convert.ToDateTime(DateTime.Now.ToString("yy-MM-dd"))) && (Convert.ToDateTime(DateTime.Now.ToString("yy-MM-dd")) <= (Convert.ToDateTime(PeriodsModel.EndTime))))) { Response.Redirect("/Message/TimeSetMessage.aspx?tid=2"); } else { BindData(); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZQUSR.Model.sr_Periods GetModel(int PK_PID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 PK_PID,PeriName,StartTime,EndTime,Extra1,Extra2 from sr_Periods "); strSql.Append(" where PK_PID=@PK_PID "); SqlParameter[] parameters = { new SqlParameter("@PK_PID", SqlDbType.Int, 4) }; parameters[0].Value = PK_PID; ZQUSR.Model.sr_Periods model = new ZQUSR.Model.sr_Periods(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["PK_PID"].ToString() != "") { model.PK_PID = int.Parse(ds.Tables[0].Rows[0]["PK_PID"].ToString()); } model.PeriName = ds.Tables[0].Rows[0]["PeriName"].ToString(); if (ds.Tables[0].Rows[0]["StartTime"].ToString() != "") { model.StartTime = DateTime.Parse(ds.Tables[0].Rows[0]["StartTime"].ToString()); } if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString()); } model.Extra1 = ds.Tables[0].Rows[0]["Extra1"].ToString(); model.Extra2 = ds.Tables[0].Rows[0]["Extra2"].ToString(); return(model); } else { return(null); } }