public bool add(SBJDJG sbjdjg) { 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[7]; param[0] = new SqlParameter("@SBJDD_ID", sbjdjg.SbjddId); param[1] = new SqlParameter("@JG", sbjdjg.Jg); param[2] = new SqlParameter("@SFTG", sbjdjg.Sftg); param[3] = new SqlParameter("@JZWJ", sbjdjg.Jzwj); param[4] = new SqlParameter("@JZSJ", sbjdjg.Jzsj); param[5] = new SqlParameter("@CJSJ", sbjdjg.Cjsj); param[6] = new SqlParameter("@SYBMQDR_ID", sbjdjg.SybmqdrId); foreach (DbParameter p in param) cmd.Parameters.Add(p); row = cmd.ExecuteNonQuery(); } } return row > 0; }
public bool update(SBJDJG entity) { return dao.update(entity); }
public SBJDJG getEntity(int id) { SBJDJG sbjdjg = 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()) { sbjdjg = new SBJDJG(); sbjdjg.SbjddId = int.Parse(reader["SBJDD_ID"].ToString()); sbjdjg.Jg = reader["JG"].ToString(); sbjdjg.Sftg = bool.Parse(reader["SFTG"].ToString()); sbjdjg.Jzwj = reader["JZWJ"].ToString(); if (reader["JZSJ"] != null && reader["JZSJ"].ToString().Length > 0) sbjdjg.Jzsj = DateTime.Parse(reader["JZSJ"].ToString()); if (reader["CJSJ"] != null && reader["CJSJ"].ToString().Length > 0) sbjdjg.Cjsj = DateTime.Parse(reader["CJSJ"].ToString()); sbjdjg.SybmqdrId = reader["SYBMQDR_ID"].ToString(); sbjdjg.Id = id; } } } } return sbjdjg; }
public bool add(SBJDJG entity) { return dao.add(entity); }