public Cls_ChiTietDichVu_DTA(Cls_ChiTietDichVu_DTA CTDV_DATA) { MaDV = CTDV_DATA.MaDV; MaPH = CTDV_DATA.MaPH; DonGia = CTDV_DATA.DonGia; SoLuong = CTDV_DATA.SoLuong; }
public Cls_ChiTietDichVu_DTA(Cls_ChiTietDichVu_DTA CTDV_DATA) { MaDV = CTDV_DATA.MaDV; MaPH = CTDV_DATA.MaPH; DonGia = CTDV_DATA.DonGia; SoLuong = CTDV_DATA.SoLuong; }
public void Insert_Update_Delete(Cls_ChiTietDichVu_DTA CTDichVu_Data, string sThucThi) { sConn.Open(); try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SP_CTDichVu"; cmd.Connection = this.sConn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MaDV", SqlDbType.Char); cmd.Parameters["@MaDV"].Value = CTDichVu_Data.MaDV; cmd.Parameters.Add("@MaPH", SqlDbType.Char); cmd.Parameters["@MaPH"].Value = CTDichVu_Data.MaPH; cmd.Parameters.Add("@DonGia", SqlDbType.Float); cmd.Parameters["@DonGia"].Value = CTDichVu_Data.DonGia; cmd.Parameters.Add("@SoLuong", SqlDbType.Int); cmd.Parameters["@SoLuong"].Value = CTDichVu_Data.SoLuong; cmd.Parameters.Add("@sqlTemp", SqlDbType.NVarChar); if (sThucThi == "Insert" || sThucThi == "Delete" || sThucThi == "Update") { cmd.Parameters["@sqlTemp"].Value = sThucThi; cmd.ExecuteNonQuery(); } } catch (Exception) { throw; } sConn.Close(); }
public void Inser_Update_Delete(Cls_ChiTietDichVu_DTA CTDichVu_DATA,string sThucThi) { CTDichVu_BUS.Insert_Update_Delete(CTDichVu_DATA, sThucThi); }