public int InsertFix(FixModel fix) { SqlParameter[] param = { new SqlParameter("@FixID", SqlDbType.VarChar, 18), new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Amount",SqlDbType.Int),new SqlParameter("@Factory",SqlDbType.VarChar,20), new SqlParameter("@FactoryDate",SqlDbType.DateTime,10) }; param[0].Value = fix.FixID; param[1].Value = fix.Name; param[2].Value = fix.Amount; param[3].Value = fix.Factory; param[4].Value = fix.FactoryDate; int result = SqlHelp.ExecuteNonQuery("prc_InsertFix", CommandType.StoredProcedure, param); return result; }
public List<FixModel> GetAllFix() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAllFix", CommandType.StoredProcedure); List<FixModel> list = new List<FixModel>(); while (dr.Read()) { FixModel fix = new FixModel(); fix.FixID = dr[0].ToString(); fix.Name = dr[1].ToString(); fix.Amount = Convert.ToInt32(dr[2]); fix.Factory = dr[3].ToString(); fix.FactoryDate = Convert.ToDateTime(dr[4]); list.Add(fix); } dr.Close(); return list; }
protected void Add_Click(object sender, EventArgs e) { FixModel fix = new FixModel(); fix.FixID = lbID.Text; fix.Name = txtFixName.Text.Trim(); fix.Amount = Convert.ToInt32(txtFixAmount.Text.Trim()); fix.Factory = txtFixFactory.Text.Trim(); fix.FactoryDate = Convert.ToDateTime(txtFixFactoryDate.Value); bool flag = bll.InsertFix(fix); if (flag) { Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加成功');location.href='FixInfo.aspx';</script>"); } else { Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加失败');</script>"); } }
public List<FixModel> GetFixByCondition(string condition) { SqlParameter param = new SqlParameter("@Condition", SqlDbType.VarChar, 255); param.Value = condition; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetFixByCondition", CommandType.StoredProcedure,param); List<FixModel> list = new List<FixModel>(); while (dr.Read()) { FixModel fix = new FixModel(); fix.FixID = dr[0].ToString(); fix.Name = dr[1].ToString(); fix.Amount = Convert.ToInt32(dr[2]); fix.Factory = dr[3].ToString(); fix.FactoryDate = Convert.ToDateTime(dr[4]); list.Add(fix); } dr.Close(); return list; }
public FixModel GetFixByID(string fixID) { SqlParameter param = new SqlParameter("@FixID", SqlDbType.VarChar, 18); param.Value = fixID; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetFixByID", CommandType.StoredProcedure, param); List<FixModel> list = new List<FixModel>(); dr.Read(); FixModel fix = new FixModel(); if (dr.HasRows) { fix.FixID = dr[0].ToString(); fix.Name = dr[1].ToString(); fix.Amount = Convert.ToInt32(dr[2]); fix.Factory = dr[3].ToString(); fix.FactoryDate = Convert.ToDateTime(dr[4]); } dr.Close(); return fix; }
public bool InsertFix(FixModel fix) { int result = dal.InsertFix(fix); return result == 0 ? false : true; }
public bool UpdateFix(FixModel fix) { int result = dal.UpdateFix(fix); return result == 0 ? false : true; }