public bool add(SBQYDPZJL sbqydpzjl) { 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[5]; param[0] = new SqlParameter("@SBQYD_ID", sbqydpzjl.SbqydId); param[1] = new SqlParameter("@PZR_ID", sbqydpzjl.PzrId); param[2] = new SqlParameter("@SFTY", sbqydpzjl.Sfty); param[3] = new SqlParameter("@YJ", sbqydpzjl.Yj); param[4] = new SqlParameter("@SPSJ", sbqydpzjl.Spsj); foreach (DbParameter p in param) cmd.Parameters.Add(p); row = cmd.ExecuteNonQuery(); } } return row > 0; }
public SBQYDPZJL getEntity(int id) { SBQYDPZJL sbqydpzjl = 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()) { sbqydpzjl = new SBQYDPZJL(); sbqydpzjl.SbqydId = int.Parse(reader["SBQYD_ID"].ToString()); sbqydpzjl.PzrId = reader["PZR_ID"].ToString(); sbqydpzjl.Sfty = bool.Parse(reader["SFTY"].ToString()); sbqydpzjl.Yj = reader["YJ"].ToString(); if (reader["SPSJ"] != null && reader["SPSJ"].ToString().Length > 0) sbqydpzjl.Spsj = DateTime.Parse(reader["SPSJ"].ToString()); sbqydpzjl.Id = id; } } } } return sbqydpzjl; }
public bool update(SBQYDPZJL entity) { return dao.update(entity); }
public bool add(SBQYDPZJL entity) { return dao.add(entity); }