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 = "修改失败！请重新操作！";
}
}
