public NL_DM_Ngach_Bac_He_So_Chi_Tiet Lay(int Ma_Ngach_Bac_He_So) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("NL_DM_Ngach_Bac_He_So_Lay", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pMa_Ngach_Bac_He_So = new SqlParameter("@Ma_Ngach_Bac_He_So", SqlDbType.Int, 4); pMa_Ngach_Bac_He_So.Value = Ma_Ngach_Bac_He_So; myCommand.Parameters.Add(pMa_Ngach_Bac_He_So); SqlDataAdapter myAdapter = new SqlDataAdapter(); DataSet myDataSet = new DataSet(); myConnection.Open(); myAdapter.SelectCommand = myCommand; myAdapter.Fill(myDataSet, "NL_DM_Ngach_Bac_He_So_Chi_Tiet"); NL_DM_Ngach_Bac_He_So_Chi_Tiet myNL_DM_Ngach_Bac_He_So_Chi_Tiet = new NL_DM_Ngach_Bac_He_So_Chi_Tiet(); if (myDataSet.Tables["NL_DM_Ngach_Bac_He_So_Chi_Tiet"] != null) { myNL_DM_Ngach_Bac_He_So_Chi_Tiet.Ma_Ngach_Bac_He_So = Ma_Ngach_Bac_He_So; myNL_DM_Ngach_Bac_He_So_Chi_Tiet.Ma_Ngach = myDataSet.Tables["NL_DM_Ngach_Bac_He_So_Chi_Tiet"].Rows[0]["Ma_Ngach"] != DBNull.Value?(string)myDataSet.Tables["NL_DM_Ngach_Bac_He_So_Chi_Tiet"].Rows[0]["Ma_Ngach"]:(string)null; myNL_DM_Ngach_Bac_He_So_Chi_Tiet.Ngay_Quyet_Dinh = myDataSet.Tables["NL_DM_Ngach_Bac_He_So_Chi_Tiet"].Rows[0]["Ngay_Quyet_Dinh"] != DBNull.Value?(DateTime?)myDataSet.Tables["NL_DM_Ngach_Bac_He_So_Chi_Tiet"].Rows[0]["Ngay_Quyet_Dinh"]:(DateTime?)null; myNL_DM_Ngach_Bac_He_So_Chi_Tiet.Bac = myDataSet.Tables["NL_DM_Ngach_Bac_He_So_Chi_Tiet"].Rows[0]["Bac"] != DBNull.Value?(int?)myDataSet.Tables["NL_DM_Ngach_Bac_He_So_Chi_Tiet"].Rows[0]["Bac"]:(int?)null; myNL_DM_Ngach_Bac_He_So_Chi_Tiet.He_So = myDataSet.Tables["NL_DM_Ngach_Bac_He_So_Chi_Tiet"].Rows[0]["He_So"] != DBNull.Value?(decimal?)myDataSet.Tables["NL_DM_Ngach_Bac_He_So_Chi_Tiet"].Rows[0]["He_So"]:(decimal?)null; } return(myNL_DM_Ngach_Bac_He_So_Chi_Tiet); } } }
public void Cap_Nhat(NL_DM_Ngach_Bac_He_So_Chi_Tiet myNL_DM_Ngach_Bac_He_So_Chi_Tiet) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("NL_DM_Ngach_Bac_He_So_Cap_Nhat", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pMa_Ngach_Bac_He_So = new SqlParameter("@Ma_Ngach_Bac_He_So", SqlDbType.Int, 4); pMa_Ngach_Bac_He_So.Value = myNL_DM_Ngach_Bac_He_So_Chi_Tiet.Ma_Ngach_Bac_He_So; myCommand.Parameters.Add(pMa_Ngach_Bac_He_So); SqlParameter pMa_Ngach = new SqlParameter("@Ma_Ngach", SqlDbType.VarChar, 50); pMa_Ngach.Value = myNL_DM_Ngach_Bac_He_So_Chi_Tiet.Ma_Ngach; myCommand.Parameters.Add(pMa_Ngach); SqlParameter pNgay_Quyet_Dinh = new SqlParameter("@Ngay_Quyet_Dinh", SqlDbType.DateTime, 8); pNgay_Quyet_Dinh.Value = myNL_DM_Ngach_Bac_He_So_Chi_Tiet.Ngay_Quyet_Dinh; myCommand.Parameters.Add(pNgay_Quyet_Dinh); SqlParameter pBac = new SqlParameter("@Bac", SqlDbType.Int, 4); pBac.Value = myNL_DM_Ngach_Bac_He_So_Chi_Tiet.Bac; myCommand.Parameters.Add(pBac); SqlParameter pHe_So = new SqlParameter("@He_So", SqlDbType.Float, 8); pHe_So.Value = myNL_DM_Ngach_Bac_He_So_Chi_Tiet.He_So; myCommand.Parameters.Add(pHe_So); myConnection.Open(); myCommand.ExecuteNonQuery(); } } }