public bool UpdatePersonal_Plan(string ID, string title, string starttime, string endtime, string userId) { bool couw = true; try { //表示修改 if (null != ID && !ID.Equals("")) { DateTime startDateTime = DateTime.Parse(starttime); DateTime endDateTime = DateTime.Parse(endtime); Personal_Plan_model = bllPersonalPlan.GetModel(int.Parse(ID)); //更新个人计划标题 Personal_Plan_model.NAMES = title; //开始时间 Personal_Plan_model.StartTime = startDateTime; //结束时间 Personal_Plan_model.EndTime = endDateTime; //发布时间(修改时间) Personal_Plan_model.DATETIME = DateTime.Now; //更新计划 bllPersonalPlan.Update(Personal_Plan_model); } else { DateTime startDateTime = DateTime.Parse(starttime); DateTime endDateTime = DateTime.Parse(endtime); //个人计划标题 Personal_Plan_model.NAMES = title; //开始时间 Personal_Plan_model.StartTime = startDateTime; //结束时间 Personal_Plan_model.EndTime = endDateTime; //发布时间(添加时间) Personal_Plan_model.DATETIME = DateTime.Now; //状态 Personal_Plan_model.Status = 0; //添加用户 Personal_Plan_model.UserID = userId; //删除标记 Personal_Plan_model.DELFLAG = 0; //计划描述 Personal_Plan_model.Overviews = ""; //添加计划 bllPersonalPlan.Add(Personal_Plan_model); } } catch { couw = false; } return(couw); }
/// <summary> /// 得到一个对象实体 /// </summary> public Dianda.Model.Personal_Plan GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,NAMES,DELFLAG,Status,Overviews,StartTime,EndTime,DATETIME,UserID from Personal_Plan "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Dianda.Model.Personal_Plan model = new Dianda.Model.Personal_Plan(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.NAMES = ds.Tables[0].Rows[0]["NAMES"].ToString(); if (ds.Tables[0].Rows[0]["DELFLAG"].ToString() != "") { model.DELFLAG = int.Parse(ds.Tables[0].Rows[0]["DELFLAG"].ToString()); } if (ds.Tables[0].Rows[0]["Status"].ToString() != "") { model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString()); } model.Overviews = ds.Tables[0].Rows[0]["Overviews"].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()); } if (ds.Tables[0].Rows[0]["DATETIME"].ToString() != "") { model.DATETIME = DateTime.Parse(ds.Tables[0].Rows[0]["DATETIME"].ToString()); } model.UserID = ds.Tables[0].Rows[0]["UserID"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Dianda.Model.Personal_Plan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Personal_Plan("); strSql.Append("NAMES,DELFLAG,Status,Overviews,StartTime,EndTime,DATETIME,UserID)"); strSql.Append(" values ("); strSql.Append("@NAMES,@DELFLAG,@Status,@Overviews,@StartTime,@EndTime,@DATETIME,@UserID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@NAMES", SqlDbType.VarChar, 500), new SqlParameter("@DELFLAG", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Overviews", SqlDbType.Text), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@DATETIME", SqlDbType.DateTime), new SqlParameter("@UserID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.NAMES; parameters[1].Value = model.DELFLAG; parameters[2].Value = model.Status; parameters[3].Value = model.Overviews; parameters[4].Value = model.StartTime; parameters[5].Value = model.EndTime; parameters[6].Value = model.DATETIME; parameters[7].Value = model.UserID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Dianda.Model.Personal_Plan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Personal_Plan set "); strSql.Append("NAMES=@NAMES,"); strSql.Append("DELFLAG=@DELFLAG,"); strSql.Append("Status=@Status,"); strSql.Append("Overviews=@Overviews,"); strSql.Append("StartTime=@StartTime,"); strSql.Append("EndTime=@EndTime,"); strSql.Append("DATETIME=@DATETIME,"); strSql.Append("UserID=@UserID"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@NAMES", SqlDbType.VarChar, 500), new SqlParameter("@DELFLAG", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Overviews", SqlDbType.Text), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@DATETIME", SqlDbType.DateTime), new SqlParameter("@UserID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.NAMES; parameters[2].Value = model.DELFLAG; parameters[3].Value = model.Status; parameters[4].Value = model.Overviews; parameters[5].Value = model.StartTime; parameters[6].Value = model.EndTime; parameters[7].Value = model.DATETIME; parameters[8].Value = model.UserID; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
//更新 protected void Button_update_Click1(object sender, EventArgs e) { try { userModel = (Dianda.Model.USER_Users)Session["USER_Users"]; //string SY_DATUM =""; string dateTime = TB_DateTime.Value.ToString(); string dateTime1 = TB_DateTime1.Value.ToString(); personalModel = personalBll.GetModel(Int32.Parse(Request.QueryString["id"])); //日期 personalModel.DATETIME = Convert.ToDateTime(dateTime); //标题 personalModel.NAMES = TextBox_Title.Text.ToString(); //内容 //personalModel.Overviews = TextBox_Content.Text.ToString(); //获得开始时间 string startTime = Convert.ToDateTime(dateTime).ToString("yyyy-MM-dd") + " " + ddl_Part.SelectedValue.ToString() + ":" + ddl_second.SelectedValue.ToString() + ":00"; //获得结束时间 string endTime = Convert.ToDateTime(dateTime1).ToString("yyyy-MM-dd") + " " + ddl_Part1.SelectedValue.ToString() + ":" + ddl_second1.SelectedValue.ToString() + ":00"; if (checkDate(startTime, endTime)) { personalModel.StartTime = Convert.ToDateTime(startTime); personalModel.EndTime = Convert.ToDateTime(endTime); //时间 personalModel.DATETIME = DateTime.Now; personalModel.UserID = userModel.ID.ToString(); //计划状态; if (RadioButton6.Checked) { personalModel.Status = 1; } else if (RadioButton7.Checked) { personalModel.Status = 3; } else { personalModel.Status = 0; } //操作编辑 //状态 if (this.RadioButton8.Checked) { personalBll.Delete(Int32.Parse(Request.QueryString["id"])); // Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "a", "alert('删除成功');location.href='Test.aspx';", true); //Labeltext.Text = "删除成功!请返回!"; Response.Redirect("Test.aspx"); } else { personalBll.Update(personalModel); // Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "a", "alert('修改成功');location.href='Test.aspx';", true); // Labeltext.Text = "修改成功!请返回!"; Response.Redirect("Test.aspx"); } //添加操作日志 Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt(); Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "修改人员", "修改成功"); } else { Labeltext.Text = "您输入的时间前后有误!请重新操作!"; // Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "a", "alert('您输入的开始时间和结束时间前后有误!请重新操作!');", true); } } catch (Exception) { // Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "a", "alert('修改失败!请重新操作!');", true); Labeltext.Text = "修改失败!请重新操作!"; } }