/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_setSystem model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_setSystem(");
strSql.Append("IsOpenWeb,CloseWebRemark)");
strSql.Append(" values (");
strSql.Append("@IsOpenWeb,@CloseWebRemark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@IsOpenWeb", SqlDbType.Int, 4),
new SqlParameter("@CloseWebRemark", SqlDbType.VarChar, 5000)
};
parameters[0].Value = model.IsOpenWeb;
parameters[1].Value = model.CloseWebRemark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_setSystem model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_setSystem set ");
strSql.Append("IsOpenWeb=@IsOpenWeb,");
strSql.Append("CloseWebRemark=@CloseWebRemark");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@IsOpenWeb", SqlDbType.Int, 4),
new SqlParameter("@CloseWebRemark", SqlDbType.VarChar, 5000),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.IsOpenWeb;
parameters[1].Value = model.CloseWebRemark;
parameters[2].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
spd.jumpAdminUrl1(this.Page, 1);//跳转三级密码
if (txtMsgContent.Text == "")
{
MessageBox.Show(this, "关闭提示信息不能为空");
return;
}
lgk.Model.tb_setSystem set = setBLL.GetModel(setBLL.GetMaxId());
if (set == null)
{
set = new lgk.Model.tb_setSystem();
set.CloseWebRemark = txtMsgContent.Text;
if (rdoEnabled.Checked == true)
{
set.IsOpenWeb = 1;
}
else
{
set.IsOpenWeb = 0;
}
if (setBLL.Add(set) > 0)
{
MessageBox.ShowAndRedirect(this, "设置成功", "SetState.aspx");
}
else
{
MessageBox.Show(this, "设置失败");
}
}
else
{
set.CloseWebRemark = txtMsgContent.Text;
if (rdoEnabled.Checked == true)
{
set.IsOpenWeb = 1;
}
else
{
set.IsOpenWeb = 0;
}
if (setBLL.Update(set))
{
MessageBox.Show(this, "设置成功");
}
else
{
MessageBox.Show(this, "设置失败");
}
}
}
/// <summary>
/// 填充数据
/// </summary>
protected void BindDate()
{
lgk.Model.tb_setSystem set = setBLL.GetModel(setBLL.GetMaxId());
if (set != null)
{
if (set.IsOpenWeb == 0)
{
rdoEnabled.Checked = false;
rdoClose.Checked = true;
}
else
{
rdoEnabled.Checked = true;
rdoClose.Checked = false;
}
txtMsgContent.Text = set.CloseWebRemark;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_setSystem GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,IsOpenWeb,CloseWebRemark from tb_setSystem ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
lgk.Model.tb_setSystem model = new lgk.Model.tb_setSystem();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["IsOpenWeb"] != null && ds.Tables[0].Rows[0]["IsOpenWeb"].ToString() != "")
{
model.IsOpenWeb = int.Parse(ds.Tables[0].Rows[0]["IsOpenWeb"].ToString());
}
if (ds.Tables[0].Rows[0]["CloseWebRemark"] != null && ds.Tables[0].Rows[0]["CloseWebRemark"].ToString() != "")
{
model.CloseWebRemark = ds.Tables[0].Rows[0]["CloseWebRemark"].ToString();
}
return(model);
}
else
{
return(null);
}
}
