/// <summary>
/// 拆分参数
/// </summary>
private void ShowData()
{
lgk.Model.tb_Security securityInfo = securityBLL.GetModel(iSecurityID);
if (securityInfo != null)
{
txtQuestion.Text = securityInfo.Question;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_Security GetModel(int SecurityID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SecurityID, Question, AddUserID, AddDate, EditUserID, EditDate, Status");
strSql.Append(" from tb_Security ");
strSql.Append(" where SecurityID=@SecurityID");
SqlParameter[] parameters =
{
new SqlParameter("@SecurityID", SqlDbType.Int, 4)
};
parameters[0].Value = SecurityID;
lgk.Model.tb_Security model = new lgk.Model.tb_Security();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SecurityID"].ToString() != "")
{
model.SecurityID = int.Parse(ds.Tables[0].Rows[0]["SecurityID"].ToString());
}
model.Question = ds.Tables[0].Rows[0]["Question"].ToString();
if (ds.Tables[0].Rows[0]["AddUserID"].ToString() != "")
{
model.AddUserID = int.Parse(ds.Tables[0].Rows[0]["AddUserID"].ToString());
}
if (ds.Tables[0].Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString());
}
if (ds.Tables[0].Rows[0]["EditUserID"].ToString() != "")
{
model.EditUserID = int.Parse(ds.Tables[0].Rows[0]["EditUserID"].ToString());
}
if (ds.Tables[0].Rows[0]["EditDate"].ToString() != "")
{
model.EditDate = DateTime.Parse(ds.Tables[0].Rows[0]["EditDate"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
return(model);
}
else
{
return(null);
}
}
protected void lbtnSubmit_Click(object sender, EventArgs e)
{
lgk.Model.tb_Security securityInfo = new lgk.Model.tb_Security();
if (txtQuestion.Text.Trim() == "")
{
MessageBox.MyShow(this, "密保问题不能为空！");//密保问题不能为空
return;
}
if (iSecurityID > 0)
{
securityInfo = securityBLL.GetModel(iSecurityID);
securityInfo.Question = txtQuestion.Text;
securityInfo.EditUserID = getLoginID();
securityInfo.EditDate = DateTime.Now;
if (securityBLL.Update(securityInfo))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改成功！');window.location.href='Security.aspx';", true);//修改成功
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改失败，请检查后再试！');window.location.href='Security.aspx';", true);//修改成功
}
}
else
{
securityInfo.Question = txtQuestion.Text;
securityInfo.AddUserID = getLoginID();
securityInfo.AddDate = DateTime.Now;
securityInfo.EditUserID = 0;
securityInfo.Status = 0;
if (securityBLL.Add(securityInfo) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('添加成功！');window.location.href='Security.aspx';", true);//修改成功
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('添加失败，请检查后再试！');window.location.href='Security.aspx';", true);//修改成功
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_Security model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Security set ");
strSql.Append(" Question = @Question,");
strSql.Append(" AddUserID = @AddUserID,");
strSql.Append(" AddDate = @AddDate,");
strSql.Append(" EditUserID = @EditUserID,");
strSql.Append(" EditDate = @EditDate,");
strSql.Append(" Status = @Status ");
strSql.Append(" where SecurityID=@SecurityID ");
SqlParameter[] parameters =
{
new SqlParameter("@SecurityID", SqlDbType.Int, 4),
new SqlParameter("@Question", SqlDbType.VarChar, 50),
new SqlParameter("@AddUserID", SqlDbType.Int, 4),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@EditUserID", SqlDbType.Int, 4),
new SqlParameter("@EditDate", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Int, 4)
};
parameters[0].Value = model.SecurityID;
parameters[1].Value = model.Question;
parameters[2].Value = model.AddUserID;
parameters[3].Value = model.AddDate;
parameters[4].Value = model.EditUserID;
parameters[5].Value = model.EditDate;
parameters[6].Value = model.Status;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_Security model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Security(");
strSql.Append("Question,AddUserID,AddDate,EditUserID,EditDate,Status");
strSql.Append(") values (");
strSql.Append("@Question,@AddUserID,@AddDate,@EditUserID,@EditDate,@Status");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Question", SqlDbType.VarChar, 50),
new SqlParameter("@AddUserID", SqlDbType.Int, 4),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@EditUserID", SqlDbType.Int, 4),
new SqlParameter("@EditDate", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Int, 4)
};
parameters[0].Value = model.Question;
parameters[1].Value = model.AddUserID;
parameters[2].Value = model.AddDate;
parameters[3].Value = model.EditUserID;
parameters[4].Value = DBNull.Value;
parameters[5].Value = model.Status;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
