public bool add(SBBFD sbbfd) { 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("@SB_ID", sbbfd.SbId); param[1] = new SqlParameter("@SBZCZT", sbbfd.Sbzczt); param[2] = new SqlParameter("@BFYY", sbbfd.Bfyy); param[3] = new SqlParameter("@SQR_ID", sbbfd.SqrId); param[4] = new SqlParameter("@SQSJ", sbbfd.Sqsj); foreach (DbParameter p in param) cmd.Parameters.Add(p); row = cmd.ExecuteNonQuery(); } } return row > 0; }
public SBBFD getEntity(int id) { SBBFD sbbfd = 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()) { sbbfd = new SBBFD(); sbbfd.SbId = int.Parse(reader["SB_ID"].ToString()); sbbfd.Sbzczt = int.Parse(reader["SBZCZT"].ToString()); sbbfd.Bfyy = reader["BFYY"].ToString(); sbbfd.SqrId = reader["SQR_ID"].ToString(); if (reader["SQSJ"] != null && reader["SQSJ"].ToString().Length > 0) sbbfd.Sqsj = DateTime.Parse(reader["SQSJ"].ToString()); sbbfd.Id = id; } } } } return sbbfd; }
public bool update(SBBFD entity) { return dao.update(entity); }
public bool add(SBBFD entity) { return dao.add(entity); }