public bool add(WJ wj) { 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("@WJLB_ID", wj.WjlbId); param[1] = new SqlParameter("@WJ", wj.Wj); param[2] = new SqlParameter("@BM_ID", wj.BmId); param[3] = new SqlParameter("@CJR_ID", wj.CjrId); foreach (DbParameter p in param) cmd.Parameters.Add(p); row = cmd.ExecuteNonQuery(); } } return row > 0; }
public bool update(WJ entity) { return dao.update(entity); }
public bool add(WJ entity) { return dao.add(entity); }
public WJ getEntity(int id) { WJ wj = 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()) { wj = new WJ(); wj.WjlbId = int.Parse(reader["WJLB_ID"].ToString()); wj.Wj = reader["WJ"].ToString(); wj.BmId = int.Parse(reader["BM_ID"].ToString()); wj.CjrId = reader["CJR_ID"].ToString(); wj.Id = id; } } } } return wj; }