public bool add(XDBZ xdbz) { 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[6]; param[0] = new SqlParameter("@BZH", xdbz.Bzh); param[1] = new SqlParameter("@FBSJ", xdbz.Fbsj); param[2] = new SqlParameter("@SSSJ", xdbz.Sssj); param[3] = new SqlParameter("@BZ_ID", xdbz.BzId); param[4] = new SqlParameter("@CJR_ID", xdbz.CjrId); param[5] = new SqlParameter("@CJSJ", xdbz.Cjsj); foreach (DbParameter p in param) cmd.Parameters.Add(p); row = cmd.ExecuteNonQuery(); } } return row > 0; }
public bool update(XDBZ entity) { return dao.update(entity); }
public XDBZ getEntity(int id) { XDBZ xdbz = 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()) { xdbz = new XDBZ(); xdbz.Bzh = reader["BZH"].ToString(); if (reader["FBSJ"] != null && reader["FBSJ"].ToString().Length>0) xdbz.Fbsj = DateTime.Parse(reader["FBSJ"].ToString()); if (reader["SSSJ"] != null && reader["SSSJ"].ToString().Length>0) xdbz.Sssj = DateTime.Parse(reader["SSSJ"].ToString()); xdbz.BzId = int.Parse(reader["BZ_ID"].ToString()); xdbz.CjrId = reader["CJR_ID"].ToString(); if (reader["CJSJ"] != null && reader["CJSJ"].ToString().Length>0) xdbz.Cjsj = DateTime.Parse(reader["CJSJ"].ToString()); xdbz.Id = id; } } } } return xdbz; }
public bool add(XDBZ entity) { return dao.add(entity); }