public bool add(BZWZSGD bzwzsgd) { int row = 0; using (DbConnection conn = new SqlConnection(SQLString.connString)) { conn.Open(); using (DbCommand cmd = conn.CreateCommand()) { cmd.CommandText = ADD; cmd.CommandType = CommandType.Text; DbParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@BZWZ_ID", bzwzsgd.BzwzId); param[1] = new SqlParameter("@SGYY", bzwzsgd.Sgyy); param[2] = new SqlParameter("@SQR_ID", bzwzsgd.SqrId); param[3] = new SqlParameter("@SQSJ", bzwzsgd.Sqsj); foreach (DbParameter p in param) cmd.Parameters.Add(p); row = cmd.ExecuteNonQuery(); } } return row > 0; }
public BZWZSGD getEntity(int id) { BZWZSGD bzwzsgd = null; using (DbConnection conn = new SqlConnection(SQLString.connString)) { conn.Open(); using (DbCommand cmd = conn.CreateCommand()) { cmd.CommandText = GET_ENTITY; cmd.CommandType = CommandType.Text; DbParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", id); foreach (DbParameter p in param) cmd.Parameters.Add(p); DbDataReader reader = cmd.ExecuteReader(); using (reader) { if (reader.Read()) { bzwzsgd = new BZWZSGD(); bzwzsgd.BzwzId = int.Parse(reader["BZWZ_ID"].ToString()); bzwzsgd.Sgyy = reader["SGYY"].ToString(); bzwzsgd.SqrId = reader["SQR_ID"].ToString(); bzwzsgd.Sqsj = DateTime.Parse(reader["SQSJ"].ToString()); bzwzsgd.Id = id; } } } } return bzwzsgd; }
public bool update(BZWZSGD bzwzsgd) { return dao.update(bzwzsgd); }
public bool add(BZWZSGD bzwzsgd) { return dao.add(bzwzsgd); }