/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_MENU entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_MENU(");
strSql.Append("MENUID,MENUNAME,MENUINFO,MENUURL,ICON,PARENTID,STATUS");
strSql.Append(") values (");
strSql.Append(":MENUID,:MENUNAME,:MENUINFO,:MENUURL,:ICON,:PARENTID,:STATUS");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":MENUID", OracleType.Number, 4),
new OracleParameter(":MENUNAME", OracleType.VarChar, 50),
new OracleParameter(":MENUINFO", OracleType.VarChar, 200),
new OracleParameter(":MENUURL", OracleType.VarChar, 200),
new OracleParameter(":ICON", OracleType.VarChar, 50),
new OracleParameter(":PARENTID", OracleType.Number, 4),
new OracleParameter(":STATUS", OracleType.Number, 4)
};
parameters[0].Value = entity.MENUID;
parameters[1].Value = entity.MENUNAME;
parameters[2].Value = entity.MENUINFO;
parameters[3].Value = entity.MENUURL;
parameters[4].Value = entity.ICON;
parameters[5].Value = entity.PARENTID;
parameters[6].Value = entity.STATUS;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
//submit
protected void btnSubmit_Click(object sender, EventArgs e)
{
Entity.BASE_MENU model = new Entity.BASE_MENU();
model = GetModel();
bllMenu.Add(model);
Response.Redirect(Request.UrlReferrer.AbsoluteUri, true);
}
private void SetModel(Entity.BASE_MENU model)
{
txtMenuIco.Text = model.ICON;
hidPrimary.Value = model.MENUID.ToString();
txtSummary.Text = model.MENUINFO;
txtMenuName.Text = model.MENUNAME;
txtMenuUrl.Text = model.MENUURL;
ddlMenuParentNode.SelectedValue = model.PARENTID.ToString();
ddlState.SelectedValue = model.STATUS.ToString();
}
private Entity.BASE_MENU GetModel()
{
Entity.BASE_MENU model = new Entity.BASE_MENU();
model.ICON = txtMenuIco.Text.Trim();
model.MENUID = Convert.ToInt32(hidPrimary.Value);
model.MENUINFO = txtSummary.Text.Trim();
model.MENUNAME = txtMenuName.Text.Trim();
model.MENUURL = txtMenuUrl.Text.Trim();
model.PARENTID = Convert.ToInt32(ddlMenuParentNode.SelectedValue);
model.STATUS = Convert.ToInt32(ddlState.SelectedValue);
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_MENU entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_MENU set ");
strSql.Append(" MENUID = :MENUID , ");
strSql.Append(" MENUNAME = :MENUNAME , ");
strSql.Append(" MENUINFO = :MENUINFO , ");
strSql.Append(" MENUURL = :MENUURL , ");
strSql.Append(" ICON = :ICON , ");
strSql.Append(" PARENTID = :PARENTID , ");
strSql.Append(" STATUS = :STATUS ");
strSql.Append(" where MENUID=:MENUID ");
OracleParameter[] parameters =
{
new OracleParameter(":MENUID", OracleType.Number, 4),
new OracleParameter(":MENUNAME", OracleType.VarChar, 50),
new OracleParameter(":MENUINFO", OracleType.VarChar, 200),
new OracleParameter(":MENUURL", OracleType.VarChar, 200),
new OracleParameter(":ICON", OracleType.VarChar, 50),
new OracleParameter(":PARENTID", OracleType.Number, 4),
new OracleParameter(":STATUS", OracleType.Number, 4)
};
parameters[0].Value = entity.MENUID;
parameters[1].Value = entity.MENUNAME;
parameters[2].Value = entity.MENUINFO;
parameters[3].Value = entity.MENUURL;
parameters[4].Value = entity.ICON;
parameters[5].Value = entity.PARENTID;
parameters[6].Value = entity.STATUS;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_MENU GetEntity(decimal MENUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select MENUID, MENUNAME, MENUINFO, MENUURL, ICON, PARENTID, STATUS ");
strSql.Append(" from BASE_MENU ");
strSql.Append(" where MENUID=:MENUID ");
OracleParameter[] parameters =
{
new OracleParameter(":MENUID", OracleType.Number, 4)
};
parameters[0].Value = MENUID;
Entity.BASE_MENU entity = new Entity.BASE_MENU();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["MENUID"].ToString() != "")
{
entity.MENUID = decimal.Parse(dt.Rows[0]["MENUID"].ToString());
}
entity.MENUNAME = dt.Rows[0]["MENUNAME"].ToString();
entity.MENUINFO = dt.Rows[0]["MENUINFO"].ToString();
entity.MENUURL = dt.Rows[0]["MENUURL"].ToString();
entity.ICON = dt.Rows[0]["ICON"].ToString();
if (dt.Rows[0]["PARENTID"].ToString() != "")
{
entity.PARENTID = decimal.Parse(dt.Rows[0]["PARENTID"].ToString());
}
if (dt.Rows[0]["STATUS"].ToString() != "")
{
entity.STATUS = decimal.Parse(dt.Rows[0]["STATUS"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
public void Add(Entity.BASE_MENU model)
{
dal.Add(model);
}
