public static int Add(NgonNguDto nn) { OleDbConnection cn; cn = DataProvider.ConnectionData(); string strSQL; strSQL = "Insert into NgonNgu(TenNgonNgu) values (?)"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); cmd.Parameters.Add("@TenNgonNgu", OleDbType.WChar); cmd.Parameters["@TenNgonNgu"].Value = nn.TenNgonNgu; cmd.ExecuteNonQuery(); strSQL = "Select @@IDENTITY"; cmd = new OleDbCommand(strSQL, cn); nn.MaNgonNgu = (int)cmd.ExecuteScalar(); cn.Close(); return nn.MaNgonNgu; }
public static IList GetList() { ArrayList ds = new ArrayList(); OleDbConnection cn; cn = DataProvider.ConnectionData(); string strSQL; strSQL = "Select * From NgonNgu"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); OleDbDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { NgonNguDto nn = new NgonNguDto(); nn.MaNgonNgu = (int)dr["MNgonNgu"]; nn.TenNgonNgu = (String)dr["TenNgonNgu"]; ds.Add(nn); } dr.Close(); cn.Close(); return ds; }
public static NgonNguDto Search(int MaNn) { NgonNguDto nn = null; OleDbConnection cn; cn = DataProvider.ConnectionData(); string strSQL; strSQL = "Select * From NgonNgu Where MNgonNgu= ? "; OleDbCommand cmd = new OleDbCommand(strSQL, cn); cmd.Parameters.Add("@MNgonNgu", OleDbType.Integer); cmd.Parameters["@MNgonNgu"].Value = MaNn; OleDbDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { nn = new NgonNguDto(); nn.MaNgonNgu = (int)dr["MNgonNgu"]; nn.TenNgonNgu = (String)dr["TenNgonNgu"]; } dr.Close(); cn.Close(); return nn; }
public static void Update(NgonNguDto nn) { OleDbConnection cn; cn = DataProvider.ConnectionData(); string strSQL; strSQL = "Update NgonNgu Set TenNgonNgu = ? Where MNgonNgu = ?"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); cmd.Parameters.Add("@TenNgonNgu", OleDbType.WChar); cmd.Parameters.Add("@MNgonNgu", OleDbType.Integer); cmd.Parameters["@TenNgonNgu"].Value = nn.TenNgonNgu; cmd.Parameters["@MNgonNgu"].Value = nn.MaNgonNgu; cmd.ExecuteNonQuery(); cn.Close(); }
public static void Update(NgonNguDto nn) { NgonNguDao.Update(nn); }
public static int Add(NgonNguDto nn) { return NgonNguDao.Add(nn); }