public void Cap_Nhat(HT_DM_Tuan_Chi_Tiet myHT_DM_Tuan_Chi_Tiet) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("HT_DM_Tuan_Cap_Nhat", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pMa_Tuan = new SqlParameter("@Ma_Tuan", SqlDbType.Int, 4); pMa_Tuan.Value = myHT_DM_Tuan_Chi_Tiet.Ma_Tuan; myCommand.Parameters.Add(pMa_Tuan); SqlParameter pTuan_So = new SqlParameter("@Tuan_So", SqlDbType.Int, 4); pTuan_So.Value = myHT_DM_Tuan_Chi_Tiet.Tuan_So; myCommand.Parameters.Add(pTuan_So); SqlParameter pNam_Tinh = new SqlParameter("@Nam_Tinh", SqlDbType.Int, 4); pNam_Tinh.Value = myHT_DM_Tuan_Chi_Tiet.Nam_Tinh; myCommand.Parameters.Add(pNam_Tinh); SqlParameter pTu_Ngay = new SqlParameter("@Tu_Ngay", SqlDbType.DateTime, 8); pTu_Ngay.Value = myHT_DM_Tuan_Chi_Tiet.Tu_Ngay; myCommand.Parameters.Add(pTu_Ngay); SqlParameter pDen_Ngay = new SqlParameter("@Den_Ngay", SqlDbType.DateTime, 8); pDen_Ngay.Value = myHT_DM_Tuan_Chi_Tiet.Den_Ngay; myCommand.Parameters.Add(pDen_Ngay); myConnection.Open(); myCommand.ExecuteNonQuery(); } } }
public HT_DM_Tuan_Chi_Tiet Lay(int Ma_Tuan) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("HT_DM_Tuan_Lay", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pMa_Tuan = new SqlParameter("@Ma_Tuan", SqlDbType.Int, 4); pMa_Tuan.Value = Ma_Tuan; myCommand.Parameters.Add(pMa_Tuan); SqlParameter pTuan_So = new SqlParameter("@Tuan_So", SqlDbType.Int, 4); pTuan_So.Direction = ParameterDirection.Output; myCommand.Parameters.Add(pTuan_So); SqlParameter pNam_Tinh = new SqlParameter("@Nam_Tinh", SqlDbType.Int, 4); pNam_Tinh.Direction = ParameterDirection.Output; myCommand.Parameters.Add(pNam_Tinh); SqlParameter pTu_Ngay = new SqlParameter("@Tu_Ngay", SqlDbType.DateTime, 8); pTu_Ngay.Direction = ParameterDirection.Output; myCommand.Parameters.Add(pTu_Ngay); SqlParameter pDen_Ngay = new SqlParameter("@Den_Ngay", SqlDbType.DateTime, 8); pDen_Ngay.Direction = ParameterDirection.Output; myCommand.Parameters.Add(pDen_Ngay); myConnection.Open(); myCommand.ExecuteNonQuery(); HT_DM_Tuan_Chi_Tiet myHT_DM_Tuan_Chi_Tiet = new HT_DM_Tuan_Chi_Tiet(); myHT_DM_Tuan_Chi_Tiet.Ma_Tuan = Ma_Tuan; myHT_DM_Tuan_Chi_Tiet.Tuan_So = (int)pTuan_So.Value; myHT_DM_Tuan_Chi_Tiet.Nam_Tinh = (int)pNam_Tinh.Value; myHT_DM_Tuan_Chi_Tiet.Tu_Ngay = (DateTime)pTu_Ngay.Value; myHT_DM_Tuan_Chi_Tiet.Den_Ngay = (DateTime)pDen_Ngay.Value; return(myHT_DM_Tuan_Chi_Tiet); } } }