/// <summary>
/// 增加一条数据
/// </summary>
public bool AddGrd(Mod_TMb_MONI_STLGRD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMB_MONI_STLGRD(");
strSql.Append("C_STL_GRD,N_STATUS)");
strSql.Append(" values (");
strSql.Append(":C_STL_GRD,:N_STATUS)");
OracleParameter[] parameters =
{
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1)
};
parameters[0].Value = model.C_STL_GRD;
parameters[1].Value = model.N_STATUS;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Mod_TMb_MONI_STLGRD mod = new Mod_TMb_MONI_STLGRD();
if (!string.IsNullOrEmpty(txtGrd.Value))
{
mod.C_STL_GRD = txtGrd.Value.Trim();
}
mod.N_STATUS = 1;
if (!string.IsNullOrEmpty(hid.Value))
{
mod.C_ID = hid.Value;
}
else
{
if (tmd.AddGrd(mod))
{
Response.Write("<script>alert('添加成功');window.parent.refers();</script>");
}
}
}
public bool AddGrd(Mod_TMb_MONI_STLGRD model)
{
return(dal.AddGrd(model));
}
