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); }