/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_PLAN GetEntity(decimal CALENDARID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CALENDARID, USERID, CALENDARCONTENT, START_DATE, END_DATE, CALENDARREMIND, CALENDARTYPE, STATE, TITLE, REMIND ");
strSql.Append(" from BASE_PLAN ");
strSql.Append(" where CALENDARID=:CALENDARID ");
OracleParameter[] parameters =
{
new OracleParameter(":CALENDARID", OracleType.Number, 4)
};
parameters[0].Value = CALENDARID;
Entity.BASE_PLAN entity = new Entity.BASE_PLAN();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["CALENDARID"].ToString() != "")
{
entity.CALENDARID = decimal.Parse(dt.Rows[0]["CALENDARID"].ToString());
}
if (dt.Rows[0]["USERID"].ToString() != "")
{
entity.USERID = decimal.Parse(dt.Rows[0]["USERID"].ToString());
}
entity.CALENDARCONTENT = dt.Rows[0]["CALENDARCONTENT"].ToString();
if (dt.Rows[0]["START_DATE"].ToString() != "")
{
entity.START_DATE = DateTime.Parse(dt.Rows[0]["START_DATE"].ToString());
}
if (dt.Rows[0]["END_DATE"].ToString() != "")
{
entity.END_DATE = DateTime.Parse(dt.Rows[0]["END_DATE"].ToString());
}
if (dt.Rows[0]["CALENDARREMIND"].ToString() != "")
{
entity.CALENDARREMIND = DateTime.Parse(dt.Rows[0]["CALENDARREMIND"].ToString());
}
entity.CALENDARTYPE = dt.Rows[0]["CALENDARTYPE"].ToString();
if (dt.Rows[0]["STATE"].ToString() != "")
{
entity.STATE = decimal.Parse(dt.Rows[0]["STATE"].ToString());
}
entity.TITLE = dt.Rows[0]["TITLE"].ToString();
if (dt.Rows[0]["REMIND"].ToString() != "")
{
entity.REMIND = decimal.Parse(dt.Rows[0]["REMIND"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
private void delplan(decimal planid)
{
Entity.BASE_PLAN model = new Entity.BASE_PLAN();
model.CALENDARID = planid;
model.STATE = 1;//更改事务状态为删除
bll.update(model);
//重新加载当前页
Response.Redirect(Request.Url.AbsoluteUri, true);
}
/// <summary>
/// 设置公告数据
/// </summary>
/// <param name="model">公告实体</param>
private void SetEntity(Entity.BASE_PLAN model)
{
SmartHyd.Utility.UserSession usersession = (SmartHyd.Utility.UserSession)Session["user"];
this.hidPrimary.Value = model.CALENDARID.ToString(); //id,主键
this.DdrType.SelectedItem.Text = model.CALENDARTYPE; //事务类型
this.txt_startTime.Text = model.START_DATE.ToString(); //开始时间
this.txt_endTime.Text = model.END_DATE.ToString(); //结束时间
this.txtPrompt.Text = model.CALENDARREMIND.ToString(); //提醒时间
this.txtContent.Text = model.CALENDARCONTENT; //日程内容
this.TxtTitle.Text = model.TITLE; //事务标题
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool update(Entity.BASE_PLAN model)
{
if (dal.Update(model))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_PLAN entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_PLAN set ");
strSql.Append(" CALENDARID = :CALENDARID , ");
strSql.Append(" USERID = :USERID , ");
strSql.Append(" CALENDARCONTENT = :CALENDARCONTENT , ");
strSql.Append(" START_DATE = :START_DATE , ");
strSql.Append(" END_DATE = :END_DATE , ");
strSql.Append(" CALENDARREMIND = :CALENDARREMIND , ");
strSql.Append(" CALENDARTYPE = :CALENDARTYPE , ");
strSql.Append(" STATE = :STATE , ");
strSql.Append(" TITLE = :TITLE , ");
strSql.Append(" REMIND = :REMIND ");
strSql.Append(" where CALENDARID=:CALENDARID ");
OracleParameter[] parameters =
{
new OracleParameter(":CALENDARID", OracleType.Number, 4),
new OracleParameter(":USERID", OracleType.Number, 4),
new OracleParameter(":CALENDARCONTENT", OracleType.VarChar, 200),
new OracleParameter(":START_DATE", OracleType.DateTime),
new OracleParameter(":END_DATE", OracleType.DateTime),
new OracleParameter(":CALENDARREMIND", OracleType.DateTime),
new OracleParameter(":CALENDARTYPE", OracleType.VarChar, 50),
new OracleParameter(":STATE", OracleType.Number, 4),
new OracleParameter(":TITLE", OracleType.VarChar, 50),
new OracleParameter(":REMIND", OracleType.Number, 4)
};
parameters[0].Value = entity.CALENDARID;
parameters[1].Value = entity.USERID;
parameters[2].Value = entity.CALENDARCONTENT;
parameters[3].Value = entity.START_DATE;
parameters[4].Value = entity.END_DATE;
parameters[5].Value = entity.CALENDARREMIND;
parameters[6].Value = entity.CALENDARTYPE;
parameters[7].Value = entity.STATE;
parameters[8].Value = entity.TITLE;
parameters[9].Value = entity.REMIND;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取事务信息实体
/// </summary>
/// <returns></returns>
private Entity.BASE_PLAN GetEntity()
{
SmartHyd.Utility.UserSession usersession = (SmartHyd.Utility.UserSession)Session["user"];
Entity.BASE_PLAN model = new Entity.BASE_PLAN();
model.CALENDARID = Convert.ToInt32(this.hidPrimary.Value); //id,主键
model.CALENDARTYPE = this.DdrType.SelectedItem.Text; //事务类型
model.START_DATE = DateTime.Parse(this.txt_startTime.Text); //开始时间
model.END_DATE = DateTime.Parse(this.txt_endTime.Text); //结束时间
model.CALENDARREMIND = DateTime.Parse(this.txtPrompt.Text); //提醒时间
model.CALENDARCONTENT = this.txtContent.Text; //日程内容
model.USERID = Convert.ToInt32(usersession.USERID); //用户编号
model.TITLE = this.TxtTitle.Text; //事务标题
model.STATE = 0; //事务状态（0：正常；1，删除）
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (null == Request.QueryString["planid"] || "" == Request.QueryString["planid"])
{
//添加页面
this.LabName.Text = "新建事务";
}
else
{
//编辑页面
decimal planid = Convert.ToDecimal(Request.QueryString["planid"]);
ViewState["planid"] = Request.QueryString["planid"];
this.LabName.Text = "编辑事务";
Entity.BASE_PLAN model = planbll.GetModel(planid);
SetEntity(model);
}
}
}
/// <summary>
/// 按钮事件：提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (null == ViewState["planid"])
{
//获取实体
Entity.BASE_PLAN model = GetEntity();
//添加数据
planbll.Add(model);
//重新加载当前页
Response.Redirect("Plan.aspx", true);
}
else
{
//获取实体
Entity.BASE_PLAN model = GetEntity();
//添加数据
planbll.update(model);
//重新加载当前页
Response.Redirect("Plan.aspx", true);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.BASE_PLAN entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_PLAN(");
strSql.Append("CALENDARID,USERID,CALENDARCONTENT,START_DATE,END_DATE,CALENDARREMIND,CALENDARTYPE,STATE,TITLE,REMIND");
strSql.Append(") values (");
strSql.Append(":CALENDARID,:USERID,:CALENDARCONTENT,:START_DATE,:END_DATE,:CALENDARREMIND,:CALENDARTYPE,:STATE,:TITLE,:REMIND");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":CALENDARID", OracleType.Number, 4),
new OracleParameter(":USERID", OracleType.Number, 4),
new OracleParameter(":CALENDARCONTENT", OracleType.VarChar, 200),
new OracleParameter(":START_DATE", OracleType.DateTime),
new OracleParameter(":END_DATE", OracleType.DateTime),
new OracleParameter(":CALENDARREMIND", OracleType.DateTime),
new OracleParameter(":CALENDARTYPE", OracleType.VarChar, 50),
new OracleParameter(":STATE", OracleType.Number, 4),
new OracleParameter(":TITLE", OracleType.VarChar, 50),
new OracleParameter(":REMIND", OracleType.Number, 4)
};
parameters[0].Value = entity.CALENDARID;
parameters[1].Value = entity.USERID;
parameters[2].Value = entity.CALENDARCONTENT;
parameters[3].Value = entity.START_DATE;
parameters[4].Value = entity.END_DATE;
parameters[5].Value = entity.CALENDARREMIND;
parameters[6].Value = entity.CALENDARTYPE;
parameters[7].Value = entity.STATE;
parameters[8].Value = entity.TITLE;
parameters[9].Value = entity.REMIND;
return(OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 新建日程信息
/// </summary>
/// <param name="model">日程信息实体</param>
public void Add(Entity.BASE_PLAN model)
{
dal.Add(model);
}
