public int InsertBasePark(BaseParkModel basePark)
{
SqlParameter[] param = { new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Amount", SqlDbType.Int),
new SqlParameter("@Memo", SqlDbType.VarChar, 50) };
param[0].Value = basePark.Name;
param[1].Value = basePark.Amount;
param[2].Value = basePark.Memo;
int result = SqlHelp.ExecuteNonQuery("prc_InsertBasePark", CommandType.StoredProcedure, param);
return(result);
}
public List <BaseParkModel> GetBasePark()
{
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetBasePark", CommandType.StoredProcedure);
List <BaseParkModel> list = new List <BaseParkModel>();
while (dr.Read())
{
BaseParkModel basePark = new BaseParkModel();
basePark.ParkID = Convert.ToInt32(dr[0]);
basePark.Name = dr[1].ToString();
basePark.Amount = Convert.ToInt32(dr[2]);
basePark.Memo = dr[3].ToString();
list.Add(basePark);
}
dr.Close();
return(list);
}
protected void Add_Click(object sender, EventArgs e)
{
BaseParkModel basePark = new BaseParkModel();
basePark.Name = txtParkName.Text.Trim();
basePark.Amount = Convert.ToInt32(txtParkAmount.Text.Trim());
basePark.Memo = txtMemo.Text.Trim();
bool flag = bll.InsertBasePark(basePark);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加成功');location.href='BaseParkInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加失败');</script>");
}
}
protected void Modify_Click(object sender, EventArgs e)
{
BaseParkModel basePark = new BaseParkModel();
basePark.ParkID = int.Parse(Request.QueryString["ID"]);
basePark.Name = txtParkName.Text.Trim();
basePark.Amount = Convert.ToInt32(txtParkAmount.Text.Trim());
basePark.Memo = txtMemo.Text.Trim();
bool flag = bll.UpdateBasePark(basePark);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改成功');location.href='BaseParkInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改失败');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
user = (UserModel)Session["User"];
if (Session["User"] == null || Session["User"].ToString() == "" || user.UserType != 1)
{
Response.Redirect("../Login.aspx");
}
else
{
if (!IsPostBack)
{
int parkID = int.Parse(Request.QueryString["ID"]);
BaseParkModel basePark = bll.GetBaseParkByID(parkID);
txtParkName.Text = basePark.Name;
txtParkAmount.Text = basePark.Amount.ToString();
txtMemo.Text = basePark.Memo;
}
}
}
public BaseParkModel GetBaseParkByID(int parkID)
{
SqlParameter param = new SqlParameter("@ParkID", SqlDbType.Int);
param.Value = parkID;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetBaseParkByID", CommandType.StoredProcedure, param);
dr.Read();
BaseParkModel basePark = new BaseParkModel();
if (dr.HasRows)
{
basePark.ParkID = Convert.ToInt32(dr[0]);
basePark.Name = dr[1].ToString();
basePark.Amount = Convert.ToInt32(dr[2]);
basePark.Memo = dr[3].ToString();
}
dr.Close();
return(basePark);
}
public bool InsertBasePark(BaseParkModel basePark)
{
int result = dal.InsertBasePark(basePark);
return(result == 0 ? false : true);
}
public bool UpdateBasePark(BaseParkModel basePark)
{
int result = dal.UpdateBasePark(basePark);
return(result == 0 ? false : true);
}