public void Insert_Update_Delete(Cls_LoaiDichVu_DTA LoaiDV_Data,string sThucThi) { sConn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SP_LoaiDichVu"; cmd.Connection = this.sConn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MaLoaiDV", SqlDbType.Char); cmd.Parameters["@MaLoaiDV"].Value = LoaiDV_Data.MaLoaiDV; cmd.Parameters.Add("@TenLoaiDV", SqlDbType.NVarChar); cmd.Parameters["@TenLoaiDV"].Value = LoaiDV_Data.TenLoaiDV; cmd.Parameters.Add("@LoaiDV", SqlDbType.NVarChar); cmd.Parameters["@LoaiDV"].Value = LoaiDV_Data.LoaiDV; cmd.Parameters.Add("@sqlTemp", SqlDbType.NVarChar); if (sThucThi == "Insert" || sThucThi == "Delete" || sThucThi == "Update") cmd.Parameters["@sqlTemp"].Value = sThucThi; cmd.ExecuteNonQuery(); sConn.Close(); }
public Cls_LoaiDichVu_DTA(Cls_LoaiDichVu_DTA LoaiDV_Data) { MaLoaiDV = LoaiDV_Data.MaLoaiDV; TenLoaiDV = LoaiDV_Data.TenLoaiDV; LoaiDV = LoaiDV_Data.LoaiDV; }
//Download source code FREE tai Sharecode.vn public void Insert_Update_Delete(Cls_LoaiDichVu_DTA LoaiDV_Data,string sThucThi) { LoaiDV_Bus.Insert_Update_Delete(LoaiDV_Data, sThucThi); }